The Cary Plant produces a part for agricultural equipment. The plant produces to demand rather than...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Cary Plant produces a part for agricultural equipment. The plant produces to demand rather than maintaining significant Inventories, so there can be significant fluctuation in monthly output. One of the significant cost Items is maintenance and repair (M&R) costs. M&R consists of both routine and unscheduled costs. The plant manager is trying to understand what effect production volume has on M&R costs and is getting conflicting Information from the machine operators (who believe that higher output is related to higher M&R costs) and the financial staff (who say that their analyses do not show this). Data on monthly output (in machine hours) and monthly M&R costs for the most recent two fiscal years follow: Month October November December January February March April May June July August September October November December January February March April May June July August September Regression Statistics Multiple R R Square Standard Error Machine-Hours 223,560 235,980 397,440 310,500 385,020 558,900 273,240 Observations Coefficients 360,180 285,660 298,080 322,920 186,300 Intercept Revenues 211,140 322,920 372,600 385,020 447,120 633,420 335,340 298,080 422,280 477,120 360,180 285,660 M&R Cost $56,518 59,320 24,150 34,230 36, 340 Required: b. Using Excel, estimate a linear regression with maintenance and repair (M&R) cost as the dependent variable and production (measured in machine hours) as the independent variable. 9,140 36,580 Note: Negative amounts should be Indicated by a minus sign. Round "Multiple R, R Square and Revenues to 5 decimal places, "Standard Error" to 1 decimal place, and "Intercept" to the nearest whole number. 43,380 53,230 52,298 30,250 55,570 48,070 29,780 42,670 38, 220 15,940 230 41,748 35,870 22,040 28,140 28,140 42,190 The Cary Plant produces a part for agricultural equipment. The plant produces to demand rather than maintaining significant Inventories, so there can be significant fluctuation in monthly output. One of the significant cost Items is maintenance and repair (M&R) costs. M&R consists of both routine and unscheduled costs. The plant manager is trying to understand what effect production volume has on M&R costs and is getting conflicting Information from the machine operators (who believe that higher output is related to higher M&R costs) and the financial staff (who say that their analyses do not show this). Data on monthly output (in machine hours) and monthly M&R costs for the most recent two fiscal years follow: Month October November December January February March April May June July August September October November December January February March April May June July August September Regression Statistics Multiple R R Square Standard Error Machine-Hours 223,560 235,980 397,440 310,500 385,020 558,900 273,240 Observations Coefficients 360,180 285,660 298,080 322,920 186,300 Intercept Revenues 211,140 322,920 372,600 385,020 447,120 633,420 335,340 298,080 422,280 477,120 360,180 285,660 M&R Cost $56,518 59,320 24,150 34,230 36, 340 Required: b. Using Excel, estimate a linear regression with maintenance and repair (M&R) cost as the dependent variable and production (measured in machine hours) as the independent variable. 9,140 36,580 Note: Negative amounts should be Indicated by a minus sign. Round "Multiple R, R Square and Revenues to 5 decimal places, "Standard Error" to 1 decimal place, and "Intercept" to the nearest whole number. 43,380 53,230 52,298 30,250 55,570 48,070 29,780 42,670 38, 220 15,940 230 41,748 35,870 22,040 28,140 28,140 42,190
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Cary Plant produces a part for agricultural equipment. The plant produces to demand rather than maintaining significant Inventories, so there can be significant fluctuation in monthly output. One...
-
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple...
-
collected: January February March April May June July August Zachary's Pizza makes specialty pizzas. Data for the past eight months were Labor Cost $7,000 8,140 9,899 9,787 8,490 7,450 9,490 7,531...
-
A trader has a soft limit of $8MM USD and a hard limit of $10MM USD. Their current NOP is $3MM USD. They purchase $6MM USD, sell $1MM USD, and then purchase another $5MM USD. Which of the following...
-
How do the time frames for financial benefits for improvements in the different categories of processes typically vary?
-
In each of the following cases, decide whether the given function is intrinsically linear. If so, identify x' and y', and then explain how a random error term e can be introduced to yield an...
-
L Stokes drew up the following trial balance as at 30 September 19X8. You are to draft the trading and profit and loss account for the year to 30 September 19X8 and a balance sheet as at that date....
-
Degelman Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2014, Job No. 50 was the only job in process. The costs incurred...
-
beta coefficients and the capital asset pricing model suppose you are wondering how much risk you must undertake to generate an acceptable return on your investment portfolio. the risk free return...
-
Directions and Info for Building 1. Use a program where you can draw and type, like pages, or you can draw this out on a piece of paper and take a picture to submit. 2. You will begin with the...
-
I need typed solution with explanation. Why do companies decentralize? What are the advantages of decentralization? What are the disadvantages of decentralization? What are the advantages of...
-
The production manager in Splish's business unit pitched an idea to her, suggesting their unit would generate $57,000 of new sales this year by purchasing a new piece of equipment with a 5-year...
-
1) Using your AS-AD diagram (with SRAS, LRAS and AD), graphically illustrate an economy that is presently at a long-run equilibrium. Label that equilibrium point A. 2). In the same diagram,...
-
Leadership in a Multicultural Tech Company Company: Tech Vista Innovations Inc. Industry: Information Technology Background: Tech Vista Innovations is a fast-growing global tech company that...
-
State A has a total population of 10 million, of which 70 percent are adults (civilian noninstitutional population aged 16 and over). 20 percent of the adult population is not looking for a job, 60...
-
Sigmund's share of assets of a partnership are as follows: Signmund's Share of Assets Section 751 Assets Non-section 751 Assets Book Tax 40000 20000 60000 30000 The partnership has no liabilities and...
-
It may not make sense for all businesses to participate in C-TPAT. What factors should one consider before deciding to participate?
-
Determine the reactions in supports A and D and connections B and C. Sketch its shear and moment diagram and determine the magnitude ankoration of the maximum shear and moment for every member. 18 3...
-
An appliance manufacturer wants to contract with a repair shop to handle authorized repairs in Indianapolis. The company has set an acceptable range of repair time of 50 minutes to 90 minutes. Two...
-
Referring to Problem 16, suppose that each server could handle four customers per hour. Answer the questions posed in the problem. Explain why the impact of reassigning customers is much less than in...
-
Three recent college graduates have formed a partnership and have opened an advertising firm. Their first project consists of activities listed in the following table. a. Draw the precedence diagram....
-
The balance sheet of Tatters Ltd on 31 December 2008 was as follows: The dividend on the preference shares is 12,000 in arrears. A scheme of reconstruction was accepted by all parties and was...
-
In preparing its accounts for the year to 31 May 2007, Whiting plc had been faced with a number of accounting problems, the details of which were as follows: (i) The company had closed down its...
-
The ledger balances of Tick Tick Ltd at 31 March 2011 were as follows: A capital reduction scheme has been sanctioned under which the 250,000 preference shares are to be reduced to 80p each, fully...
Study smarter with the SolutionInn App