Freshly Baked Hub has 3 warehouses and 3 branches store. The following table shows the shipping costs between each warehouse and store, the warehouse capabilities and store capacities. To Branch Store Capabilities From X Y A P 350 P 400 P 280 7,000 B P 197 P 510 P 370 8,000 P 470 P 630 P 285 12,000 Сарacity 6,000 14,000 7,000 27,000

Freshly Baked Hub has 3 warehouses and 3 branches store. The following table shows the shipping costs between each warehouse and store, the warehouse capabilities and store capacities. To Branch Store Capabilities From X Y A P 350 P 400 P 280 7,000 B P 197 P 510 P 370 8,000 P 470 P 630 P 285 12,000 Сарacity 6,000 14,000 7,000 27,000

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
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
Erett's utillity function can be written as a where zy the quanity of hambargers conmutned and zy is the quantity of milk shakes. e Income le $2,000 00. 2nd attempt Part 1 Hamburgers cost $8.00 each and the price of one milk shake is $4.00, If he is maximiziog his utility, how much will Brett spendon hamburgers? S20 Part 2 The price of hamburgers decreases to $7.37 each. Now, how much will Brett spend on hamburgers if he is maimiping his utikity? S 135.68
Demand for doughnut holes on Saturdays at Don’s Doughnut Shoppe is shown in the following table. Demand(dozens) RelativeFrequency Demand(dozens) RelativeFrequency 19 .02 25 .10 20 .06 26 .14 21 .17 27 .10 22 .02 28 .03 23 .14 29 .05 24 .17 a-1. Determine the optimal number of doughnut holes, in dozens, to stock if labor, materials, and overhead are estimated to be $4.80 per dozen, doughnut holes are sold for $6.40 per dozen, and leftover doughnut holes at the end of each day are sold the next day at half price. (Round your answer to the nearest whole number.) Optional number of doghnuts: ??? What is the resulting service level: ???
T-Shirts Unlimited is a retailer that sells every kind ofT-shirt imaginable. Th e diff erent types of T-shirts are stored indepartments that all take up the same amount of space. Given theavailable warehouse space (Figure 10-15) and a from–to matrixshowing the number of trips to and from each department (Table10-13), help T-Shirts Unlimited decide where to store each typeof T-shirt.
11. XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 100 to make and receive an order and holding cost is OR 4.5 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 499 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. 600 units b. 180 units C. 199 units d. None is correct e. 164 units f. 517 units
Two plants supply three customers with medicalsupplies. The unit costs of shipping from the plants to thecustomers, along with the supplies and demands, are givenin Table 42. TAB LE 42ToFrom Customer 1 Customer 2 Customer 3 SupplyPlant 1 $55 $65 $80 35Plant 2 $10 $15 $25 50Demand 10 10 10 a The company’s goal is to minimize the cost of meeting customers’ demands. Find two optimal bfs for thistransportation problem.b Suppose that customer 2’s demand increased by oneunit. By how much would costs increase?
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 400 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is COR 3.5 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 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the best decision that minimizes the total annual inventory cost is
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 2.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at price RO 5; quantity 200 to 499 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. 199 units O b. None is correct 500 units d. 180 units e. 220 units
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, andordering costs are $96. The following price schedule applies. Determine the following:a. The optimal order quantityb. The number of orders per yearNumber of Boxes Price per Box1,000 to 1,999 $1.25 2,000 to 4,999 1.205,000 to 9,999 1.1510,000 or more 1.10
12. 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 3.5 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 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the best decision that minimizes the total annual inventory cost is a. 185 units, Total cost = 30,649 b. 500 units, Total cost = 24,995 c. 200 units, Total cost =27,240 d. None is correct e. 450 units, Total cost = 23,500
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