Linear program 3- weekly demand The weekly demand for a product, which is held in stock is always 90 units. When an order fornew stock is placed, it is delivered almost instantaneously by an ordering cost of 50,000 isincurred. The product costs 3, 000 per unit, and it costs 15 percent of this amount to hold a unitin stock for a year. Currently, orders are placed for 2000 units. There are 50 working weeks in aand lead time is one week.yeara) The MD of the company seeks your expert advice on ways in which to determine the economic orderquantity, optimal order cycle time, re-order level and total annual inventory cost. Advise the MD, pro-viding detailed explanation using your answer. Write your answer in a form of a report to the MD.b)Advise the MD about savings, if any, could be made by changing from current order quantity of GH¢2000 units to the one obtained in (a) above.c) Describe the order policy followed by the firm based on your calculations.d) Explain any two assumptions about the order policy.

Answered: ) The MD of the company seeks your…

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

Rocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?
A firm experiences demand with a mean of 100 units perday. Lead time demand is normally distributed, with a meanof 1,000 units and a standard deviation of 200 units. It costs$6 to hold one unit for one year. If the firm wants to meet90% of all demand on time, what will be the annual cost ofholding safety stock? (Assume that each order costs $50.)
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
Rocky Mountain Tire Center sells 20,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year.The purchase price is $20 per tire if fewer than 500 tires are ordered, $18 per tire if 500 or more-but fewer than 1,000- tires a re ordered, and $17 per tire if I ,000 or more tires areordered.a) How many tires should Rocky Mountain order each time it places an order?b) What is the total cost of this policy?
A firm incurs $30 in fixed order costs per order and a holding cost per unit of $1per year. Annual demand is 10,000 units. The firm is required to order an integer multiple of500 units. What order quantity should the firm use to minimize ordering and holding costs?
A firm experiences demand with a mean of 100 units per day. Lead time demand is normally distributed with mean 1000 units and standard deviation 200 units. It costs $6 to hold one unit for one year. If the firm wants to meet 90% of all demand on time, what is the expected annual cost of holding safety stock? Assume that each order costs $50.
Lia ITZY has determined that the annual demand for number 6 screws is 100,000 screws. Lia, who works in her brother’s hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that the demand is constant throughout the year. QUESTION: How many number 6 screws should Lia order at a time if she wishes to minimize total inventory cost?
Lia ITZY has determined that the annual demand for number 6 screws is 100,000 screws. Lia, who works in her brother’s hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that the demand is constant throughout the year. QUESTION: How many orders per year would be placed? What would the annual ordering cost be?
A company has an annual demand of 2500 units. The cost to place an order to replenish inventory is SR18.75 per order, and annual inventory holding cost per unit is SR1.5. On average, delivery of an order takes 3 working days (Lead time). Assume the store is open 250 days per year. What is the optimal order size? What is the optimal number of orders per year? What is the optimal number of days between orders? What is the Reorder Point (ROP)? What is the Reorder Point (ROP) with 2 days safety stock.
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate. i) What is the cost minimizing solution for this product each year? ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.
Change the ordering simulation so that emergencyorders are never made. If demand in any week isgreater than supply, the excess demand is simplylost. Simulate the same (s, S) policies as in theexample.
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

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS