4. Steel Clad Cookware (20 points) Steel Clad Cookware produces 5 different types of pans and...

Transcribed Image Text:

4. Steel Clad Cookware (20 points) Steel Clad Cookware produces 5 different types of pans and skillets: Chef's Pans, Saut Pans, Deep Skillets, French Skillets, and Nonstick Skillets. Each of these products requires different amounts of inputs as given in the following Table. In addition to those inputs in the Table, other inputs are also required but we do not need to consider them since they are in plentiful supply. Chef's Pan 2 2.8 .8 .075 Table of input per unit of product Price Variable Cost Table of input per unit of product pounds of Steel hours of Manufacturing Time hours of Polishing Time hours of Packing time The price and variable cost of each product is given below. Saut Pan 1.5 2.4 .8 .06 Chef's Pan $18.90 $13.60 Deep Skillet 1 1.8 .4 .05 Saut Pan $14.90 $10.10 Deep Skillet $12.90 $9.60 French Skillet 0.8 1.2 .4 .065 French Skillet $16.90 $13.70 Nonstick Skillet 0.5 1.6 .6 .1 Nonstick Skillet $13.90 $10.10 Steel Clad is planning its production of these products for next year and for this period it has the following resources and capacity available: 8,000 pounds of Steel, 10,000 hours of Manufacturing time, 3,000 hours of Polishing time, and 500 hours of Packing time. The company wants to maximize profit and can sell unlimited amounts of each product. However, the Marketing Department wants to sell at least 500 units of each product and it wants to sell at least twice as many Saut Pans as Chef's Pans. Steel Clad is planning its production of these products for next year and for this period it has the following resources and capacity available: 8,000 pounds of Steel, 10,000 hours of Manufacturing time, 3,000 hours of Polishing time, and 500 hours of Packing time. The company wants to maximize profit and can sell unlimited amounts of each product. However, the Marketing Department wants to sell at least 500 units of each product and it wants to sell at least twice as many Saut Pans as Chef's Pans. (a) Formulate the problem as an algebraic linear optimization model. Be sure to define your variables. (Handwrite your answer. 5 points) (b) Construct an EXCEL model for this problem (Turn in via Blackboard, 5 points) (c) Using your EXCEL model and Solver, determine an optimal solution. (Handwrite your answer. 5 points) (d) Could Steel Clad make more money if it schedules assembly workers to work overtime? Why/why not? Use the Sensitivity Report to explain. (Handwrite your answer. 5 points) 4. Steel Clad Cookware (20 points) Steel Clad Cookware produces 5 different types of pans and skillets: Chef's Pans, Saut Pans, Deep Skillets, French Skillets, and Nonstick Skillets. Each of these products requires different amounts of inputs as given in the following Table. In addition to those inputs in the Table, other inputs are also required but we do not need to consider them since they are in plentiful supply. Chef's Pan 2 2.8 .8 .075 Table of input per unit of product Price Variable Cost Table of input per unit of product pounds of Steel hours of Manufacturing Time hours of Polishing Time hours of Packing time The price and variable cost of each product is given below. Saut Pan 1.5 2.4 .8 .06 Chef's Pan $18.90 $13.60 Deep Skillet 1 1.8 .4 .05 Saut Pan $14.90 $10.10 Deep Skillet $12.90 $9.60 French Skillet 0.8 1.2 .4 .065 French Skillet $16.90 $13.70 Nonstick Skillet 0.5 1.6 .6 .1 Nonstick Skillet $13.90 $10.10 Steel Clad is planning its production of these products for next year and for this period it has the following resources and capacity available: 8,000 pounds of Steel, 10,000 hours of Manufacturing time, 3,000 hours of Polishing time, and 500 hours of Packing time. The company wants to maximize profit and can sell unlimited amounts of each product. However, the Marketing Department wants to sell at least 500 units of each product and it wants to sell at least twice as many Saut Pans as Chef's Pans. Steel Clad is planning its production of these products for next year and for this period it has the following resources and capacity available: 8,000 pounds of Steel, 10,000 hours of Manufacturing time, 3,000 hours of Polishing time, and 500 hours of Packing time. The company wants to maximize profit and can sell unlimited amounts of each product. However, the Marketing Department wants to sell at least 500 units of each product and it wants to sell at least twice as many Saut Pans as Chef's Pans. (a) Formulate the problem as an algebraic linear optimization model. Be sure to define your variables. (Handwrite your answer. 5 points) (b) Construct an EXCEL model for this problem (Turn in via Blackboard, 5 points) (c) Using your EXCEL model and Solver, determine an optimal solution. (Handwrite your answer. 5 points) (d) Could Steel Clad make more money if it schedules assembly workers to work overtime? Why/why not? Use the Sensitivity Report to explain. (Handwrite your answer. 5 points)

Answer rating: 100% (QA)

Steel Clad Cookware Linear Optimization Model a Formulating the Problem as an Algebraic Linear Optimization Model Decision Variables x1 Number of French Skillets to produce x2 Number of Chefs Pans to ... View the full answer