A product has a daily demand of 50 units. Ordering cost is RO 50, and holding cost is RO 4 per unit per year. The EOQ model is appropriate. The cost-minimizing solution for this product will cost, year in total annual inventory (holding and ordering) costs. Assume there are 240 workdays. Round-up to per the nearest integer О а. 2000 O b. 2191 О с. 1200 O d. 800 Oe. None is correct

A product has a daily demand of 50 units. Ordering cost is RO 50, and holding cost is RO 4 per unit per year. The EOQ model is appropriate. The cost-minimizing solution for this product will cost, year in total annual inventory (holding and ordering) costs. Assume there are 240 workdays. Round-up to per the nearest integer О а. 2000 O b. 2191 О с. 1200 O d. 800 Oe. None is correct

Name: A product has a daily demand of 50 units. Ordering cost is RO 50, and
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A product has a daily demand of 50 units. Ordering cost is RO 50, and holding cost is RO 4 per unit peryear. The EOQ model is appropriate. The cost-minimizing solution for this product will cost.year in total annual inventory (holding and ordering)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

Using excel. Apply the EOQ model to the following quantity discountsituation for which D5 500 units per year, Co5 $40, and theannual holding cost rate is 20%. What order quantity do yourecommend?DiscountDiscountCategoryOrder Size(%)unit Cost10 to990$10.002100 or more3$9.70
A component used in a manufacturing facility is ordered from an outside supplier.Because the component is used in a variety of end products, the demand is high. Estimated demand (in thousands) over the next 10 weeks isWeek 1 2 3 4 5 6 7 8 9 10Demand 22 34 32 12 8 44 54 16 76 30The components cost 65 cents each and the interest rate used to compute the holding cost is 0.5 percent per week. The fixed order cost is estimated to be $200. (Hint:Express h as the holding cost per thousand units.)d. Which method resulted in the lowest-cost policy for this problem?
A component used in a manufacturing facility is ordered from an outside supplier.Because the component is used in a variety of end products, the demand is high. Estimated demand (in thousands) over the next 10 weeks isWeek 1 2 3 4 5 6 7 8 9 10Demand 22 34 32 12 8 44 54 16 76 30The components cost 65 cents each and the interest rate used to compute the holding cost is 0.5 percent per week. The fixed order cost is estimated to be $200. (Hint:Express h as the holding cost per thousand units.)a. What ordering policy is recommended by the Silver–Meal heuristic?
A component used in a manufacturing facility is ordered from an outside supplier.Because the component is used in a variety of end products, the demand is high. Estimated demand (in thousands) over the next 10 weeks isWeek 1 2 3 4 5 6 7 8 9 10Demand 22 34 32 12 8 44 54 16 76 30The components cost 65 cents each and the interest rate used to compute the holding cost is 0.5 percent per week. The fixed order cost is estimated to be $200. (Hint:Express h as the holding cost per thousand units.)c. What ordering policy is recommended by the least unit cost heuristic?
A component used in a manufacturing facility is ordered from an outside supplier.Because the component is used in a variety of end products, the demand is high. Estimated demand (in thousands) over the next 10 weeks isWeek 1 2 3 4 5 6 7 8 9 10Demand 22 34 32 12 8 44 54 16 76 30The components cost 65 cents each and the interest rate used to compute the holding cost is 0.5 percent per week. The fixed order cost is estimated to be $200. (Hint:Express h as the holding cost per thousand units.)b. What ordering policy is recommended by the part period balancing heuristic?
Open the A2 Liquor Company Excel file. Make the following changes: The profit for beer has increased to $6 per ton and its demand has increased to 5 tons per week. What is the profit under the optimal product mix? 14 12 18 16 Which of the following is an assumption of the basic fixed-order-quantity inventory model (for example, EOQ)? Ordering costs are variable. Lead times are constant. Lead times are unknown. Back-orders are allowed
An electronics shop sells 6000 headphones in a year and the sales is relatively constantthroughout the year. These headphones are purchased for SR 20.00 each, and the leadtime is three days. The holding cost per headphone per year is 10% of the unit cost andthe ordering cost per order is SR 75. There are 300 working days per year. Calculate thefollowing:(i) What is the annual holding cost?(ii) In minimizing the cost, how many orders would be made each year?(iii) Given the EOQ, what is the total annual inventory cost (including purchase cost)?(iv) What is the time between orders?(v) What is the ROP? Write the answer on the computer
At Dot Com, a large retailer of popular books, demand isconstant at 20,400 books per year. The cost of placing anorder to replenish stock is $35, and the annual cost of holdingis $6 per book. Stock is received 5 working days after an orderhas been placed. No backordering is allowed. Assume 250working days a year.a. What is Dot Com’s optimal order quantity?b. What is the optimal number of orders per year?c. What is the optimal interval (in working days) betweenorders?
The manager of a hardware store decides to use theEOQ with shortages model to determine the orderingpolicy for tape measures. Using economic considerations,the manager determines that she should usean order quantity of Q 5 30 and have a maximumshortageof b 5 3. The lead time for her supplier todeliver an order is L working days, where there are sixworking days in a week. (Essentially, you can ignoreSundays.) The weekly demand is for 20 tape measures.What reorder point should the manager use ifL 5 3; if L 5 5; if L 5 10? (Hint: The manager shouldplan her orders so that the inventory level is 2b whenan order arrives.)
If D = 8000 per month, S = $45 per order and H = $x per unit per month. If doubling the holding cost makes the optimal order quantity (EOQ) become 600, what is the value of x?
1. David and Beth Sheba run a health food store. Their top selling item is called Heavenly Kelp. The annual demand for this is 3200 units, and demand is constant throughout the year. The cost of placing an order is $100, while the holding cost per unit per year is $4. How many orders per year should be placed if they wish to minimize their total cost ? If you want to be eligible for partial credit, give an idea as to how you arrived at that number?
If the following data is known in determining the Quantity Discount with EOQ - Demand rate = 100.000 - Ordering Cost = 5000 - Holding/Carrying cost = 600 Price Range LOWER UPPER PRICE 1 1 1000 1000 2 1001 1500 900 3 1501 3000 800 4 3001 3500 700 5 3501 3750 650 6 3751 4000 600 Based on the data provided, determine the optimal order quantity and total cost for this case! 2 1001 1500 900 3 1501 3000 800 4 3001 3500 700 5 3501 3750 650 6 3751 4000 600