QUESTION 7 4.25 points Save Answer The ABB Manufacturing Company produces spare parts for civil construction engines. The net requirements for a highly demanded wearing part over the next 5 months are given in the table below. The setup cost is $120, and the holding cost is estimated at $1.5 per unit per month. Months 1 12 13 14 15 Requirements | 90 148 ||78 119 75 Capacity 150 160 50 120 55 a. By filling the following table, determine if there is a feasible solution to the problem or not. Cumulative requirement Cumulative capacity Answer by Yes or No. Feasibility check is satisfied: b. Determine a feasible L4L schedule using the lot-shifting technique. Fill the following table and compute the total cost corresponding to the obtained schedule. 90 |48 ||78 119 75 r r 150 120 1155 150 160 Ending Inventory The total cost of the obtained schedule: S c. Using the improvement steps, generate an improved schedule. Fill the following table. Excess capacity What is the cost of the plan found after improvements (holding cost + setup cost)? The total cost of the improved plan: $ QUESTION 7 4.25 points Save Answer The ABB Manufacturing Company produces spare parts for civil construction engines. The net requirements for a highly demanded wearing part over the next 5 months are given in the table below. The setup cost is $120, and the holding cost is estimated at $1.5 per unit per month. Months 1 12 13 14 15 Requirements | 90 148 ||78 119 75 Capacity 150 160 50 120 55 a. By filling the following table, determine if there is a feasible solution to the problem or not. Cumulative requirement Cumulative capacity Answer by Yes or No. Feasibility check is satisfied: b. Determine a feasible L4L schedule using the lot-shifting technique. Fill the following table and compute the total cost corresponding to the obtained schedule. 90 |48 ||78 119 75 r r 150 120 1155 150 160 Ending Inventory The total cost of the obtained schedule: S c. Using the improvement steps, generate an improved schedule. Fill the following table. Excess capacity What is the cost of the plan found after improvements (holding cost + setup cost)? The total cost of the improved plan: $