please help so lost
Week 6 Homework-Prince-Excel PAGE LAVOUT FORMULAS DATA REVIEW VEW FILE OME INSERT Cut 11 A A Wrap Text Calibei EB Insert Delete Format Copy Paste Conditional Format as Cell - A EE Merge & Center $%. BIU Format Painter Formatting Table Styles Number Styles Cells Clipboard font Alignment B8 X A C D E G H J K L M Materials Variances. Sweets Company produces boxes of chocolate. Sweets purchased 4,000 pounds of chocolate during the month of April for $4.80 per pound. A standard of 2 pounds of material is expected to be used for each box produced, at a cost of $5 per pound. Sweets produced 1,000 boxes of chocolate during the month of April and used 2,200 pounds of chocolate. 2 Required: 3 Calculate the materials price variance for the month of April. 4 Calculate the materials quantity variance for the month of April. 6 7 STD Actual DM Materials Price s per unit Actual Quantity Purchased Actual Price Standard Price ) 8 Variance S per #Purchased 10 11 # Used 12 Sper Unit Units Prod Materials Quantity Variance Standard Price Actual Quantity Used Standard Quantity) x 13 14 Week 6 Homework-Prince-Excel FILE ME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut A A Wrap Text Calibri 11 p Copy Conditional Format as Formatting Table Styles Styles Cell Insert Delete Form Paste BIU A- Merge & Center Format Painter Font Cells Clipboard Alignment Number X f B8 A B C D E F G H K M 3 Calculate the materials price variance for the month of April. 4 Calculate the materials quantity variance for the month of April. 5 6 7 STD Actual Materials Price DM Rs per unit Actual Quantity Purchased ( Actual Price Standard Price) X Variance S per # 10 #Purchased 11 Used 12 5 per Unit Materials Quantity Variance Units Prod Standard Price (Actual Quantity Used Standard Quantity) 13 14 15 16 17 18 19 10-19 20 10-21 22 23 24 10-27 10-29 30 31 32 33 10-36 Quiz Type Quiz Type 2 READY