Question
Any help on question 1 (where it says x2) is greatly appreciated! Pro-ect I You have iust been hired as a consultant to a large
Any help on question 1 (where it says x2) is greatly appreciated!
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66715cc9cc5cb_35366715cc9af9ef.jpg)
Pro-ect I You have iust been hired as a consultant to a large manufacturing company OF ships, and have decided to use our new MBA skills to make a recommendation to management on "hat should be the cost driver(s) For estimating the monthly manufacturing overhead costs Discussion with the workers and development OF an ABC analysis has revealed that overhead costs are associated with the number OF machine hours, number OF Data For the ast 12 months have been athered roduction batches, and nu You will not earn cre er OF s ecial treatments Month Machine hours Number of batches Number of s ecial Manufacturing Overhead costs 558,000 433,000 408,000 283,000 245,500 308,000 358,000 445,500 533,000 858,000 558,000 883,000 Do not retype the information above. You should use this worksheet as our data sheet and your solution should be on se arate sheets. Required: I Prepare 3 scattergraphs and 3 simple regression analyses""" to estimate the overhead costs using each OF the cost drivers abova Make sure you show(insert) the equation OF the line and R-squared on each OF your scattergraphs The output For your simple regression table should be on a separate sheet and should type out the equation OF the line below the table output I have prepared the machine hoursscattergraph and regression for you. therefore. you are preparing 2 regression tables. You may want to redo this scattergraph and regression analysis iust to make sure you understand the process. IF you have done your scattergraph and simple regression correctly the equation OF the line and the R-squared should match the respective output To make a scattergraph with data From nonadiacent columns highlight the X data (La independent variable-cost driver) First and then hold down the control (Ctrl) key and highlight the Y data (La the dependent variable-costl 2 Prepare a multiple regression table using all three OF the activities as the independent variabla using the output From the multiple regression, give the equation OF the line to estimate Factory cost in terms OF the 3 cost drivers below the table output Also,make sure you identify which cost driver relates to XI, X2, and X3--I have done the First one For you(excel reads left to ri ht the 2 other X variables(l have identified the XI variable For ou, which "ill be the First column hi hli hted Machine Hours 3 Assuming the Following level OF cost-driver volume For the month, "hat is the estimated cost using simple regression For each OF the cost drivers and using multiple regression You must use cell references on the output tables you generated on separate worksheets from the regression tables to estimate the costs. You should have 4 com utations For this answer"" am re arin the answer usin machine hours to estimate manufacturin overhead costs, therefore, ou onl have to re are 3 com utations t if ou t our numbers or do not reference the re ression worksheets.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started