Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand Standard deviation of daily demand Item cost Annual holding cost Review period 2,240 6 Optimal target level $35.00 20 28 mufflers mufflers per working day per muffler % of item value working days Ordering cost Service probability Lead time Working days $ 60 per order 89 % 2 working days 280 per year a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round Intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand Standard deviation of daily demand Item cost Annual holding cost Review period 2,240 6 Optimal target level $35.00 20 28 mufflers mufflers per working day per muffler % of item value working days Ordering cost Service probability Lead time Working days $ 60 per order 89 % 2 working days 280 per year a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round Intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

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

Related questions

Q: A company begins a review of ordering policies for its continuous review systems by checking the…

A: Given that:Demand88Total Weeks52Ordering cost75Holding Cost16Lead time5S.D22Service level98%EOQ207Z…

Q: Describe the 3 differences between a fixed-quantity (Q) and a fixed-period (P) inventory system? a

A: An inventory system is a process by which you follow your goods throughout your complete supply…

Q: GameStop has maintained 75% service level for inventory of PlayStation 5. Mean demand during lead…

A: Initial Service level = 75% Mean demand during lead time = dL = 166 Std. deviation during lead time…

Q: A retailer uses a periodic review order-up-to model to control the inventory of one of its high…

A: In this question, we have been given, Average demand=2580 units per week The standard deviation of…

Q: ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average…

A: Following are the calculations: EOQ =2*Annual Demand*Ordering CostHolding Cost =2*125000*4009.50…

Q: 12.4 Demand for ice cream at the Ouachita Dairy can be approximated by a normal distribution with a…

A: To determine the reorder point consistent with the desired service level of 95%, we need to…

Q: Which of the following is an element of inventory holding costs? A Housing costs B Material handling…

A: Inventory holding costs, also referred to as carrying costs, encompass a variety of expenses that…

Q: A spice retailer has a lead time of 4 weeks from its supplier of a particular item and the retailer…

A: Given that: Period length = 1 week Lead time, LT = 4 weeks Mean = 40 units Standard Deviation = 30…

Q: H & K Electronic Warehouse sells a 12-pack of AAA batteries, and this is a very popular item. Demand…

A: Mean demand (d) = 50 unitsStandard deviation of daily demand = 16Lead time (L) = 5 daysStandard…

Q: You are given the demand and inventory related information about a grocery store’s product in the…

A: Determining the reorder point is essential to inventory management to make sure a company can fulfil…

Q: a. What is the economic quantity for Ben to order? Note: Round your answer to the nearest whole…

A: An inventory management approach/strategy called economic order quantity (EOQ) aids in formulating…

Q: A service garage uses 120 boxes of cleaning cloths a year. The boxes cost $6 each. Ordering cost is…

A: Annual demand, d=120 boxes Unit cost, u =$6 per box Holding cost percentage =10% Ordering cost, o…

Q: Peach Company uses 800 units of a product per year on a continuous basis. The product has a Fixed…

A: Given data Annual demand = 800 units Fixed cost (S) = $50 Carrying or holding cost (H) = $2 Lead…

Q: d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99%…

A: Inventory management is the process in which the firm's inventory is managed to track all the…

Q: Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year…

A: Standard deviation =13 packagesLead time (LT) = 1.5 weeks

Q: William Beville's computer training school, in Richmond, stocks workbooks with the following…

A: EOQ is calculated based on data and historical demand patterns, promoting data-driven…

Q: weekly demand for hamleys (a famous toy brand) at a toy store is normally disrtibuted with a…

Q: Refer to the standard normal table for z-values. a. If the company uses a periodic review system, P…

A: Here, given that this company uses a period review system, I would determine the EOQ quantity, from…

Q: Dalia, the office manager of a desktop publishing outfit, stocks replacement toner cartridges for…

A: Find the given details below: Given details:HereOrder QuantityQReorder pointRAnnual Demand…

Q: The purchasing agent for a company that assembles and sells air-conditioning eqpt in US has noted…

A: The phrase price escalation is derived from the economics discipline. It's the idea that if a…

Q: a. What is the economic quantity for Ben to order? b. At what inventory level should he place an…

A: Below is the solution:-

Q: with a total dollar usage of $10,000,000 per year. a. What would you expect to be the number of SKUs…

A: Stockkeeping units SKU play a key role in inventory management and control. It helps in identifying…

Q: Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range

A: Economic order quantity: Economic order quantity (EOQ) determines an optimal order quantity size…

Q: Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in…

A: Pipeline inventory is the inventory that is required to meet the demand during the Lead time.Weekly…

Question

Problem 20-36 (Algo)
Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to
manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or
order-up-to level).
Annual demand
standard deviation of daily demand
Item cost
Annual holding cost
Review period
2, 240
6
$35.00
20
28
Optimal target level
mufflers
mufflers per working day
per muffler
% of item value
working days
Ordering cost
Service probability
Lead time
Working days
$60
per order
89 %
2 working days
per year
280
a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the
given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole
number.)

b. If the service probability requirement is 90 percent, the optimal target level will:
O Increase
O Decrease
O Stay the same

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Trending now

This is a popular solution!

Step by step

Solved in 8 steps

SEE SOLUTION Check out a sample Q&A here

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.
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
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.