Please answer #6 and #7 in excel format with the formulas showing. Screenshots work perfectly!

7. Given the following forecast and cost information, determine the total cost of a chase plan that uses regular time production output of 400 units per month, overtime is used when needed up to a maximum of 40 units per month, and subcontracting is used if additional units are needed to meet the forecast. Month 2 3 4 5 6 Forecast 430 400 440 450 480 480 Regular time cost = $50 per unit Overtime cost = $65 per unit Subcontracting cost = $75 per unit How would the developer use demand planning prior to the anticipated launch of a new product? How would its demand planning differ for the launch of an updated version of an existing product? 3. Suppose you were in charge of product purchasing for the men's sportswear department of a large department store in the suburbs of Chicago. How might you use top-down and bottom-up planning for your S&OP? What would likely be some of the advantages and disadvantages of each approach? 4. You have just been put in charge of a golf equipment store in the western New York region and are interested in employing some "demand influencing options" for boosting sales. Please give examples of how you would employ different options (e.g., price, advertising and promotions, etc.) for improving demand. 5. You have been named manager for a Mexican-themed restaurant at a vacation hot spot in the Dominican Republic. Your highest volume season is typically from mid-November to late March. How might you use various "supply influencing options" for improving capacity and sales planning at the restaurant? Go through each option from the textbook (e.g., varying the workforce size, use of inventories, etc.) and discuss how each option could be used to improve the efficiency of your operations. 6. Given the following forecast and cost information, determine the total cost of a plan that uses regular time production output of 600 units per month, overtime is used when needed up to a maximum of 60 units per month, and subcontracting is used if additional units are needed to meet the forecast. 8. Refer to the data in Problem 6. If backorders are allowed, determine the total cost of a plan if overtime is limited to 40 units per month and subcontracting is limited to 20 units per month. Backordering costs are $30 per unit. 9. The manager of a company that produces compressors for refrigerators has developed the following forecast for compressor demand: Month 1 2 3 4 5 6 7 Forecast 140 155 150 145 155 145 130 The company has a regular time capacity to produce 140 compressors each month, and the regular and overtime costs of production per compressor are $50 and $70, respectively. Develop a chase plan that matches the forecast and compute the total cost of this plan. 10. Develop a level production plan for the compressor demand forecast in Problem 9 by using overtime, inventory, and backlogs to absorb demand fluctuations. Inventory holding costs are $10 per month per compressor and backlog costs are $80 per month per compressor. Month 6 4 5 2 3 1 Forecast 690 650 670 570 600 630