4. Steel Clad Cookware (20 points) Steel Clad Cookware produces 5 different types of pans and...
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
Answer rating: 100% (QA)
To maximize profit and meet the given constraints we can formulate this problem as a linear progra... View the full answer
Related Book For
Probability And Statistics For Engineering And The Sciences
ISBN: 9781305251809
9th Edition
Authors: Jay L. Devore
Posted Date:
Students also viewed these mathematics questions
-
Assume Zo's utility function is U(C, L) = CL where C is consumption measured by her total income and L is leisure. Total income is labour income and non-labour income. She has y = $400 non-labour...
-
The following data are from Gennings, Chinchilli, and Carter, (1989). An in vitro toxicity study of isolated hepatocyte suspensions was conducted to study the impact of combining carbon tetrachloride...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Calculate the pre-merger earnings per share for Admiral and Favorite and the pre-merger price-to-earnings (P/E) ratio for each company (based on the stated prices per share). Calculate the exchange...
-
1. Why do low interest rates mean that a lower-than-intended present value of retirement savings translates into a smaller-than-expected future value? 2. If interest rates rise, could Ghelfi again...
-
The minimum daily temperature at a mountain village was recorded to the nearest 0.5C on 200 consecutive days. The results are grouped into a frequency table and a histogram is drawn. The temperatures...
-
Algonquin Equipment reported the following items on November 30, 2010 (amounts in thousands, with last years amounts also given as needed): Requirements 1. Compute Algonquin Equipments (a) quick...
-
A solid round bar, 25 mm in diameter, has a groove 2.5-mm deep with a 2.5-mm radius machined into it. The bar is made of AISI 1018 CD steel and is subjected to a purely reversing torque of 200 N m....
-
A 55kg bicyclist (including the bicycle), initially at rest, pedals to the right, causing her speed to increase steadily for 6.9s. During this time she travels 34m while experiences a 60N drag and...
-
Exhibit 4 in the case shows the average cost per passenger for British Airways. Classify the listed operating expenses per passenger as fixed or variable. (Note: Assume aircraft capacity is fixed....
-
Kramer Corporation began the current period with 4,110 units in process that were 100% complete as to materials and 60% complete I as to conversion. Costs of $7,540 in direct materials and $4,820 in...
-
You plan on cooking a 20-lb (9.7 kg) turkey for Thanksgivingthis year. The change in enthalpy for the process of cooking yourturkey would be 1 thawed raw turkey (s) > 1 perfectly roastedturkey (s)...
-
25/A daredevil on a motor- cycle leaves the end of a Figure P5.24 ramp with a speed of 35.0 m/s as in Figure P5.25. If his speed is 33.0 m/s when he reaches the peak of the path, what is the maximum...
-
Morris Companies has an issue of preferred stock outstanding that pays a $28.75 dividend every year in perpetuity. What is the required return if this issue currently sells for $265.00 per share?
-
What mass of calciumchloride, CaCl 2 (molar mass = 111.0 g/mol) isneeded to prepare 2.850 L of a 1.56 M solution?
-
You are trying to find out how high you have to pitch a water balloon in order for it to burst when it hits the ground. You discover that the balloon bursts when you have pitched it to a height of 18...
-
1) Given the equation: f(x)= 5x+2 3x-1 find f'(2). 5 2) Given f(x) = - find f'(x). 3) Find and simplify the derivative of the function: S(x) = (+3)(4x +1) 4) Use Chain Rule to find the derivative of...
-
Periwinkle Company is a multinational organization. Its Parts Division is located in Lavender Land, while its Assembly Division is located in North Orchid. During the current year Periwinkle Companys...
-
Let X denote the proportion of allotted time that a randomly selected student spends working on a certain aptitude test. Suppose the pdf of X is where - 1 a. Use the method of moments to obtain an...
-
Four universities-1, 2, 3, and 4-are participating in a holiday basketball tournament. In the first round, 1 will play 2 and 3 will play 4. Then the two winners will play for the championship, and...
-
A sonnet is a 14-line poem in which certain rhyming patterns are followed. The writer Raymond Queneau published a book containing just 10 sonnets, each on a different page. However, these were...
-
What is the difference between a primary beneficiary relationship and a foreseen party relationship?
-
What is the difference between a privity relationship and a primary beneficiary relationship?
-
What is the difference between a foreseen party relationship and a foreseeable party relationship?
Study smarter with the SolutionInn App