1. A college graduate who is living in Cincinnati expects to earn an annual salary of $55,000. The Excel file Cost of Living Adjustments shows the comparative salaries in other cities and percentage adjustments for living expenses. Develop an Excel template that allows the user to enter current annual expenses (in Cincinnati) for groceries, housing, utilities, transportation, and health care and compute the corresponding expenses for any selected city and the net salary surplus for both Cincinnati and the selected city. An example of what the output should look like is provided next: Cincinnati Atlanta
Salary $55,000.00 $60,482.00
Annual Expenses Groceries $7,800.00 $8,970.00
Housing $14,400.00 $18,000.00
Utilities $3,000.00 $2,700.00
Transportation $1,020.00 $1,081.20
Healthcare $4,200.00 $4,410.00
Total $30,420.00 $35,161.20
Salary Surplus $24,580.00 $25,320.80
2. Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the Sales Transactions database.

After creating an organizational strategy based on porter’s models, a company can a) create process models. b) calculate inputs and outputs. c) examine market structure. d) develop information systems. only answer if you're positive! you!

For a multistate lottery, the following probability distribution represents the cash prizes of the lottery with their corresponding probabilities. complete parts (a) through (c) below. x (cash prize, $) p(x) grand prizegrand prize 0.000000008860.00000000886 200,000 0.000000390.00000039 10,000 0.0000016950.000001695 100 0.0001582930.000158293 7 0.0039114060.003911406 4 0.0080465690.008046569 3 0.012865710.01286571 0 0.975015928140.97501592814 (a) if the grand prize is $13 comma 000 comma 00013,000,000, find and interpret the expected cash prize. if a ticket costs $1, what is your expected profit from one ticket? the expected cash prize is $nothing.

Exercise 15-7 crawford corporation incurred the following transactions. 1. purchased raw materials on account $53,000. 2. raw materials of $45,200 were requisitioned to the factory. an analysis of the materials requisition slips indicated that $9,400 was classified as indirect materials. 3. factory labor costs incurred were $65,400, of which $50,200 pertained to factory wages payable and $15,200 pertained to employer payroll taxes payable. 4. time tickets indicated that $55,000 was direct labor and $10,400 was indirect labor. 5. manufacturing overhead costs incurred on account were $81,700. 6. depreciation on the company’s office building was $8,100. 7. manufacturing overhead was applied at the rate of 160% of direct labor cost. 8. goods costing $89,400 were completed and transferred to finished goods. 9. finished goods costing $76,000 to manufacture were sold on account for $105,100. journalize the transactions. (credit account titles are automatically indented when amount is entered. do not indent manually.) no. account titles and explanation debit credit (1) (2) (3) (4) (5) (6) (7) (8) (9) (to record the sale) (to record the cost of the sale) click if you would like to show work for this question: open show work