The yearly demand of a product is 15000 units. Annual inventory holding cost is $25 per unit. The fixed ordering cost is $75. There are 300 work days in a year and the lead time is 2 working days. (a) Find the economic order quantity (b) Find the annual holding cost. (c) Find the annual ordering cost. (d) Compute the reorder point.

The yearly demand of a product is 15000 units. Annual inventory holding cost is $25 per unit. The fixed ordering cost is $75. There are 300 work days in a year and the lead time is 2 working days. (a) Find the economic order quantity (b) Find the annual holding cost. (c) Find the annual ordering cost. (d) Compute the reorder point.

Name: The yearly demand of a product is 15000 units. Annual inventory holdi
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: The yearly demand of a product is 15000 units. Annual inventory holding cost is $25 per unit. Thefixed ordering cost is $75. There are 300 work days in a year and the lead time is 2 working days.(a) Find the economic order quantity(b) Find the annua

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

www.www A toy manufacturer uses approximately 40000 silicon chips annually. The chips are used at a steady rate during 350 working days per year. The annual holding cost is $4 per chip, ordering cost is $145, and lead time is 5 days. Determine the annual cost saving if company uses optimal EOQ (part a) instead of current order quantity of 3000 units (Round your answer to 1 decimal places)
SF, owner of the kebab houses, uses 20 pounds of mince each day in preparing meatball. Order costs for mince are $10.00 per order, and carrying costs are 4 cents per pound per day. Lead time for each order is three days, and the mince itself costs $3.00 per pound. At what point should she reorder mince? Select one: 20 pounds remaining 60 pounds remaining 100 pounds remaining 80 pounds remaining 40 pounds remaining
A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units? 4) When should the museum place an order, at how many units (i.e.: what is their reorder point or lead time demand)? Sales per week (demand) Purchase cost Order cost Annual holding cost Birdfeeder: Operating weeks per year Lead time for orders (weeks) Order size EOQ (calculated) 18 $ $ 60.00 45.00 25% of…
You have been asked by your boss to calculate the Economic Order Quantity (EOQ) for one of the major sub-components used by your firm. You have been provided the following data: The weekly demand for this part is 125 units. The cost of the sub-component is $300. The annual holding cost is 0.5% and the ordering or setup cost is $50.
4
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $8 per stone for quantities of 600 stones or more, $9 per stone for orders of 400 to 599 stones, and $10 per stone for lesser quantities. The jewelry firm operates 200 days per year. Usage rate is 25 stones per day, and ordering costs are $48. a. If carrying costs are $2 per year for each stone, find the order quantity that will minimize total annual cost. (Round your intermediate calculations and final answer to the nearest whole number.)b. If annual carrying costs are 30 percent of unit cost, what is the optimal order size? (Round your intermediate calculations and final answer to the nearest whole number.)c. If lead time is six working days, at what point should the company reorder?
Intan Store sells 240,000 cabinets per year. Based on the company's policy, a safety stock of 4 percent from yearly sales is to be maintained. The carrying cost is RM0.60 per unit annually and the ordering costs are RM150.00. The delivery time is 10 days. Order should be placed in multiple of 100 units. i. Compute the economic order quantity (assume 360 days per year). ii. Compute the total inventory cost. iii. Compute the reorder inventory level. iv. Compute the average inventory please answer complete
Enter the formulas in the template. The numeric answers are to the right. Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered $200.00 $190.00 2,500 Total Cost Order Cost Order Cost (D/Q* Ordering Cost) Carry Cost Carry Cost (Q/2* Carrying Cost) Purchase Cost (D* Price) Quantity Discount Template (Detailed Documentation) Discount Quantity Min. 1 50 90 125 150 200 Price 1,400 1,100 900 895 890 885 Demand = Carrying cost = Ordering cost = EOQ = Average Inventory Order per year = Total Cost = Quantity Ordered 72.5 72.5 90.0 125.0 150.0 200.0 $200.00 $190.00 2,500 72.5 36.3 2.8 $13,784.05 Order Cost $6,892 Total Cost $ 293,784.05 $ 233,784.05 $ 194, 105.56 $ 194,875.00 $ $ 198,500.00 $2,500.00 Order Cost (D/Q* Ordering Cost) $6,892.02 $6,892.02 $5,555.56 $4,000.00 195,583.33 $3,333.33 Carry Cost $6,892…
Please do not give solution in image formate thanku. Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in Jakarta, the company produces subcomponents at a rate of 300 per day, and it uses these subcomponents at a rate of 12,500 per year (of 250 working days). Holding costs are $22 per item per year, and ordering costs are $32 per order. a) What is the economic production quantity b) how many production runs will be made each year c) what is the max inventory level d) what percentage of time will the facility be producing components e) what is the annual cost of ordering and holding inventory
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
For the most popular craft item at Hobbies & More has an annual demand of 3600. The lead time is 16 days and sigma of d is 8. What is the approximate Reorder point with safety stock if the desired service level is 90% (Z = 1.28 from Appendix A)? [Notes: H&M operates 300 days per year; round the answer to nearest whole number]. 197 216 144 233
Demand is Normally distributed with mean of 14 per week and a weekly variance of 3. The ordering cost is $81.84. Lead time is 5 weeks. Shortages cost an estimated $1.12 per unit short to expedite orders to appease customers. The holding cost is $5.07 per week. Estimate the stockout risk if the target service level is 0.89. (Enter a number with two decimal places, e.g. 0.12)