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.6, Problem 37P
Summary Introduction
To determine: The way to satisfy the demands of the customers with less amount of waste.
Introduction: The variation between the present value of the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $50 each and gadgets have a profit margin of $40 each. To produce each item, a setup cost is incurred. This setup cost is $300 for widgets and $400 for gadgets. Widgets consume 5 units of raw material A and 4 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 600 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets.
Set up the problem in Excel and find the optimal solution.
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $45 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $500 for gadgets. Widgets consume 5 units of raw material A and 6 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 500 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets.Set up the problem in Excel and find the optimal solution.
(Leave no cells blank — be certain to enter "0" wherever required. Round your answers to 2 decimal places.)
(Round your answer to 2 decimal places.)
A manufacturer produces both widgets and gadgets. Widgets generate a profit of $25 each and gadgets have a profit margin of $75 each. To produce each item, a setup cost is incurred. This setup cost is $400 for widgets and $300 for gadgets. Widgets consume 6 units of raw material A and 8 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets.
Set up the problem in Excel and find the optimal solution.
The manufacturer will produce .......widgets and ...... gadgets
the manufacturer's profit will be ......
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
- In the lawn mower production problem in Example 8.4, experiment with the penalty cost for unsatisfied pickups in week 1. If this cost is sufficiently small, does the company ever produce fewer than seven models in week 1 and allow some week 1 pickups to be unsatisfied?arrow_forwardA company has one machine which can be used to make product Alpha and product Beta. Each unit of product Alpha requires 45 minutes of machine time, while each unit of product Beta requires 37 minutes of machine time. The machine can be used for 8 hours per day and 5 days per week. Next week the company will produce 23 units of product Alpha. After completing the production of Alpha, the company will produce product Beta. How many units of product Beta can be produced next week? Use at least 4 decimals.You must showm your calculation steps and brief explanation on your Excel spreadsheets.arrow_forwardFor a concert management company, there are multiple venues for performances in the US. The concert management company hires multiple performers. Each performance venue hosts many concerts a year. Performers perform several times a year for concerts. Each concert has one or more performers, a name, and a specified seating arrangement. A concert is held in one (and only one) of several concert halls, each of which has a hall number and the type and number of seats. Each concert generates revenues from the sales of tickets. Assume that the price of the ticket is the same for the same concert, but different prices for different concerts. Identify several 2 attributes and a key field for each entity. Represent this situation with an E-R diagram. State assumptions if any.arrow_forward
- A glassblower makes glass decanters and glass trays on a weekly basis. Each item requires 1 pound of glass, and the glassblower has 15 pounds of glass available each week. A glass de- canter requires 4 hours of labor, a glass tray requires only 1 hour of labor, and the glassblower works 25 hours a week. The profit from a decanter is $50, and the profit from a tray is $10. The glassblower wants to determine the total number of decanters (x1) and trays (x2) that he needs to produce in order to maximize his profit. Requirements:a) Define decision variables and tabulated datab) Formulate the Integer Linear Programming Model.arrow_forwardThe American National Bus Lines is proud of its 8-week bus driver training program that it conducts for all its drivers. Each 8-week training program costs the company $ 25000 for instructors, equipment and so on and is independent of the number of new drivers in the class as long as the class size remains less than or equal to 35. The training program must provide the company with 7 new fully trained drivers per month. After completing the training program, new drivers are paid $1800 per month but do not work until a full-time position is open. The company views the $1800 as holding cost necessary to maintain a supply of newly trained drivers available for immediate service. Viewing new drivers as inventory –type units, how large should the training classes be in order to minimize the total annual training and new driver idle-time costs? How many training classes should the company hold each year? What is the total annual cost of your recommendation?arrow_forwardPlease do not give solution in image format thanku A farmer in Wood County has 900 acres of land. She is going to plant each acre with corn, soybeans, or wheat. Each acre planted with corn yields a $2000 profit; each with soybeans yields a $2,500 profit; and each with wheat yields a $3,000 profit. She has 100 workers and 150 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Assuming a linear relationship, use Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. Corn Soybeans Wheat Labor(workers) 0.1 0.3 0.2 Fertilizer(tons) 0.2 0.1 0.4arrow_forward
- A paper mill sells rolls of paper to newspapers, which usually placeorders for rolls of different widths. They have just received a large order for 1 millionfeet of 4-foot-wide paper, 3 million feet of 9-foot-wide paper, and 2 million feet of 12-foot-wide paper. The mill produces rolls of the following two sizes: (1) 2,000 feet longand 12 feet wide, at a cost of $400 per roll, and (2) 2,000 feet long and 18 feet wide, ata cost of $900 per roll. Large cutting machines are used to cut these rolls to rolls ofdesired widths. What should the mill do to satisfy this order at minimum cost?(a) Define decision variables.(b) Write a suitable LP problem formulation.arrow_forwardHome mortgage lenders often charge points on a loan in order to avoid exceeding a legal limit on interest rates or to make their rates appear competitive with those of other lenders. As an example, with a two-point loan, the lender would loan only $98 for each $100 borrowed. The borrower would receive only $98 but would have to make payments just as if he or she had received $100. In this way, the lender can make more money while keeping his or her interest rate lower. Suppose that you receive a loan of $260,000 payable at the end each month for 30 years with an interest rate of 9% compounded monthly, but you have been charged three points. What is the effective interest rate on this home mortgage loan?arrow_forwardWoolworths has two types of milk packages: 2 litres and 5 litres. There are two types of customers: small families and large families. There are 200 small families and 100 large families. A small family's value is 5 for the 2 litre milk and 6 for the 5 litre milk; a large family's value is 6 for the 2 litre milk and 10 for the 5 litre milk. Woolworths does not know whether a customer has a small family or large family. The marginal cost per litre is 1. Suppose the price for the 2-litre milk is P2, and the price for the 5-litre milk is P5. If a family does not purchase milk, it gets a value of 0. Q. To maximize its profit, what prices P2 and P5 should Woolworths choose?arrow_forward
- Formulate and then solve a linear programming model of this problem, to determine how manycontainers of each product to produce tomorrow to maximize profits. The company makes fourjuice products using orange, grapefruit, and pineapple juice.Product Retail Price per QuartOrange juice $1.00Grapefruit juice .90Pineapple juice .80All-in-One 1.10The All-in-One juice has equal parts of orange, grapefruit, and pineapple juice. Each product isproduced in a one-quart size (there are four quarts in a gallon). On hand are 400 gallons of orangejuice, 300 gallons of grapefruit juice, and 200 gallons of pineapple juice. The cost per gallon is$2.00 for orange juice, $1.60 for grapefruit juice, and $1.40 for pineapple juice.In addition, the manager wants grapefruit juice to be used for no more than 30 percent of thenumber of containers produced. She wants the ratio of the number of containers of orange juice tothe number of containers of pineapple juice to be at least 7 to 5.arrow_forwardTRUE OR FALSE In a simplex maximization slack variable is added to convert the objective function to equation.arrow_forward
arrow_back_ios
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,