Project 1 Food services company is looking at the costs involved with their catering services. In the past the company has used meals produced as the cost driver for Overhead costs, but you have been recently hired as a consultant and have decided to use your new MBA skills to make a recommendation to management on what should be the cost driver(s) for overhead costs. You have decided to include number of deliveries in your analysis, too. Total Meals Overhead Month Deliveries produced Cost 1,340 12,690 $ 69,094 1,180 11,980 64,927 1.050 10,950 60,332 CI A W N- 930 10,280 57,953 840 9,020 55,984 780 8,130 53, 119 700 7.540 52,706 630 6,980 53,874 680 8,930 53,445 10 760 9,800 54,869 Your calculation must use cell references that reference the output from the regression tables. Cost Drivers (independent variables) Meals produced 11,500 Guidance: Deliveries 1,185 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 will see that I have referenced Solution: the simple regression output worksheet that uses meals as the Meals Produced Independent variable. Answer: $ 62,750.74 You need to answer: Deliveries Answer: X1- Deliveries $ 64,502.84 X2- Meals Produced Multiple regression $ 64,454.27 4. Using the simple and multiple regression analyses above and your regression output table, what would you recommend to estimate the Overhead Costs? Why? Make sure you discuss the Coefficient of Determination in your response. You must provide specific numbers based on your output tables in your comments. Your comments should be at least 75 words