1. A local producer of vegetables is deciding how much inventory to have to meet the next week'sdemand. Vegetable products are perishable with a shelf-life of a week.Based on the historical observations, the company expects the weekly demand to follow a normaldistribution with mean 4500 pounds and standard deviation of 400 pounds.The price of the product is $14 per pound in the store, and it costs $6 to produce. If there are anyleftovers, the company is required to dispose them safely to avoid any pollution. This processcosts $0.5 per pound.Answer the following questions.a) What is the cost of overage per pound?b) What is the cost of underage per pound?c) What is the optimal order quantity?

The ideal order quantity refers to how much inventory a business should have on hand at any given…

Answered: Answer the following questions. a) What…

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

Stationery Supplies orders plastic erasers from a company in Nürnberg, Germany.It takes six weeks to ship the erasers from Germany to Utah. Stationery Suppliesmaintains a standing order of 200 erasers every six months (shipped on the first ofJanuary and the first of July).a. Assuming the ordering policy the store is using does not result in large buildupsof inventory or long-term stock-outs, what is the annual demand for erasers?b. Draw a graph of the pipeline inventory (that is, the inventory ordered but notreceived) of the erasers during one year. What is the average pipeline inventoryof erasers during the year?
Please provide answers to subparts d to J: Company B is a retailer of mobile phones in Australia that works 250 days in a year. The manager is determining a minimum-cost inventory plan for an upcoming phone to be launched in the market. She has collected the following information: • Annual demand: 1000 phones • Phone cost: $1,214 each • Phone RRP: $1,349 each • Net weight: 163 g each • Tare weight: 277 g each • Annual inventory holding cost: 15% • Cost per order to replenish inventory: $75 • Annual in-transit holding cost: 10% • Freight rate: $8.10 per kg • Time to process order for freight: 1 days • Freight transit time: 3 days Solve this problem using a non-linear programming (NLP) model to determine the followings: d. The total cost for holding the inventory e. The total cost for transportation f. The total cost for holding the phones during transit g. The total cost for this inventory plan h. The number of orders i. Ordering point j. The profit from this inventory plan
Chicago’s Treadway Tires Dealer must order tires fromits national warehouse. It costs $10,000 to place an orderand $400 to review the inventory level. Annual tire sales are N(20,000, 4,000,000). It costs $10 per year to hold a tire ininventory, and each order arrives two weeks after beingplaced (52 weeks 1 year). Assume that all shortages arebacklogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage cost is$100 per tire.
Weiss’s paint store keeps an inventory of white latex paint product in the gallon size. The manager reviews the stock level every 4 months. Demand is observed to be normally distributed with a monthly mean of 28 gallons and a standard deviation of 8. Re-supply lead time is 2.5 months. The store manager targets a 98 percent in-stock probability during the lead time. • What is the target inventory position?
33- Which one of the following is a reason for a stock out situation for a retailer? a. Consumer demand remains unchanged b. Price of the product increases c. More lead time taken by the supplier d. There is buffer stock with the retailer
The following lots of a particular commodity were available for sale during the year Beginning inventory 9 units at $47 First purchase 15 units at $50 Second purchase 20 units at $21 Third purchase 18 units at $58 The firm uses the periodic system, and there are 27 units of the commodity on hand at the end of the year. What is the ending inventory balance at the end of the year rounded to nearest dollar according to the average cost method? Do not round intermediate calculations. a.$1,269 b.$1,233 c.$1,323 d.$1,148
The Suregrip Tire Company carries a certain type oftire with the following characteristics:Average annual sales = 600 tiresOrdering cost = $40 per orderCarrying cost = 25 percent per yearItem cost = $50 per tireLead time = 4 daysStandard deviation of daily demand = 1 tirea. Calculate the EOQ.b. For a Q system of inventory control, calculate the safety stock required for service levels of 85, 90, 95,97, and 99 percent.c. Construct a plot of total inventory investment versus service level.d. What service level would you establish on the basis of the graph in part c? Discuss.
Weiss’s paint store uses a (Q, R) inventory system to control its stock levels. For a particularly popular white latex paint, historical data show that the distribution of monthly demand is approximately normal, with mean 28 and standard deviation 8. Replenishment lead time for this paint is about 14 weeks. Each can of paint costs the store $6. Although excess demands are back-ordered, the store owner estimates that unfilled demands cost about $10 each in bookkeeping and loss-of-goodwill costs. Fixed costs of replenishment are $15 per order, and holding costs are basedon a 30 percent annual rate of interest.a. What are the optimal lot sizes and reorder points for this brand of paint?b. What is the optimal safety stock for this paint?
The purchasing manager for the Atlantic Steel Company must determine a policy for orderingcoal to operate 12 converters. Each converter requires exactly 5 tons of coal per day to operate,and the firm operates 360 days per year. The purchasing manager has determined that the orderingcost is $80 per order and the cost of holding coal is 20% of the average dollar value of inventoryheld. The purchasing manager has negotiated a contract to obtain the coal for $12 per ton forthe coming year. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost of the coal).
Boreki Enterprises has the following 10 items ininventory. Theodore Boreki asks you, a recent OM graduate, todivide these items into ABC classifications.ITEM ANNUAL DEMAND COST/UNITA2 3,000 $ 50B8 4,000 12C7 1,500 45D1 6,000 10E9 1,000 20F3 500 500G2 300 1,500H2 600 20I5 1,750 10J8 2,500 5a) Develop an ABC classification system for the 10 items.b) How can Boreki use this information?c) Boreki reviews the classification and then places item A2 intothe A category. Why might he do so?
The following lots of a particular commodity were available for sale during the year Beginning inventory 7 units at $49.00 First purchase 18 units at $54.00 Second purchase 25 units at $59.00 Third purchase 14 units at $59.00 The firm uses the periodic system, and there are 23 units of the commodity on hand at the end of the year. What is the amount of inventory at the end of the year according to the FIFO method? Select the correct answer. $1,127.00 $1,357.00 $3,616.00 $3,593.00
The manager of Alaina’s Garden Center must make the annual purchasing plans for rakes, gloves, and other gardening items. One of the items the company stocks is Fast-Grow, a liquid fertilizer. The sales of this item are seasonal, with peaks in the spring, summer, and fall months. Quarterly demand (in cases) for the past 2 years follows: Quarter Year 1 Year 2 1 2 3 4 45 339 299 222 67 444 329 283 Total 905 1,123 If the expected sales for Fast-Grow are 1,850 cases for year 3, use the multiplicative seasonal method to prepare a forecast for each quarter of the year.

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

Answer the following questions. a) What is the cost of overage per pound? b) What is the cost of underage per pound? c) What is the optimal order quantity?