Question:Consider a company facing a demand pattern and costs as follows:MonthJanFebMarAprМayJunJulAugSepOctNovDecSequentialnumber1346.78.9101112TotalRequirements(units)20401101206030308012013040800Given: Fixed ordering cost A = $25.00, carrying cost r (per month) = $0.05 (Carrying costs are very high in this industry) and unitvariable cost v = $4.00.Using a "three-month" decision rule, the replenishment schedule and associated costs are as follows:Month1345| 789.101112TotalStartinginventoryReplenishment | 170RequirementsEndinginventoryTotal replenishment costs: $110.00Total carrying costs: $156.00Total replenishment + carrying: $256.001501109030110801704021013029080040110206030203012408001501109011080170780Construct a replenishment schedule and calculate the associated costs using the Fixed Economic Order Quantity method.20

Three month decision rule means procurement will be done once in three months i.e. the procurement…

Answered: Consider a company facing a demand…

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

QUESTION 10 An automotive warehouse stocks a variety of parts that are sold at neighborhood stores One particular part, a popular brand of oil filter, is purchased by the warehouse for $1.50 each. It is estimated that the cost of order processing and receipt is $100 per order. The company uses an inventory carrying charge based on a 25 percent annual interest rate. The monthly demand for the filter follows a normal distribution with mean 280 and standard deviation 70. Order lead time is assumed to be five months. Assume that if a filter is demanded when the warehouse is out of stock, then the demand is back-ordered, and the cost assessed for each back-ordered demand is $12.80. Determine the optimal values of the order quantity and the reorder level Q= 1358 R= 1765
QUESTION 1:A confectioner buys plastic boxes in bulk and uses them to pack chocolates. The annual requirement of these boxes is 1,200, and each box costs $30. The ordering and carrying costs are $10 per order and 20%, respectively. The supplier from whom the confectioner purchases these boxes sells them only in lots of 25, that is, you only purchase quantities in multiples of 25 boxes.(a) How many boxes should the confectioner order so as to minimise inventory total stocking costs?(b) If the supplier offers 2% discount on the cost of each box when the purchases are in quantities of 300 at a time, should the confectioner accept this offer?(c) Suppose the supplier has decided that instead of the 2% discount offer the following price breaks will be used:ORDER QUANTITY COST PER BOXLess than 100 $30.00100 to 199 $29.75200 or more $29.60What order quantity should the confectioner make?
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
Question 1: Which of the following best defines " stockout costs"? options: A) They are physical goods used in operations. B) They are costs associated with retrieving inventory items from a workshop C) They are costs associated with interruptions to assembly lines D) They are associated with inventory being unavailable when needed to meet demand. E) None of the above. Question 2 At many LCBO stores in Ontario, Hennessy Cognac is kept in a clear locked case. Based on this information, according to the ABC Inventory Analysis method, is Hennessy most likely to be classified as an A item, a B item, a C item, or none of these? Question 2 options: A) C item B) None C) A item D) B item Question 3 What purpose does Rent the Runway's high-speed reverse logistics system serve? options: A) It allows the customers to return inventory to the fulfillment centre in record time. B) It allows the company to send inventory out to recipients (customers) in record time. C) It allows customers to return…
NING SYSTEM (ACADEMIC) tory Management - Spring21 Time left 1:14:19 Alocal Omani retail store finds out the its competition is ordering 50O kgs each order of a coffee brand. Over years the local Omani store has realized that its competition has adopted an economic ordering quantity (EOQ) policy for ordering. Whereas, local Omani store has determined that it take OMR 25 to order and the annual holding cost is 25% of the price of the coffee brand. The price of the coffee brand is OMR 100 per kg. What is the annual demand for this coffee brand? Round up to the nearest integer None is correct Ob. 100,000 150,000 O d. 90,000 125.000 NEXT PAGE US PAGE
14 To calculate Economic Order Quantity (EOQ =sqrt(D*k/h)
3. Fortnex is a company that assembles small household appliances including coffee makers, toasters, and food mixers. The parent company of Fortnex has been concerned about the rising product cost of the finished products, which has led to reduced profit margins. One of the demands of the parent company has been to review the inventory management practices of Fortnex. Two areas which Fortnex is currently investigating are economic order quantity EOQ and ABC analysis. Perform the following. (i) At present the company purchases copper wire for a certain appliance under economic order quantities based on the information given in Table 3-1. The supplier of copper wire is proposing a discount of 5% of unit price if Fortnex purchases in lot sizes of 1000 kg. rather than the calculated EOQ. Determine if Fortnex should take advantage of the price discount. Justify your response. For a particular series of referenced products, the number of units used a year, and the unit cost are as shown in…
Question2: A company that sells fruit juices sells 1250 cases of fruit juice from cases priced at $50 per case in a month. The business is in city x and juices are ordered from city y. Each order costs the business $250. Storage costs are 20% of a case of fruit juice. According to this;a) the economic order quantity of the enterprise?b) How many days is the time between two orders?c) What is the total inventory cost of the business, including the acquisition costs, in dollars/month?
Question 26 Store A orders on a weekly basis. Its weekly demand is 50 units with a standard deviation of five units. The holding cost is $10 per unit per week and a 0.99 in-stock probability is desired. What will be the effect on Store A's average on-hand inventory if lead time decreases from six weeks to three weeks? Group of answer choices It will increase It will decrease It will remain the same It will double
Question 29 Which one of the following methods will be most suitable for managing dependent demand? Q-model ABC Analysis P-model The single-period model Material Requirements Planning
Question 23 A truck maintenance facility has annual demand of 25000 gallons of motor oil and operates 360 days per year. The lead time from placement of an order for motor oil until delivery is 5 days and the standard deviation of daily usage is 12.5 gallons. Use z=1.28 for a 90% service level and determine the appropriate re-order point. O 347.22 gallons 35.77 gallons 383 gallons 370 gallons
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS