Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are excited about your future prospects. You created budgets three months ago and now it is time to measure your actual costs and volume
You are excited about your future prospects. You created budgets three months ago and now it is time to measure your actual costs and volume against your budgets. You decide to evaluate direct materials and direct labor variances to measure actuals against 1st Quarter budgets. Perform direct materials and direct labor evaluations and discuss what may be causing any variances.
Materials Actuals | |||||
Q1 | |||||
Required production | 37,031 | ||||
Raw materials needed | |||||
Material | Amt per dz | ||||
Flour | 0.75 | 27,773 | |||
Butter | 0.25 | 9,258 | |||
Sugar | 0.57 | 21,108 | |||
Eggs | 0.17 | 6,172 | |||
Milk | 0.09 | 3,333 | |||
Cocoa Powder | 0.25 | 9,258 | |||
Chocolate icing | 0.75 | 27,773 | |||
Bakery box | 1.00 | 37,031 | |||
Material | Cost per unit | ||||
Flour | $ 1.55 | $ 43,124.69 | |||
Butter | $ 0.84 | $ 7,742.71 | |||
Sugar | $ 1.13 | $ 23,892.78 | |||
Eggs | $ 0.82 | $ 5,078.22 | |||
Milk | $ 1.66 | $ 5,543.43 | |||
Cocoa Powder | $ 2.95 | $ 27,336.74 | |||
Chocolate icing | $ 1.88 | $ 52,190.72 | |||
Bakery box | $ 1.04 | $ 38,445.49 | |||
Total | $ 203,354.80 | $ 5.50 | |||
Labor Actuals | |||||
Q1 | |||||
Dz/Hr | Actual Time | Hrly Rate | 37,031 | ||
Mixers | 32 | 1157.22 | $ 15.00 | $ 17,358.33 | |
Bakers | 18 | 2057.28 | $ 16.50 | $ 33,945.19 | |
Packers | 35 | 1058.03 | $ 13.00 | $ 13,754.41 | |
Total | $ 65,057.93 | ||||
*Actual time based on 1st quarter Required Production listed on this tab |
|
Please answer the chart below
Analysis | Standard Formula | Answer | Favorable / Unfavorable | What does this tell us? |
Sample | Actual Price X Actual Quantity | $XXX.00 | ||
Direct Materials Price Variances | ||||
Direct Materials Quantity Variances | ||||
Direct Labor Rate Variance | ||||
Mixers | ||||
Bakers | ||||
Packers | ||||
Direct Labor Time Variance | ||||
Mixers | ||||
Bakers | ||||
Packers | ||||
1. The Direct Labor Rate Variance and the Direct Labor Time Variance are a summation of the mixers, bakers, and packers.
|
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