Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me fill in the chart and answer the last question this is all the given information for this assignment please help as much
please help me fill in the chart and answer the last question
this is all the given information for this assignment please help as much as possible
You are excited about your future prospects. You created budgets three months ago and now it is time to ease your actual costs and volume against your budgets. You decide to evaluate direct materials and direct labor variances to measure actuals against ist Quarter budget. The tables below depict the actuals for January February, and March. Perform direct materials and direct labor evaluations and discuss what may be causing any variances Sales Actuals Actual sales Actual, average selling price per donen Actual direct material cost Actual direct labor cost Total Sales revenue QI 37,000 5 15.64 $ 201, 15489 $65.057.93 5578.680.00 Favorable/ Analysis Standard Formula Answer What does the Unfavorable Sample Actual Price X Actual Quantity Sxxx.00 Direct Materials Price Varances Direct Materials Quantity Variances Direct Labor Hate Variance Mies Boken Packers Direct Labor Time Variance Mixers Sakers Packers I The Direct Labor Rate Variance and the Direct Labor Time Variance are a summation of the mixers, balens, and packers Production Actual Budgeted sales Desired Ending Inventory Total Units Needed Less Beve Inventory Required Production 91 37 000 411 37411 (180 37,031 Sales Actuals Actual sales Actual, average selling price per dozen Actual direct material cost Actual direct labor cost Total Sales revenue Q1 37,000 $ 15.64 $ 203,354.80 $ 65,057.93 $ 578,680.00 Production Actuals Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production Q1 37,000 411 37,411 (380) 37,031 Materials Actuals Q1 37,031 Required production Raw materials needed Material Flour Butter Sugar Eggs Milk Cocoa powder Amt per dz 0.75 0.25 0.57 0.17 0.09 0.25 27,773 9,258 21,108 6,172 3,333 9,258 Materials Actuals Q1 37,031 Required production Raw materials needed Material Flour Butter Sugar Eggs Milk Cocoa Powder Chocolate icing Bakery box Amt per dz 0.75 0.25 0.57 0.17 0.09 0.25 0.75 1.00 27,773 9,258 21,108 6,172 3,333 9,258 27,773 37,031 Material Flour Butter Sugar Eggs Milk Cocoa Powder Chocolate icing Bakery box Total Cost per unit $ 1.55 $ 43,124.69 $ 0.84 $ 7,742.71 $ 1.13 $ 23,892.78 $ 0.82 $ 5,078.22 $ 1.66 $ 5,543.43 $ 2.95 $ 27,336.74 $ 1.88 $ 52,190.72 $ 1.04 $ 38,445.49 $ 203,354.80 $ 5.50 Labor Actuals Q1 D2/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 Favorable/ Analysis Standard Formula Answer What does this tell us? Unfavorable Sample Actual Price X Actual Quantity SXXX.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. You are acted about your ordboget three months ago and now time to me you to send volume against your budgets you decide direct materih dired tabor variances to meet tutor budget. The table below depict the yearyd Mari Perfordrer directorations and what may be causing any variance Favorable / Underable What does the tellus? Standard Formula Anner Actual Price Alvalanty Soc.00 Anali Sample Dret Mars Price Varan Best Mas Quantity Varance Directorate Maar Attuale Antwerpen Actual del Actul directo con 10 11 12 13 Production Actual 91 37.000 5 15.64 $201. 1540 $65.0579 $57.00 Packers Direct Lib Te Varunca Mars B Pachers 1. Direct laborate variance and the Dreabor Time Warnemation of the makers and packers 15 Dates 24 Desire Eninger Total United 18 Being story 19 Required Production 20 25 22 More Actual 01 17.000 411 17411 03600 37,031 Qi 17,031 24 Required production Sales Actuals Anal Actual sales Actual, average selling price per dozen Actual direct material cost Actual direct labor cost 5) Total Sales revenue Q1 37,000 $ 15.64 $ 203,354.80 $ 65,057.93 $ 578,680.00 Sam Direc Direc Direc N E F Direc N E p 3 Production Actuals 1 Budgeted Sales Desired Ending Inventory Total Units Needed 3 Less: Beginning Inventory 3 Required Production 1. Th Q1 37,000 411 37,411 (380) 37,031 7 1 2 Materials Actuals Required production Q1 37,031 Raw materials needed Material 3 Flour Butter Sugar Eggs 2 Milk Cocoa Powder Chocolate icing Bakery box Amt per dz 0.75 0.25 0.57 0.17 0.09 0.25 0.75 1.00 27,773 9,258 21,108 6,172 3,333 9,258 27,773 37,031 Material Cost per unit 22 Materials Actuals 23 Q1 24 Required production 37,031 25 26 Raw materials needed 27 Material Amt per dz 28 Flour 0.75 27,773 29 Butter 0.25 9,258 30 Sugar 0.57 21,108 31 Eggs 0.17 6,172 32 Milk 0.09 3,333 33 Cocoa Powder 0.25 9,258 34 Chocolate icing 0.75 27,773 35 Bakery box 1.00 37,031 36 37 Material Cost per unit 38 Flour $ 1.55 $ 43,124.69 39 Butter $ 0.84 $ 7,742.71 40 Sugar $ 1.13 $ 23,892.78 41 Eggs $ 0.82 $ 5,078.22 42 Milk $ 1.66 $ 5,543.43 43 Cocoa Powder $ 2.95 $ 27,336.74 44 Chocolate icing $ 1.88 $ 52,190.72 45 Bakery box $ 1.04 $ 38,445.49 46 Total $ 203,354.80 $ 5.50 47 48 49 Labor Actuals 50 Q1 51 Dz/HT Actual Time Hrly Rate 37,031 52 Mixers 32 1157.22 $ 15.00 $17,358.33 53 Bakers 18 2057.28 $ 16.50 $33,945.19 54 Packers 35 1058.03 $ 13.00 $13,754.41 55 Total $ 65,057.93 56 Actual time based on 1st quarter Required Production listed on this tab 57 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