Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The controller of Brokaw Production has collected the following monthly cost data for analyzing the behavior of utility costs. Total Utility Costs Total Machine Hours

The controller of Brokaw Production has collected the following monthly cost data for analyzing the behavior of utility costs.

Total Utility Costs

Total Machine Hours

January

$3,200

400

February

4,700

550

March

4,000

500

April

2,100

790

May

3,600

450

June

5,300

700

July

5,500

690

August

5,100

620

September

7,400

880

October

4,600

610

November

3,000

350

December

6,700

820

  1. Determine the fixed costs and unit variable costs using regression analysis. (We recommend the use of Excel.) (Round fixed cost to 0 decimal places e.g. 1,252 and variable cost to 4 decimal places e.g. 1.2512.)

Fixed costs - $ ______________

Unit variable costs - $ __________ /machine hour

  1. What utility cost does the cost equation estimate for a level of activity of 500 machine hours? (Round answer to 2 decimal places e.g. 1,250.25.)

Utility costs - $ _________________

  1. By what amount does this differ from Marchs observed cost for 500 machine hours? (Round answer to 2 decimal places e.g. 1.25.)

Amount differ - $ ________________

  1. What utility cost does the cost equation estimate for a level of activity of 700 machine hours? (Round answer to 2 decimal places e.g. 1,250.25.)

Utility costs - $ _________________

  1. By what estimate does this differ from Junes observed cost for 700 machine hours? (Round answer to 2 decimal places e.g. 1.25.)

Amount differ - $ ________________

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

Horngrens Accounting The Financial Chapters

Authors: Tracie Miller Nobles, Brenda Mattison

13th Edition

0136162185, 9780136162186

More Books

Students also viewed these Accounting questions