Question #1. Please show all math steps and create a table.

CASE EIGHT GLASSES A DAY (EGAD) The EGAD Bottling Company has decided to introduce a new line Backordering cost Backlogs are not allowed of premium bottled water that will include several "designer" flavors. Marketing manager Georgianna Mercer is predicting an upturn in demand based on the new offerings and the increased Among the strategies being considered are the following: public awareness of the health benefits of drinking more water. - Level production supplemented by up to 10 tankloads a She has prepared aggregate forecasts for the next six months, as month from overtime. shown in the following table (quantities are in tankloads). - A combination of overtime, inventory, and subcontracting. Regular production should be the same each month. - Using overtime for up to 15 tankloads a month, along with inventory to handle variations. Regular production should be Production manager Mark Mercer (no relation to Georgianna) has the same each month. developed the following information. (Costs are in thousands of dollars.) Question 1. The objective is to choose the plan that has the lowest cost. Which plan would you recommend? 2. Presumably, information about the new line has been shared with supply chain partners. Explain what information should be shared with various partners, and why sharing that information is important