Ans:
a
Activity variance for revenue =Actual revenue-Planning budgeted
revenue= (1800*16.50)-(1700*16.50)=1650
F
b
Spending variance for the cost of ingredients =
Actual Cost of Ingredients-Budgeted cost for actual
meals served= 11140-(1800*6.25)=110 F
c
Spending variance for wages and salaries =Actual Cost of
wages and salaries-Budgeted cost =10640-10400=240
U
d
Actual total expenses =11140+10640+1170+220+2005=27155
27155
Flexible budget total expenses =
(1800*6.25)+10400+800+(1800*0.2)+2200+600+(1800*0.8)=27050
27050
Spending variance for total expenses = 27155-27050=105
U
Chapter 9 Applying Excel (B) Saved Requirement 2: Revise the data in your worksheet to reflect...
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: Chapter 9: Applying Excel Data Revenue $16.50 q Cost of ingredients $6.25 q Wages and salaries $10,400 Utilities $800 + $0.20 q Rent $2,200 Miscellaneous $600 + $0.80 q Actual results: Revenue $29,445 Cost of ingredients $11,425 Wages and salaries $10,605 Utilities $1,190 Rent $2,200 Miscellaneous $2,045 Planning budget activity 1,700 meals served Actual activity 1,800 meals served a. What is the activity...
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: 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)). b. What is the spending variance for the cost of ingredients? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance))....
revise the data in your worksheet to reflect the results for the subsequent period as shown below: 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)). b. What is the spending variance for the cost of ingredients? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance))....
Chapter 10: Applying Excel: Exercise (Part 2 of 2) Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A 1 Chapter 10: Applying Excel 3 4 Data Exhibit 10-1: Standard Cost Card Inputs 6 Direct materials Standard Quantity 3.0 pounds 0.50 hours 0.50 hours Standard Price 4.00 per pound 22.00 per hour 6.00 per hour 7 Direct labor Variable manufacturing overhead 8 9 10 Actual results: 11 Actual output Actual...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: Chapter 10: Applying Excel M Data Exhibit 10-1: Standard Cost Card Inputs Direct materials Direct labor Variable manufacturing overhead 6 Standard Quantity 3.0 pounds 0.50 hours 0.50 hours $ $ $ Standard Price 4.00 per pound 22.00 per hour 6.00 per hour 8 10 Actual results: Actual output Actual variable manufacturing overhead cost 12 $ 13 14 2,050 units 6,526.50 Actual...
Chapter 9: Applying Excel $16.50 9 $6.25 9 Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $0.20 g $10,400 $800 $2,200 $600 $0.80 g Actual results: Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $27.920 $11,110 $10,130 $1.080 $2,200 $2,240 Planning budget activity Actual activity 1.800 meals served 1,700 meals served Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget Construct a flexible...
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Chapter 09: Applying Excel Data Exhibit 9-8: Standard Cost Card Inputs Standard Quantity Standard Price Direct materials 3.0 pounds $4.00 per pound Direct labor 0.50 hours $22.00 per hour Variable manufacturing overhead 0.50 hours $6.00 per hour Actual results: Actual output 2,040 units...
Check my work TB Problem Qu. 9-389 Bickel Corporation uses customers served as... Bickel Corporation uses customers served as its measure of activity. The following report compares the planning budget to the actual operating results for the month of November: Bickel Corporation Comparison of Actual Results to Planning Budget For the Month Ended November 30 Actual Planning Budget 34,000 Variances Results Customers served Revenue ($3.50q) Expenses: Wages and salaries ($23,400 + $1.24q) Supplies ($0.64q) Insurance ($5,300) Miscellaneous expense ($4,300 +...
Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element per Month Variable Element per Customer Served Actual Total for May Revenue $ 5,700 $ 209,500 Employee salaries and wages $ 64,000 $ 1,100 $ 106,400 Travel expenses $ 560 $ 19,000 Other expenses $ 43,000...