Question

In: Statistics and Probability

ighMed, a manufacturer of medical equipment used in heart procedures, is located in Madison, Wisconsin, and...

ighMed, a manufacturer of medical equipment used in heart procedures, is located in Madison, Wisconsin, and its products are used by cardiologists all over North America. The medical equipment is not sold through purchasing agents but directly to doctors. HighMed currently divides the United States into 24 territories, each with its own sales force. All product inventories are maintained locally and replenished from Madison every four weeks using UPS. The average replenishment lead-time using UPS is one week. UPS charges at a rate of $0.60+0.40x, where x is the quantity shipped in pounds. The products sold fall into two categories - Highval and Lowval. Highval products weigh 0.20 pounds and cost $200 each. Lowval products weigh 0.06 pounds and cost $25 each.
Weekly demand for Highval products in each territory is normally distributed, with a mean of H=2 with a standard deviation of H=5. Weekly demand for Lowval products in each territory is normally distributed, with a mean of L=20 with a standard deviation of L=5. HighMed maintains sufficient safety inventories in each territory to provide a cycle service level (CSL) of 0.997 for each product. Holding cost at HighMed is 20 percent.
In addition to the current approach, the management team at HighMed is considering two other options:
Option A. Keep the current structure but replenish once every week rather that once every four weeks.
Option B. Eliminate inventories in the territories, aggregate all inventories in a finished-goods warehouse at Madison, and replenish the warehouse once a week.
If inventories are aggregated at Madison, orders will be shipped using FedEx, which charges $5.10+0.50x per shipment, where x is the quantity shipped in pounds. The factory requires a one- week lead-time to replenish finished-goods inventories at the Madison warehouse. An average customer order is for one unit of Highval and 10 units of Lowval.
What should HighMed do? (In order to analyze this, you need to compare the current situation,

Solutions

Expert Solution

ANSWER::

Average replenishment lead-time= 1 week

Quantity shipped= x pounds

L= 1 week

T=4 weeks

For HighVal products:

  • Weight=0.2 pounds
  • Cost= $200
  • Weekly demand H=2 and H= 5

For LowVal products:

  • Weight=0.06 pounds
  • Cost= $25
  • Weekly demand L=20 and L= 5

CSL=0.997

Holding Cost = 20%

UPS Lead time= 1 week

UPS charges=$ 0.6+0.4x

FedEx charges=$ 5.1+0.5x

Customers order 1 H + 10 L units

Solution:

Total Cost = Inventory Cost + Transportation Cost

1. For Current Scenario

Calculating Inventory Costs

A) For HighVal Product

Avg Lot size QH=Expected demand X Time = 2 unitsX 4= 8 units

Safety inventory ssH=F-1(CSL)T+L =F-1(0.997)4+1 = 30.7 units

Total HighVal inventory= QH/2+ssH =8/2+30.7=34.7 units

Total HighVal inventory for 24 territories = 24X 34.7 = 832.8 units

B) For LowVal Product

Avg Lot size QL=Expected demand X Time = 20unitsX 4= 80units

Safety inventory ssL=F-1(CSL)T+L =F-1(0.997)4+1 = 30.7 units

Total LowVal inventory= QL/2+ssL =80/2+30.7=70.7 units

Total LowVal inventory for 24 territories = 24X 70.7 = 1696.8 units

Average inventory holding cost=20% of ( HighVal inventory X $200 + LowVal inventory X $25 ) = 0.2X(832.8X200+1696.8X25) =$41796

Calculating Transportation Cost

Average weight of each order= 0.2X QH+0.06XQL=0.2 x 8 +0.06 X 80= 6.4 pounds

Shipping Cost per order= $0.6 +0.4 X 6.4 = $ 3.16

Annual Transportation Cost= $ 3.16 X 13 X 24= $ 985.92

Total Cost= $ 41796 +985.92 =$ 42781.92

Similarily for Option A and Option B

Reorder Interval= 1 week

Calculations for Option A and Option B

Option A Option B
HighVal Safety Inventory 466.3 95.2
HighVal Inventory 490.3 119.2
LowVal Safety Inventory 466.3 95.2
LowVal Inventory 706.3 335.2
Inventory Cost 23143.5 6444
Shipment size 2HighVal+20LowVal 1HighVal+10LowVal
Shipment weight 1.6 0.8

For Option A

Annual Transportation cost for option A =1547.52

Total Annual Cost =$ 24690.52

For Option B

Average weight of each customer order=0.2*0.8+0.06*8 = 0.64 pounds

Shipping cost per customer= $ 5.1+0.5*0.64=$5.42

Number of customer orders per territory per week = 4

Total orders per year =4x52x24= 4992

Annual transportation cost=$ 5.42*4992=$27056.64

Total Cost =$27056.64+6444= $33500.64

The transportation cost increases in case of the change in shipment weight .Aggregating inventory will lead to a low transportation cost but is better option in case of large customer size in case the customer size is small disaggregartion is a better option.

NOTE:: I HOPE YOUR HAPPY WITH MY ANSWER....***PLEASE SUPPORT ME WITH YOUR RATING...

***PLEASE GIVE ME "LIKE"...ITS VERY IMPORTANT FOR ME NOW....PLEASE SUPPORT ME ....THANK YOU


Related Solutions

Determining Training Needs at Summit Credit Union Summit Credit Union, located in Madison and Milwaukee, Wisconsin,...
Determining Training Needs at Summit Credit Union Summit Credit Union, located in Madison and Milwaukee, Wisconsin, is a small company with 366 employees. A merger in 2015 doubled the size of the company and made it necessary to build a new corporate culture. Summit’s mission is to improve credit members’ financial lives to help them achieve their dreams. For example, in 2013, Summit members saved over $13 million based on higher savings rates, lower loan rates, and lower fees compared...
2- The PACE project at the University of Wisconsin in Madison deals with problems associated with...
2- The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk drinking on college campuses. Based on random samples, the study states that the percentage of UW students who reported bingeing at least three times within the past two weeks was 42.2% in 1999 (n = 334) and 21.2% in 2009 (n = 843). Test that the proportion of students reporting bingeing in 1999 is different from the proportion of students reporting bingeing in...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk drinking on college campuses. Based on random samples, the study states that the percentage of UW students who reported bingeing at least three times within the past two weeks was 42.2% in 1999 (n = 334) and 21.2% in 2009 (n = 843). Test that the proportion of students reporting bingeing in 1999 is different from the proportion of students reporting bingeing in 2009...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk drinking on college campuses. Based on random samples, the study states that the percentage of UW students who reported bingeing at least three times within the past two weeks was 42.2% in 1999 (n = 334) and 21.2% in 2009 (n = 843). Test that the proportion of students reporting bingeing in 1999 is different from the proportion of students reporting bingeing in 2009...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk...
The PACE project at the University of Wisconsin in Madison deals with problems associated with high-risk drinking on college campuses. Based on random samples, the study states that the percentage of UW students who reported bingeing at least three times within the past two weeks was 42.2% in 1999 (n = 334) and 21.2% in 2009 (n = 843). Test that the proportion of students reporting bingeing in 1999 is different from the proportion of students reporting bingeing in 2009...
Badger Billing is considering opening a new production facility in Madison, Wisconsin. In deciding whether to...
Badger Billing is considering opening a new production facility in Madison, Wisconsin. In deciding whether to proceed with the project, the company has gathered the follwing information: The estimated up-front cost of constructing the new facility at t=0 is $12 million. For tax purposes, the facility will be depreciated on a straight-line basis of 5 years (eg: $2.4 million/year) Badger will operate the facility for four (4) years. The company estimates that the facility can be sold at the end...
MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston, Texas. It...
MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston, Texas. It is a global leader in developing, manufacturing, selling and servicing diagnostic imaging and therapeutic medical devices used to diagnose and treat cardiovascular and other diseases. MERMED earned $300 million of revenue in 2015, while employing more than 10,000 people worldwide. One of it’s manufacturing plants is located in Dingle, Co. Kerry, Ireland. Tom Jones is the plant manager at the Dingle facility. The Dingle...
MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston, Texas. It...
MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston, Texas. It is a global leader in developing, manufacturing, selling and servicing diagnostic imaging and therapeutic medical devices used to diagnose and treat cardiovascular and other diseases. MERMED earned $300 million of revenue in 2015, while employing more than 10,000 people worldwide. One of it’s manufacturing plants is located in Dingle, Co. Kerry, Ireland. Tom Jones is the plant manager at the Dingle facility. The Dingle...
A medical practice purchases computer equipment that cost $15,000 to be used for medical billing. In...
A medical practice purchases computer equipment that cost $15,000 to be used for medical billing. In addition, the practice purchases billing software that cost $5,000. Both the computer equipment and the software are expected to have 3-year useful lives and no salvage value. Please calculate the Three years of depreciation using straight-line, double declining balance, and sum-of-the-years digits. Asset Cost: Salvage Value: Asset Life: Straight-line Depreciation Each Year #DIV/0! Asset Cost: $0 Salvage Value: $0 Asset Life: 0 Depreciation Year...
Company Information: MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston,...
Company Information: MERMED Inc. is a medical device manufacturer. The company’s headquarters is located in Houston, Texas. It is a global leader in developing, manufacturing, selling and servicing diagnostic imaging and therapeutic medical devices used to diagnose and treat cardiovascular and other diseases. MERMED earned $300 million of revenue in 2015, while employing more than 10,000 people worldwide. One of it’s manufacturing plants is located in Dingle, Co. Kerry, Ireland. Tom Jones is the plant manager at the Dingle facility....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT