Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve using excel include formulas in your answer please and thank you. Fill in all of the ? please. D E F G Standard
Please solve using excel include formulas in your answer please and thank you. Fill in all of the ? please.
D E F G Standard Price $4.00 per pound $22.00 per hour $6.00 per hour Actual price $3.80 per pound $21.60 per hour 1 Chapter 10: Applying Excel 2 3 Data 4 Exhibit 10-1: Standard Cost Card 5 Inputs Standard Quantity 6 Direct materials 3.0 pounds 7 Direct labor 0.50 hours 8 Variable manufacturing overhead 0.50 hours 9 10 Actual results: 11 Actual output 2,000 units 12 Actual variable manufacturing overhead cost $7,140 13 Actual Quantity 14 Actual direct materials cost 6,500 pounds 15 Actual direct labor cost 1,050 hours 16 17 Enter a formula into each of the cells marked with a ? below 18 Main Example: Chapter 10 19 20 Exhibit 10-4: Standard Cost Variance Analysis-Direct Materials 21 Actual Quantity of Input, at Actual Price ? pounds 22 Actual Quantity of Input, at Standard Price ? pounds 23 Standard Quantity Allowed for the Actual Output, at Standard Price ? pounds 24 Direct materials variances: 25 Materials price variance ? 26 Materials quantity variance ? 27 Materials spending variance ? 28 29 Exhibit 10-6: Standard Cost Variance Analysis-Direct Labor 30 Actual Hours of Input, at Actual Rate ? hours 31 Actual Hours of Input, at Standard Rate ? hours * 32 Standard Hours Allowed for the Actual Output, at Standard Rate ? hours x 33 Direct labor variances: 34 Labor rate variance ? 35 Labor efficiency variance ? 36 Labor spending variance 37 38 Exhibit 10-8: Standard Cost Variance Analysis-Variable Manufacturing Overhead 39 Actual Hours of Input, at Actual Rate ? hours 40 Actual Hours of Input, at Standard Rate ? hours * 41 Standard Hours Allowed for the Actual Output, at Standard Rate ? hours x 42 Variable overhead variances: 43 Variable overhead rate variance ? 44 Variable overhead efficiency variance ? 45 Variable overhead spending variance ? ? per pound = ? per pound ? per pound ? ? ? ? per hour ? per hour = ? per hour ? ? ? ? per hour = ? per hour ? per hourStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started