Operational Analysis Read Case Study “Mead Meals on Wheels” in Chapter 9 of the required text. Using the information in the case study, discuss the following: ·         MMWC buys the equipment to expand their services. Present a recommendation supporting the type of financial impact the expansion of services will have on MMWC. ·         Clearly label the calculation of the impact of food costs and the financial impact costs. Use formulas to calculate the costs and format the cells to insert a comma if there is more than three numbers and round to the nearest whole number. ·         Submit to your instructor your two-to-three page Word document (not including title and reference pages) and your Excel worksheet. Your paper should be formatted according to APA style as outlined in the approved APA style guide, and you must cite at least two scholarly sources Case Study Mead Meals on Wheels The Mead Meals on Wheels Center (MMWC) provides meals every day to the homebound elderly. The city of Wabash pays MMWC $32 per week for each person it serves. There is no shortage of demand for MMWC’s services among the elderly citizens of Wabash, and MMWC can find qualified recipients for as many meals as it can deliver. Each person helped by MMWC receives two hot meals per day, seven days per week, for a total of 14 meals every week. To service the contract, MMWC has a central kitchen that has the capacity to produce a maximum of 9,600 meals per day. It costs MMWC an average of $36,000 per week to operate the kitchen and other central facilities regardless of the number of meals that MMWC serves. This covers all of MMWC’s fixed costs (e.g., rent, equipment costs, and its personnel including administrative staff) as well as its fixed seasonal service contract costs (utilities, snow removal, etc.). The first problem that MMWC faces is figuring out how much it can afford to spend per person, per week for food to supply the program. Food is MMWC’s only variable expense. You are MMWC’s only program analyst. Question 1: The executive director has come to you to calculate how much MMWC can spend per week, per person and still break even. What do you tell the executive director? Using your work to define MMWC’s spending limit, the executive director prepared a request for bids and sent it to all of the food purveyors in and near Wabash. The best bid came in at $.50 (fifty cents) below the number that you have calculated as MMWC’s break-even per person-week. Using the lowest bid and the information given earlier, the executive director wants you to prepare a budget for MMWC in a format that will allow her to monitor MMWC’s performance on a quarterly basis for the coming year. For budgeting purposes, the executive director has told you to assume that there are 13 weeks in each quarter. You know from your experience that the fixed expenses for the organization vary by season.