Please Help with the blank yellow questions

I See The Light 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: Fixed 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 $ 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 @ $16.00 0 3000 @ $30.00 90,000.00 $ 200,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $ 20,000.00 6,800.00 13,200.00 $ 213,410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 147,410.00 159,410.00 $ 213,410.00 Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places Lamp Kit $16.72 Labor $2.10 {4.01} {4.02} {4.03} Variable Overhead $2.13 Projected Variable Manufacturing Cost Per Unit $20.95 {4.04} Total Variable Cost Per Unit 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 3.18 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 2.13 {4.05} {4.06} {4.04} 20.95 Projected Total Variable Cost Per Unit 26.26 {4.07} Schedule of Fixed Costs 20x1 Cost 20x2 Cost Projected Percent Increase Fixed Overhead 300,000.00 {4.08} lamps @ ) (normal capacity of Fixed Selling Fixed Administrative 33,000.00 62,000.00 {4.09} {4.10} Projected Total Fixed Costs 395,000.00 {4.11} The company wants to maintain the same number of units in the beginning and ending inventories of vork-in-process, and electrical parts while increasing the inventory of Lamp Kits to 650 pieces and decreasing the finished goods by 20%. Complete the following budgets 1 Production Budget Planned Sales Desired Ending Inventory of Finished Goods Total Needed Less: Beginning Inventory 43000 2400 45400 3000 Total Production 42,400 units {7.01} 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, $##.##) 42,400 units 650 units 43.050 units 500 units {8.01) {8.02) {8.03} {8.04} $ $ 16.72 711,436.00 {8.05) {8.06} 3 Direct Labor Budget S 2.10 {8.07} Labor Cost Per Lamp Production Total Labor Cost (Round to two places, $##.##) 42,400 units 89.040.00 S {8.08} 4 Factory Overhead Budget $ Variable Factory Overhead: Variable Factory Overhead Cost Per Unit Number of Units to be produced Total Variable Factory Overhead (Round to two places, $##.##) Fixed Factory Overhead 2.1300000 42.400 units 90,312.00 300,000.00 $ $ {8.09} {8.10} Total Factory Overhead (Round to two places, $##.##) $ 390,312.00 {8.11} 4 Factory Overhead Budget Overhead Allocation rate based on: 1. Number of Units Total Factory Overhead / Number of Units (Round to two places, $##.##) 42400 390312 $9.21 {9.01} 5 Cost of making one unit next year Cost of one Lamp Kit Labor Cost Per Lamp Factory overhead per unit 16.72 $2.10 {9.02} {9.03} Total cost of one unit (Round to two places, $##.##) 6 Selling and Admin. Budget {9.04} Fixed Selling Variable Selling (Round to two places, $##.##) Fixed Administrative Variable Administrative (Round to two places, $##.##) Total Selling and Administrative (Round to two places, $##.##) 33000 $136,740.00 62000 91,590.00 323,330.00 $ $ {9.05} {9.06} 7 Round dollars to two places, $##.## $ 90,000.00 {9.07} to be produce d. 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 $ $ 8,000.000 680,800.000 10,400.000 $ {9.08} Total Materials: Labor Overhead Cost of Goods Available Less: Ending Inventory, Finished Goods Cost of Goods Sold {9.09} {9.10} {9.11} {9.12} {9.13} {9.14} places, $#### 34,710.000 $ Beginning Cash Balance Cash Inflows: Sales Collections: Account Receivable (Sales last year not collected) Sales made and collected in 20x2 Cash Available $ 67,500.00 {10.02} {10.03} {10.04} $ 54,000.000 {10.05} Cash Outflows: Purchases Accounts Payable (Purchases last year) Purchases made and paid for in 20x2 Other Manufacturing Costs Direct Labor Total Manufacturing Overhead Selling and Administrative Less: Depreciation Total Cash Outflows {10.06} {10.07} Budgeted Cash Balance before financing Needed Minimum Balance {10.08} Amount to be borrowed (if any) $ {10.09} Budgeted Cash Balance {10.10}