The problem is #30 a...if you read the question it says to get the answer you must have an excel spread sheet. Its not provided in the answer. We have to show our work and I dont know how to do this excel spread sheet. There are answers for a, b, and c, but the excel spreadsheet must be accompanied with the answers. Three other students according to the comments have ask the same thing.

I need to be able to provide an excel spreadsheet. There are answers, but I don't see the work in a spreadsheet to show the work. She is asking for one.

PROBLEMS Company are analyzing the 30, Multiple The managers of Peterson Catering the following cost costs involved in providing services. Managers have VIP number of drivers: units of meals produced, total deliveries, number of levels new customers, and new products developed. Here are the cost data and driver activity for the past 16 months. Total Meals VIP New Products overhead Produced Deliveries Services Customers 69,094 12,690 1.340 310 11.980 64,927 3............................. 60,332 10,950 1.050 245 4-........................... 57,953 10,280 205 185 6............................. 53,119 8,130 160 52,706 7,540 144 53,874 6,980 135 8,930 53,445 0............. 54,869 9,800 175 11........................... 59,985 10,560 12 61.121 11,560 1.070 13............................. 63,926 11.710 1.240 12,460 66,602 72,773 13,520 1,450 16 71,391 13,620 1,510 315 972,101 169,730 16,440 3,674 103 17 a. Using multiple regression, find the cost driver rates for each of the cost drivers. (Note: You must use a computer program such as Microsoft Excel to perform this b. Management estimates the following levels of cost driver volumes for the next month for the budget. What is the estimated cost for the budget? (Don't forget to include the intercept of the regression in your estimate.) Meals produced 1.100 Deliveries New customers New products c. Peterson's Catering Company is considering outsourcing deliveries. Compa your answer in requirement b., how would be saved per month by outsou 31. the delivery service (before much cost of outsourcing? considering the Account analysis. Refer to problem 30. a. Indicate the information in addition to that provided in problem 30 requi perform account analysis