Nunavut Company Operates a Chain of Cozy Coffee Shops Required:
A

Nunavut Company operates a chain of cozy coffee shops.The company's chief executive officer is interested in accumulating some information on the overhead costs incurred by the company.You have been asked to analyze the following six months' worth of data.
$\begin{array}{lrr}\text { Month } & \text { Overhead } & \text { No. of } \\&\text { cost } & \text { Labour Hours }\\\text { January } & \$ 60,160 & 867 \\\text { February } & 56,500 & 624 \\\text { March } & 58,900 & 689 \\\text { April } & 63,500 & 974 \\\text { May } & 59,325 & 730 \\\text { June } & 62,400 & 901\end{array}$
Required:
A. Using the high low method, construct a cost formula for the total overhead cost.
B. The CEO would like to limit total overhead cost in future months to 20% of total revenues. Will that be possible if total revenues are expected to average $300,000 per month and total labour hours per month are expected to average 1,000? Show all of your calculations.
C. Compute the total cost of overhead assuming 1,000 labour hours are incurred in a given month.