1. Using the data on material handling, use regression software such as Microsoft Excel to complete...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 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: 42,778 X Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 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: 42,778 X 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): Multiple R R Square Adjusted R Square Standard Error Observations McCourt Company SUMMARY OUTPUT Regression Statistics Total Regression 2 Residual Intercept X Variable 11 X Variable 2 df 7 SS 37,768,070.16 0.999 0.997 ✔ 0.997 ANOVA 9 37,868,200.00 Coefficients 119.600 100,129.84 14,304.26 10 MS F 18,884,035 1,320.168 Standard Error Significance F t Stat 6.863 0.340 86.068 0.340 0.006 17.446 9.50629E-10 P-value 0.000239 9,81E-08 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: 42,778 X Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400 Month January February March April May June July August September October Materials Handling Cost $5,600 3,090 2,780 8,000 1,990 5,300 4,300 6,300 2,000 6,240 Number of Moves 475 125 175 600 200 300 250 400 100 425 Pounds Moved 12,000 15,000 7,800 29,000 600 23,000 17,000 25,000 6,000 22,400
Expert Answer:
Answer rating: 100% (QA)
To complete the missing data in the table we need to use regression analysis with the given data Usi... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
An employee has $64 withheld from each monthly paycheck that is deposited in an account. The account earns 12% interest annually, and the interest is compounded monthly. Assuming the employee makes...
-
For the following graphical figure, write the function x(n) and h(n) in: 1. sequential vector 2. functional representation 3. Tabular 2 10) hp) Draw the block diagram of the following function: 1....
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Inverse permutation. Write a program that reads in a permutation of the integers 0 to n-1 from n command-line arguments and prints the inverse permutation. (If the permutation is in an array a[], its...
-
Deuterium (D, or 2H; is an isotope of hydrogen with atomic mass - 2. Deuterium can be introduced into organic compounds by using reagents in which hydrogen has been replaced by deuterium. Outline...
-
In June of 2016, Kevin inherits stock worth $125,000. During the year, he collects $6,500 in dividends from the stock. How much of these amounts, if any, should Kevin include in his gross income for...
-
In what ways can you improve your communication skills?
-
Three different plans for financing a $5,000,000 corporation are under consideration by its organizers. Under each of the following plans, the securities will be issued at their par or face amount,...
-
x2 - 4x - 9 if x 5-3 3. Let f(x) 4x - x2 if - 3
-
Kai is the president of Zebra Antiques. An employee, Reese Francis, is due a raise. Reeses current benefit analysis is as follows: Compute the benefit analysis assuming: 3 percent increase in pay. ...
-
Explain what a challenge for cause and a peremptory challenge are. Provide an example of both. Explain the purpose of a directed verdict, when does it occur and why. Explain the function of the Court...
-
In a region grappling with a burgeoning housing crisis, South Florida's local government faces a pressing challenge: How can it best support its residents in securing affordable housing? Some argue...
-
1.Basic Corporation's common stock is currently selling for $58 a share. If the expected dividend at the end of the year is $2.50 and last year's dividend was $2.00, what is the rate of return...
-
For thiscase,you will play the role of team president for a minor league baseball team, the Wilmington Lions. The Lions are located in Wilmington, Delaware, and play in the International League of...
-
Year Net Cash Flow Discount Factor Present Value ( using the factor ) Present Value ( using Excel formula ) 0 $ ( 3 , 5 0 0 , 0 0 0 . 0 0 ) 1 $ ( 3 , 5 0 0 , 0 0 0 . 0 0 ) ( $ 3 , 5 0 0 , 0 0 0 . 0 0...
-
You are the mediator in a dispute between friends. You know from your initial meetings what issues are important to the parties and what has led to the escalation of this situation. You have noticed...
-
Perdon Corporation manufactures safes-large mobile safes, and large walk-in stationary bank safes. As part of its annual budgeting process, Perdon is analyzing the profitability of its two products....
-
Based on the scenario described below, generate all possible association rules with values for confidence, support (for dependent), and lift. Submit your solutions in a Word document (name it...
-
Van Doren Corporation is considering producing a new product, Autodial. Marketing data indicate that the company will be able to sell 45,000 units per year at $30. The product will be produced in a...
-
Why is there an inherent conflict between planning and control uses of budgets?
-
Paramount Medical Services has two outpatient clinics and a pathology laboratory, which are organized as separate profit centers. When the pathology laboratory conducts tests ordered by the clinics,...
-
Dropping a product line (Learning Objective 4) Suppose Kelloggs is considering dropping its Special-K product line. Assume that dur ing the past year, Special-Ks product line income statement showed...
-
Determine product mix for retailer (Learning Objective 5) Vivace sells both designer and moderately priced fashion accessories. Top manage ment is deciding which product line to emphasize....
-
Identify constraint, then determine product mix (Learning Objective 5) Lifemaster produces two types of exercise treadmills: Regular and Deluxe. The exercise craze is such that Tifemaster could use...
Study smarter with the SolutionInn App