Part $1$: High Low Calculations

Use the data in the following table to answer questions regarding the production of a product Xnew.

$\backslash$table$[[$Month$,$Labor Hours,Mfg$.$ OH Costs,$],[$January$,4,738,$$$,399,684],[$February$,4,953,$$$,408,965],[$March$,4,883,$$$,403,815],[$April$,5,677,$$$,457,656],[$May$,4,465,$$$,390,263],[$June$,5,505,$$$,451,085],[$July$,4,135,$$$,363,054],[$August$,5,743,$$$,459,855],[$September$,5,084,$$$,423,221],[$October$,5,109,$$$,412,494],[$November$,3,697,$$$,331,453],[$December$,3,875,$$$,358,638]]$

Q$1.$ Use the high low method to estimate the amount of variable overhead per labor hour.

Place your answer in highlighted cell.

Q$2.$ Use the high low method to estimate the amount of fixed overhead per month.

Place your answer in highlighted cell.

Additional data about Xnew is given below:

$\backslash$table$[[$Sales price per unit of Xnew,$$,210\mathrm{.}00],[$Direct Labor costs per unit of Xnew,$$,22\mathrm{.}50],[,$ Xnew uses $\frac{1}{2}$ hour of labor per unit,,$],[$Direct Material costs per unit of Xnew,$$,40\mathrm{.}20],[$Variable Sales and Administrative,$$,52\mathrm{.}00],[,$ costs per unit of Xnew,$$,102,000],[\backslash$table$[[$Fixed Sales and Administrative costs$],[$traceable to Xnew per month$]],,]]$

Q$3.$ What is the estimated variable cost per unit of Xnew?