Determine the company''s utility cost equation

Assignment Help Managerial Accounting
Reference no: EM13877497

Tools Are Us Corporation produces toolboxes used by construction professionals and homeowners. The company is concerned that it does not have an understanding of its utility consumption. The company's president, George, has asked the plant manager and cost accountant to work together to get information about utilities cost. The two of them accumulated the following data for the past 14 months (production volume is presented in units):  


January

113,000 (Production)
$1,712 (utility cost)

February

114,000 (production)
 1,716 (utility)

March
 90,000 (production)
 1,469 (utility)

April
110,000 (production)
1,600 (utility)

May
112,000 (production)
1,698 (utility)

June
101,000 (production)
 1,691(utility)

July
104,000 (production)
 1,700 (utility)

August
105,000 (production)
 1,721(utility)

September
115,000 (production)
 1,619 (utility)

October
 97,000 (production)
1,452 (utility)

November
 98,000 (production)
1,399 (utility)

December
98,000 (production)
1,403 (utility)

January
112,000 (production)
1,543 (utility)

February

107,000 (production)
1,608 (utility)

Required

A.    Use the high/low method to determine the company's utility cost equation.
B.    What would be the expected utility cost of producing 120,000 units? (The relevant range is 85,000 to 125,000 units of production.)
C.    Using the data shown and a spreadsheet program, perform a regression analysis. Discuss any differences in the results and the potential impact on decision making. (Sawyers 114)

Sawyers,  Jackson,  Jenkins. Managerial ACCT2, 2e, 2nd Edition. Cengage Learning, 02/2012. VitalBook file.

The citation provided is a guideline. Please check each citation for accuracy before use.

Reference no: EM13877497

Questions Cloud

Show the sequence of reactions starting : Isoleucine is degraded to propionyl-CoA and acetyl-CoA in a six-step pathway that uses chemical strategies analogous to those in the TCA cycle and the b-oxidation of fatty acids.  The (out of sequence) structures of the pathway intermediates are show..
Calculate the expected gross margin next month : Calculate the expected gross margin next month.  Calculate the expected contribution margin next month.  Calculate the expected total administrative expense next month.
At what level of output the average cost is minimum : A firm has the following total cost function TC = 0.8Q3- 20Q2+ 220Q + 500 - What is the average total cost if output is 15 units?
Data input section : The spreadsheet model should include a "Data Input Section" (whereby all raw / original data from the case should be entered), "Additional Information Section" (whereby other relevant information for the individual problems should be entered) and an ..
Determine the company''s utility cost equation : A. Use the high/low method to determine the company's utility cost equation. B.  What would be the expected utility cost of producing 120,000 units? (The relevant range is 85,000 to 125,000 units of production.) C.    Using the data shown and a sprea..
Calculate the expected profit for each wine : Calculate, the expected demand and the standard deviation of the demand for each wine and calculate the expected profit for each wine.
Explain structures of the brain and each structure function : Write a 700- to 1050-word paper in APA format describing the five major structures of the brain and each structure's function(s) in the human body
Find combination of price : A noncompetitive firm faces the following demand function for its product P = 2400 - 16 Q + 12 , Find the combination of price and quantity that maximizes the firm's revenue.
Calculate atomic packing : The unit cell for Cr2O3 has hexagonal symmetry with lattice parameters a = 0.4961 nm and c = 1.360 nm. If the density of this material is 5.22 g/cm3, calculate its atomic packing factor.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What amount of the yyy production costs is avoidable

What is the minimum acceptable price of this one-time-only special order and what other items should Tamworth Cabinets consider before accepting this one-time-only special order?

  Basic journal entries

Prepare journal entries and explanations to record the preceding transactions and events - Basic Journal Entries

  The cereal division of mckenzie corporation.

The following pertains to the Cereal Division of McKenzie Corporation.

  Sample question-cost-volume-profit analysis

Suppose only the specified paramenters change in cost-volume-profit analysis. If the contribution margin increases by $2 per unit then operating profits will ____.

  Cost analysis in sea transportation

Please define the cost allocation keys in sea transport business. Think about owning a ship, but are not operating it efficiently and effectively so that your costs are always much more than your revenues. What will be your solution? What if you d..

  Rank the services offered in order of their profitability

Determine the best sales mix. Rank the services offered in order of their profitability and which ranking would you recommend? What additional amount of total contribution margin would be generated if your recommendation were to be accepted?

  What is the growth rate in sales for the past three years

What is the growth rate in sales for the past three years and are revenues and expenses growing at the same rate? What was the experience in the past few years?

  Cash payments on accounts payable

Determine the amounts - Cash collected from sales during Year 2 and cash payments on accounts payable during Year 2.

  Prepare the journal entry for green company

Prepare the journal entry for Green Company and assume that the exchange lacked commercial substance. Prepare the journal entry for Ice Mountain Company.

  Compute mission indirect cost allocation rate

Compute the total costs assigned to the Web and Greg engagements. Compute Mission's indirect cost allocation rate

  Prepare a statement of owners equity for april

Prepare a statement of owner's equity for April. The statement of owner's equity for a proprietorship is similar to the retained earnings statement for a corporation.

  Question 1 bobsnbspcompany sells one product with a

question 1 bobsnbspcompany sells one product with a variable cost of 5 per unit. the company is unsure what price to

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd