Due Date: 10/16/2021 There are two furniture manufactures, Bulldog and Eagle Furniture, in Orangeburg. Both of them can produce the items internally with each capacity of 100, or purchase from other subcontractors. These two company policies regulate that the total amounts of buying each product should not exceed one-half of the total amount of making of each product. For example, if 30 items are to be produced, only 15 or fewer items are to be purchased. For Bulldog Furniture, it will cost Su if it is produced internally and Sv to cost if it is purchased from other subcontractors. For Eagle Furniture, it will cost Sw if it is produced internally and Sx to cost if it is purchased. Now there are two customers that these two manufactures must supply the product . Their demands and unit shipping costs are given as follows: Customer 1 $10 Customer 2 $15 $10 $5 $12 $9 Bulldog (Produced Item Bulldog (Purchased Item Eagle (Produced Item Eagle (Purchased Item) Demand $5 $8 D2 D1 Name Gerardo Nma Tyriece Devin D1 120 100 80 90 D2 150 170 180 190 (a) Formulate the above problem as an LP model. (b) Solve it using Excel spreadsheet and Solver. Sz 40 Name Devin Tyriece Nma Diego Su 50 65 45 40 Sy 35 30 25 20 Sw 40 45 35 35 Sx 20 20 15 15 Sy 65 50 80 85 45 65 50 Due Date: 10/16/2021 There are two furniture manufactures, Bulldog and Eagle Furniture, in Orangeburg. Both of them can produce the items internally with each capacity of 100, or purchase from other subcontractors. These two company policies regulate that the total amounts of buying each product should not exceed one-half of the total amount of making of each product. For example, if 30 items are to be produced, only 15 or fewer items are to be purchased. For Bulldog Furniture, it will cost Su if it is produced internally and Sv to cost if it is purchased from other subcontractors. For Eagle Furniture, it will cost Sw if it is produced internally and Sx to cost if it is purchased. Now there are two customers that these two manufactures must supply the product . Their demands and unit shipping costs are given as follows: Customer 1 $10 Customer 2 $15 $10 $5 $12 $9 Bulldog (Produced Item Bulldog (Purchased Item Eagle (Produced Item Eagle (Purchased Item) Demand $5 $8 D2 D1 Name Gerardo Nma Tyriece Devin D1 120 100 80 90 D2 150 170 180 190 (a) Formulate the above problem as an LP model. (b) Solve it using Excel spreadsheet and Solver. Sz 40 Name Devin Tyriece Nma Diego Su 50 65 45 40 Sy 35 30 25 20 Sw 40 45 35 35 Sx 20 20 15 15 Sy 65 50 80 85 45 65 50