$\backslash$table$[[$Month$,$Un Produced,Total Cost$],[$January$,27,500,$$$21,500$

$\backslash$table$[[$Month$,$Un Produced,Total Cost$],[$January$,27,500,21,500],[$February$,22,500,20,500],[$March$,25,000,25,000],[$April$,35,000,21,500],[$May$,47,500,25,500],[$June$,17,500,18,500],[$July$,30,000,23,500],[$August$,52,500,28,500],[$September$,37,500,26,000],[$October$,62,500,29,000],[$November$,67,500,31,000],[$December$,57,500,26,000]]$

Colculate:

MIN units

MAX units

Change in dollars

Change in volume

Variable cost per unit

Total fixed costs

Estimate total cost for production of $47,700$ units

Min funcion

Max function

Change in dollars

Change in volume

Varlable cost per unit

Total fixed costs for high point: $7.$ Total cost to produce $47,700$ units

$47,700$

$\backslash$table$[[,$Total cost,$=$ Fixed cost, Variable cost $x,$Units$],[$High$-$Low Method Cost Equation,Total cost,$=,+1,$Units$],[$Regression Cost Equation,Total cost,$=,+1,$Units$],[$RSquare$,,,,],[$Intercept and Slope,Total cost,,$+1,$Units$]]$

Instructions to Add Data Analysis

Click on the "Data" tab

Click on "Data Analysis"

A$.$ Click on "Analysis Tools" if disabled $(($For PCs$,$ "Data Analysis Toolpack", File $$ Options $$ Add$-$ins$)$

B$.$ Select "Analysis ToolPack"

Add$-$in Go to Excel $($by Apple emblem; top left$)$

$($for Macs$)$ Preferences $$ Ribbon$/$Toolbar $$ under menu click on all commands $($not just popular$)$ Add$-$in