The staff of controller of McCourt Company added the variable "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 Required: 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 fill in the blank 491c8af8afe4f84_1 Adjusted R Square fill in the blank 491c8af8afe4f84_2 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 fill in the blank 491c8af8afe4f84_3 86.068 6.863 0.000239 X Variable 1 fill in the blank 491c8af8afe4f84_4 0.340 0.340 9.81E-08 X Variable 2 fill in the blank 491c8af8afe4f84_5 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: $fill in the blank 491c8af8afe4f84_6 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): $fill in the blank 491c8af8afe4f84_7 Total material handling cost (add each component in the equation and then round to the nearest dollar): $fill in the blank 491c8af8afe4f84_8

College Algebra (MindTap Course List)

12th Edition

ISBN:9781305652231

Author:R. David Gustafson, Jeff Hughes

Publisher:R. David Gustafson, Jeff Hughes

Chapter4: Polynomial And Rational Functions

Section4.6: Rational Functions

Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.

See similar textbooks

Related questions

Topic Video

Question

The staff of controller of McCourt Company added the variable "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

Required:

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	fill in the blank 491c8af8afe4f84_1
Adjusted R Square	fill in the blank 491c8af8afe4f84_2
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	fill in the blank 491c8af8afe4f84_3	86.068	6.863	0.000239
X Variable 1	fill in the blank 491c8af8afe4f84_4	0.340	0.340	9.81E-08
X Variable 2	fill in the blank 491c8af8afe4f84_5	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: $fill in the blank 491c8af8afe4f84_6

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): $fill in the blank 491c8af8afe4f84_7
Total material handling cost (add each component in the equation and then round to the nearest dollar): $fill in the blank 491c8af8afe4f84_8

Expert Solution

Step 1

Note:

Hey, since there are multiple subparts posted, we will answer first two subparts. If you want any specific subpart to be answered then please submit that subpart only or specify the subpart in your message.

Given,

The staff of controller of McCourt Company added the variable "pounds moved" to the ten-month data set:

Month	Materials Handling Cost	Number of Moves	Pounds Moved
January	5600	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

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.