Essay
The cost accountant for Vancouver Company used an Excel spreadsheet program to run ordinary least squares (regression) method on a set of monthly cost data for its utility cost. Vancouver's cost driver for utility cost is machine hours. The following results were produced.
Intercept 3,500
X Variable 3.75
Required:
A. Construct the cost formula for Vancouver's utility cost using the results from the least squares (regression) method.
B. Using the formula calculated in (A), calculate the estimated cost of utilities for May assuming that Vancouver will incur 150,000 machine hours?
Correct Answer:
Verified
A. Total utility cost = $3,500...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q153: Which formula calculates the variable rate
Q154: Using Microsoft Excel, the function INTERCEPT returns
Q155: Select the appropriate classification of each of
Q156: London Company makes hearing aids. London has
Q157: Prince Albert Company makes cross-country skis. The
Q159: Why is managerial judgment essential to predicting
Q160: Which statement best describes the relationship between
Q161: When the level of activity increases within
Q162: Refer to Banff Company. What is the
Q163: Match each following terms with their correct