Please help... Cell formulas are needed as well.

A B C D E F C 1 2 Tempo Company's fixed budget (based on sales of 7,000 units) follows. 3 4 Budgeted units Budgeted selling price per unit 7,000 $400 5 $2,800,000 6 7 8 9 10 Fixed Budget Sales (7,000 units x $400 per unit) Costs Direct materials Direct labor Indirect materials Supervisor salary Sales commissions Shipping Administrative salaries Depreciation Office equipment Insurance Office rent Income 11 12 280,000 490,000 175,000 65,000 140,000 154,000 210,000 35,000 20,000 36,000 $1,195,000 13 14 15 16 17 18 19 Required: 20 1. Compute total variable cost per unit. 21 22 (Use cells A2 to D17 from the given information to complete this question.) 23 24 Total variable cost per unit 25 26 2. Compute total fixed costs. 27 28 (Use cells A2 to 017 from the given information to complete this question.) 29 30 Total fixed costs $0 (Use cells A2 to E32 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Total Fixed Cost Units Sales of 6,000 Unit Sales of 8,000 per Unit Sales Variable costs Total variable costs Contribution margin Fixed costs Total fixed costs Income