Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations. Calculate the material variances. Calculate the labor variances. Complete your
Based on the data presented in the Spreadsheet below (Variances tab), complete the following calculations.
- Calculate the material variances.
- Calculate the labor variances.
Complete your calculations by filling the in highlighted cells. Discuss your observations about the variances and ways to plan to improve any of the variances.
Cookie Business | |||
Actual Cost of Direct Materials | $ 225,000 | ||
Standard Cost of Direct Materials | $ 224,800 | ||
Actual Materials Used | 30 | ||
Standard Materials Used | 31 | ||
Actual Direct Labor Rate | $ 15.50 | ||
Standard Labor Rate | $ 15.00 | ||
Actual Hours Worked | 45 | ||
Standard Hours Worked | 40 | ||
Amount | Favorable/ Unfavorable | ||
Calculate Materials Variances: | |||
Materials Price Variance | |||
Materials Quantity Variance | |||
Calculate Labor Variances: | |||
Labor Rate Variance | |||
Labor Efficiency Variance |
Step 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