Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The cost accountant for Bolagio Company used an Excel spreadsheet program to run ordinary least squares regression analysis on a set of cost data for
The cost accountant for Bolagio Company used an Excel spreadsheet program to run ordinary least squares regression analysis on a set of cost data for its utility cost. Bolagio's cost driver for utility cost is machine hours. The following results were produced.
Intercept | 2,490 |
X Variable |
4.89
|
Required:
A. Construct the cost formula for Bolagio's utility cost using the results from the method of least squares.
Total utility cost | = | Fixed cost | + | Variable cost |
= | $ | + | ($ per hour X no. of machine hours) |
B. Using the formula computed in (A), what is the estimated cost of utilities for May assuming that Bolagio will incur 110,000 machine hours? $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started