filling the excel

Production Budget - for the Profit Planning Year Jan 1 to Dec 31, 2023 MyArmor, Inc. Test My Budget B A Quarter in the 2023 Planning Year 2nd 3rd 151 Full Year Total Units 4th All Units are Finished Units (Finished Cell Phone Covers) Sales in Units (from Sales Budget) plus Units Needed in Ending Inventory Jess Units Available from Beginning Inventory () Finished Units to Produce Check Amounts - 13.000 units 12,000 units Fix the Format of All White Cells 15,600 units 17.200 units 4 Incorrect Check Amounts Blank Multiple Choice Questions) Answer Multiple Choice Questions 1. Using the data in the simple example on Pg 1 of the Production Budget pdf document. what would be Finished Units to Produce if Units in Beginning Inventory were 35 rather than 202 A 110 B. 100 C. 90 D. 80 2. Which one of the following statements in correct? A Total Dollar Sales on the Sales Budget is an input to the Production Budget B. Finished Units to Produce on the Production Budget will be an input to the Direct Labor Budget C Finished Units to Produce on the Production Budget will be an input to the Cash Budget D. Nore of the above statements are correct Answer: Sa Vs Back to Original Amounts Fit the Tom of Yew Celle As of Dec. 31 2022 Applies to All Otrs. In 2023 Quarter in the 2023 Planning Year 2nd 3rd 1st Quarter of 2024 1st 4th Sales Budget Sales in Units Average Selling Price per Unit Cash Collection Pattern for Sales in the 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 12.000 units $26 per unit 40% 18.000 units $28 per un 2.000 units $30 par unit 20% 40% 14.000 rs $26 per unit Remainder 30% 70% Reminder Reminder BOX Reminder Production Budget Finished Units in Inventory as of 12/31/2022 (me prior year) 3.000 units Forecasted Sales in Units - 1st Quarter of 2024 (next year of the Next Qu's Sales in Units to Have in This Ons Ending Inventory 55.000 40% 10 20% 30% 2016 10% 15.000 110.000 Raw Materials Budget Ounces of Plastic Steel Powder (PP) Required per Finished Unt Soros Ounces of Pip Required to Have in this ars Ending invention Ounces of Psp in Raw Materials inventory - as of 12/31/2022 the prior year Forecasted Ounces of PoP Required in the 1st or of 2024 (next year) Cost of PsP per Ounce Cash Payment Pattern for PSP Purchased in the 1st Quarter 2nd Quarter Jid Quarter 4th Quarter 51. 10 per 2 $1.10 pero 40% $1.10 per az 30% 40% $1 10 per az Reminder Remainder 70% Remainder BON Red