can someone help me out with part 4 and 5

4 Factory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, $#) 9. 5 Cost of making one unit next year Cost of one Lamp Kit Labor Cost Per Lamp Factory overhead per unit 9. 19. Total cost of one unit (Round to two places. $$###) 6 Selling and Admin Budget oil Fixed Selling Variable Selling (Round to two places, $#### Fixed Administrative Variable Administrative (Round to two places, $## ##) Total Selling and Administrative (Round to two places. $## ##) Cost of Goods 7 Sold Budget- Beginning inventory, Finished Goods Production Costs: Materials: Lamp Kits Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production Round dollars to two places. $ (9 Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory. Finished Goods Cost of Goods Sold STE Ink to Ink to Shape Math Convert Ink Repla Replay Touch Mode Drawing Tools fx H K D E Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45,00 Cost of Goods Sold $30.00 Gross Profit Selling Expenses Fixed Variable (Commission per unit) $3.00 Administrative Expenses Fored Variable @ $2.00 Total Selling and Administrative Expenses Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00 50,000.00 92.000.00 190,000.00 185.000.00 $ I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.00 67,500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 @ $18.00 0 3000 $30.00 $ 90.000.00 200.210.00 Fred Assets Equipment Accumulated Depreciation Total Fued Assets Total Assets $ 20,000.00 8,800.00 13.200.00 5213 410.00 5 54.000 54.000.00 Current Labies Accounts Payable Total Lates Glockholder's Equity Common Sauck Retained Earrings Total blockholders Equity Total Liabetes and Stockholder's Equity 5 12.000.00 147 41000 169.410.00 Search JK4259 toSave OF Data Review View Develope Formulas Home Draw . Insert Page Layout be 10 STE Ink to ink to Shape Math Convert Ink Replay Replay Touch Input Mode Drawing Tools Ix 552800 D E G B shnippley 519 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, Sw) 34 400 units 650 units 35.050 units 500 units 34550 16 00 552 800.00 (801 (8.02 (803 (8.04 18.05 18.06 $ 3 Direct Labor Budget Labor Cost Per Lamp Production Total Labor Cost (Round to two places, st) $ 209 (8.07 $ 71,552.00 18.08 $ 4 Factory Overhead Budget Variable Factory Overhead: Vanable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, S.) Fixed Factory Overhead Total Factory Overhead (Round to two places, St > $ $ 21300000 34,400 units 73 272.00 255.000.00 (8.09 18.10 $ 338,27200 (8111 2 4 Factory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, $#) 9. 5 Cost of making one unit next year Cost of one Lamp Kit Labor Cost Per Lamp Factory overhead per unit 9. 19. Total cost of one unit (Round to two places. $$###) 6 Selling and Admin Budget oil Fixed Selling Variable Selling (Round to two places, $#### Fixed Administrative Variable Administrative (Round to two places, $## ##) Total Selling and Administrative (Round to two places. $## ##) Cost of Goods 7 Sold Budget- Beginning inventory, Finished Goods Production Costs: Materials: Lamp Kits Beginning Inventory Purchased Available for Use Ending Inventory of Lamp Kits Lamp Kits Used In Production Round dollars to two places. $ (9 Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory. Finished Goods Cost of Goods Sold STE Ink to Ink to Shape Math Convert Ink Repla Replay Touch Mode Drawing Tools fx H K D E Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ $45,00 Cost of Goods Sold $30.00 Gross Profit Selling Expenses Fixed Variable (Commission per unit) $3.00 Administrative Expenses Fored Variable @ $2.00 Total Selling and Administrative Expenses Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00 50,000.00 92.000.00 190,000.00 185.000.00 $ I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.00 67,500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Lamp Kits Work in Process Finished Goods Total Current Assets 8,000.00 500 @ $18.00 0 3000 $30.00 $ 90.000.00 200.210.00 Fred Assets Equipment Accumulated Depreciation Total Fued Assets Total Assets $ 20,000.00 8,800.00 13.200.00 5213 410.00 5 54.000 54.000.00 Current Labies Accounts Payable Total Lates Glockholder's Equity Common Sauck Retained Earrings Total blockholders Equity Total Liabetes and Stockholder's Equity 5 12.000.00 147 41000 169.410.00 Search JK4259 toSave OF Data Review View Develope Formulas Home Draw . Insert Page Layout be 10 STE Ink to ink to Shape Math Convert Ink Replay Replay Touch Input Mode Drawing Tools Ix 552800 D E G B shnippley 519 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, Sw) 34 400 units 650 units 35.050 units 500 units 34550 16 00 552 800.00 (801 (8.02 (803 (8.04 18.05 18.06 $ 3 Direct Labor Budget Labor Cost Per Lamp Production Total Labor Cost (Round to two places, st) $ 209 (8.07 $ 71,552.00 18.08 $ 4 Factory Overhead Budget Variable Factory Overhead: Vanable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, S.) Fixed Factory Overhead Total Factory Overhead (Round to two places, St > $ $ 21300000 34,400 units 73 272.00 255.000.00 (8.09 18.10 $ 338,27200 (8111 2