70.2K

Verified Solution

Link Copied!

Can you help me fill in the white cells on the blue picture?

Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2017 MyArmor, Inc Set Input Values Back to Original Amounts As of Dec. 31 2016 Applies to All Qtrs. Quarter in the 2017 Planning Year 1st Quarter Fix the Format of All Yellow Cells in 2017 1st 2nd 3rd 4th of 2018 Sales Budget Sales in Units Average Selling Price per Unit Cash Colleerion Pattern for Sales in the: 1st Quarter 14,000 units 530 per unn 60% 12,000 units 528 per uni 10% 4096 18,000 units S34 per unit 18,000 units S34 per unit 2nd 70% Remainder 3rd Quarter 4th Quarter Production Bud 3,000 units Finished Units in Inventory as of 1231/16 (the prior Forecasted Sales in Units st Quarter of 2018 (n ycar) 16,000 units % of the Next Qtr.'s Sales in Units to Have in This Qtr.'s Ending Inventory Raw Materials Budget 10 oz Ounces of PlasticSteel Powder (PsP) Required per Finished Unit ired" Have in This Qrs Ending Invetory % nr Next Qtr. 's "Ounces of Ps P R 20% 30% 30% 20% Ounces of PsP in Raw Materials Inven as of 123116 (the priory 15,000 oz 130,000 z Forecasted "Ounces of PsP Required" in the 1st Qtr of 2018 (next year) Cost of PsP per Ounce Cash Payment Pattern for PsP Purchased in the 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $1.20 per oz 1.10 per oz 30% 50% S1.10 per o2 $1.20 per oz 30% 80% Remainder Direct Labor Bud Direct Labor Hours (hrs) per Finished Unit Avcrage Cost of a Direct Labor Hour 0.20 hrs S18 per hour 318 per bor S20 per hour $20 per hour Manufacturing Overhead Budget vanable Overhead Cost Rate per Direct Labor Hour (DLH) . Total Fixed Manufacturing Overhcad Cost per Quarter 8 per DLH S50,000 59,000 r Quarter Included in Fixed Manu

Answer & Explanation Solved by verified expert

See Answer