Examlex

Solved

The Cost Accountant for Vancouver Company Used an Excel Spreadsheet  Intercept 3,500X Variable 3.75\begin{array} { l l } \text { Intercept } & 3,500 \\\mathrm { X } \text { Variable } & 3.75\end{array}

question 130

Essay

The cost accountant for Vancouver Company used an Excel spreadsheet program to run ordinary least squares on a set of cost data for its utility cost.Vancouver's cost driver for utility cost is machine hours.The following results were produced.
Required:
 Intercept 3,500X Variable 3.75\begin{array} { l l } \text { Intercept } & 3,500 \\\mathrm { X } \text { Variable } & 3.75\end{array} A. Construct the cost formula for Vancouver's utility cost using the results from the method of least squares.
B. Using the formula computed in (A), what is the estimated cost of utilities for May assuming that Vancouver will incur 150,000 machine hours?


Definitions:

Immediate Retrofitting

The quick adaptation or upgrading of existing structures or systems to improve efficiency, performance, or compliance with current standards and regulations.

Spent Fuel Reprocessing

The chemical treatment of used nuclear fuel to extract usable elements such as uranium and plutonium for re-use in reactors.

Synfuels

Synthetic fuels made from coal, natural gas, or biomass through chemical conversion; alternatives to traditional fossil fuels.

Commercially Attractive

Refers to properties or qualities that appeal to business interests or harbor potential for economic gain.

Related Questions