3. A company which produces a single product has definite orders for this product over the next six months as follows: 1 3 4 5 Month 2 Demand 350 680 475 590 460 6 390 The company ended the previous month (month 0) with an inventory of 200 units, and the previous month production level was 400 units. The company wishes to end this six-month planning period with an inventory of at least 50 units. It costs $3.50 per unit to increase the production level from one month to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one month to the next is $4.80 per unit per month. No shortages are permitted. In each month, the company wants to produce an integer number of units. The company wishes to minimize the sum of production level change costs and inventory costs over the six-month planning horizon.

3. A company which produces a single product has definite orders for this product over the next six months as follows: 1 3 4 5 Month 2 Demand 350 680 475 590 460 6 390 The company ended the previous month (month 0) with an inventory of 200 units, and the previous month production level was 400 units. The company wishes to end this six-month planning period with an inventory of at least 50 units. It costs $3.50 per unit to increase the production level from one month to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one month to the next is $4.80 per unit per month. No shortages are permitted. In each month, the company wants to produce an integer number of units. The company wishes to minimize the sum of production level change costs and inventory costs over the six-month planning horizon.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month periodwere as follows:Month Sales (000 units)Feb. 19Mar. 18Apr. 15May 20Jun. 18Jul. 22Aug. 20a. Plot the monthly data on a sheet of graph paper
A company is planning to purchase 10,000 units of a particular item in the year ahead. The item is purchased in boxes each containing 10 units of the item, at a price of €400 per box. The cost of holding an item in inventory for a year (including insurance, interest and space costs) is 10% of the purchase price. The cost of placing and receiving orders is to be estimated from cost data collected relating to similar orders, where costs of €7,000 were incurred on 25 orders. It should be assumed that ordering costs change in proportion to the number of orders placed. 5% should be added to the above ordering costs to allow for inflation. Assume that usage of the item will be even over the year. Required: (a) Calculate the economic order quantity (EOQ) in boxes which minimises total costs (b) Outline when and why it is appropriate to use economic batch quantity (EBQ)
1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past three years of data, the following shows the monthly demand at Carolina Industries. Unit Demand # Months 300 6 400 8 500 12 600 10 A.If the company places monthly orders equal to the expected value of the monthly demand, what should Carolina’s monthly order quantity be for this product? B. What are the variance and the standard deviation for the number of units demanded?
3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $12 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $1 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 15 pounds. a) What is the cost of underestimating demand for each pound? b) What is the overage cost per pound? c) How many pounds of oyster should she order each day? d) What is the stockout risk for this order size?
Your company currently keeps a safety stock of 554 units of a particular product that has a lead time of 10 days. Records indicate that the weekly demand was as follows: 1176 955 780 1052 736 842 748 993 852 738 794 1444 1333 1372 1106 706 923 734 786 729 1357 1165 1277 683 1106 What is the current service level? Input your result as the decimal form and round to 4 decimal places. You are requested to recommend a safety stock that will ensure an average service level of 97.5%. The lead time is not expected to change. What safety stock would you recommend? (0 decimal places)
Your firm uses a periodic review system for all SKUs classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUs classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item’s current characteristics are:Demand 1D2 = 15,080 units/yearOrdering cost 1S2 = $125.00/orderHolding cost 1H2 = $3.00/unit/yearLead time 1L2 = 5 weeksCycle@service level = 95 percentDemand is normally distributed, with a standard deviation of weekly demand of 64 units.a. Calculate the item’s EOQ.b. Use the EOQ to define the parameters of an appropriate continuous review and periodic review system for this item.c. Which system requires more safety stock and by how much?
That One Book sells its books through The Witch and the Wardrobe bookstores. It costs That One Book $0.80 to print each book; it sells the book to The Witch and the Wardrobe for $2.50. The Witch and the Wardrobe then sells the books at retail for $6.00. Whatever doesn’t sell gets thrown away. Demand for the book each issue is normal with a mean of 5219 and a standard deviation of 1610. To give The Witch and the Wardrobe incentive to order more books, it proposes a revenue-sharing contract. Instead of selling the book to The Witch and the Wardrobe for $2.50, That One Book will sell its books to The Witch and the Wardrobe for only $1.00. However, for each book that The Witch and the Wardrobe sells at retail, The Witch and the Wardrobe must give $2.00 back to That One Book. With this revenue sharing agreement in place, what is the optimal order amount that will maximize The Witch and the Wardrobe expected profit? Please do fast ASAP
Q: A hardware company stocks nuts and bolts and orders them from a local supplier once every 2 weeks (10 working days). Lead time is 2 days. The company has determined that the average demand for 1⁄2 inch bolts is 150 per week (5 working days), and it wants to keep a safety stock of 3 days’ supply on hand. An order is to be placed this week, and the stock on hand is 130 bolts.a. What is the target level?b. How many 1⁄2 inch bolts should be ordered this time?
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Compute the probability of a stock-out for the…
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
XYZ Company must order tires from its warehouse. It costs $10550 to place an order and to review the inventory level. Annual tire sales are normally distributed with mean 20000 and variance 4,000,000. It costs $10 per year to hold a tire in inventory, and each order arrives two weeks after being placed. The Company uses periodic review (R, S) policy. What is the review interval R (in years), estimated using EOQ.? Select one: a. 1.027 O b.0.1083 c. 0.2297 d. 0.1624 e. 0.3248
Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases thepencils for 6 cents each and sells them for 20 cents each. There is a two-monthlead time from the initiation to the receipt of an order. The store accountantestimates that the cost in employee time for performing the necessary paperworkto initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lostprofit plus an additional 20 cents per pencil, which represents the cost of loss ofgoodwill.b. Find the simultaneous optimal values of Q and R.