Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Consumer Finance Research

Authors: Jing J. Xiao

1st Edition

1441926046, 978-1441926043

More Books

Students also viewed these Finance questions