I answered the rest, can you please just help me fill out the last column for unit sales of 18,000. Thank you!!

Tempo Company's fixed budget (based on sales of 16,000 units) folilows. 3,360,000 Pixed Budget Sales (16,000 units * $210 per unit) Costs Direct materials Direct labor Indirect materials Supervisor salary Sales commissions Shipping Administrative salaries Depreciation office equipment Insurance Office rent Income 400,000 688,000 448,000 200,000 144,000 224,000 250,000 220,000 190,000 200,000 396,000 1. Compute total variable cost per unit. 2. Compute total fixed costs. 3. Prepare a flexible budget at activity levels of 14,000 units and 18,000 units. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare a flexible budget at activity levels of 14,000 units and 18,000 units. TEMPO COMPANY TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Total Fixed Units Sales Unit Sales of per Unit Cost of 14,000 18,000 $ 210.00 $ 2,940,000 25.00 Sales Variable costs Direct materials Direct labor Indirect materials Sales commissions Shipping 43.00 28.00 9.00 350,000 602,000 392,000 126,000 196,000 14.00 119.00 0 1,666,000 1,274,000 91.00 Total variable costs Contribution margin Fixed costs Supervisor salary Administration salaries Depreciation - Office equipment Insurance Office rent 200,000 250,000 220,000 190,000 200,000 200,000 250,000 220,000 190,000 200,000 200,000 250,000 220,000 190,000 200,000 $ 1,060,000 $1,060,000 $ 1,060,000 Total fixed costs Income $ 214,000