Mr. Analytyks the VP of Operations and Supply Chain at Blue Bee Beverages (BBB) is planning the operations for the next year. BBB has three plants and has 150 temporary employees working at the plants. The company plans on expanding its production capacity by adding two more plants. ABC consulting has identified five potential locations from which BBB can select up to two additional sites. The table below shows the current and potential sites, the variable cost (production cost per unit) and the fixed cost (production setup cost). The company's supply chain consists of 3 distribution centers (DCs). Industrial distributors will do the last mile distribution of shipping the beverages to the retail stores. Thus, industrial distributors help BBB to achieve some economies of scale. Mr. Analytyks needs to worry only about the network optimization as the last mile distribution is done at the industrial distributor's cost. This means Mr. Analytyks scope is limited to determining how much to produce in each plant, the man power required for production, and transportation of the finished products to the DCs. The table below shows the cost of transporting a carton of the beverage to the DCs from the plant locations. The table below shows the forecasted demand of the product for the next 12 months at the DC locations. Mr. Analytyks is not so happy with the demand fluctuations. This means Ms. Resorzes, the head of the Human Resources may need to hire and fire some of the employees each month. When they spoke on the phone, she expressed her displeasure at frequent hiring and layoff. Analytyks who is a graduate from UNCW assured her that he can offset the HR requirements by means of inventory. He gave a lecture to Resorzes on how inventory, a necessary evil, can help smoothen production requirements. Currently there are 60 workers employed at the existing plants. Each employee can produce up to 1000 cartons each month. The maximum number of workers each factory can handle is 100 . The monthly cost of each employee is $3500. The hiring and firing costs are $0 and $5000 respectively. The cost of carrying inventory is $700/ carton/month. At the beginning of month 1 there is no inventory. Mr. Analytyks has tasked you to come up with two optimization models. (i) to do the site selection, and (ii) to find the production plan. Model 1 Site Selection: Consider the production and variable costs of the current and potential sites. The variable cost includes the transportation and production cost. You should ensure that the current sites are open always and maximum of two additional sites from the potential locations may be opened. Analytyks suggested you to use the aggregate 12 months demand for each DC (e.g. DC1: 995,000) in the optimization model. What is the total logistics cost (production + transportation) for the forecasted demand. You are required to provide a robust solution. Meaning if the demand increases by 15% and 20% from the current level. In these scenarios which among the potential sites will be selected. Based on the robust solution, what is your suggestion for the potential site. Model 2 Human resources planning: Based on the current monthly forecast demand data (use monthly sum of demand of all DCs e.g. Month 1,125K), find the production plan for the next year. You are required to find the number of employees hired and fired each month and the total inventory of the items carried each month. What is the total cost of your production plan. (you can solve this problem on or after the 2nd week) Mr. Analytyks the VP of Operations and Supply Chain at Blue Bee Beverages (BBB) is planning the operations for the next year. BBB has three plants and has 150 temporary employees working at the plants. The company plans on expanding its production capacity by adding two more plants. ABC consulting has identified five potential locations from which BBB can select up to two additional sites. The table below shows the current and potential sites, the variable cost (production cost per unit) and the fixed cost (production setup cost). The company's supply chain consists of 3 distribution centers (DCs). Industrial distributors will do the last mile distribution of shipping the beverages to the retail stores. Thus, industrial distributors help BBB to achieve some economies of scale. Mr. Analytyks needs to worry only about the network optimization as the last mile distribution is done at the industrial distributor's cost. This means Mr. Analytyks scope is limited to determining how much to produce in each plant, the man power required for production, and transportation of the finished products to the DCs. The table below shows the cost of transporting a carton of the beverage to the DCs from the plant locations. The table below shows the forecasted demand of the product for the next 12 months at the DC locations. Mr. Analytyks is not so happy with the demand fluctuations. This means Ms. Resorzes, the head of the Human Resources may need to hire and fire some of the employees each month. When they spoke on the phone, she expressed her displeasure at frequent hiring and layoff. Analytyks who is a graduate from UNCW assured her that he can offset the HR requirements by means of inventory. He gave a lecture to Resorzes on how inventory, a necessary evil, can help smoothen production requirements. Currently there are 60 workers employed at the existing plants. Each employee can produce up to 1000 cartons each month. The maximum number of workers each factory can handle is 100 . The monthly cost of each employee is $3500. The hiring and firing costs are $0 and $5000 respectively. The cost of carrying inventory is $700/ carton/month. At the beginning of month 1 there is no inventory. Mr. Analytyks has tasked you to come up with two optimization models. (i) to do the site selection, and (ii) to find the production plan. Model 1 Site Selection: Consider the production and variable costs of the current and potential sites. The variable cost includes the transportation and production cost. You should ensure that the current sites are open always and maximum of two additional sites from the potential locations may be opened. Analytyks suggested you to use the aggregate 12 months demand for each DC (e.g. DC1: 995,000) in the optimization model. What is the total logistics cost (production + transportation) for the forecasted demand. You are required to provide a robust solution. Meaning if the demand increases by 15% and 20% from the current level. In these scenarios which among the potential sites will be selected. Based on the robust solution, what is your suggestion for the potential site. Model 2 Human resources planning: Based on the current monthly forecast demand data (use monthly sum of demand of all DCs e.g. Month 1,125K), find the production plan for the next year. You are required to find the number of employees hired and fired each month and the total inventory of the items carried each month. What is the total cost of your production plan. (you can solve this problem on or after the 2nd week)