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)
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
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
-
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...
-
Should a company's independent auditors be concerned with whether or not a client provides a non-hostile work environment for its employees? If your answer is "yes," identify the specific audit...
-
Why do most of the public company audit reports we see include unmodified audit opinions?
-
True or False: If \(E R R>M A R R\), then \(I R R>E R R>M A R R\).
-
After reviewing the waiting line analysis of Problem 12, the manager of Petes Market wants to consider one of the following alternatives for improving service. What alternative would you recommend?...
-
Solve the following complex number problems. Solutions for complex number transformation is required in this item. a. Simplify: 120 +31 18-2115 2111 +5 b. (32-120)+(1/120) (4-1)(-1-1) 5e C. 2e0.25mi...
-
Honda Motor Corporation of Japan is a leading international manufacturer of automobiles, motorcycles, all-terrain vehicles, and personal watercraft. As a Japanese company, it follows Japanese GAAP...
-
Before doing a lot of research and taking ACE444, you decided (by some friends indication) to buy a 10 year principal STRIP bond with a par value of $1000, and yield-to-maturity of 2%. You bought it...
-
An particle with charge -e is fired into a magnetic field of B = 2.9 mT. The velocity of the particle is 6.1 x 106 m/s and is perpendicular to the B field. What is the magnitude of the force this...
-
What are the recurrence relation T(n) of the following algorithm and big O notation (Please show detailed steps for full credits) long power (long x, long n) if (n == 0) return 1; else return x power...
-
The transferor's control is determined by comparing stock owned by the transferor with all outstanding stock. When is the transferor's control determined?
-
The binomial expansion 1,728x+3,456x2 +2,304x + 512 can be expressed as (ax+b)3. What is the value of b?
-
Corporate Groups and Bell Case Should the law recognize the single economic enterprise theory of corporate groups or remain with the separate legal entity approach endorsed by Walker v Wimborne?...
-
Solve the following: L-1 {5s-6s-3) Is(s+1)2 where k is a constant
-
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...
-
Discuss four important risk and tax-related considerations that are relevant to Omos portfolio. With most of Omos personal net worth tied up in his software company, he is asset rich but cash poor....
-
Determine the most appropriate strategy that can generate liquidity and accomplish Omos goals. Justify your response. Jing asks Omo about his plans for the shares of his previous employers company....
-
Recommend, for both Enlows niece and nephew, the most tax-efficient wealth transfer option (lifetime gift or testamentary bequest). Show your calculations. Recommend, for both Enlow's niece and...
Study smarter with the SolutionInn App