C). Given the following data, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $6 per unit per quarter, what is the annual carrying cost? Opening and ending inventory are zero. Quarter 1 Quarter 2| Quarter 3 Quarter 4 2$ Totals Forecast Demand 5000 7000 8500 9500 Production Ending Inventory Average Inventory Inventory Cost If the company always carries 100 units of safety stock, what is the annual cost of carrying it?

C). Given the following data, calculate a level production plan, quarterly ending inventory, and average quarterly inventory. If inventory carrying costs are $6 per unit per quarter, what is the annual carrying cost? Opening and ending inventory are zero. Quarter 1 Quarter 2| Quarter 3 Quarter 4 2$ Totals Forecast Demand 5000 7000 8500 9500 Production Ending Inventory Average Inventory Inventory Cost If the company always carries 100 units of safety stock, what is the annual cost of carrying it?

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Conduct the ABC analysis for a convenience store, using the following percentages A inventory - most important items, generating 60% of sales B inventory - items generating the next 30% of sales Cinventory - items generating <10% of sales Stock (units) |Unit price Revenue 1000 $ 1.89 Product АВС Candy bars Cereal 200 $ 4.50 Cookies 400 $ 4.00 Milk 100 $ 2.00 200 $ 3.00 500 $ 1.50 Muffins Soda Hints 1. sort by revenue (largest to smallest) 2. calculate % of total revenue for each item 3. run a cumulative % for the items 4. identify the cut-off for each category You can run the entire exercise sorting and extending the table above
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.
Do you think the safety stock (safety inventory) could be negative? What is the meaning of a negative safety inventory (hint: safety stock is the difference between the optimal inventory and the average demand)?
A building materials stockist obtains its cement from a single supplier. Demandfor cement is reasonably constant throughout the year. Last year the company sold 2 000tonnes of cement. It estimates the costs of placing an order at around 25 MU each timean order is placed and charges inventory holding at 20% of purchase cost. The companypurchases cement at 60 MU per tonne.a) How much cement should the company order at a time?b) Instead of ordering EOQ, why not a order convenient 100 tonnes? Please mention formulas and do it in detail so I can understand.
Replenishment of Regular Stocks of Farmacia Romy & Fe The following are the details regarding the stocks on Paracetamol tab 500 mg of Farmacia Romy & Fe: (a) 150 tablets are sold daily (b) 4 boxes of 100s are on hand as stocks of the drugstore (c) Inventory is every 30 days What should be the Order Quantity for the Paracetamol product? 150 tablets 400 tablets 4,500 tablets 4,900 tablets 50 boxes None of the given choices How is the quantity to be ordered computed or determined? Order Quantity = Average Daily Movement x (X)Days + Regular Order Order Quantity = (Average daily off take x Inventory days ) – Stock-on-hand Order Quantity = (Average daily off take x Inventory days ) + Stock-on-hand Order Quantity = Average Daily Movement x (X)Days -- Regular Order None of the given choices
The Suregrip Tire Company carries a certain type of tire 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. excelc. 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.
At theEOQ, what is the firm’s total inventory costper year, assuming safety stock = 15 units?
A golf specialty wholesaler operates 50 weeks per year. Management is trying to determine an inventory policy for its 1-irons, which have the following characteristics: > Demand (D) = 2,000 units/year > Demand is normally distributed > Standard deviation of weekly demand = 2 units > Ordering cost = $30/order > Annual holding cost (H) = $5.00/unit > Desired cycle-service level = 85% > Lead time (L) = 4 weeks Refer to the standard normal table for z-values. a. If the company uses a periodic review system, P should be 3.87 weeks. (Enter your response rounded to the nearest whole number.) T should be units. (Enter your response rounded to the nearest whole number.)
Use the information below for the following questions: Knights Corporation also needs to determine the proper reorder point and safety stock level. Annual Demand = 15000 gallons Lead Time = 15 days Standard deviation of lead time = 3 days Standard deviation of demand = 10 gallons Service Level = 96% (Z score of 1.75 or 1.76) Open days per year = 360 days 1. What is the reorder point? (keep two decimal places through your work, round your final answer up to the next highest whole number) 2.What is the safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number) 3. If the service level increased to 99% (Z score of 2.32 or 2.33), what would be the new safety stock? (keep two decimal places through your work, round your final answer up to the next highest whole number)
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.
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 200 units and a standard deviation of 16 units. It is purchased from a wholesaler at a cost of $12.50 per unit. You are using a continuous review system to control this inventory. The supply lead time is 4 weeks. Placingan order costs $50, and the inventory carrying rate per year is 20 percent of the item’s cost. Your firm operates 5 days per week, 50 weeks per year.a. What is the optimal ordering quantity for this item?b. How many units of the item should be maintained as safety stock for 99 percent protection against stockouts during an order cycle?c. If supply lead time can be reduced to 2 weeks, what is the percent reduction in the number of units maintained as safety stock for the same 99 percent stockout protection?d. If through appropriate sales promotions, the demand variability is reduced so that the standard deviation of weekly…