Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra And Trigonometry A Unit Circle Approach,

Authors: Mark Dugopolski

6th Edition

0321867564, 9780321867568

More Books

Students also viewed these Mathematics questions

Question

What are some barriers to effective delegation?

Answered: 1 week ago

Question

2. I try to be as logical as possible

Answered: 1 week ago