Q3)) A firm has established a distribution network for the supply of a rawmaterial critical to its manufacturing Currently there are three origins for this raw material,which must be shipped to three manufacturing plants. The current network has thefollowing characteristics:Origin 1Origin 2Origin 3DEMANDPlant 1$7$10Plant 2$5$7$845Plant 3$2$3SUPPLY304050120/120$3$93540(a) Calculate a solution using the northwest-corner rule. Calculate the cost of this solution.(b) Calculate the solution using intuitive lowest cost method. Calculate the cost of thissolution.(c) Using the solution in (c), calculate improvement indices, iterate once. Can you achieve abetter solution? If yes, what is the cost of this solution?

The transportation problem is a linear programming problem that involves finding the optimal way to…

Answered: Q3) )A firm has established a…

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

Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.45 a copy. You sell a copy of San Pedro Times for $1.40. Daily demand is distributed normally with mean = 340 and standard deviation = 68. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) 8 Answer is complete but not entirely correct. Optimal order quantity 0.05 b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) * Answer is complete but not entirely correct. Probability 3 X %
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
The operations manager of a company extracted the following annual demand data from the research and development department of the company. Use it to answer questions 23-30. Year Price (¢) Demand Jan 6. 9500 Feb Mar April Мay June July 8 9000 8000 6800 5000 11 18 24 32 3500 40 2000 23. What is the percentage change in demand for transport services between Feb and May? (a) 0.44% (b) 4.44% (c) 44.4% (d) 45.4% 24. What is the average demand for the period \(a) 6257 (b) 6527 (c) 6752 (d) 7245 25. The percentage change in price between Jan and May is: Ya) 45.45% (b) 45.54% (c) 54.45% (d) 54.54% 26. How will a passenger pay for this transport service is he travelled six times in May? (a) 44 (b) 84 * (c) 144 (d) 244 27. How much more or less will a passenger pay if she travelled five times in April and three times in July? (a) 30- (b) (30) (c) 60 (d) (60) Page 5 of 16 Pcu IDL/supp' 636-19 28. What is the price elasticity ofr demand for this transport service hetween Inn and Muy (u) 0.319 (b)…
***** The company Marombeiro is a commercial representative of a food supplement widely consumed in gyms. The average daily demand for the product is 1,500 units and a standard deviation of 300 units. Average shipping time is 5 days. Of course, if the order is placed at the end of the week, it may take a little longer to receive the shipment, so the standard deviation of the delivery time is 2 days. The unit has a value of R$ 50.00 per unit in stock, an order cost of R$ 50.00 and an annual maintenance fee of 20%. Suppose Company Marombeiro wants to change the service to 99%. How many days of safety stock the company will have. ( )5.12 days ( )5.67 days ( )5.33 days ( )4.77 days
A jewelry shop procures a ring at $20 each and sells it at $80 each. Weekly demands for the ring over the past 20 weeks are as follows. Demand 51 52 53 54 55 56 57 58 59 60 Frequency o 1 3 2 2 3 4 2 2 1 What are the under-stocking and over-stocking costs for the shop? What is the newsvendor critical ratio? How many rings per week should the shop order? Suppose that the weekly demand is uniformly distributed between 40 and 80. How many rings per week should the shop order?
Perform an ABC analysis on the following set of products Item Annual Demand Unit Cost A211 800 R9 B390 100 R90 C003 450 R6 D100 400 R100 E707 85 R2000 F660 250 R320 G473 500 R75 H921 100 R75
1. Consider the following demand scenario: Quantity Probability 2,000 3% 2,100 8% 2,200 2,300 15% 30% 2,400 17% 2,500 12% 2,600 10% 2,700 5% Suppose the manufacturer produces at a cost of $20/unit and sells to the distributor at $40/unit. The distributor sells to end customers for $50/unit during season; unsold units are sold for $10/unit after season. 1. Assume the manufacturer will buy any unsold items at price $32/unit. What is the optimal order quantity? 2. What is the expected number of unsold items? 3. What is the profit for the distributor? 4. What is the profit for the supplier?
1) Assume that you are a manager of one of the hotels in the UAE. As you know, UAE has an excellent weather from October to April, so the room occupancy rate is high during this period. However, the occupancy rate becomes low during the period from May to September due to the hot weather and this happens every year. Based on the above information: 1- What is type of demand state that you face in this situation? Explain it? 2- And explain how can you manage this demand state in detail? 2) In this course, you were requested to provide relevant recommendations to intensive growth strategies for a selected hotel of your choice in the UAE, write a report to explain each one of them and show their relevant recommendations as follows: 1- Market penetration strategy (explain and write recommendations) 2- Market development strategy (explain and write recommendations) 3- Product development strategy (explain and write recommendations) 4- Related diversification strategy (explain and write…
Specialty Toys, Inc., sells a variety of new and innovative children's toys. As with other products, Specialty faces the decision of how may Weather Teddy units to order for coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team ask you for analysis of the stock-out probabilities for various order quantities, an estimate of the product potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty%u2019s sales forecaster predicted and expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and…
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS