Revise the data in your worksheet to reflect the results for the subsequent period as shown...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B Chapter 9: Applying Excel 3 Data 4 Revenue 16.50 a 6.25 9 %24 Cost of ingredients 6 Wages and salaries 10,400 Utilities 800 %24 0.20 a 8 Rent 2,200 6. Miscellaneous 600 2$ 0.80 a 10 Actual results: 11 Revenue %24 30,175 12 Cost of ingredients 13 11,150 Wages and salaries 14 24 10g00 Utilities 15 $. 1,185 Rent 16 Miscellaneous 17 $4 2,200 $4 2,080 18 Planning budget activity 19 Actual activity 20 1,700 meals served 1,800 meals served %24 2. 67 a. What is the activity variance for revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the activity variance for revenue 1,615 F ces b. What is the spending variance for the cost of ingredients? (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero variance). The amount of the spending variance for the cost of ingredients c. What is spending variance for wages and salaries? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). nces The amount of the spending variance for wages and salaries d. What is spending variance for total expenses? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the spending variance for total expenses 90 Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B Chapter 9: Applying Excel 3 Data 4 Revenue 16.50 a 6.25 9 %24 Cost of ingredients 6 Wages and salaries 10,400 Utilities 800 %24 0.20 a 8 Rent 2,200 6. Miscellaneous 600 2$ 0.80 a 10 Actual results: 11 Revenue %24 30,175 12 Cost of ingredients 13 11,150 Wages and salaries 14 24 10g00 Utilities 15 $. 1,185 Rent 16 Miscellaneous 17 $4 2,200 $4 2,080 18 Planning budget activity 19 Actual activity 20 1,700 meals served 1,800 meals served %24 2. 67 a. What is the activity variance for revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the activity variance for revenue 1,615 F ces b. What is the spending variance for the cost of ingredients? (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero variance). The amount of the spending variance for the cost of ingredients c. What is spending variance for wages and salaries? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). nces The amount of the spending variance for wages and salaries d. What is spending variance for total expenses? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). The amount of the spending variance for total expenses 90
Expert Answer:
Answer rating: 100% (QA)
answered this a Revenue Activity Variance 165000 F Budgeted R... View the full answer
Posted Date:
Students also viewed these accounting questions
-
At Stevens Manufacturing, workers are organized in teams that combine their efforts to produce complex units of a final product. Stevens is using a facility layout known as a(n): consolidated process...
-
1. Use these data to answer Questions 1a and 1b. These data are saved as Chapter 5 Data Set 2. 1. Compute the Pearson product-moment corre- lation coefficient by hand and show all your work. 2....
-
From the data in your exam-grade table in Test Yourself Question 1, illustrate each of the rules mentioned in this appendix. Be sure to point out an instance where the marginal grade falls but the...
-
The maker of a $10,000, 8%, 90-day note receivable failed to pay the note on the due date of June 30. What accounts should be debited and credited by the payee to record the dishonored note...
-
Explain the rationale underlying volume consolidation. What are the risks associated with using a single supplier for an item?
-
Presented below is information related to Farr Company. Retained earnings, December 31, 2010 ............. $ 650,000 Sales ........................... 1,400,000 Selling and administrative expenses...
-
As a customer, think back to a recent sales presentation that you felt went well. What made it good? What did the salesperson do (or not do) that most impressed you? Did you buy the product or...
-
How might the outcome of this case have been different if Cameron had been merely an aircraft parts supplier, with his only profit to be from the sale of components to Anderson?
-
The production function is Y (K, L) = K 1/3 L 2/3. The savings rate is 25%(.25), the depreciation rate is 1% (0.1). What is the law of motion?
-
Kathy wants to buy a condominium selling for $95,000. The taxes on the property are $1500 per year, and homeowners insurance is $336 per year. Kathys gross monthly income is $4000. She has 15 monthly...
-
Interpersonal Communication Approaches to Handling Conflict (CH 9) and Cultural Influences on Communication (CH 5) Paragraph 1-5: Describe & cite each of the Approaches to Handling Conflict (also...
-
Compute the Cost of Goods Manufactured and Cost of Goods Sold for South Marine Company for the most recent year using the amounts described next. Assume that Raw Materials Inventory contains only...
-
Prepare Sally Jensen's 2022 tax return in Profile. Submit the entire return in one PDF file. Information relating to Sally's tax return: 1. Sally is married to Peter Jensen. 2. Peter has net income...
-
Using the comparison calculator between a Roth IRA and a regular IRA found at a web based calculator decide whether an individual with the following data is better off with a regular IRA or a Roth...
-
Journalize the transactions for the year of 2. Post transactions to T-accounts to determine the December 31, , balances related to the investment and investment income accounts. 3. Prepare 's partial...
-
Due to its experience rating, Ianelli, Inc., is required to pay unemployment taxes on its payroll as follows: 1. Under SUTA for Massachusetts on taxable payroll of $17,700, the contribution rate is...
-
H was a participant at a programming event last month. The speaker at the event stated that Polymorphism promotes extensibility. In order to explain how this is possible, the speaker should state all...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
Holland at Home is considering introducing a variation of its current breakfast cereal, Zonnatura Regular Muesli Rich. The new cereal will be similar to the old with the exception that it will...
-
TSMC Corporation is considering selling one of its old wafer fabrication machines. The machine, purchased for \($3,000,000\) 5 years ago, had an expected life of 10 years and an expected salvage...
-
Assume that Fiskars Finland plans to invest in a new project that will annually generate revenues of \($2.3\) million. Cash expenses including both fixed and variable costs will be \($950,000,\) and...
Study smarter with the SolutionInn App