Determine the order quantity, reorder point, annual holding cost, and order cost, then assume a price break of $50 per order was offered for purchase quantities of 2,000 or more units per order. If you took advantage of this price break, how much would you save annually? When calculating the z-score, use the NORM.S.INV() function from excel. Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.PARAMETERItem cost$10.00VALUEOrder costAnnual holding costAnnual demandAverage weekly demandStandard deviation of weekly demandLead timeService probability$250.00 per order33% of item cost25,750 units515 per week25 units1 week95%

Order QuantityThe Economic Order Quantity (EOQ) formula is used to determine the optimal order…

Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost $10.00 VALUE Order cost Annual holding cost Annual demand Average weekly demand Standard deviation of weekly demand Lead time Service probability $250.00 per order 33% of item cost 25,750 units 515 per week 25 units 1 week 95%

Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost $10.00 VALUE Order cost Annual holding cost Annual demand Average weekly demand Standard deviation of weekly demand Lead time Service probability $250.00 per order 33% of item cost 25,750 units 515 per week 25 units 1 week 95%

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

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

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

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Pricing Decisions at Madison The Madison Company manufactures and retails a certain product. The company wants to determine the price that maximizes its profit from this product. The unit cost of producing and marketing the product is 50. Madison will certainly charge at least 50 for the product to ensure that it makes some profit. However, there is a very competitive market for this product, so that Madisons demand falls sharply when it increases its price. How should the company proceed?2 In the pricing model in Example 7.1 with the constant elasticity demand function, the assumption is that all units demanded are sold. Suppose the company has the capacity to produce only 200 units. If demand is less than capacity, all of demand is sold. If demand is greater than or equal to capacity, only 200 units are sold. Use Solver to find the optimal price and the corresponding profit. Then use SolverTable to see how sensitive these answers are to the production capacity, letting it vary from 170 to 230 in increments of 10. Discuss your findings relative to the original solution in Example 7.1. In other words, what is the effect of capacity on the optimal price and profit?