Clough Company Is Interested in Establishing the Relationship Between Utility

question 1

Essay

Clough Company is interested in establishing the relationship between utility costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
$\begin{array}{llll}&&\text { Utility } \\\text { Month } & \text { Machine Hours } & \text { Costs }\\\text { January } & 3,250& \$ 2,080 \\\text { February } & 3,77 0 & 25,200 \\\text { March } & 2,470 & 16,200 \\\text { April } & 4,030 & 27,600 \\\text { May } & 4,940 & 33,900 \\\text { June } & 4,290 & 26,400 \\\text { July } & 5,330 & 29,700 \\\text { August } & 4,550 & 27,300 \\\text { September } & 2,600 & 18,600 \\\text { October } & 4,810 & 31,200 \\\text { November } & 6,110 & 37,200 \\\text { December } & 5,460& 33,300\end{array}$


Required:
(a.) What is the equation for utility costs using the high-low method?
(b.) Prepare an estimate of utility costs for a month when 3,000 machine hours are worked.

---

Definitions:

Entrepreneurs

Individuals who create, organize, and operate businesses, taking on greater than normal financial risks in order to do so, often seen as innovators who drive economic growth.

Traders

Individuals or entities engaged in the buying and selling of goods, services, or financial instruments, often acting as intermediaries in trade transactions.

Birthday Party

A celebration or gathering marking the anniversary of a person's birth.

Generalized Reciprocity

A form of exchange where goods or services are given without an immediate or specific expectation of return, often found in close relationships.