McCourt Company had the following 10 months of data on materials handling cost and number of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
McCourt Company had the following 10 months of data on materials handling cost and number of moves: Materials Handling Cost Number of Moves $5,600 475 3,090 125 175 600 Month January February March April May June July August September October 2,780 Multiple R R Square Adjusted R Square Standard Error Observations 8,000 1,990 5,300 4,300 6,300 2,000 6,240 0.94 0.88 ✓ 0.87 ✓ 746.14 200 10 300 Required: 1. Using the above data on material handling, using regression software such as regression function within Microsoft Excel, and fill in the missing data in the table below (round answers to two decimal places). McCourt Company SUMMARY OUTPUT Regression Statistics 250 400 100 425 df Regression 1 Residual Total Intercept X Variable 1 8 Total cost 9 SS Coefficients ANOVA 996.27 ✓ 11.68 ✔ 33,414,382.28 4,453,817.72 556,727.20 37,868,200.00 MS 33,414,382 60.02 ✓ Standard Error 4,088 F ✓ 1.51 ✔ X ✓ 516.99 X Significance F t Stat 2. McCourt estimates that November will now have 350 moves. Using this new value, calculate the following expected total, fixed and variable costs for the month of November (round all costs to the nearest dollar): Expected fixed cost Expected variable cost 5. Using a P-value of 0.05 for significance, the following is true: Only V is a reliable estimate 1.93 7.75 3. What is the percentage of material handing cost explained by moves: X percent 4. Using a P-value of 0.10 for significance, the following is true: Both F and V are reliable estimates .000055 P-value 0.09 0.000055 McCourt Company had the following 10 months of data on materials handling cost and number of moves: Materials Handling Cost Number of Moves $5,600 475 3,090 125 175 600 Month January February March April May June July August September October 2,780 Multiple R R Square Adjusted R Square Standard Error Observations 8,000 1,990 5,300 4,300 6,300 2,000 6,240 0.94 0.88 ✓ 0.87 ✓ 746.14 200 10 300 Required: 1. Using the above data on material handling, using regression software such as regression function within Microsoft Excel, and fill in the missing data in the table below (round answers to two decimal places). McCourt Company SUMMARY OUTPUT Regression Statistics 250 400 100 425 df Regression 1 Residual Total Intercept X Variable 1 8 Total cost 9 SS Coefficients ANOVA 996.27 ✓ 11.68 ✔ 33,414,382.28 4,453,817.72 556,727.20 37,868,200.00 MS 33,414,382 60.02 ✓ Standard Error 4,088 F ✓ 1.51 ✔ X ✓ 516.99 X Significance F t Stat 2. McCourt estimates that November will now have 350 moves. Using this new value, calculate the following expected total, fixed and variable costs for the month of November (round all costs to the nearest dollar): Expected fixed cost Expected variable cost 5. Using a P-value of 0.05 for significance, the following is true: Only V is a reliable estimate 1.93 7.75 3. What is the percentage of material handing cost explained by moves: X percent 4. Using a P-value of 0.10 for significance, the following is true: Both F and V are reliable estimates .000055 P-value 0.09 0.000055
Expert Answer:
Related Book For
Fundamental accounting principle
ISBN: 978-0078025587
21st edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these accounting questions
-
Consider the function f(x) = x - 8 - 30x + 13. a) List all the critical values of f(x). Note: Give your answer as a comma separated list eg. "1,2,3" without quotes. If there are no critical values,...
-
Duncan Shirts sells championship shirts with official sports league logos. Duncan employs five college students who serve as sales representatives in their spare time. Each sales representative at...
-
make argument essay on the below reading: Statistics about the scope of sexual violence are always chilling, but even such accountings do little to capture the true breadth and scope of harassment...
-
Use the same information as in question 4, except that Hughes has a debit balance of $5,000 in its Allowance for Doubtful Accounts before any adjustments are made at the end of the year. In this...
-
Professor Canty conjectures that there might exist some ei, ai,j, and ti,j values for which FASTEST-WAY produces li[j] values such that l1[j] = 2 and l2[j] = 1 for some station number j. Assuming...
-
despite meticulous efforts to maintain accuracy, are an inevitable aspect of financial record-keeping. These errors can occur at various stages of the accounting process and may lead to discrepancies...
-
Consider the gasoline mileage data in Table B.3. a. Fit a multiple linear regression model relatmg gasoline mileage $y$ (miles per gallon) to engine displacement $x_{1}$ and the number of carburetor...
-
David Ricardo of Iron Law, Inc. claims that he meets the company standard of spending an average of no more than $ 8 a day on business lunches. As company auditor, you take a random sample of 12 of...
-
Required information [The following information applies to the questions displayed below.] The Sky Blue Corporation has the following adjusted trial balance at December 31. Cash Accounts Receivable...
-
A camera is listed for $599 less 30%, 20%, and 5%. (a) What is the net price? (b) What is the total amount of discount allowed? (c) What is the exact single rate of discount that was allowed?
-
KLMN is a TV station that is selling slots on its Sunday local news program special for October 2023 (when we are in March 2023) in the up-front (i.e., "early") market. There are 5 slots of 30...
-
Which of the following is not a cost advantage independent of scale? A. proprietary technology B. favorable locations C. experience in the industry D. high volume of production
-
Why have firms such as Google, Facebook, and Amazon gained monopoly power in search, social media, and online retail, respectively, despite potential competitors having virtually unrestricted access...
-
In many respects, social forces are the drivers of consumer markets. True or False
-
When switching costs are high, __________. A. customers are less likely to try a new competitor. B. companies spend more on technology. C. companies seek new suppliers to reduce costs. D. none of the...
-
The expansion of a religion in an emerging country is an example of a social force. True or False
-
QUESTION 2 Which is not the name of a MOSFET terminal? A source B. channel C-body D. gate E. drain
-
Find the area of the surface generated by revolving the para- metric curve x = cos 1, y = sin? 1 (0 < I sa/2) about the y-axis.
-
Fancher organized a limited partnership and is the only general partner. Carley invested $20,000 in the partnership and was admitted as a limited partner with the understanding that she would receive...
-
Polaris uses a time ticket for some employees. What is the difference between a clock card and a time ticket?
-
The following information is available for Amos Company for the year ended December 31, 2013. a. Balance of retained earnings, December 31, 2012, prior to discovery of error, $ 1,375,000. b. Cash...
-
A blender does 5000 J of work on the food in its bowl. During the time the blender runs, 2000 J of heat is transferred from the warm food to the cooler environment. What is the change in the thermal...
-
Which system contains more atoms: 5 mol of helium (A = 4) or 1 mol of neon (A = 20)? A. Helium B. Neon C. They have the same number of atoms.
-
A sample of ideal gas is in a sealed container. The temperature of the gas and the volume of the container are both increased. What other properties of the gas necessarily change? (More than one...
Study smarter with the SolutionInn App