**Please use either the AMPL method or the Excel solver method, thank you.
Section C - Complex Linear Programming Model - AMPL/Excel Solver Solution Methods For problem 5 build the LP Model from the word problem, using your desired solution method (AMPL/Excel solver). Submit all supporting work. 5. You are a senior manager working for a clothing company, and you need to plan you fall production for your professional and casual lines. Labor and Clothing Item Materials Required Price Machine Cost 3 yards of wool Tailored wool 2 yards of acetate for $300 $160 slacks lining Cashmere sweater 1.5 yards of cashmere $450 $150 Silk blouse 1.5 yards of silk $180 $100 Silk camisole 0.5 yards of silk $120 $60 2 yards of rayon Tailored skirt 1.5 yards of acetate for $270 $120 lining Wool blazer 2.5 yards of wool $320 $140 1.5 yards of acetate for lining Clothing Item Material Required Price Labor and Machine Cost Velvet Pants $350 $175 Cotton Sweater 3 yards of velvet 2 yards of acetate for lining 1.5 yards of cotton 0.5 yards of cotton 1.5 yards of velvet $130 $60 Cotton Miniskirt $75 $40 Velvet Shirt $200 $160 Button-down blouse 1.5 yards of rayon $120 $90 Price per The material costs and quantities ordered for next month are listed below. Any material that is not used in production can be sent back to the textile manufacturer for a full refund, except for scrap material. When a silk blouse or cotton sweater is produced, scrap is generated which is adequate to make a silk camisole or cotton miniskirt respectively. Therefore, whenever a silk blouse is produced, a silk camisole must be produced, and if a cotton sweater is produced, a cotton miniskirt must be produced. Material Material Yard Ordered Wool $9 45,000 yards Acetate $1.50 28,000 yards Cashmere $60 9,000 yards Silk $13 18,000 yards Rayon $2.25 30,000 yards Velvet $12 20,000 yards Cotton $2.50 30,000 yards Some items have limited demand. Specifically, velvet pants and shirts are limited to 5,500 pairs and 6,000 shirts. No more than 4,000 cashmere sweaters are expected to be sold. Additionally, because many people think silk is difficult to maintain, shirt blouses are limited to 12,000 and camisoles to 15,000. a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for the seasonal production? c). Your advisors remind you that velvet can be a volatile material, with frequent booms and flops. In order to reduce risk, you choose to exclude any velvet production. What is the new optimum solution? Section C - Complex Linear Programming Model - AMPL/Excel Solver Solution Methods For problem 5 build the LP Model from the word problem, using your desired solution method (AMPL/Excel solver). Submit all supporting work. 5. You are a senior manager working for a clothing company, and you need to plan you fall production for your professional and casual lines. Labor and Clothing Item Materials Required Price Machine Cost 3 yards of wool Tailored wool 2 yards of acetate for $300 $160 slacks lining Cashmere sweater 1.5 yards of cashmere $450 $150 Silk blouse 1.5 yards of silk $180 $100 Silk camisole 0.5 yards of silk $120 $60 2 yards of rayon Tailored skirt 1.5 yards of acetate for $270 $120 lining Wool blazer 2.5 yards of wool $320 $140 1.5 yards of acetate for lining Clothing Item Material Required Price Labor and Machine Cost Velvet Pants $350 $175 Cotton Sweater 3 yards of velvet 2 yards of acetate for lining 1.5 yards of cotton 0.5 yards of cotton 1.5 yards of velvet $130 $60 Cotton Miniskirt $75 $40 Velvet Shirt $200 $160 Button-down blouse 1.5 yards of rayon $120 $90 Price per The material costs and quantities ordered for next month are listed below. Any material that is not used in production can be sent back to the textile manufacturer for a full refund, except for scrap material. When a silk blouse or cotton sweater is produced, scrap is generated which is adequate to make a silk camisole or cotton miniskirt respectively. Therefore, whenever a silk blouse is produced, a silk camisole must be produced, and if a cotton sweater is produced, a cotton miniskirt must be produced. Material Material Yard Ordered Wool $9 45,000 yards Acetate $1.50 28,000 yards Cashmere $60 9,000 yards Silk $13 18,000 yards Rayon $2.25 30,000 yards Velvet $12 20,000 yards Cotton $2.50 30,000 yards Some items have limited demand. Specifically, velvet pants and shirts are limited to 5,500 pairs and 6,000 shirts. No more than 4,000 cashmere sweaters are expected to be sold. Additionally, because many people think silk is difficult to maintain, shirt blouses are limited to 12,000 and camisoles to 15,000. a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for the seasonal production? c). Your advisors remind you that velvet can be a volatile material, with frequent booms and flops. In order to reduce risk, you choose to exclude any velvet production. What is the new optimum solution
