1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
tiny-mole [99]
3 years ago
8

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collect

ed and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 2,000 $ 18,950 February 2,400 $ 22,100 March 1,400 $ 14,050 April 2,600 $ 24,100 May 3,300 $ 28,800 June 2,800 $ 23,100 July 3,600 $ 25,300 August 3,000 $ 23,300 September 1,500 $ 16,600 October 3,200 $ 27,100 November 4,200 $ 32,100 December 3,700 $ 28,300 Summary Output Regression Statistics Multiple R 0.960 R Square 0.921 Adjusted R2 0.913 Standard Error 1,545.17 Observations 12.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 7,465.99 1,566.61 4.77 0.00 3,975.37 10,956.62 Machine Hours 5.76 0.53 10.78 0.00 4.57 6.95 If the controller uses the high-low method to estimate costs, the cost equation for electricity costs is: (Round intermediate calculations to 2 decimal places.)
Mathematics
1 answer:
mars1129 [50]3 years ago
8 0

Answer:

If the controller uses the high-low method to estimate costs, the cost equation for electricity costs is "Total cost = $5,010 + ($6.45 * Machine hours)".

Step-by-step explanation:

Note: The data needed to estimate costs using the high-low method is merged together. It is therefore sorted before answering the question as follows:

Month          Machine Hours          Electricity Costs

January              2,000                           $18,950

February            2,400                           $22,100

March                 1,400                            $14,050

April                   2,600                            $24,100

May                    3,300                            $28,800

June                   2,800                           $23,100

July                    3,600                            $25,300

August               3,000                            $23,300

September         1,500                             $16,600

October             3,200                             $27,100

November         4,200                             $32,100

December         3,700                             $28,300

The explanation of the answer is now provided as follows:

Step 1: Calculation of variable cost per hour

From the data above, the highest Machine Hours and Electricity Costs occur in November, while the lowest occur in March. Therefore, we have:

Variable cost per hour = (Highest Electricity Costs - Lowest Electricity Costs) / (Highest Machine Hours - Lowest Machine Hours = ($32,100 - $14,050) / (4,200 – 1,400) = $18,050 / $2,800 = 6.44642857142857

Rounding to 2 decimal places as required, we have:

Variable cost per hour = $6.45

Therefore, the variable-cost components using the high-low method is $6.45.

Step 2: Calculation of total fixed cost

The formula for calculating the total cost is given as follows:

Total cost = Total Fixed Cost + Total Variable Cost ................. (1)

Where;

Total Variable Cost = Variable cost per hour * Machine hours at a particular Electricity Costs

Using highest levels of activity and substitute into equation (1), we have:

$32,100 = Total Fixed Cost + ($6.45 * 4,200)

Total Fixed Cost = $32,100 - ($6.45 * 4,200) = $32,100 - $27,090 = $5,010

Therefore, the fixed-cost components using the high-low method is $5,010.

Step 3: Derivation of the cost equation for electricity costs

The cost equation for electricity costs can be obtained based on the total cost function given in equation (1) above, where:

Total Fixed Cost = $5,010

Total Variable Cost = Variable cost per hour * Machine hours = $6.45 * Machine hours

Substituting the values into equation (1), we have:

Total cost = $5,010 + ($6.45 * Machine hours)

Therefore, if the controller uses the high-low method to estimate costs, the cost equation for electricity costs is "Total cost = $5,010 + ($6.45 * Machine hours)".

You might be interested in
If there are 120 calories in 4 ounces of hot fudge, how many calories are in 8
miss Akunina [59]

Answer:

240 calories

Step-by-step explanation

You're doubling the amount of fudge, so double the amount of calories. You could also think of it as 2 4-oz portions of fudge, then just add the calories (120+120) together.

3 0
3 years ago
Vlad has found a magic box. If he opens it now he will only get $15. But every month the amount in the box increases by $15. If
Triss [41]
He would have to wait 30 months to get $450
4 0
2 years ago
The exchange rate at the post office is £1 = €1.17. How many euros do I get for £280?
lidiya [134]

Answer:

327.21 euros.

Step-by-step explanation:

5 0
3 years ago
Yuk noticed that out of 24 students entering the building at Willowville Elementary School this morning, 8 of them were carrying
nordsb [41]

Answer:

the students that brought a lunch box is 28

Step-by-step explanation:

The computation of the students that brought a lunch box is shown below:

= Entire school students × students that carry a lunch box ÷ entering students

= 84 students × 8 ÷ 24 students

= 28 students

Hence, the students that brought a lunch box is 28

3 0
3 years ago
What number is being factored in this factor tree? A. 72 B. 180 C. 216 D. 324 Whoever gets right gets 50 points and Brainliest
aliina [53]

Answer:

im pretty sure its A

Step-by-step explanation:

Hope this helped!

6 0
3 years ago
Other questions:
  • *WILL GIVE BRIANLIEST**BRIANLIEST WILL BE GIVEN*(08.06 LC)
    15·1 answer
  • The product of 8 and a number, decreased by 22 is<br> 186. What is the number?
    8·2 answers
  • A chef uses 4 cups of potatoes to make a batch of mashed potatoes. If p represents the number of cups of potatoes, which equatio
    12·2 answers
  • The length of the blue ribbon is two-thirds the length of the red ribbon. Write an equation to find the length r of the red ribb
    12·2 answers
  • Can you help me I forgot
    10·2 answers
  • How many solutions will each system of equations have? y=-2x+5 and 2x + y = -7
    8·1 answer
  • Does anyone have the answer key to these proofs? They are Mrs. E Teaches Math introductory proofs. There are 14 total. I've done
    10·1 answer
  • You are making a walkway around part of a swimming pool. The dimensions of the swimming pool are 18 and 25, while the dimensions
    9·1 answer
  • (a) 3 - 2/3÷4/3 × 7<br>(b) [(2/3)/(5/6)]-2/5<br>(c) {(-3/4) +( 1/2)}/{(2/5)-(5/2)}<br>​
    15·2 answers
  • Part III: Find the unknown side lengths, AB and BC. HINT: Use either the Pythagorean Theorem or special right triangle propertie
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!