Question: I need help on this, please explain. Thank you . G PROBLEM following information is available for Coady's Chocolates: H Required: Provide input into cells

G PROBLEM following information is available for Coady's Chocolates: H Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the IF function to denote if each variance is Favorable or Unfavorable a. Calculate the direct materials price and quantity variances Actual production, boxes 3,400 Budgeted production, boxes 3,000 Direct materials standards Pounds of chocolate per box 3 Cost per pound $ 6.00 Actual direct materials Pounds of chocolate purchasec 9,000 Pounds of chocolate used 9,500 Cost per pound $ 6.10 AQ x AP S 54,900 AQ x SP 54,000 Direct Materials Price Variance $ 900 un AQ x SP 57,000 SQ - SP 61,200 Direct Materials Quantity Variance $ 4,200 fa b. What might have caused the variances you calculated? Coady's Chocolates appears to have purchased a higher quality chocolate at a lower price Direct Materials Price Variance 900 un AQ SP $ 57.000 SQ SP 61,200 $ Direct Materials Quantity Variance $ 4,200 fa b. What might have caused the variances you calculated? Coady's Chocolates appears to have purchased a higher quality chocolate at a lower price than the standard specified. The higher quality chocolate appears to have been processed better than the standard quality, requiring less chocolate complete the production run
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
