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
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).
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 83% (6 reviews)
1 The calculations to estimate the companys utilities cost behaviour are shown below using Excel Som...View the full answer
Answered By
Nazrin Ziad
I am a post graduate in Zoology with specialization in Entomology.I also have a Bachelor degree in Education.I posess more than 10 years of teaching as well as tutoring experience.I have done a project on histopathological analysis on alcohol treated liver of Albino Mice.
I can deal with every field under Biology from basic to advanced level.I can also guide you for your project works related to biological subjects other than tutoring.You can also seek my help for cracking competitive exams with biology as one of the subjects.
3.30+
2+ Reviews
10+ Question Solved
Related Book For
Management Accounting
ISBN: 9781760421144
7th Edition
Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton
Question Posted:
Students also viewed these Advanced Accounting 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
-
In your assigned team, discuss Intels disclosure about the computer security flaws to Chinese companies before disclosure to U.S. government agencies and officials. What potential ethical issues do...
-
The A-36 steel bars are pin connected at \(B\). If each has a square cross section, determine the vertical displacement of \(B\). 800 lb A B D 8 ft 4 ft 10 ft 2 in. H I2 I 2 in.
-
You recently began a job as an accounting intern at Reilly Golf Park. Your first task was to help prepare the cash budget for April and May. Unfortunately, the computer with the budget file crashed,...
-
A car dealer acquires a used car for $14,000, with terms FOB shipping point. Compute total inventory costs assigned to the used car if additional costs include $250 for transportation-in. $300 for...
-
Which of the graphs in Fig. Q25.12 best illustrates the current I in a real resistor as a function of the potential difference V across it? Explain. Figure Q25.12 (a) (b) (c) (d)
-
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...
-
Roso Companys investments in available-for-sale securities at December 31 show total cost of $202,000 and total fair value of $210,000. Prepare the adjusting entry.
-
Shannon Company contracts to sell on September 1, 2022 equipment to a German purchaser. The price of the equipment is 200,000 and the bill will be settled in Euros. The future transaction is viewed...
-
Select a city near their hometown to focus on and explore. Students will produce a three page briefing on the current state of the city including demographics, services, and community assets. Be sure...
-
k ces Coram Audio makes wireless headphones. Each pair of headphones comes with a travel case. Since its founding, Coram has manufactured its own travel cases. Recently, Holmur Travel Gear (HTG), a...
-
Let the demand in a competitive market be given by P=100-2Q. The private marginal cost (supply) is given by MC(private)=20. But consumption/production of the good leads to a negative externality...
-
San Mateo Circultry manufactures electrical Instruments for a variety of purposes. The following costs related to maintaining product quality were incurred in May. Training of quality-control...
-
Write down your strategy for solving an oblique triangle.
-
Tanaka Company's cost and production data for two recent months included the following: March April Production (units).........300................600 Rent.....................$1,800............$1,800...
-
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:...
-
write a page on global migration giving statistics and then focus on migration within Africa and then South Africa. Write reference?
-
Lesotho'footwear industry manufacturer one in maseru and other in maputsoe.aputsoe.in maseru te marginal benefit associated wih ppolluiio cleeanup is MB = 3 0 0 - 1 0 Q while in maputsoe te marginal...
-
Under what conditions would the Fed choose to decrease the money supply, how would it do so , and what is the goal of doing so ? How does the Fed factor inflation into its actions?
Study smarter with the SolutionInn App