Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products, regular grind and super grind, from the same raw materials. After reviewing the production rate, demand, and profit for each of the two types of grind, Malloy Milling found the following linear optimization model for profit, where R is the number of tons of regular grind produced and S is the number of tons of super grind produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 1000 R + 1900 S R+S2 700 R S (Total production) 5* 168 R2 400 S2 200 (Time limitation) (Demand for regular grind) (Demand for super grind) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce tons of regular grind and tons of super grind. This solution gives the V possible profit, which is $ (Type integers or decimals rounded to two decimal places as needed.) Questior Viewer

Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products, regular grind and super grind, from the same raw materials. After reviewing the production rate, demand, and profit for each of the two types of grind, Malloy Milling found the following linear optimization model for profit, where R is the number of tons of regular grind produced and S is the number of tons of super grind produced. Implement the linear optimization model on a spreadsheet and use Solver to find an optimal solution Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables. Maximize Profit = 1000 R + 1900 S R+S2 700 R S (Total production) 5* 168 R2 400 S2 200 (Time limitation) (Demand for regular grind) (Demand for super grind) Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce tons of regular grind and tons of super grind. This solution gives the V possible profit, which is $ (Type integers or decimals rounded to two decimal places as needed.) Questior Viewer

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section11.4: Marketing Models

Problem 35P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
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?
Define the different components (y, x, a, and b) of a linearregression equation
North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77.0 +0.43Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Winter Spring Summer Fall In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place): Quarter Winter Factor (Index) 0.80 1.20 1.40 0.60 Spring Summer Fall Energy Use
each company sinks wells of the same size at the same time. If both companies sink wide wells, each will extract 2 million barrels in 6 months, but each company will receive profit of only GHC 1 million. On the other if each company sinks a narrow well, it will take a year for Clampett and TEXplor to extract their respective shares, but their profits will be GHC14 million apiece. Finally, if one company drills a wide well while the other company drills a narrow well, the first company will extract 3 million barrels and the second company will extract only 1 million barrels. In this case, the first company will earn profits of GHC 16 million and the second company will actually lose GHC 1million.1. Illustrate this using a normal form game. 2. Does either firm have a strictly dominant strategy? If yes, what is (are) these strategies? Explain your answer. 3. What strategy will each firm adopt? Explain your answer. 4. Does this game have a Nash equilibrium? Explain your answer5. Is…
FIND THE OPTIMUM SOLUTION TO X= Y= MAX Z=
A manager uses this equation to predict demand for landscaping services: Ft = 14 + 4t. Over the past eight periods, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 Demand: 20 25 25 35 35 40 45 50 Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period t Tracking Signal 1 2 3 4 5 6 7 8
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
4. Explain how the logit model overcomes the problems associated with the Linera Probability Model in binary dependent variaraile model.
Long-Life Insurance has developed a linear model that it uses to determine the amount of term life Insurance a family of four should have, based on the current age of the head of the household. The equation is: y=150 -0.10x where y= Insurance needed ($000) x = Current age of head of household b. Use the equation to determine the amount of term life Insurance to recommend for a family of four of the head of the household is 40 years old. (Round your answer to 2 decimal places.) Amount of term life insurance thousands