A manufacturer produces both widgets and gadgets. Widgets generate a profit of $70 each and gadgets have a profit margin of $50each. To produce each item, a setup cost is incurred. This setup cost is $600 for widgets and $300 for gadgets. Widgets consume 6units 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. Eachday, the manufacturer has 600 units of each raw material available. Assume that it is possible to produce fractional quantities ofwidgets and gadgets.Set up the problem in Excel and find the optimal solution.a. The manufacturerwidgets andgadgets.(Leave no cells blank – be certain to enter "O" wherever required. Round your answers to 2 decimal places.)b. The manufacturer will producewidgets andgadgetsMc

Answered: Image /qna-images/answer/a177d4ff-6708-4e38-b96a-36994671903f.jpg

Answered: A manufacturer produces both widgets…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 73P

See similar textbooks

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?
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
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 $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 ......
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.)
Stan Moneymaker needs 15 gallons of gasoline to top off his automobile’s gas tank. If he drives an extra eight miles (round trip) to a gas station on the outskirts of town, Stan can save $0.10 per gallon on the price of gasoline. Suppose gasoline costs $3.90 per gallon and Stan’s car gets 25 mpg for in-town driving. Should Stan make the trip to get less expensive gasoline? Each mile that Stan drives creates one pound of carbon dioxide. Each pound of CO2 has a cost impact of $0.02 on the environment. What other factors (cost and otherwise) should Stan consider in his decision making?
Based on Zangwill (1992). Murray Manufacturingruns a day shift and a night shift. Regardless of thenumber of units produced, the only production costduring a shift is a setup cost. It costs $8000 to run theday shift and $4500 to run the night shift. Demand forthe next two days is as follows: day 1, 2000; night 1,3000; day 2, 2000; night 2, 3000. It costs $1 per unitto hold a unit in inventory for a shift.a. Determine a production schedule that minimizesthe sum of setup and inventory costs. All demandmust be met on time. (Note: Not all shifts have tobe run.)b. After listening to a seminar on the virtues of theJapanese theory of production, Murray has cut thesetup cost of its day shift to $1000 per shift and thesetup cost of its night shift to $3500 per shift. Nowdetermine a production schedule that minimizes thesum of setup and inventory costs. All demand mustbe met on time. Show that the decrease in setupcosts has actually raised the average inventorylevel. Is this reasonable?
A company produces three types of items. A singlemachine is used to produce the three items on a cyclicalbasis. The company has the policy that every item isproduced once during each cycle, and it wants to determinethe number of production cycles per year that will minimizethe sum of holding and setup costs (no shortages areallowed). The following data are given:Pi number of units of product i that could be producedper year if the machine were entirely devoted toproducing product iDi annual demand for product iKi cost of setting up production for product ihi cost of holding one unit of product i in inventoryfor one yeara Suppose there are N cycles per year. Assuming thatduring each cycle, a fraction N1of all demand for eachproduct is met, determine the annual holding cost andthe annual setup cost.b Let qi* be the number of units of product i producedduring each cycle. Determine the optimal value of N(call it N*) and qi*. c Let EROQi be the optimal production run size forproduct i if…
A jeweler and her apprentice make silver pins and necklaces by hand. Each week they have 80 hours of labor and 36 ounces of silver available. It requires 8 hours of labor and 2 ounces of silver to make a pin and 10 hours of labor and 6 ounces of silver to make a necklace. Each pin also contains a small gem of some kind. The demand for pins is no more than six per week. A pin earns the jeweler $400 in profit, and a necklace earns $100. The jeweler wants to know how many of each item to make each week to maximize profit. a. Formulate an integer programming model for this problem. b. Solve this model by using the computer. Compare this solution with the solution without integer restrictions and indicate whether the roundeddown solution would have been optimal.
During the next four months, a customer requires,respectively, 500, 650, 1000, and 700 units of acommodity, and no backlogging is allowed (that is,the customer’s requirements must be met on time).Production costs are $50, $80, $40, and $70 per unitduring these months. The storage cost from one monthto the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the endof month 4 can be sold for $60. Assume there is nobeginning inventory.a. Determine how to minimize the net cost incurred inmeeting the demands for the next four months.b. Use SolverTable to see what happens to the decisionvariables and the total cost when the initial inventoryvaries from 0 to 1000 in 100-unit increments. Howmuch lower would the total cost be if the companystarted with 100 units in inventory, rather than none?Would this same cost decrease occur for every100-unit increase in initial inventory?
Kevin runs a factory that makes stereo tuners. Each S100 takes 9 ounces of plastic and 6 ounces of metal. Each G150 requires 3 ounces of plastic and 9 ounces of metal. The factory has 360 ounces of plastic, 702 ounces of metal available, with a maximum of 24 S100 that can be built each week. If each S100 generates $13 in profit, and each G150 generates $8, how many of each of the stereo tuners should Kevin have the factory make each week to make the most profit? S100= G150= Best profit=
Carlo and Anita make mailboxes and toys in their craft shop near Lincoln. Each mailbox requires 1 hour of work from Carlo and 1 hourfrom Anita. Each toy requires 1 hour of work from Carlo and 4 hoursfrom Anita. Carlo cannot work more than 6 hours per week and Anita cannot work more than 12 hours per week. If each mailbox sells for $12 and each toy sells for $23, then how many of each should they make to maximize their revenue? What is their maximum revenue? Carlo and Anita should make, x mailboxes and y toys. Their maximum revenue is:

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS