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...
-
XM, Ltd. was a small engineering firm that built high-tech robotic devices for electronics manufacturers. One very complex device was partially completed at the end of 2015. Barb McLauren, head...
-
Which of the following would likely encourage a firm to increase the debt in its capital structure? a. The corporate tax rate increases. b. The personal tax rate increases. c. Due to market changes,...
-
Repeat Problem 15.D12 but for \(\mathrm{q}=0.0015 \mathrm{~m}^{2} / \mathrm{s}\). a. Determine film thickness \(\delta\), average vertical velocity of film, and Reynolds number. b. Determine average...
-
The unadjusted trial balance for Sierra Corp. is shown in Illustration 4-4. In lieu of the adjusting entries shown in the text at October 31, assume the following adjustment data. 1. Advertising...
-
Extra Problem In 2010, the census reported that 8.7% of the citizens in Cobb County were senior citizens (65 years of age or older). A developer who builds communities for senior citizens wants to...
-
Hank has a 30% interest in KKC LLC, a calendar year entity. At the beginning of the year, Hank had an outside basis in KKC of $60,000 which included his $10,000 share of KKC liabilities. On July 1st,...
-
A local dealer sells baseballs for $25.00 each. If this is a 76.7% markup on cost, find the equivalent markup percent on the selling price
-
The statement of financial position of Corona Ltd shows total assets as at 30 June 2022 which include Cash $87,000, Inventories $65 000, Furniture $57 000, Office Equipment $465 000 (Accumulated...
-
Anna's preferences can be represented by the utility function with marginal rate of substitution MRS(x,y) = 3x+4 2y For each of the given parameter values below, determine whether the listed bundle...
-
Comparative financial statement data for Sunland Corporation and Marigold Corporation, two competitors, appear below. All balance sheet data are as of December 31, 2022. Sunland Corporation Marigold...
-
During the current year, Ron and Anne sold the following assets: (Use the dividends and capital gains tax rates and tax rate schedules.) Capital Asset L stock M stock N stock 0 stock Antiques Rental...
-
Sharp Co. manufactures table saws. Sharp has a contractwith Home Depot whereby Home Depot agrees to sell Sharp table saws.There is an insuring requirement in the contract that runs to HomeDepots...
-
The Basquin fatigue constants for high-cycle-fatigue for high-strength AISI 4142 steel are given as of = 1937 MPa and b = -0.076. A bar made of this material is subjected to uniaxial cyclic loading...
-
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...
-
Determine the quick ratio for the commercial construction company in Figures 6-1 and 6-2 . What insight does this give you into the companys financial operations? Data From Figures 6-1 Figure 6-2...
-
In 2010, your company purchased a front-end loader for \($150,000,\) a dump truck for \($85,000,\) and a dumping trailer (pup) for the dump truck for \($38,000.\) The front-end loader was placed in...
-
For the current tax year, what are the maximum Section 179 deductions and the amount where Section 179 begins to be phased out?
Study smarter with the SolutionInn App