GoodsWest is a manufacturing company headquartered in Western Australia. It has five plants which serve different states. Tables 1-3 show the necessary data on the fixed cost of operating plants and the variable manufacturing and transportation costs. Table 1. Fixed cost of operating plants and their annual production capacity Fixed cost (1000 AUD) Plant Annual capacity (1,000 units) P1 25,000 25,000 10,000 20,000 35,000 P2 P3 P4 P5 Table 2. Annual demand at each market (1,000 units) Market WA NT QLD NSW VIC ACT SA Demand 1000 500 1500 1300 1100 200 450 Table 3. Transportation cost of every 1,000 units (1,000 AUD) WA NT QLD NSW VIC ACT SA 10 1200 20 35 25 30 30 25 25 20 25 15 35 20 25 20 25 20 25 15 15 25 15 15 25 20 15 P1 P2 P3 P4 P5 2000 1000 1500 2500 1500 10 30 25 25 15 20 TAS 350 TAS 25 25 25 15 15 Asia 2000 Asia 10 20 25 20 25

GoodsWest is a manufacturing company headquartered in Western Australia. It has five plants which serve different states. Tables 1-3 show the necessary data on the fixed cost of operating plants and the variable manufacturing and transportation costs. Table 1. Fixed cost of operating plants and their annual production capacity Fixed cost (1000 AUD) Plant Annual capacity (1,000 units) P1 25,000 25,000 10,000 20,000 35,000 P2 P3 P4 P5 Table 2. Annual demand at each market (1,000 units) Market WA NT QLD NSW VIC ACT SA Demand 1000 500 1500 1300 1100 200 450 Table 3. Transportation cost of every 1,000 units (1,000 AUD) WA NT QLD NSW VIC ACT SA 10 1200 20 35 25 30 30 25 25 20 25 15 35 20 25 20 25 20 25 15 15 25 15 15 25 20 15 P1 P2 P3 P4 P5 2000 1000 1500 2500 1500 10 30 25 25 15 20 TAS 350 TAS 25 25 25 15 15 Asia 2000 Asia 10 20 25 20 25

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.5: Introduction To @risk

Problem 19P: In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with...

See similar textbooks

Similar questions

3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds
ABC Company has correctly computed its economic order quantity at 1,000 units; however, management feels it would rather order in quantities of 1,500 units. How should ABC’s total annual purchase order cost and total annual carrying cost for an order quantity of 1,500 units compare to the respective amounts for an order quantity of 1,000 units? A. Lower purchase order cost and lower carrying cost B. Lower purchase order cost and higher carrying cost C. Higher purchase order cost and higher carrying cost D. Higher purchase order cost and lower carrying costs
Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution please
Use dynamic programming to solve 0-1 knapsack problem in which the knapsack can hold up to 13kg with the following items: Item Weight (kg) Value 1 3 12 2 5 25 3 7 50
Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
CWD Agro Inc. produces two pepper sauces, Erica and Red scorpion. These sauces are bothmade by blending two ingredients, A and B. A certain level of flexibility is permitted in theformulae for these products. The allowable percentages, along with revenue and cost data, aregiven in the following table. Up to 80 quarts of A and 60 quarts of B could be purchased.CWD can sell as much of these sauces as it produces. a. Formulate an LP whose objective is to maximise the net profit from the sale of the sauces.
Becton Labs, Inc., produces various chemical compounds for industrial use. One compound, called Fludex, is prepared using an elaborate distilling process. The company has developed standard costs for one unit of Fludex, as follows: Standard Quantityor Hours Standard Priceor Rate Standard Cost Direct materials 2.30 ounces $ 26.00 per ounce $ 59.80 Direct labor 0.50 hours $ 14.00 per hour 7.00 Variable manufacturing overhead 0.50 hours $ 3.40 per hour 1.70 Total standard cost per unit $ 68.50 During November, the following activity was recorded related to the production of Fludex: Materials purchased, 12,500 ounces at a cost of $305,625. There was no beginning inventory of materials; however, at the end of the month, 2,800 ounces of material remained in ending inventory. The company employs 21 lab technicians to work on the production of Fludex. During November, they each worked an average of 150 hours at an average pay rate of $12.00 per hour.…
1. At the beginning of each semester, BOOKY can order 60, 80, or 100 copies of the book from the publisher, each with differing discounts per book. The ordering costs are listed in the following table. Number of Books Ordered 60 80 100 Ordering Costs 6100 7700 9100 2. BOOKY can either sell the book at the retail price ($130 per copy) or offer a 10% discount ($117 per copy). The demand distributions under different selling prices are listed in the following tables. The demand distribution for the textbook when the selling price is $130 per copy. Demand Probability 70 0.6 90 0.4 The demand distribution for the textbook when the selling price is $117 per copy. Demand Probability 80 0.15 100 0.85 3. Any unmet demand for the textbook will be irrecoverable There are two decision variables in this decision problem: the ordering quantity and the selling price of the textbook. a) If BOOKY is allowed to return unsold textbooks to the publisher for a refund of…
At the beginning of month t, farmer Smith has xtbushels of wheat in his warehouse. He has the opportunityto sell wheat at a price st dollars per bushel and can buywheat at pt dollars per bushel. Farmer Smith’s warehousecan hold at most C units at the end of each month.a Formulate a recursion that can be used to maximizethe total profit earned during the next T months.b Let ft(xt) be the maximum profit that can be earnedduring months t, t 1, . . . , T, given that xt bushels of wheat are in the warehouse at the beginning of month t. By working backward, show that for appropriately cho-sen constants at and bt, ft(xt) at btxt c During any given month, show that the profit-maximizing policy has the following properties: (1) The amount sold during month t will equal either xt or zero.(2) The amount purchased during a given month will beeither zero or sufficient to bring the month’s endingstock to C bushels.
The Feed ’N Ship Ranch fattens cattle for localfarmers and ships them to meat markets in KansasCity and Omaha. The owners of the ranch seek todetermine the amounts of cattle feed to buy so thatminimum nutritional standards are satisfied and atthe same time total feed costs are minimized. Thefeed mix can be made up of the three grains thatcontain the following ingredients per pound of feed: The cost per pound of stocks X, Y, and Z is $2, $4,and $2.50, respectively. The minimum requirementper cow per month is 4 pounds of ingredient A, 5pounds of ingredient B, 1 pound of ingredient C, and8 pounds of ingredient D.The ranch faces one additional restriction: itcan obtain only 500 pounds of stock Z per month from the feed supplier, regardless of its need. Be-cause there are usually 100 cows at the Feed ’N Ship Ranch at any given time, this means that no morethan 5 pounds of stock Z can be counted on for usein the feed of each cow per month.(a) Formulate this as an LP problem.(b) Solve using…
nJuicy Juice manufactures different juices made entirely of various exotic nuts. Their primary market is China and they operate 3 plants located in Ethiopia, Tanzania and Nigeria. You have been asked to help them determine where to manufacture the two newest juices they offer, Gingko Nut and Kola Nut. Each plant has a different variable cost structure and capacity for manufacturing the different juices. Also each juice has an expected demand. Cost/unit Gingko Kola Ethiopia ¥21.00 ¥22.50 Tanzania ¥22.50 ¥24.50 Nigeria ¥23.00 ¥25.50 Capacity Units/month Ethiopia 425 Tanzania 400 Nigeria 750 Demand Units/month Gingko 550 Kola 450 same exampe is used but in this case each plant has a different fixed and variable cost structur and cpacity for manufacturing the differnt Juices. the fixed cost only applies if the plant produces any juice Capacity Unit-Month Fixed…