Question

In: Operations Management

Given the following information, formulate an inventory management system. The item is demanded 50 weeks a...

Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.

Item cost $ 7.00 Standard deviation of weekly demand 20 per week
Order cost $ 243.00 Lead time 1 week(s)
Annual holding cost (%) 32 % of item cost Service probability 95 %
Annual demand 22,100
Average demand 442 per week

a. Determine the order quantity and reorder point. (Use Excel’s NORMSINV( ) function to find your z-value and then round that z-value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers to the nearest whole number.)

b. Determine the annual holding and order costs. (Do not round any intermediate calculations. Round your final answers to 2 decimal places.)

c. Assume a price break of $50 per order was offered for purchase quantities of 2,200 units per order. If you took advantage of this price break, how much would you save annually? (Do not round any intermediate calculations (including number of setups per year). Round your final answer to 2 decimal places.)

Solutions

Expert Solution

a) and b)

c)

When purchase quantity = 2200 units, order cost = 243-50 = $193

Annual ordering cost =( Annual demand/order quantity)* order cost = (22100/2200)*193 = $1938.77

Anmual holding cost = (Order quantity/2) *holding cost = (2200/2)*2.24 = $2464

Total cost = 1938.77+2464 = 4402.77

Annual savings = 4904.99-4402.77 = $ 502.22


Related Solutions

Consider the following information on an inventory management system:             Item Cost:                 &nbsp
Consider the following information on an inventory management system:             Item Cost:                                $10             Order Cost:                              $250             Annual Holding Cost:              33% of item cost             Annual Demand:                     25,750             Average Demand:                   515 per week             Std. Dev. of Demand:              125 per week             Leadtime:                                2 weeks          1. Ignoring the uncertainty in the demand (i.e. looking only at average values), find the optimal order quantity and the reorder point. What is the annual inventory holding and ordering cost for this...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the month of september: Sep. 1 Inventory 24 units at $15          5 sold 17 units         17 Purchased 10 units at $20          30 sold 8 units If Addison uses LIFO, the cost of the ending inventory on September 30 is a. $160 b.$125 c. $180 d. $145 Please help! I don't understand. Due at 11:59 p.m. Thanks!
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in...
Given the following inventory information… Item number Unit cost Annual usage in units Current inventory in units B8867 10 100 4500 J1252 5.25 6500 120 K9667 1.22 4000 1000 L2425 12.5 54 254 M4554 5.25 6500 120 T6334 70 500 800 W9856 .75 800 20000 X2215 1.5 8000 2000 Y3214 70 1000 500 Y6339 4 3500 125 which of the following items is not classified as C items by annual dollar usage? Which is not classified as C items by...
For the last 50 weeks, the demand for a product was observed to be as given...
For the last 50 weeks, the demand for a product was observed to be as given in the table below. For example, 250 units were demanded for 10 weeks in the span of 50 weeks (not necessarily in one single stretch!). The unit price of the product $500 and normally sells for $750, If the product is not sold during that week, it can be sold at a reduced price of $300 per unit. If it is out of stock,...
The Lippert Company uses the periodic inventory system. The following July data are for an item...
The Lippert Company uses the periodic inventory system. The following July data are for an item in loppers inventory: July 1 Beginning Inventory 100 units@ $8 per unit 10 Purchased 120 units@ $9 per unit 15 sold 130 units@ 26 Purchased 95 units@ $10 per unit Calculate the cost of goods sole for July and ending inventory at July 31 using (a) first-in, first out (b) last-in, first out and (c) the weighted- average cost methods. Round your final answers...
The Lippert Company uses the perpetual inventory system. The following July data are for an item...
The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 60 units @ $11 per unit 10 Purchased 80 units @ $12 per unit 15 Sold 90 units @ 26 Purchased 55 units @ $13 per unit Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods. Round your final answers to the...
Brooks Company carries three inventory items. The following information pertains to the ending inventory: Item Quantity...
Brooks Company carries three inventory items. The following information pertains to the ending inventory: Item Quantity Unit Cost Unit Market Value A 195 $ 10 $ 9 F 255 12 11 K 173 5 8 Required a. Determine the ending inventory that Brooks will report on the balance sheet, assuming that it applies the lower-of-cost-or-market rule to individual inventory items. b. Prepare the necessary journal entry, assuming the decline in value was immaterial. (If no entry is required for a...
Design an Inventory class that can hold information for an item in a retail store’s inventory.
C++! Becareful following the test case.7. Inventory ClassDesign an Inventory class that can hold information for an item in a retail store’s inventory.The class should have the following private member variables.Variable Name   DescriptionitemNumber   An int that holds the item’s number.quantity               An int that holds the quantity of the item on hand.cost    A double that holds the wholesale per-unit cost of the itemThe class should have the following public member functionsMember Function               Descriptiondefault constructor             Sets all the member variables...
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $...
Consider the following financial statement information for the Mediate Corporation:      Item Beginning Ending   Inventory $ 4,880         $ 6,310            Accounts receivable 2,963         3,831            Accounts payable 4,018         5,195              Credit sales $ 50,484         Cost of goods sold 30,640        Required: (a) Calculate the operating cycles. (Do not round your intermediate calculations.) (Click to select)42.09days91.21days94.86days36.34days87.56days (b) Calculate the cash cycle. (Do not round your intermediate calculations.)
The firm uses the periodic inventory system and there are 240 units of the item on...
The firm uses the periodic inventory system and there are 240 units of the item on hand at the end of the year. The following units of a particular item were available for sale during the year: Beginning inventory 150 units @ $755 Sale 120 units First purchase 400 units @ $785 Sale 200 units Second purchase 300 units @ $805 Sale 290 units
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT