Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use excel spreadsheet to show calculations. thank you Simon Company had the following information available Budgeted Costs The budget was to manufacture and sell
Please use excel spreadsheet to show calculations. thank you
Simon Company had the following information available Budgeted Costs The budget was to manufacture and sell 6.200 units Direct Materials: 4 pounds per unit Direct Labor: 1.5 hours per units $2.00 per pound $15 per hour The company sold 5,000 units and had the following costs: Direct Materials: 19,500 pounds that cost 541,490 Direct Labor: 8,000 hours that cost $118.900 Required 1. Calculate the amount actually spent on direct materials 2 Calculate the flexible budget for direct materials 3. Calculate the amount of the flexible budget for direct materials 4. Is the flexible budget variance for direct materials favorable or unfavorable? 5. Calculate the amount of the price variance for direct materials 6. the price variance on direct materials favorable or unfavorable? 7. Calculate the amount of the efficiency variance on direct materials 8. Is the efficiency variance on direct materials favorable or unfavorable 9. Calculate the flexible budget variances for direct materials and direct labor 10. Calculate the amount of the flexible budget for direct materials 11. Is the flexible budget variance for direct materials favorable or unfavorable? 12 Calculate the amount of the price variance for direct materials 13. If the price variance on direct materials favorable or unfavorable? 14. Calculate the amount of the efficiency variance on direct materials 15. Is the efficiency variance on direct materials favorable or unfavorable? 16. Calculate the flexible budget variances for direct materials and direct labor Problem 3: Write Your Answers Here Answe Question 1. Actual Cost of Direct Materials 2. Flexible Budget for Direct Materials 3. Flexible Budget Variance for Direct Materials 4. Flex Budget Variance on DM- Favorable or Unfavorable 5. Price Variance on Direct Materials 6. Price Variance-Favorable or Unfavorable 7. Efficiency Variance on Direct Materials 8. Efficiency Variance - Favorable or Unfavorable 9. Actual Cost of Direct Labor 10. Flexible Budget for Direct Labor 11. Flexible Budget Variance for Direct Labor 12. Flex Budget Variance on DL - Favorable or Unfavorable 13. Price Variance on Direct Labor 14. Price Variance-Favorable or Unfavorable 15. Efficiency Variance on Direct Labor 16. Efficiency Variance - Favorable or Unfavorable ConclusionStep 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