develop a manufacturing budget using an excel spreadsheet

Projected Sales Budget 2021 Quan Expected Unt Sales 10000 147000 14.000 5000 Unit Sling Price 78 18 76 Total Sales 780,000 1.082.000 1.092.000 1.200.000 4.212.000 Additional information for the Production Budget 1 Beginning Fished Goods Inventory in una for Q1 2021 is 500 units 2 Each quarter's Finished Goods Inventory should contan 5% of the following quarter's Expected Unt Sales Estimated Q1 2022 Expected Units are people to be 10.000 Additional Information for the Direct Materials Budget 1 There are 3 pounds of direct mater per une offreshed goods 2 18% of the nest quarter's production materials are required to be an ending direct materials inventory 324.000 pound material we estimated to be needed for Q1 2022 production Beginning inventory for Q1 2021 was 3.0 pounds of direct materials 5 Total cost per pound of direct materiale $4.00 Additional information for the Direct Labor Budget 1 There are 1.75 hours of direct labor needed to produce come unto finished goods 2 Direct laboris 518.25 per hour Additional information for the Manufacturing Overhead Budget 1 Variable Com a Indirect Materials (51 40 hou Indirect Labor $1.20 hour) ce $0401hour) & Maintenance (30 hour) 2 Find out Supervisory Salaries $27.000 per quarter Depreciation $10,500 per quan c. Property taxes and we 59.295 per quarter d. Maintenance $11.450 per quarter Manufacturing Overhead is led to production on the basis of direct labor hours Seton Manufacturing Projected SG&A Expense Budget 2021 Quarter 1 2 4 Ver Budgetled Unt Sales 10.000 14600 14.000 SRO 54.000 Variable Cost Sales Commission (1.30/unit) 30.000 46.200 46.200 52.00 178.200 Freight-out ($100 10,000 14.000 14.000 16.000 $4.000 Total variable cost 43.000 60.2001 232.200 Foxed Cost Adversaing 5.000 5.000 5.000 5.000 20.000 Sales Sales 15.000 15.000 15.000 15.000 0.000 Oflice Salaries 7.500 7.500 7500 7500 30.000 Depreciation 1,340 1.3 53 Property Taxes and inance 1500 1,500 1.500 Totale con 30 30 30 340 30.00 135 Total SOLA 7 200 SO SO Additional information for the income Statement 1 Interest Expense of $6.000 is expected to be eamed in 2021 2 Taxe is 30%