Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6.4, Problem 18P
a)
Summary Introduction
To create: A one-way SolverTable for the steel available.
Introduction: The variation between the present value of the
b)
Summary Introduction
To create: A one-way SolverTable for the labor hours available.
Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).
c)
Summary Introduction
To create: A one-way SolverTable for the unit profit contribution of large minivans.
Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).
d)
Summary Introduction
To create: A one-way SolverTable for the minimum production level of large minivans.
Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).
e)
Summary Introduction
To create: A one-way SolverTable for the minimum production level of compact cars.
Introduction: The variation between the present value of the cash outflows and the present value of the cash inflows are known as the Net Present Value (NPV).
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The following information relates to Questions 10-11:
The production planner for Rienzo, Inc. produces two chemicals: Alpha (A) and Delta (D). Two of his resources are constrained: Jaya, of which he can get at most 8,400 litres per week; and Sanga, of which he can get at most 4,600 litres per week. Each unit of Alpha chemical requires 16 litres of Jaya and 7 litres of Sanga, while a unit of Delta chemical uses 8 litres of each type of raw material. Profits for the Alpha blend are £3.00 per unit, and profits for the Delta blend are £5.00 per unit.
Question 10
What is the objective function?
A
£1 A + £5 D = Z
B
£8 A + £16 D = Z
C
I do not wish to answer this question.
D
£3 A + £5 D = Z
E
£16 A + £8 D = Z
F
£7 A + £8 D = Z
PLEASE SHOW IN EXCEL
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table:
Production Time (hours)
Model
Cuttuing
and Sewing
Finishing
and Shipping
Profit/Glove
Regular model
1
1/2
1/8
$5
Catcher's model
3/2
1/3
1/4
$8
Assume that the company is interested in maximizing the total profit contribution.
Let R = number of units of regular model.C = number of units of catcher’s model.
Max
5 R
+
8 C
s.t.
1 R
+
C
≤
900
Cutting and sewing
R
+
C
≤
300
Finishing
R
+
C
≤
100…
The owner of Artisanal Chips etc. produces three flavors of artisanal corn chips marketed at new college graduates — pumpkin (P), chipotle adobo (C) and basement (B). He has a limited amount of the three ingredients used to produce these chips available for his next production run: 1,000 ounces of salt, 2,000 ounces of maize, and 1,200 ounces of herbs. A bag of pumpkin chips requires 2 ounces of salt, 6 ounces of maize, and 2 ounces of herbs to produce; while a bag of chipotle-adobo chips requires 6 ounces of salt, 6 ounces of maize, and 5 ounces of herbs. A bag of basement chips requires 2 ounces of salt, 3 ounces of maize, and 4 ounces of herbs. Profits for a bag of basement chips are $1, for chipotle-adobo chips is $0.60, and for a bag of pumpkin chips $0.50.
Formulate an LP that maximizes the profit of making chips using the resources on hand.
(Note that write down your whole LP.)
Chapter 6 Solutions
Practical Management Science
Ch. 6.3 - Prob. 1PCh. 6.3 - Prob. 2PCh. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Prob. 4PCh. 6.3 - Prob. 5PCh. 6.3 - Prob. 6PCh. 6.3 - Prob. 7PCh. 6.3 - Prob. 8PCh. 6.3 - Prob. 9PCh. 6.3 - Prob. 10P
Ch. 6.4 - Prob. 11PCh. 6.4 - Prob. 12PCh. 6.4 - Prob. 13PCh. 6.4 - Prob. 14PCh. 6.4 - Prob. 15PCh. 6.4 - Prob. 16PCh. 6.4 - Prob. 17PCh. 6.4 - Prob. 18PCh. 6.4 - Prob. 19PCh. 6.4 - Prob. 20PCh. 6.4 - Prob. 21PCh. 6.4 - Prob. 22PCh. 6.4 - Prob. 23PCh. 6.5 - Prob. 24PCh. 6.5 - Prob. 25PCh. 6.5 - Prob. 26PCh. 6.5 - Prob. 28PCh. 6.5 - Prob. 29PCh. 6.5 - Prob. 30PCh. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - Prob. 32PCh. 6.5 - Prob. 33PCh. 6.5 - Prob. 34PCh. 6.5 - Prob. 35PCh. 6.6 - Prob. 36PCh. 6.6 - Prob. 37PCh. 6.6 - Prob. 38PCh. 6 - Prob. 39PCh. 6 - Prob. 40PCh. 6 - Prob. 41PCh. 6 - Prob. 42PCh. 6 - Prob. 43PCh. 6 - Prob. 44PCh. 6 - Prob. 45PCh. 6 - Prob. 46PCh. 6 - Prob. 47PCh. 6 - Prob. 48PCh. 6 - Prob. 49PCh. 6 - Prob. 50PCh. 6 - Prob. 51PCh. 6 - Prob. 52PCh. 6 - Prob. 53PCh. 6 - Prob. 54PCh. 6 - Prob. 55PCh. 6 - Prob. 56PCh. 6 - Prob. 57PCh. 6 - Prob. 58PCh. 6 - Prob. 59PCh. 6 - Prob. 60PCh. 6 - Prob. 61PCh. 6 - Prob. 62PCh. 6 - Prob. 63PCh. 6 - Prob. 64PCh. 6 - Prob. 65PCh. 6 - Prob. 66PCh. 6 - Prob. 67PCh. 6 - Prob. 68PCh. 6 - Prob. 69PCh. 6 - Prob. 70PCh. 6 - Prob. 71PCh. 6 - Prob. 72PCh. 6 - Prob. 73PCh. 6 - Prob. 74PCh. 6 - Prob. 75PCh. 6 - Prob. 76PCh. 6 - Prob. 77PCh. 6 - Prob. 78PCh. 6 - Prob. 79PCh. 6 - Prob. 80PCh. 6 - Prob. 81PCh. 6 - Prob. 82PCh. 6 - Prob. 83PCh. 6 - Prob. 84PCh. 6 - Prob. 85PCh. 6 - Prob. 86PCh. 6 - Prob. 87PCh. 6 - Prob. 88PCh. 6 - Prob. 89PCh. 6 - Prob. 90PCh. 6 - Prob. 91PCh. 6 - Prob. 92PCh. 6 - This problem is based on Motorolas online method...Ch. 6 - Prob. 94PCh. 6 - Prob. 95PCh. 6 - Prob. 96PCh. 6 - Prob. 97PCh. 6 - Prob. 98PCh. 6 - Prob. 99PCh. 6 - Prob. 100PCh. 6 - Prob. 1CCh. 6 - Prob. 2CCh. 6 - Prob. 3.1CCh. 6 - Prob. 3.2CCh. 6 - Prob. 3.3CCh. 6 - Prob. 3.4CCh. 6 - Prob. 3.5CCh. 6 - Prob. 3.6C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- ABC is a small manufacturer of two types of popular all-terrain snow skis, the J and the D models. The manufacturing process consists of two principal departments: fabrication and finishing. The fabrication department has 12 skilled workers, each of whom works 7 hours per day. The finishing department has 3 workers, who also work a 7-hour shift. Each pair of J skis require 3.5 labor-hours in the fabricating department and 1 labor-hour in finishing. The D model requires 4 labor-hours in fabricating and 1.5 labor-hours in finishing. The company operates 5 days a week. ABC makes a net profit of $50 on the J model and $65 on the D model. In anticipation of the next ski-sale season, ABC must plan its production of these two models. Because of the popularity of its products and limited production capacity, its products are in high demand, and ABC can sell all it can produce each season. The company anticipates selling at least twice as many D as J models. Determine how many of each model…arrow_forwardA manufacturer of microcomputers produces four models: Portable, Student, Office, and Network. The profit per unit on each of these four models is $500, $350, $700, and $1000, respectively. The models require the labor and materials per unit shown below. Portable Student Office Network Total Labor (hrs/week) 5 5 6 8 4000 Chassis (unit/week) 1 1 1 1 400 Disk Drive (unit/week) 2 1 2 1 300 Hard Disk (unit/week) 0 0 0 1 20 Memory Chip (unit/week) 16 8 32 64 22,000 Circuit Bds. (unit/week) 1 1 2 4 10,000 How many of each model should be produced to maximize profit. What is the maximum profit?arrow_forwardAn enterprise produces P1, P2 and P3 products using H1 and H2 raw materials. Production data are presented in the table below. The labor time per unit of P1 product is twice that of P2 and three times that of P3. The entire workforce of the production facility is enough to produce 1500 units of P1 product. The market requirement for products is in the order of 3: 2: 5. Establish the Linear programming (DP) model that will maximize the profits of the business and determine the best production quantities?arrow_forward
- Due to the unavailability of desired quality of raw materials, ABC Ltd. can manufacture maximum 80 units of product A & 60 units of product B. A consumes 5 units and B consumes 6 units of raw materials in the manufacture respectively and their respective profit margins one RO 50 & RO 80. Further, A requires 1 man-day of labour per unit & B requires 2 man-day of labour per unit. The constraints operating are: Supply of raw material - maximum 600 units Supply of labour - maximum 160 man-days. Formulate as a LP model & solve graphically.arrow_forwardHart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:Department Product 1 Product 2 Product 3A 1.5 3 2B 2 1 2.5C 0.25 0.25 0.25During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $25 for product 1, $28 for product 2, and $30 for product 3. a. Formulate a linear programming model for maximizing total profit contribution. b. Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution?c. After evaluating the solution obtained in part (b), one of the production supervisors noted that production setup costs had not been taken into account. She noted that setup costs are $400 for product 1, $550 for product 2, and $600 for product 3. If the solution developed in part…arrow_forwardAMCHEM Chemical Company produces three products: A, B, and C. Each product requires labor to produce it, and production of each product creates pollutants. By law the firm is not allowed to produce more than the following pollutants per day: 200 pounds of sulfur dioxide, 300 pounds of carbon monoxide, 150 pounds of hydrogen sulfide, and 50 pounds of benzene. The total number of person-hours of labor available per day is 6000. In addition, the total output per day of products A and B combined cannot be more than the output of product C. Each pound of product A generates a profit of $5, each pound of B generates $7, and each pound of C generates $4. Pollutant and labor rates per hundred pounds of product are given here. a. Formulate this problem as a linear program to maximize daily profit.b. Solve the problem using a computer.arrow_forward
- Omega Manufacturing makes three products. Each product requires manufacturing oper-ations in three departments: A, B, and C. The labor-hour requirements, by department,are as follows:TABLE 1:Department Product 1 Product 2 Product 3A 0.25 1.00 0.50B 2.50 2.00 1.00C 2.00 1.50 3.00During the next production period, the labor-hours available are 72 in department A, 370in department B, and 450 in department C.The variable cost of producing each product, sales price of each product, and the fixedsetup cost of a production run for each product is given in Table 2.TABLE 2:Product 1 Product 2 Product 3Variable Cost (per unit) $13.50 $12.30 $11.30Setup Cost $610 $420 $530Sales Price (per unit) $31 $25 $28a) Formulate an Integer Programming model to maximize the profit.b) Solve the problem by using Excel Solver. Show the optimal solution and optimal value in your printouts.arrow_forwardAlthough the problems say solve graphically, please solve all problems using the QM for Windows software or solve manually. B.6 The Christina Alvarez Company manufactures two lines of designer yard gates, called model A and model B. Every gate requires blending a certain amount of steel and zinc, the company has available a total of 25.000 Ib of steel and 6,000 lb of zinc. Each model A gate requires a mixture of 125 Ib of steel and 20 lb of zinc, and each yields a profit of 590. Each model B gate requires 100 1b of steel and 30 ib of zinc and can be sold for a profit of $70. Find by graphical IP the best production mix of yard gates.arrow_forward3. ???????? ? =24? +32? Subject to the constraints 5? + 4? ≤ 200 3? + 5? ≤ 150 5? + 4? ≥ 100 8? + 4? ≥ 80 ?, ? ≥ 0 Solve the above LPP graphically. Draw the constraints and objective function in a graph sheet.arrow_forward
- Please use excel for this problem A furniture manufacturer produces two types of tables – country and contemporary – using three types of machines. The time required to produce the tables on each machine is given in the following table: Machine Country Contemporary Total Machine Time Available Per Week Router 3.5 4.0 1,000 Sander 4.5 6.5 2,000 Polisher 3.0 2.0 1,500 Country tables sell for $395 and contemporary tables sell for $515. Management has determined that at least 25% of the tables made should be country and at least 38% should be contemporary. How many of each type of table should the company manufacture if it wants to maximize its revenue? Formulate an LP model for this problem Create the spreadsheet model and use Solver to solve the problem.arrow_forward6. Product A requires 7.1 minutes of milling, 7 minutes for inspection, and 6 minutes of drilling per unit; product B requires 7.3 minutes of milling, 5 minutes for inspection, and 8 minutes of drilling per unit; product C requires 2.6 minutes of milling, 3 minutes for inspection, and 15 minutes of drilling. The department has 12 hours available during the next period for milling, 15 hours for inspection, and 24 hours for drilling. Product A contributes $2.0 per unit to profit, product B contributes $2.3 per unit, and product C contributes $4.0 per unit. How do you express the milling constraint mathematically? NOTE: Let A,B, and C denote respectively the number of A, B, and C to be produced. a. A + B + C <= 12 b. A + B + C <= 720 c. 7.1 A + 7.3 B + 2.6 C <= 12 d. 7.1 A + 7 B + 6C <= 12 e. 7.1 A + 7.3 B + 2.6 C <= 720arrow_forwardKane Manufacturing has a division that produces two models of fireplace grates, x units of model A and y units of model B. To produce each model A grate requires 3 lb of cast iron and 6 min of labor. To produce each model B grate requires 4 lb of cast iron and 3 min of labor. The profit for each model A grate is $4.00, and the profit for each model B grate is $3.50. Also, 1000 lb of cast iron and 20 labor-hours are available for the production of fireplace grates per day.Because of a backlog of orders for model A grates, Kane's manager had decided to produce at least 150 of these grates a day. Operating under this additional constraint, how many grates of each model should Kane produce to maximize profit? (x,y)= What is the optimal profit?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,