PLEASE MAKE SURE TO SHOW EXCEL FUNCTIONS AND GAVE AT LEAST ONE ABSOLUTE CELL REFERENCE!!

Tempo Company's fixed budget $($based on sales of $7,000$ units$)$ follows. $($Click on the Graded Worksheet Tab below.$)$

Fixed Budget Flexible Budget

Budgeted units $7,0006,0008,000$

Selling price per unit $$400$

Fixed Budget $($based on sales of $7,000$ units$)$

Sales $$2,800,000$

Costs

Direct materials $280,000$

Direct labor $490,000$

Indirect materials $175,000$

Supervisor salary $65,000$

Sales commissions $140,000$

Shipping $154,000$

Administrative salaries $210,000$

Depreciation$$Office equipment $35,000$

Insurance $20,000$

Office rent $36,000$

Income $$1,195,000$

Required:

$1.$ Compute total variable cost per unit.

$2.$ Compute total fixed costs.