Refer to the data in Exercise 3.26. Data in Exercise 3.26 Required: 1. Construct an Excel spreadsheet

Question:

Refer to the data in Exercise 3.26.

Data in Exercise 3.26

Utilities cost Month Machine hours $35 100 52 500 January 33 150 February 31 500 33 000 March 33 000 33 675 April 36 000

Required:
1. Construct an Excel spreadsheet to estimate the company's utilities cost behaviour.
2. Provide an assessment of the explanatory power of this equation (using the equation and other statistics).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Management Accounting

ISBN: 9781760421144

7th Edition

Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton

See More Books

Question Posted: Nov 01, 2017 05:31 AM

See More Questions

Refer to the data in Exercise 32 for the Halifax General Hospital. In exercise Required: 1. Using the highlow method, estimate the fixed cost of admitting patients per month and the variable cost of...
Refer to the data in Exercise 113. Assume that Vancouvers sales by major market are as follows: In Exercise The company would like to initiate an intensive advertising campaign in one of the two...
Refer to the data in Exercise 6-16. Assume that Minneapolis' sales by major market Data in Exercise 6-16 The company would like to initiate an intensive advertising campaign in one of the two market...
Carter Co. has a value of $80 million. Buleigh is otherwise identical to Carter Co., but has $32 million in debt. Suppose that both firms are growing at a rate of 5%, the corporate tax rate is 38%,...
Explain why this compound gives about 50%syn elimination whenheated: N(CH3)3
Based on information in the Application The Demand Elasticities for Google Play and Apple Apps, the demand function for mobile applications at the Apple App Store is QA = 1.4p -2 and the demand...
It seems that there are many ways for fraud and abuse to take place in the field of accounting. How can this occur when there are so many regulatory bodies and professional accounting standards in...
What is the control requirement of 351? Describe the effect of the following in satisfying this requirement: a. A shareholder renders only services to the corporation for stock. b. A shareholder...
How does the implementation of Lean Management methodologies foster organizational agility and enhance operational efficiency in complex business ecosystems ?
Allie has bought a new apple orchard. The orchard has a single file of trees, numbered from 1 to N. Each tree has a certail number of ripe apples. Allie has a rule she wants to follow. She wants to...
Daisy Wong is the accountant for the Heavy Manufacturing Company. She has been asked by one of Heavy's senior managers to provide an estimate of the firm's utilities costs using the high-low method....
Plasma Pathology has incurred the following costs in its diagnostic blood laboratory during the past 12 months: Required: 1. Use regression analysis to estimate the variable cost per blood test and...
There are four primary operations that are normally performed on a register. Describe each operation.
Your boss has been pressuring you because you are weeks late turning in a termination report. However, you cannot begin your section of the report until your colleague, Matt Churetta, finishes his...
Your co-worker is concerned about the new computer software that IT just installed on everyones office computers. He is not very familiar with the new program and has been struggling to figure it...
Emerson has taken the following notes about their groups meetings. Which of the following are specific observations that they could use in a performance review of group members? If they had it to do...
As a supervisor in a state agency, you have a dilemma. You received this email message today: Peggy has worked in your office for 10 years. She designed, writes, and edits a monthly statewide...
Your computer network has been experiencing slowdowns and an investigation has uncovered the reason. A number of employees have been using the system to download and share songs and vacation photos....
What is meant by the term tax morality? If for example, your company has a subsidiary in Russia where some believe tax evasion is a fine art, should you comply with Russian tax laws or violate the...
Answer the following two independent questions. a. MM Corporation is considering several proposed investments for the coming budget year. MM produces electrical apparatus for industrial complexes....
Tenneco, Inc., produces three models of tennis rackets: standard, deluxe, and pro. Following are the sales and cost information for 2011: Fixed manufacturing support costs are $800,000, and fixed...
The following information pertains to Torasic Companys budgeted income statement for the month of June 2011: Sales (1,200 units at $250) $300,000 Variable cost 150,000 Contribution margin $150,000...
Breakeven point, what-if analysis Air Peanut Company manufactures and sells roasted peanut packets to commercial airlines. Following are the price and cost data per 100 packets of peanuts:...
What are some scholarly sources that support the implementation of a case manager?
Review your own current processes relating to ER and IR within the organisation and identify three issues that can be improved upon.
A group of students working on a collaborative research project needs a centralized space to store and edit their documents. Which Teams feature should they primarily use?

Refer to the data in Exercise 3.26. Data in Exercise 3.26 Required: 1. Construct an Excel spreadsheet

Question:

Utilities cost Month Machine hours $35 100 52 500 January 33 150 February 31 500 33 000 March 33 000 33 675 April 36 000 34 350 May 45 000 35 025 June 48 000 42 000 July 60 000 34 200 August 45 000 34 500 September 45 000 34 050 October 42 000 36 150 November 61 500 37 425 December 58 500

Step by Step Answer:

1 The calculations to estimate the companys utilities cost behaviour are shown below using Excel Som...View the full answer

Management Accounting

Students also viewed these Advanced Accounting questions