Problem 1 The demand data of product X are listed in Table 1 . Table 1 Demand Data a. Plot the data and analyze the data pattern (5) b. Use the double exponential smoothing method, assuming =0.2, and =0.15 to determine the demand for the next 5 periods. (15) c. Calculate the MAD and analyze the result (10) Score: 30 Problem 2 ABC Co. has developed a specialized airtight vacuum bag to extend the freshness of seafood shipped to restaurants. The management has put together the following demand data and capacity of each alternative in each period are shown in Table 2 and the cost data is presented in Table 3. Table 2. Forecast Data and Capacity (in Unis) a. Setup the transportation problem to solve this problem (5) b. Find the best plan using the Heuristic transportation method and prepare the MPS. (20) c. What is the cost of the plan? (5) d. Does any regular time capacity go unused? If so, how much in which periods? (5) Score : 35 Problem 3 Electro Fans Manufacturing has prepared a six-week MPS as seen in Table 4. Each fan consists of a housing assembly, two grills, a fan assembly, and an electrical unit. The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob. Table 5 gives lead times, on-hand inventory, and scheduled receipts. a. Construct a product structure tree (10). b. Prepare a Planned Order Release (POR) for Grills and Switch (25). Tahle 4. Master Production Schedule (MPS) of Fan 20" Problem 1 The demand data of product X are listed in Table 1 . Table 1 Demand Data a. Plot the data and analyze the data pattern (5) b. Use the double exponential smoothing method, assuming =0.2, and =0.15 to determine the demand for the next 5 periods. (15) c. Calculate the MAD and analyze the result (10) Score: 30 Problem 2 ABC Co. has developed a specialized airtight vacuum bag to extend the freshness of seafood shipped to restaurants. The management has put together the following demand data and capacity of each alternative in each period are shown in Table 2 and the cost data is presented in Table 3. Table 2. Forecast Data and Capacity (in Unis) a. Setup the transportation problem to solve this problem (5) b. Find the best plan using the Heuristic transportation method and prepare the MPS. (20) c. What is the cost of the plan? (5) d. Does any regular time capacity go unused? If so, how much in which periods? (5) Score : 35 Problem 3 Electro Fans Manufacturing has prepared a six-week MPS as seen in Table 4. Each fan consists of a housing assembly, two grills, a fan assembly, and an electrical unit. The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob. Table 5 gives lead times, on-hand inventory, and scheduled receipts. a. Construct a product structure tree (10). b. Prepare a Planned Order Release (POR) for Grills and Switch (25). Tahle 4. Master Production Schedule (MPS) of Fan 20