Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please provide the correct answer, no explanation needed. 7. An important application of regression analysis in accounting is in the estimation of cost. By collecting
Please provide the correct answer, no explanation needed.
7.
An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 3800 450 4500 550 5200 650 6000 750 7000 800 7400 The data on the production volume :1: and total cost y for particular manufacturing operation were used to develop the estimated regression equation 3} = 411.54 + 8.732;. a. The company's production schedule shows that 700 units must be produced next month. Predict the total cost for next month. 33* = 0 (to 2 decimals) b. Develop a 98% prediction interval for the total cost for next month. 8 0 (to 2 decimals) t-value 0 (to 3 decimals) spred 0 (to 2 decimals) Prediction Interval for an individual Value next month ( 0, 0) (to whole number) c. If an accounting cost report at the end of next month shows that the actual production cost during the month was $6,000, should managers be concerned about incurring such a high total cost for the month? Discuss. Based on one month, $6,000 \\'0 outside the upper limit of the prediction interval. A sequence of five to seven months with consistently high costs should cause concern. Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage Annual (hours) Maintenance Expense 20 24 17 29 27 37 35 44 39 54 24 38 31 40 38 46 47 59 45 47 a. Develop the estimated regression equation that relates annual maintenance expense (in hundreds of dollars) to weekly usage hours (to 3 decimals). Expense = 0 + 0 Weekly Usage b. Test the significance of the relationship in part (a) at a 0.05 level of significance. Compute the value of the F test statistic (to 2 decimals). MameBM What is your conclusion? conclude that there is a significant relationship between expense and weekly usage V w c. Jensen expects the new machine to be used 30 hours per week. What is the expected annual maintenance expense in hundreds of dollars (to 2 decimals)? $ 0 hundred Develop a 95% prediction interval for the company's annual maintenance expense for this machine (to 2 decimals). ($ 0 hundred, $ 0 hundred) d. If the maintenance contract costs $3000 per year, would you recommend purchasing the contract for the new machine in part (c)? Why or why not? Yes, the expected maintenance expense is greater than $3000 v w The regional transit authority for a major metropolitan area wants to determine whether there is any relationship between the age of a bus and the annual maintenance cost. A sample of 10 buses resulted in the following data. Click on the datafile logo to reference the data. DATA file Age of Bus (years) Maintenance Cost ($) 350 370 480 520 A W N N N N 590 550 750 800 UT 790 950 a. Develop the least squares estimated regression equation (to 4 decimals, if necessary). y = * + & Age b. Test to see whether the two variables are significantly related with a = 0.05. Reject null hypothesis c. Did the least squares line provide a good fit to the observed data? Yes d. Develop a 95% prediction interval for the maintenance cost for a specific bus that is 4 years old (to 1 decimal). $ to $A B C D E F G Age Cost 350 2 370 2 480 NO UA W N 2 520 2 590 w 550 8 4 750 4 800 10 5 790 11 5 950 12Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started