Once an aileron, elevon, or flap is produced, it is either sent to the distribution center (DC) or stored until the next period. There is a limit on the number of products (units) that can be kept in storage at the end of any given period because of the size of the storage area in each plant. A maximum of 40 units of all products combined can be stored in plant A and 60 units can be stored in plant B. Shipping and inventory costs are shown below. Unit Shipping Costs (S/unit) Inventory Holding Costs Product Plant A Plant B Unit Holding Cost (S/unit/period) Product Aileron Aileron 10.40 11.20 50.00 Elevon 7.40 8.00 Elevon 43.60 Flap 8.70 9.20 Flap 55.00 The sales department provided the following production requirements based on customer contracts and agreements that must be met throughout the next six periods of production. Production Requirements for the Six Period Planning Horizon (units/period) Product Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Aileron 60 100 140 160 180 190 Elevon 220 240 250 290 320 190 Flap 130 180 200 240 220 210 Supplemental demand can be created by advertising. Advertising in any given period has an effect on demand in future periods. The unit investment costs below reflect the cost to generate one unit of additional demand in that period plus the demand generated in future periods. IED Inc. had allocated an advertising budget of $100,000 for all six periods. Product Advertising Costs Unit Investment (S/unit) Additional Demand Generated (units/period) Period t Period t+1 Period t+2 Aileron 400.00 d 0.4 d 0.2 d Elevon 300.00 d 0.4 d 0.2 d Flap 440.00 d 0.4 d 0.2 d Each unit produced has the following requirements based on the type of product (ailerons, elevons, or flaps) and the plant at which it is produced. These requirements are summarized below. Product Raw Materials and Labor Requirements Plant A Product Raw Material 1 Raw Material Labor Raw Material 1 (lbs./unit) Plant B Raw Material 2 (lbs./unit) Labor (S/hour) (lbs./unit) (hrs./unit) 2 (lbs./unit) 8.40 Aileron 184.00 8.50 178.00 8.20 8.10 Elevon 220,00 0,00 6.90 215.00 0.00 6.80 Flap 168.00 10.60 10.10 160.00 9.80 9,60 Spring 2022 IE 222 - Industrial Operations Analysis -1- Case Study Description IED Inc. operates two manufacturing plants (A and B) that have the capability to produce three different products for the aerospace industry: ailerons, elevons, and flaps. Your consulting group "Optimize Consulting" is responsible to determine a production, inventory, distribution, and marketing plan for the next six periods that will ensure profit maximization and provide management with a useful decision- making tool. In order to facilitate your analysis, IED Inc. has gathered the necessary system requirements that will be needed for your model. These include the revenues generated from sales, costs incurred throughout the manufacturing process, as well as projected demand for all periods: Revenues are generated by selling ailerons, clevons, and flaps at the following unit prices: Selling Prices Product Unit Price (S/unit) Aileron $5,000.00 Elevon $4,360.00 Flap $5.500.00 Costs associated with obtaining raw materials, production, storage and shipping are summarized below. Plant A has 1800 hours of regular time labor available per period and plant B has 2800 hours of regular time labor available per period. Overtime hours can be scheduled at both plants if necessary. Your group needs to incorporate special restrictions into the model to ensure that labor in consecutive periods does not differ by more than five percent. The table below shows costs associated with regular and overtime labor for each period. Labor Costs Regular Time Labor (S/hour) Period Overtime Labor (S/hour) 1 28.00 42.00 2 28.00 42.00 3 30.80 46.20 30.80 46.20 30.80 46.20 6 30.80 46.20 Two types of raw materials are used: 1 and 2. There are 140,000 lbs. of raw material 1 and 4,000 lbs. of raw material 2 available each period. Costs differ between plants because of the proximity of the vendor in relation to each plant. Raw material costs for each plant are: Raw Materials Costs (S/lb.) Raw Material Plant A Plant B 1 2.25 2.60 2 3.10 5.60