AAR shows the following maintenance costs for the first $6$ months of $2024$:

$\backslash$table$[[,$Month,Units Produced,Total Cost,$\backslash$table$[[$Variable Cost Per$],[$unit$]],$Total Variable Costs,Total Fixed Costs,POINTS$],[,$Jan,$9800,14,740,,,,6],[,$Feb,$8500,13,050,0,,,2],[,$Mar,$7000,11,100,0,,,2],[,$Apr,$7600,11,880,0,,,2],[,$May,$8100,12,530,0,,,2],[,$Jun,$7900,12,270,0,,,2],[,,,,,,,],[$INSTRUCTIONS:$],[,,,,,,,]]$

a$.$ Compute the Variable Cost per unit using the High$-$Low Method in cell E$4.($Excel formulas must be visible. No hardcoded numbers allowed$)$

b$.$ Compute Total Variable Costs in column F$.$

c$.$ Compute Total Fixed Costs in column G$.$

d$.$ Write the cost formula below applicable to this data set.

e$.$ If production for July is estimated to be $8,000$ units, what is total cost? $($show your work$)$

Total Points for this problem

$22$