Meet me during my office hours or by appointment if you have any question about this HW. Case 1 -The EGAD Bottling Company has recently expanded its bottles spring water operations to include several new flavors. Marketing manager Georgianna Mercer is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecast for the next six months, as shown in the following table: Other information been provided by the production manager as follow: Develop 2 heuristic aggregate plans (in Excel) for EGAD and compare total costs: a. Chase Strategy. Do not use backordering! b. Use in-house production only. No subcontracting. Use Inventory and Backordering if necessary. Meet me during my office hours or by appointment if you have any question about this HW. Case 1 -The EGAD Bottling Company has recently expanded its bottles spring water operations to include several new flavors. Marketing manager Georgianna Mercer is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecast for the next six months, as shown in the following table: Other information been provided by the production manager as follow: Develop 2 heuristic aggregate plans (in Excel) for EGAD and compare total costs: a. Chase Strategy. Do not use backordering! b. Use in-house production only. No subcontracting. Use Inventory and Backordering if necessary