Note: Please provide in excel format (horizontal)

Farmington Corporation manufactures toaster ovens, generally selling from 20,000 to 30,000 units per year. The following cost data apply to the activity levels shown:

Required: 1) Complete the preceding table by filling the missing amounts for 25,000 and 30,000 units. 2) Assume that Farmington actually makes 28,000 units. What would be the total costs and the cost per unit at this level of activity?

Number of Units 2 20,000 25,000 30,000 Total costs $300,000 200,000 $500,000 Fixed Variable Total costs Cost per Unit ixed Variable Ixcd $15.00 10.00 $25.00 Total cost per unit