B. For each of the following, you are to set up a linear program and solve theproblem using the Excel Solver.5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following tableshows the shipping costs between each warehouses and store, the warehousecapabilities and store capacities.Branch StoreToCapabilitiesFromYAP 350P 400P 2807,000BP 197P 510P 3708,000P 470P 630P 28512,000Сарacity6,00014,0007,00027,000Linear Program:Solver Solution:х1 x2 х3 х4 х5 х6 х7 х8 х9Decision:Constraints:TotalSign Capability12345Minimize C:Warehouse

Answered: B. For each of the following, you are…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

2. The following table contains figures on the monthly volume and unit costs for a random sampla et 16 items from a list of 2,000 inventory items at a health care facility: Unit Cost Usage Item Unit Cost Usage Item K34 $10 200 F99 20 60 К35 25 600 D45 10 550 K36 36 150 D48 12 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30 a. Develop an A-B-C classification for these items.
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days
Greenwood Maps le/193342/discussions/topics/171826/View M Inbox (2,132) - langfordk X Haribo has manufactured gummy bears, since 1920. Those bears are currently made in 16 plants around the world. Starting in 2020, those gummy bears will also be made in the US when Haribo opens a new plant in Wisconsin. Worldwide, about 100 million gummy bears are made by Haribo per day. The ingredients in gummy bears are sugar, glucose syrup, starch, flavoring, food coloring, citric acid, and gelatin. MAR 2023 Intersession - GX Gummy bears are made in a special machine called a starch mogul. A flat gummy bear mold tray is filled with powered starch. (The flat tray is why gummy bears are flat on the backside.) A hot, liquid gummy bear mixture is poured into the tray. The tray is cooled overnight and then the gummy bears are removed and the process starts over with the now emptied tray with more of the gummy bear mixture. Gummy bears are package by machine into a variety of package sizes. The Haribo…
1. Cooking Oil Blending with Inventory A company makes very fine cooking oil used in used in high-quality restaurants for salad oil. It is a blend of 5 different vegetable oils. The following table gives the posted prices of raw vegetable oils over a 3-month period of next year. These prices can be locked in now by means of futures contracts. Raw oil prices (Pesos) Price of oil Coconut Month Corn Peanut Sesame Sunflower Jan 1.79 1.72 2.03 1.88 1.72 Feb 1.80 1.40 1.72 2.03 2.03 Mar Hardness 1.72 8.8 1.49 1.56 2.03 2.19 5.0 4.2 2.0 6.1 The hardness of the blend = weighted average of hardness of oils in the blend, must be between 3.0 and 5.8. The company's blending plant has a monthly capacity for processing: at most 150 liter of corn, peanut, and coconut oils combined at most 100 liter of sesame and sunflower oils combined At the start of the 3-month period assume that there are 300 liters of each kind of vegetable oil in storage. The plan must provide for the same quantities of each oil…
Chicago’s Treadway Tires Dealer must order tires fromits national warehouse. It costs $10,000 to place an orderand $400 to review the inventory level. Annual tire sales are N(20,000, 4,000,000). It costs $10 per year to hold a tire ininventory, and each order arrives two weeks after beingplaced (52 weeks 1 year). Assume that all shortages arebacklogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage cost is$100 per tire.
1. XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost ? Round -up to the nearest integer a. 164 units b. 199 units c. 500 units d. 180 units E. None is correct
"A chipboard company has 4 factories, Mazatenango, Retalhuleu, Escuintla and Xela. It has four major distributors of its chipboards, which are distributor 1, distributor 2, distributor 3 and distributor 4: Mazatenango Retalhuleu Escuintla Xela DEMAND D1 10 16 19 12 350 D2 12 10 18 15 300 D3 15 22 10 10 250 IN THIS CASE USE VOGEL'S APPROXIMATION METHOD D4 20 10 12 20 200 SUPPLY 150 150 350 250 1) Formulate the problem as a transportation problem, solve it with the three methods and find the optimal cost for this problem. methods and find the optimal cost for this transportation problem. (remember to go through all possible routes).
Minimize z= 5.15x1+ 4.5x2 + 4.36x3 (hundreds of dollars) s.t: ?x1 + ?x2 + ?x3 > 140 ?x1 + ?x2 + ?x3 s 200 (production capacity: hours) (warehouse capacity; hundreds of sq. ft.) ?x1+?x2 = 5 (demand for 6 oz. giasses; hundreds of cases) x1, x2, x3 20 4.5X2 -1.25 Basis Св 5X1 4.36X3 S1 S2 a3 RHS -0.75 10.7 X3 1. 4.36 -0.13 11.25 1.25 -2.5 11.5 S2 0.1 X1 5.15 C-Z How much is it worth an extra hour added to b1 on the optimal solution?
Your options for shipping $100,000 of machineparts from Baltimore to Kuala Lumpur, Malaysia, are (1) usea ship that will take 30 days at a cost of $3,800 or (2) truck theparts to Los Angeles and then ship at a total cost of $4,800.The second option will take only 20 days. You are paid via aletter of credit the day the parts arrive. Your holding cost isestimated at 30% of the value per year.a) Which option is more economical?b) What customer issues are not included in the datapresented?
Three suppliers A, B and C, each produce road grit which has to be delivered to council depots W, X, Y and Z. The stock held at each supplier and the demand from each depot is known. The cost, in pounds, of transporting one lorry load of grit from each supplier to each depot is also known. This information is given in the table. Suppliers Depot W Depot X Depot Y Depot Z Stock (Lorry Loads) Supplier A 180 110 130 290 14 Supplier B 190 250 150 280 16 Supplier C 240 270 190 120 20 Demand (Lorry Loads) 11 15 14 10 50 Use VAT method to supply out all the stocks
Pls help with below homework. A company distributes air filters for retail stores. Buy your filters from various manufacturers. Filters are purchased in lots of 1,000 units and ordering each order costs $ 40.00. Demand from retail stores is 20,000 filters per month and the cost of holding inventory is $ 0.10 per filter per month. a) What is the optimal quantity that should be ordered in relation to so many pot sizes. b) What would be the optimal amount I should ask if the cost of holding is $ 0.05 per filter per month?

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