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

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 1 lot 2 lots 3 lots (a) Show a regret table. Order size 1 lot 2 lots 3 lots 13 9 6 Low 13 9 6 Low Demand Medium 16 24 32 16 24 32 High 16 32 61 Demand Medium (b) What decision should be made by the optimist? O 1 lot O2 lots 3 lots 16 32 61 High Maximum Regret 2:06 PM
15. Global companies that deal with the political and financial risks of conducting business in a particular foreign location face which of the following type of risk? a. Country risk b. Principal risk c. Interest rate risk d. Commodity price risk 16 The benefits of a just-in-time system for raw material usually includes a. Elimination of non-value adding operations b. Increase in the number of suppliers, thereby ensuring competitive bidding c. Maximization of the standard delivery quantity, thereby lessening the paperwork for each delivery d. Decrease in the number of deliveries required to maintain production 17. A city regulation that freezes apartment rent prices is most likely to cause a. The demand curve for apartment rentals to fall b. The supply curve for apartment rentals to rise c. The quantity demanded of apartment rentals to exceed the quantity supplied d. The quantity supplied of apartment rentals to exceed the quantity demanded 18. Which of the following is not…
1
Sheet 9: Q8 Planning model Q8. Use below table to to find the profit of the company, (production plan is 3000) Y slope 2500 2000 5500 65000 7500 95000 Unit price 15.5 Units 3000 Fixed cost 19000 Y(pkp) X(pkp) alope Var cot sotal cost Sale
7. Nowjuice, Inc., produces Shakewell fruit juice. A planner has developed an aggregate forecast for demand (in cases) for the next six months. Month May Jun Jul Forecast 4,000 4,800 5,600 Aug Sep 7,200 Oct 6,400 5,000 Use the following information to develop aggregate plans. Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Beginning inventory $10 per case 5,000 cases $16 per case $20 per case $1 per case per month 0 Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use level production. Supplement using overtime as needed. b. Use a combination of overtime (500 cases per period maximum), inventory, and subcontracting (500 cases per period maximum) to handle variations in demand. c. Use overtime up to 750 cases per period and inventory to handle variations in demand.
Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.
PROBLEM 8 Jim Huang and Roderick Wheeler were sales representatives in a computer store at a shopping mall in Arlington, Virginia, when they got the idea of going into business in the burgeoning and highly competitive microcomputer market. Jim went to Taiwan over the summer to visit relatives and made a contact with a new firm producing display monitors for microcomputers, which was looking for an East Coast distributor in America. Jim made a tentative deal with the firm to supply a maximum of 500 monitors per month and called Rod to see if he could find a building they could operate out of and some potential customers. Rod went to work. The first thing he did was send bids to several universities in Maryland, Virginia, and Pennsylvania for contracts as an authorized vendor for monitors at the schools. Next, he started looking for a facility to operate from. Jim and his operation would provide minor physical modifications to the monitors, including some labeling,…
3. The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item pro- duction. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. Week On hand 30 30 30 1 2 3 4 5 6 7 8 40 40 40 45 45 13 8 4 Item: P24 Forecast Orders Projected available balance 20 Available-to-promise MPS a. Complete the MPS time-phased record for product P24. b. Can Murphy accept the following orders? Update the MPS time-phased record for accepted orders. Amount 40 Order Desired Week 1 4 2 6 3 30 2 4 25 3 30 4882 7623
Q7. The president of Rose Bowl Enterprises, Desmond Howard, projects the firms aggregate DEMAND requirements over the next 8 months as follows: These are the monthly DEMAND, not production. MONTH JAN FEB MAR APR MAY JUN JULY AUG DEMAND 1,400 1,600 1,800 1,800 2,200 2,200 1,800 1,800 PRODUCTION 1,600 from December INVENTORY 200 from Dec plus 200 His operations manager is considering a new plan, which begins in January with 200 units on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle time costs. The plan is called plan A. Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand was given as 1,600 units per month. Therefore, the production for JAN will be 1,600. However, only 1,400 are needed. Therefore, the extra 200 produced go into inventory and there is a holding cost for inventory. Also, per the above, you already have 200 units in inventory…
Q46 Mixing Company manufactured 2,500 units of its only product during 2022. The inputs for this production are as follows: 550 pounds of Material A at a cost of $2.50 per pound 400 pounds of Material H at a cost of $3.75 per pound 700 direct labor hours at $60 per hour The firm manufactured 3,920 units of the same product in 2021 with the following inputs: 700 pounds of Material A at a cost of $2.20 per pound 560 pounds of Material H at a cost of $3.50 per pound 600 direct labor hours at $58 per hour The partial operational productivity of Material A in 2021 is: Multiple Choice 5.60 units per pound. 0.44 units per pound. 4.67 units per pound. 5.18 units per pound. 0.51 units per pound.