Jam costs $10/jar, requires a 6mo. lead time, and willsell for $35/jar. If you stock out, you'll face a $25/jarloss of goodwill. Placing an order costs $50, andmoney that is tied up in capital is assumed to have a20% interest rate for calculating holding costs. Duringthe 6-mo replenishment time, he sells ~100 jars, butwith substantial variation. Estimates are a standarddeviation of demand during each 6-mo period of 25jars. Assume demand is described by a normaldistribution. How should the Jam be ordered?

EOQ stands for Economic Order Quantity. It is a measurement used in the field of Operations,…

Answered: Jam costs $10/jar, requires a 6mo. lead…

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

Harvey’s Specialty Shop is a popular spot that specializes in international gourmet foods. Oneof the items that Harvey sells is a popular mustard that he purchases from an English company.The mustard costs Harvey $10 a jar and requires a six-month lead time for replenishment ofstock. Harvey uses a 20 percent annual interest rate to compute holding costs and estimatesthat if a customer requests the mustard when he is out of stock, the loss-of-goodwill cost is $25a jar. Bookkeeping expenses for placing an order amount to about $50. During the six-monthreplenishment lead time, Harvey estimates that he sells an average of 100 jars, but there issubstantial variation from one six-month period to the next. He estimates that the standarddeviation of demand during each six-month period is 25. Assume that demand is described bya normal distribution. How should Harvey control the replenishment of the mustard?
A local supermarket sells a popular brand of shampoo at a fairly steady rate of 380 bottles per month. The cost of each bottle to the supermarket is 45 cents, and the cost ofplacing an order has been estimated at $8.50. Assume that holding costs are based ona 25 percent annual interest rate. Stock-outs of the shampoo are not allowed.c. If the item sells for 99 cents, what is the annual profit (exclusive of overhead andlabor costs) from this item?
I need a detailed explanation on how to solve this problem: A paint shop implements an inventory policy on its stock of white paint, which costs the store $6 per can. Monthly demand for cans of white paint is normal with mean 28 and standard deviation 8. The replenishment lead time is 14 weeks. Excess demand is backordered, but costs $10 per back ordered can in labor and loss of goodwill. There is a fixed cost of $15 per order, and the holding cost is based on 30% interest rate per annum. In your computations, assume 4 weeks per month. - Write down the model name and parameters. - What are the optimal lot size and reorder points for white paint (include the formulas)? - What is the optimal safety stock (include the formula)? *** Suppose the paint shop from the above problem adopts a service level policy. - What are the optimal lot size and reorder points for white paint, such that 90% of the cycles are filled without backordering (include all formulas)? - What is the fill rate…
The Rahway, New Jersey, plant of Metalcase, a manufacturer of office furniture, produces metaldesks at a rate of 200 per month. Each desk requires 40 Phillips head metal screws purchasedfrom a supplier in North Carolina. The screws cost 3 cents each. Fixed delivery charges and costsof receiving and storing shipments of the screws amount to about $100 per shipment, independently of the size of the shipment. The firm uses a 25 percent interest rate to determineholding costs. Metalcase would like to establish a standing order with the supplier and is considering several alternatives. What standing order size should they use?
(D) One of the managers of the business has indicated that his main objective is to cut back on his tax liability as much as possible and is of the view that the FIFO method would be best. Do you agree with him? Explain your answer clearly, with reference to the most popular methods of inventory valuation. (E) Universal Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. i) What is the total stock administrative cost of Universal’s current inventory policy?ii) Is this the entity’s cost minimizing solution for this product each year? Explain.
(D) One of the managers of the business has indicated that his main objective is to cut back on his tax liability as much as possible and is of the view that the FIFO method would be best. Do you agree with him? Explain your answer clearly, with reference to the most popular methods of inventory valuation. (E) Universal Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000 units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs the business $75 to place a single order. Currently the business places 12 orders each year. i) What is the total stock administrative cost of Universal’s current inventory policy? ii) Is this the entity’s cost minimizing solution for this product each year? Explain.
Which of the following changes in the in-stock probability increases the order quantitythe most?a. An increase in the in-stock probability from 70 percent to 80 percent.b. An increase in the in-stock probability from 70 percent to 85 percent.c. An increase in the in-stock probability from 80 percent to 90 percent.d. An increase in the in-stock probability from 80 percent to 95 percent.
I Carry rents trucks for moving and hauling. Each truck costs the company anaverage of $8,000, and the inventory of trucks varies monthly depending on thenumber that are rented out. During the first eight months of last year, I Carry hadthe following ending inventory of trucks on hand:Month Number of Trucks Month Number of TrucksJanuary 26 May 13February 38 June 9March 31 July 16April 22 August 5I Carry uses a 20 percent annual interest rate to represent the cost of capital.Yearly costs of storage amount to 3 percent of the value of each truck, and the costof liability insurance is 2 percent.a. Determine the total handling cost incurred by I Carry during the period Januaryto August. Assume for the purposes of your calculation that the holding costincurred in a month is proportional to the inventory on hand at the end of themonth.b. Assuming that these eight months are representative, estimate the average annual cost of holding trucks
What is the relationship between the average inventory and the in-stock probability?a. The more the inventory, the lower the in-stock probability.b. There isn’t a definitive relationship—more inventory could mean a lower or a higherin-stock probability.c. The more the inventory, the higher the in-stock probability.
Buckley Enterprise sells a product that cost $450 per unit and has a monthly demand of 5,000units. The annual holding cost per unit is calculated as 5% of the unit purchase price. It costs thebusiness $75 to place a single order. Currently the business places 12 orders each year.i) What is the total stock administrative cost of Buckley’s current inventory policy?ii) Is this the entity’s cost minimizing solution for this product each year? Explain.
Under the last-in, first-out (LIFO) inventory valuation method, a price index for inventory must be established for tax purposes. The quantity weights are based on year-ending inventory levels. Unit Price ($) Product EndingInventory Beginning Ending A 500 0.15 0.19 B 50 1.40 1.80 C 100 4.50 4.20 D 60 12.00 13.60 Use the beginning-of-the-year price per unit as the base-period price and develop a weighted aggregate index for the total inventory value at the end of the year. (Round your answer to the nearest integer.) I = ?? What type of weighted aggregate price index must be developed for the LIFO inventory valuation? -Paasche index -Laspeyres Index
Hammonds Corporation is trying to decide between two alternate order plans for itsinventory of a certain item. Irrespective of the plan to be followed, demand for the item isexpected to be 1,000 units annually. Under Plan A: order costs would be $ 40 per orderand inventory holding costs (carrying cost) would be $100 per unit per annum. Under PlanB order costs would be $30 per order, while holding costs would be 20% of unit cost whichis $480.Determine:i. the economic order quantity for EACH plan ii. total inventory cost for EACH plan iii. hence, indicate which plan would be better for the company

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