The Hawkins Supply Company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective

The Hawkins Supply Company is currently faced with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.The company would like to reduce the double and sometimes triple handling of items. How can this goal be achieved? Are there alternative solutions which might also be effective

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 15P

See similar textbooks

Similar questions

The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Show & Sell can advertise its products on local radio and television (TV). The advertising budget is limited to $10,000 a month. Each minute of radio advertising costs $15 and each minute ofTY commercials $300. Show & Sell likes to advertise on radio at least twice as much as on TV. In the meantime, it is not practical to use more than 400 minutes of radio advertising a month. From past experience, advertising on TV is estimated to be 25 times as effective as on radio. Determine the optimum allocation of the budget to radio and TV advertising.
Kris Lee, the owner and manager of the Quality Hardware Store, is reassessing his inventory policy for hammers. He sells an average of 50 hammers per month, so he has been placing an order to purchase 50 hammers from a wholesaler at a cost of $20 per hammer at the end of each month. However, Kris does all the ordering for the store himself and finds that this is taking a great deal of his time. He estimates that the value of his time spent in placing each order for hammers is $75. What would the unit holding cost for hammers need to be for Kris' current inventory policy to be optimal according to the basic EOQ model? What is this unit holding cost as a percentage of the unit acquisition cost? What is the optimal order quantity if the unit holding cost actually is 20 percent of the unit acquisition cost? What is the corresponding value of TVC? What is TVC for the current inventory policy? If the wholesaler typically delivers an order of hammers in 5 working days (out of 25 working…
3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds
Ascent, Inc. manufactures hiking boots. Demand for boots is highly seasonal. In particular, the demand in the next year is expected to be 3,000, 4,000, 8,000, and 7,000 pairs of boots in quarters 1, 2, 3, and 4, respectively. With its current production facility, the company can produce at most 6,000 pairs of boots in any quarter. Ascent would like to meet all the expected demand, so it will need to carry inventory to meet demand in the later quarters. Each pair of boots sold generates a profit of ₱1,000 per pair. Each pair of boots in inventory at the end of a quarter incurs ₱400 in storage and capital recovery costs. Ascent has 1,000 pairs of boots in inventory at the start of quarter 1. Ascent's top management has given you the assignment of modeling and analyzing what the production schedule should be for the next four quarters. In particular, you are asked to determine how many pairs of boots to produce in each quarter so that you satisfy the demand in each quarter. While doing…
The three blood banks in Franklin County are coor-dinated through a central office that facilitates blood delivery to four hospitals in the region. The cost toship a standard container of blood from each bankto each hospital is shown in the table on this page.Also given are the biweekly number of containers of blood available at each bank and the biweekly num-ber of containers needed at each hospital. How many shipments should be made biweekly from eachblood bank to each hospital so that total shipmentcosts are minimized? From\To Hospital 1 Hospital 2 Hospital 3 Hospital 4 Supply Bank 1 $8 $9 $11 $16 50 Bank 2 12 7 5 8 80 Bank 3 14 10 6 7 120 Demand 90 70 40 50
Auria will produce 3 vehicle components and knows that each start generates a cost of 5,000 pesos. The cost of the units is $ 200, $ 100 and $ 70 respectively. Annual demand is 100,000 units for Product A, 150,000 units for Product B, and 200,000 units for Product C. The inventory rate is 15% per month. Product A and B are basic and substitutable products, so there must be a minimum average inventory of 8,000 units of both. The company seeks a maximum of $ 100,000 invested money in inventory. The available warehouse space is 400m3 and product A occupies 0.5m3, product B 0.7m3 and C 1m3. Consider that product A and C allow shortages and the goodwill loss cost is $ 3 for each unit of those items. a) Formulate the problem as a mathematical programming model (objective function and constraints) that minimizes the total annual cost