Help with B on the bottom please

Phoenix Company's 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of16,000 units. PHOENIX COMPANY Fixed Budget Report For Year Ended December 31. 2019 Sales $3,600,000 Cost of goods sold Direct materials $960,000 Direct labor 240,000 Machinery repairs (variable cost) 64,000 DepreciationPlant equipment (straightline) 315,000 Utilities ($48,000 is variable) 198,000 Plant management salaries 230,000 2,007,000 Gross profit 1,593,000 Selling expenses Packaging 80,000 Shipping 112,000 Sales salary (fixed annual amount) 260,000 452,000 General and administrative expenses Advertising expense 133,000 Salaries 251,000 Entertainment expense 100,000 484,000 Income from operations $ 657,000 Phoenix Company's actual income statement for 2019 follows. PHOENIX COMPANY Statement of Income from Operations For Year Ended December 31, 2019 Sales (19,000 units) $4,338,000 Cost of goods sold Direct materials $1,156,000 Direct labor 293,000 Machinery repairs (variable cost) 67,000 DepreciationPlant equipment (straightline) 315,000 Utilities (fixed cost is $147,500) 203,750 Plant management salaries 240,000 2,274,750 Gross profit 2,063,250 Selling expenses Packaging 92,000 Shipping 126,000 Sales salary (annual) 276,000 494,000 General and administrative expenses Advertising expense 141,000 Salaries 251,000 Entertainment expense 103,000 495,000 Income from operations $1.074.250 Requhed: 1. Prepare a flexible budget performance report for 2019. (Indicate the effect of each variance by selecting for favorable, unfavorable, and No variance.) b. The production supervisor is implementing some changes to production that are expected to improve the materials quantity variance. With these changes, the supervisor believes that their unfavorable quantity variance would have been only half (50%) what it was. HINT: Use MQV = (SQ-AQ)SP; Set MQV to 50% of the quantity variance from 2c. Use the AQ and SP from 2c and solve for Actual Quantity to achieve the desired variance. This will be total quantity of raw material. Divide this quantity by the number of finished goods units produced/sold to express this as POUNDS PER UNIT (ONE UNIT) of finished goods". Management wants to use this as their new standard for next year. Include this in the standard cost card below2) With respect to direct material, calculate the following relating to their operating results for the year. a) Assume Phoenix Company paid an average of $15.00 (actual price, AP) a pound for its raw material during the year. How many pounds of raw material did they use? Hint: Actual direct material expenses (connect income statement) divided by 15. Round to the nearest whole number of pounds. Use this as your actual quantity, AQ, for the calculation of DM variances below. Direct materials per income statement 1,156,000 Divided by cost of direct materials per pound 15 Actual quantity of direct materials used 77,067 pounds b) Using the standard cost card and the flexible budget, how many pounds should Phoenix Company have used? Round to the nearest whole number of pounds. Use this as standard quantity, SQ, for the calculations of DM variances below. Actual numbers of units sold 19,000 Multiplied by standard pounds per unit sold 4 Standard quantity of direct materials to be used 76,000 c) Complete the following table to calculate the direct material price and quantity variances. Direct Material Variances Actual Cost Standard Cost AQ X AF AQ X SP SQ X SP 77,067 x 15 19,000.00 X 50.00 76,000 x 15 1.156,000 1,156,000 1.140,000 (16,000.00) 180,000.00) Favorable/Unfavorable Direct material price variance 0 Direct material quantity variance 16,000 unfavorable Total direct material variance 16,000 Unfavorable