In Solver’s sensitivity report for the product mix model, the allowable decrease for available assembling hours is 2375. This means that something happens when assembling hours fall to 20,000 - 2375 = 17,625. See what this means by first running Solver with 17,626 available hours and then again with 17,624 available hours. Explain how the two solutions compare to the original solution and to each other.

In Solver’s sensitivity report for the product mix model, the allowable decrease for available assembling hours is 2375. This means that something happens when assembling hours fall to 20,000 - 2375 = 17,625. See what this means by first running Solver with 17,626 available hours and then again with 17,624 available hours. Explain how the two solutions compare to the original solution and to each other.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 50P

See similar textbooks

Similar questions

In a production process model such as Repco’s, certain inputs make no sense in the usage table (the range B7:D9 of the model). For example, suppose that, in addition to current usages, each unit of drug A -requires one unit of drug C. Why does this result in a nonsensical problem? What happens if you run Solver on it anyway? What happens if you run Solver on it after adding a constraint that the sum of the units produced (over all three drugs) must be at least 1?
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…
Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)
FarmFresh Foods manufactures a snack mix called TrailTime by blending three ingredients: a dried fruit mixture, a nut mixture, and a cereal mixture. Information about the three ingredients (per ounce) is shown below. Ingredient Cost Volume Fat Grams Calories Dried fruit 0.35 0.25 cup 0 150 Nut mix 0.50 0.375 cup 10 400 Cereal mix 0.20 1 cup 1 50 Let D = number of ounces of dried fruit mix in the blend; N = number of ounces of nut mix in the blend ; C = number of ounces of cereal mix in the blend. The constraint that would ensure the mixture has no more than 25 grams of fat is:
The Silly Nut Company makes two mixtures of nuts: Mixture A and Mixture B. A pound of Mixture A contains 12 oz of peanuts, 3 oz of almonds and 1 oz of cashews and sells for $4. A pound of Mixture B contains 12 oz of peanuts, 2 oz of almonds and 2 oz of cashews and sells for $5. The company has 1080 lb. of peanuts, 240 lb. of almonds, 160 lb. of cashews. How many pounds of each of mixtures A and B should the company make to maximize profit? (Hint: Use consistent units. Work the entire problem in pounds by converting all values given in ounces into fractions of pounds).
An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper ads. Information about each medium is shown below. Medium Cost per Ad # Reached Exposure Quality TV 500 10,000 30 Radio 200 3000 40 Newspaper 400 5000 25 Let T = number of TV ads; R = number of radio ads; and N = number of newspaper ads. The objective function that will produce the least total cost is:
A company produces two types of tables a and be if it takes 2jours of cutting and 4hours of assembling to produce table a .it takes 10 hours of cutting and 4hours of assembling to produce table b. The company has at most 112 hours of cutting and 54 hours of assembly.the company profit is birr 60 for each table a and 170 for each table b .how many of each type of table should produces inorder to maximize profit
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.
LINGO SOFTWARE Consider a production-mix problem where we are concerned with what mix of four products we should produce during the upcoming week. For each product, each unit produced requires a known amount of production time on each of the three machines. Each machine has a certain number of hours of production time available per week. Each product provides a certain profit per unit produced. Figure 3S1.2 shows three types of data: machine-related data, product-related data, and data related to combinations of a machine and product. The objective is to determine how much to produce for each product so that total profit is maximized while not exceeding the limited production capacity of each machine. Requirement: Solve this problem in LINGO software.
Four cleaning crews are available for a job that requires an area of 5000 square feet to be cleaned. Each cleaning crew charges a fixed cost that is only charged if the company is hired and a variable cost that is dependent on the number of square feet cleaned (see below). The job can be performed either by a single cleaner or by a combination of cleaners. Company A Cost = 0.01x2 + x + 25,000 Company B Cost = 0.14x2 - 11x + 20,000 Company C Cost = 0.07x2 - 6x + 3000 Company D Cost = 0.15x2 -10x +1000 Formulate and solve a mathematical programming model that will determine which crews to hire and how much (in square feet) of the job that each should do. What is the solution if, instead of 5000 square feet, we need to clean 10,000 square feet?
A manufacturer produces two sizes of leather handbags. It takes longer to cutand dye the leather for the smaller bag, but it takes more time sewing the largerbag. The production constraints and profit for each type of bag is given in thetable below.Cutting anddyingSewing ProfitLarge bag 0.6 hr 2 hr $30Small bag 1 hr 1.5 hr $25The machinery limits the number of bags produced to at most 1000 per week. Ifthe company has a maximum of 900 hours per week available for cutting anddying and a maximum of 1800 hours available per week for sewing, determinethe number of each type of bag that should be produced weekly to maximiseprofit. (Assume that all bags produced are also sold).
Please no written by hand and no emage Kindly create a spreadsheet from the problem description. Find the optimal solution using Excel Solver (Please show working with steps on a spreadsheet) : The Heinrich Company manufactures two types of plastic hangerracks (Foldaways and Straightaways) especially suited for mountingnear clothes dryers. Because permanent press clothing must be hungon hangers immediately after removal from the dryer, these items havebeen especially popular. However, there is some concern that thePreppie movement (popularized by its own handbook) will extinguishpolyester clothing; Heinrich is terribly interested in doing the best withthe resources it has while its products are still in demand. The firsttype of hanger rack, the Foldaway, requires 10 ounces of plasticmaterial and 0.3 hours of labor. Plastic costs Heinrich 10 cents anounce; labor costs Heinrich $20 per hour. The second type of hangerrack, the Straightaway, requires 15 ounces of plastic and 0.175…