Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Applying the Concepts The staff of controller of McCourt Company added the varlable pounds moved to the ten-month data set: Month Materials Handling Cost Number

image text in transcribed

image text in transcribed

Applying the Concepts The staff of controller of McCourt Company added the varlable "pounds moved to the ten-month data set: Month Materials Handling Cost Number of Moves Pounds Moved January $5,600 475 12,000 February 3,090 125 15,000 March 2,780 175 7,800 April 8,000 600 29,000 May 1,990 200 600 June 5,300 300 23,000 July 4,300 250 17,000 August 6,300 400 25,000 September 2,000 100 6,000 October 6,240 425 22,400 22,400 Required: Microsoft AutoUpdate Update is ready to be installed 1. Using the data on material handling, use regression software such as Microsoft Excel to complete the missing data in the table below (round regression parameters to the nearest cent and other answers to three decimal places): McCourt Company SUMMARY OUTPUT Regression Statistics Multiple R 0.999 R Square Adjusted R Square Standard Error 119.600 Observations 10 ANOVA df SS MS F Significance F Regression 2 37,768,070.16 18,884,035 1,320.168 9.50629E-10 Residual 7 100,129.84 14,304.26 Total 9 37,868,200.00 Coefficients Standard Error t Stat P-value Intercept 86.068 6.863 0.000239 X Variable 1 0.340 0.340 9.81E-08 X Variable 2 0.006 17.446 5E-07 2. Using the cost equation from Requirement 1, calculate the total expected material handling cost for November if 350 moves are expected and 17,000 pounds of material will be moved (round final answer to the nearest dollar). Expected material handling cost: $ 3. For the coming year, McCourt expects 3,940 moves involving a total of 204,000 pounds. Calculate the following: Total expected fixed costs (round to the nearest dollar): $ Total material handling cost (add each component in the equation and then round to the nearest dollar): $ Cumulative Learning Curve The lasrnina Rinchnur hail the shar han arload narit RARE or the number of unite indicad incrnncon Tha hacir of thn Insrnina ni ir almost intithin Winarform an antion nuor and varim and auch da

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_2

Step: 3

blur-text-image_3

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

Public Finance In Theory And Practice

Authors: Holley Ulbrich

1st Edition

0324016603, 978-0324016604

More Books

Students also viewed these Finance questions

Question

3. Explain the process of litigation.

Answered: 1 week ago