6. Find the formulation for the coffee demand in Dubai.7. Find the constraints will ensure that if Roaster A is selected then Roaster E cannot beselected. Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee tothree UAE cities (Al-Ain, Abu Dhabi, and Dubai). The monthly demand in the three cities is as follows:CityMonthly Demand (tons)1- Al-Ain502- Abu Dhabi1203- Dubai280In order to guarantee supplies from the five coffee roasters, you need to sign a monthly contract and pay a monthly fee.If you decide to sign a contract with a roaster, then you can use its supplies and pay for transportation cost of the coffeesupplied from the roaster to the 3 cities. The production capacity of each roaster and their monthly fee are as follows:RoasterMonthly Supply (tons)Monthly Fee (contract)A75$800B150$1200с175$1350D200$1500E125$1000The transportation cost per ton of coffee from roasters to the 3 UAE cities is as follows:RoasterAl-AinAbu DhabiDubaiA$5$8$6B$3$6$7C$4$9$6D$8$5$9E$7$9$2Your company asked you to minimize the total monthly cost of coffee supply from the five roasters and coffeedistribution to the three UAE cities.

Based on the given information we have to minimize the total monthly cost of coffee supply from the…

Answered: Monthly Demand 50 abi 120 280 guarantee…

Business

Operations Management

Monthly Demand 50 abi 120 280 guarantee supplies from de to sign a contract wit rom the roaster to the 3

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

Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
Q1. An LMN sugar mill company, department stores wish to purchase 10,000 handbags of which 2,000 are of style A, 2,000 are of style B, 3,000 of style C and 3,000 are of style D. Four manufacturers P, Q, R and S bid to supply not more than the following quantities, all styles combined. P= 1,500, Q = 2,600, R = 3,500 and S = 3,000. The following table gives the cost per handbag of each style of the bidders in RO. per handbag: Style Manufacturers P Q R S A 9 12 10 8 B 10 11 9 7 C 8 10 7 10 D 10 9 9 8 Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? Compare transportation cost by both models(NWCR and LCM)
Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (UNITS) January February 4,100 4,200 March 3,900 April 4,300 May 4,900 June 4,600 July 5,200 August 4,800 September 5,300 October 5,600 November 6,200 December 5,900
Can you think of other attributes that might be associated with SUPPLY SCHEDULE?
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
11. Provide an example for each type of approach to demand analysis.
Lakewood Fashions must decide how many lots of assorted ski wear to order for its three stores. Information on pricing, sales, and inventory costs has led to the following payoff table, in thousands. Order size 2 lots 1 lot 1 lot 3 lots (a) Show a regret table. Order size 2 lots 3 lots Low 13 9 6 Low Demand Medium 16 23 38 High 16 38 61 Demand Medium (b) What decision should be made by the optimist? O 1 lot O2 lots O 3 lots (c) What decision should be made by the conservative? O 1 lot O 2 lots O3 lots (d) What decision should be made using minimax regret? O 1 lot O2 lots O 3 lots High Maximum Regret
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
1. Using the data provided here for problem 1. Calculate the following: 6 7 8 | 9 Week Demand 1| 2 3 4 5 2554 2333 4678 4525 2243 2988 2301 3777 3245 2122 2987 2487 2567 10 11 12 13 a. Average weekly demand. b. Target inventory for 98% Inventory Service Level for this period if you get replenished with new inventory every two weeks. Formulas used: a. b.
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
Problem 2: Week Forecast Customer Orders Projected On-Hand Inventory MPS Available-to-Promise On-hand Inventory schedule production whenever projected on-hand inventory drops below MPS lot size Complete the master production schedule based on the following information 160 160 30 300 1 120 110 2 100 100 3 130 75 4 110 50 5 140 32 6 140 11 7 170 5 8 180 0
4 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the Expected Monetary Value (EMV)? Alternatives Large Inventory Small Inventory Probability A) $68,400 O B)-$20,000 O C) $10,000 O D) $51,500 O E) $78,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 30