A1 Part 2 35 A B \begin{tabular}{l|l} fx & Part 2 \\ \hline & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|l} \hline C & D & E & F & G & H \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l} \hline H & I & J & K & L & M & N & O \end{tabular} \begin{tabular}{l|l} P & Q \end{tabular} Q R R S S T T U Type out the equation of the line on your multiple regression worksheet. 3. Assuming the following level of cost-driver volume, what is the estimated overhead cost using simple regression for each of the cost drivers and using multiple regression to estimate the cost of overhead. You should have 3 computations for this answer (you need to determine 2 since I have calculated the first one for you). 44 Cost Drivers (independent variables): Meals produced Deliveries Solution: I have estimated the overhead costs using the simple regression table output and the estimated cost driver level. Please click on the cell with my answer and you wit see that I have referenced the simple regression output worksheet that uses meals as the independent variable. You need to answer: Deliveries Answer: Multiple regression 62 4. Using the simple and multiple regression analyses above, what would you recommend 70 72 Simple Reg- Meals Scattergraph-Meals Ready Accessibility: Investigate Type here to search Do not retype the information above. You should use this worksheet as your data sheet and your solution should be on separate worksheets. When you have completed the requirements you should have this data sheet, 2-simple regression tables, 1-multiple regression table, Required: There are 4 areas to this part that are listed below with specific requirements. 1. I have developed the simple regression table and the scattergraph using Meals produced as the cost driver (l.e. independent variable) 26 You do not need to redo these, but you may want to use these as a verification that you know how to develop a scattergraph and a simple regression table. 27 Prepare the scattergraph and simple regression analysis if deliveries is the independent variable to estimate the Overhead costs. 28 Make sure you show the equation of the line and R-squared on each of your scattergraphs. 29 The output and chart for your simple regression should be on separate sheets that should be named appropriately. 30 Type the equation of the line under the regression output on each of the simple regression worksheets. 31 To make a scattergraph with data from nonadjacent columns highlight the X data (i.e. independent variable-cost driver) first and then hold down the 32 control (ctrl) key and highlight the Y data (i.e. the dependent variable-cost). 33 If you have done your scattergraphs correctly the equation of the line and the R-squared should match the output you have on your regression table. 34 (i.e. R-squared, Intercept, and X Variable.) Hint: the Y (dependent) variable is the same in all your scattergraphs and regression analyses. 35 \begin{tabular}{|l|l|l|l|l|l|l|l} Project 1 & Part 1 & Part 2 & Simple Reg-Meals & Scattergraph-Meals \end{tabular} Ready Accessibility: Investigate A1 Part 2 35 A B \begin{tabular}{l|l} fx & Part 2 \\ \hline & \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|l} \hline C & D & E & F & G & H \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l} \hline H & I & J & K & L & M & N & O \end{tabular} \begin{tabular}{l|l} P & Q \end{tabular} Q R R S S T T U Type out the equation of the line on your multiple regression worksheet. 3. Assuming the following level of cost-driver volume, what is the estimated overhead cost using simple regression for each of the cost drivers and using multiple regression to estimate the cost of overhead. You should have 3 computations for this answer (you need to determine 2 since I have calculated the first one for you). 44 Cost Drivers (independent variables): Meals produced Deliveries Solution: I have estimated the overhead costs using the simple regression table output and the estimated cost driver level. Please click on the cell with my answer and you wit see that I have referenced the simple regression output worksheet that uses meals as the independent variable. You need to answer: Deliveries Answer: Multiple regression 62 4. Using the simple and multiple regression analyses above, what would you recommend 70 72 Simple Reg- Meals Scattergraph-Meals Ready Accessibility: Investigate Type here to search Do not retype the information above. You should use this worksheet as your data sheet and your solution should be on separate worksheets. When you have completed the requirements you should have this data sheet, 2-simple regression tables, 1-multiple regression table, Required: There are 4 areas to this part that are listed below with specific requirements. 1. I have developed the simple regression table and the scattergraph using Meals produced as the cost driver (l.e. independent variable) 26 You do not need to redo these, but you may want to use these as a verification that you know how to develop a scattergraph and a simple regression table. 27 Prepare the scattergraph and simple regression analysis if deliveries is the independent variable to estimate the Overhead costs. 28 Make sure you show the equation of the line and R-squared on each of your scattergraphs. 29 The output and chart for your simple regression should be on separate sheets that should be named appropriately. 30 Type the equation of the line under the regression output on each of the simple regression worksheets. 31 To make a scattergraph with data from nonadjacent columns highlight the X data (i.e. independent variable-cost driver) first and then hold down the 32 control (ctrl) key and highlight the Y data (i.e. the dependent variable-cost). 33 If you have done your scattergraphs correctly the equation of the line and the R-squared should match the output you have on your regression table. 34 (i.e. R-squared, Intercept, and X Variable.) Hint: the Y (dependent) variable is the same in all your scattergraphs and regression analyses. 35 \begin{tabular}{|l|l|l|l|l|l|l|l} Project 1 & Part 1 & Part 2 & Simple Reg-Meals & Scattergraph-Meals \end{tabular} Ready Accessibility: Investigate
