Question
I am stuck working through these can you please help me? Proiect 1 You have just been hired as a consultant to a large manufacturing
I am stuck working through these can you please help me?
Proiect 1 You have just been hired as a consultant to a large manufacturing company of sodas, and have decided to use your new MBA skills to make a recommendation to management on what should be the cost driver(s) for estimating the monthly overhead cost for one of the lants that manufactures this drink outside the United States. Month January February March April May June July August September October November December January February March Volume of liquid produced hectoliters 890 1 ,212 1,262 1,494 1,667 1,628 1,216 1,145 1,072 1,032 872 006 1,041 Number of Batches Water used in hectoliters 7,336 8,002 10,420 10, 326 7,746 7,168 6,933 6,759 64 68 66 73 76 891 96 94 721 691 64 62 60 60 62 Total Overhead costs for the plant 61,020 64,622 68,630 70,663 79,927 82,867 81 ,748 68,819 66,376 63,767 62,646 56,837 61 ,298 63,791 Do not retype the information above. sheets. Requi red: You should use this workshe_ep.yyour data sheet and your solution should be on separate 1 _ Prepare 3 scattergraphs and 3 simple regression analyses to estimate the overhead costs using each of the cost drivers above. Make sure show(insart) the equation of the line and R-squared on each of your scattergraphs_ The output for your simple regression table should ba on a separate sheet and should type out the equation of the line below the table out ut_ I have prepared the volume of liquid produced scattergraph and regression for you, therefore, you actually only have to do 2. You may want to redo this scattergraph and regression analysis just to make sure you understand the process. have dona your scattergraph and simple regression correctly the equation of the line and tha R-squared should match the respective output. To make a scattergraph with data from nonadjacent columns highlight the X data@p_ independent variable-cost driver) first and then hold down the control .(ptrl) key and highl!ght the Y data (i_e_ the d?pendent variable-cost 2. Prepare a multiple regression table using all three of the activities as the independent variable. Using the output from the multiple regression, gwe the equation of the line to estimate factory cost in terms of the 3 cost drivers below the table output. Also, make sure identify which cost driver relates to Xl, X2, and X3l have done the first one for reads left to right Identity the 2 other X variables(l have identified the Xl variable for you, which will be the first column highlighted Volume of li uid oduced projectl DATA Simple-volume Scattergraph-volume
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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