I need help with my master budget project.

INPUT

SALES

Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Set Input Values Back to Original Amounts As of Dec. 31 2020 Applies to All Qtrs. in 2021 Fix the Format of All Yellow Cells Quarter in the 2021 Planning Year 2nd 3rd 1st Quarter of 2022 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 10,000 units $30 per unit 60% 18,000 units $34 per unit 12,000 units $28 per unit 10% 40% 18,000 units $34 per unit Remainder Remainder 70% Remainder 80% Remainder 3,000 units Production Budget Finished Units in Inventory - as of 12/31/2020 (the prior year) Forecasted Sales in Units - 1st Quarter of 2022 (next year) % of the Next Qtr.'s Sales in Units to Have in This Qtr.'s Ending Inventory 16,000 units 30% 10 oz 20% 30% 30% 20% 15,000 oz Raw Materials Budget Ounces of Plastic Steel Powder (PSP) Required per Finished Unit % of Next Qtr.'s "Ounces of Psp Required to have in This atr's Ending Inventory Ounces of Psp in Raw Materials Inventory - as of 12/31/2020 (the prior year) Forecasted Ounces of PsP Required in the 1st Qtr of 2022 (next year) Cost of Psp per Ounce Cash Payment Pattern for Psp Purchased in the 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 130,000 oz $1.20 per az 40% $1.20 per oz $1.10 per oz 30% 50% $1.10 per oz Remainder 30% 80% Remainder Remainder 70% Remainder Direct Labor Budget Direct Labor Hours (hrs) per Finished Unit Average Cost of a Direct Labor Hour 0.20 hrs $18 per hour $18 per hour $20 per hour $20 per hour Manufacturing Overhead Budget Variable Overhead Cost Rate per Direct Labor Hour (DLH) Total Fixed Manufacturing Overhead Cost per Quarter Depreciation per Quarter Included in Fixed Manufacturing Overhead $8 per DLH $50,000 $ $9,000 Finished Goods Inventory Budget No Required Input Data Inputs (Assumptions) for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Set Input Values Back to Original Amounts As of Dec. 31 2020 Applies to All Qtrs. in 2021 Fix the Format of All Yellow Cells Quarter in the 2021 Planning Year 2nd 3rd 1st Quarter of 2022 1st 4th Cost of Goods Sold Budget Only Required Input Data is on the Prior Year Balance Sheet below $6 per unit Selling, General and Administrative (SG&A) Budget Variable SG&A Cost per Unit Sold Advertising Fixed Cost Salary Fixed Cost Mall Kiosk Rental Fixed Cost Utilities Fixed Cost Property Taxes Depreciation $5,000 $40,000 $1,000 $1,000 $0 $12,000 $5,000 $40,000 $1,000 $1,000 $12,000 $12,000 $15,000 $45,000 $2.000 $2,000 $0 $13,000 $15,000 $45,000 $2,000 $2,000 $12,000 $14,000 $0 $0 $10,000 $10,000 Cash Budget Equipment Purchases Dividends per Quarter Annual Interest Rate Charged by the Bank on the Bank Loan $15,000 6% Income Statement No Required Input Data Prior Year Balance Sheet as of Dec. 31, 2020 Cash Accounts Receivable Raw Material Inventory Finished Goods Inventory Property, Plant & Equipment, gross Accumulated Depreciation Total Assets $ $24,000 $125,000 $18,000 $60.000 $723,000 (S260,000) $690,000 Accounts Payable Bank Loan Common Stock Retained Earnings Total Liabilities & Equity $28,000 $60,000 $160,000 $442,000 $690.000 Sales Budget - for the Profit Planning Year Jan. 1 to Dec. 31, 2021 MyArmor, Inc. Test My Budget Quarter in the 2021 Planning Year 2nd 3rd 1 st 4th Full Year Total