Design your own inventory management problem with the required input data and answer the following questions : a. What is the optimal order size? b. What is the optimal number of orders per year? What is the optimal number of days between orders?

Name: Design your own inventory management problem with the required input d
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Design your own inventory management problem with the required input data and answer the following questions : a. What is the optimal order size? b. What is the optimal number of orders per year? What is the optimal number of days between orders? d.

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.
Banana Inc. a Company that markets skin care products . The annual demond is 2400 units and ordering cost is 10 per order . The holding cost per year is 0.30 .Amount of the working days of the is 250 days in a year , Lead time of the order is 2 days . a. What is the optimal order size? b. What is the optimal number of orders per year? c. What is the optimal number of days between orders? d. What is the annual inventory cost? e. If the lead time were 2 days, what would be the reorder point? f. For what value of ordering cost would 1000 units of order size be optimal? g. Determine how often the firm should order. h. Determine the size of each order ı. At what price should the firm order?
Do all work in Excel with Formulas An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days. a. Find the optimal order quantity. b. What is the reorder point? c. How often should an order be placed? d. What is the cycle time?
A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 20 cans per day. Inventory holding costs are $0.50 per can per year. Ordering costs are $10 per order. The lead time is two weeks. Backorders are not practical— the motorist drives away.a. Based on these data, choose the appropriate inventory model and calculate the economic order quantity and reorder point. Describe in a sentence how the plan would work. Hint: Assume demand is deterministic.b. The boss is concerned about this model because the demand really varies. The standarddeviation of demand was determined from a data sample to be 6.15 cans per day. Themanager wants a 99.5 percent service probability. Determine a new inventory planbased on this information and the data in part (a). Use Qopt from part (a).
Custom Computers, Inc. assembles custom home computer systems. The heat sinks needed are bought for $12 each and are ordered in quantities of 1300 units. Annual demand is 5200 heat sinks, the annual inventory holding cost rate is $3 per unit, and the cost to place an order is estimated to be $50. Calculate the following: (a) Average inventory level (b) The number of orders placed per year (c) The total annual inventory holding cost (d) The total annual ordering cost (e) The total annual cost
The demand for a commodity is 40,000 units a year, at a steady rate. It costs $20 to place an order, and $0.40 to hold a unit for a year. Find the order size to minimize inventory costs, the number of orders placed each year, the length of the inventory cycle and the total costs of holding inventory for the year. What is the EOQ? What is the number of orders placed each year? What is the inventory cycle (length of time that the the order size will last)? in terms of weeks What is the total ordering & carrying costs at the EOQ level?
The expected annual usage of a particular material is 540,000 units, and the standard order size is 36,000 units. The invoice cost of each unit is P900, and the ordering cost per order is P240. Assuming the company does not maintain safety stock. a. What is the average inventory? b. What is the ordering cost?
An organization manufactures supplies for landscaping companies which has an annual demand of 16,000. The cost of storing each unit is $2.5/year and $50 to make an order. Say the company has 300 days of annually, answer the following questions: a. What is the optimal order quantity? b. How many orders in a year? c. How many days between orders? d. How much is the total inventory cost?
A car rental agency uses 96 boxes of staples a year. The boxes cost $5 each. It costs $10 to order staples, and it costs $0.80 to hold a box of staples in inventory for 1 year. A.) How many boxes of staples should the car rental company order each time it needs staples, to minimize the combined ordering and holding costs for staples? B.) Using the order size that minimizes the car rental agency’s combined ordering and holding costs for staples, how long will a single order of staples last the agency, before it must receive more staples? (Assume there are 52 weeks in the year for the car rental agency.) C.) Using the order size that minimizes the car rental agency’s combined ordering and holding costs for staples, how much does the car rental agency actually spend on holding costs for staples each year?
Helen needs 1159 kgs of chicken per day on average to make enchiladas for her store. The supplier charges a $67 delivery fee per order (which is independent of the order size) and $3.90 per kg. Helen’s annual holding cost is 20%. Assume 52 weeks per year and 7 days per week. If Helen wants to minimize inventory holding and ordering costs, how much chicken should she purchase with each order (in kgs)? Provide your answer as an integer value.Use Econimic Order Quantity formula. The answer is 8,513. Not sure how to get there.
Do all work in Excel showing formulas An office supply store open 5 days a week must determine the best inventory policy for boxes of copier paper. Weekly demand is nearly constant at 250 boxes and when orders are placed, then entire shipment arrives at once. The cost per box is $22 and the inventory holding cost is 30%. Orders are placed at a cost of $40 each, including preparation time and communication charges, and the lead time is 2 days. a. Find the optimal order quantity. b. What is the reorder point? c. How often should an order be placed? d. What is the cycle time?
Company XYZ makes bicycles. XYZ produces 400 bicycles a month. They must buy tires from a supplier at a cost of $20 per tire. The inventory holding cost rate is 15% and ordering costs $50 per order. Part i) Let’s assume that there is no shortage inventory allowed. Calculate optimal annual order quantity Calculate annual total inventory cost ^already have the answer for this one. Just input the whole question so it would make more sense. Part ii) Let’s assume that shortage inventory is allowed. With that being said, we know that the shortage cost per unit of item is $5 per year. <<this is the one that I am stuck on. Calculate optimal annual order quantity Calculate annual total inventory cost Hint: Each bicycle has two tires.