Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PYTEC ENGINEERED MATERIALS, INC Pytec Engineered Materials, Inc. is a wholesale distributor of plane parts that is a supplier to one of the largest plane

PYTEC ENGINEERED MATERIALS, INC

Pytec Engineered Materials, Inc. is a wholesale distributor of plane parts that is a supplier to one of the largest plane manufacturers in the world. Two former airplane manufacturing technicians, Matt Briggs and Dave Floyd. The company startedout at Briggs' family house's garage.Over the next 10 years, their business grew. With the growth, the company moved from the garage to an old packaging warehouse in Everett. Larger square footage of the warehouse gave Briggs and Floyd the opportunity to store more inventory, and, thus, they were able to offer a larger portfolio of plane parts. Due to the growth of the plane sales of their customer, the large plane manufacturer, and due to their expanded portfolio ofplane parts, Pytec's started experiencing tremendous growth.Twenty years later, Pytec was the highest- volume independent supplier of plane parts in PNW.

Recently, Pytec relocated to a new location off I-5 in Mukilteo area. Their new location is composed of offices and multiple warehouses. The warehouses have the capacity to hold more than 100,000 ft2of materials. The capacity utilization of the new warehouses had increased from 65% to almost 95%, even though only a limited number the new products were introduced by Pytec. However, due to unexpected developments in the airplane market, the sales growth for Pytec has started to flatten. With the aim of improving things, Briggs and Floyd hired a manager to help them with decision making. Laura Crowley was the first decision-maker to join the company in many years.

On her first day as the materials manager for Pytec, which was a new position created for her, Laura Crowley received the status reports on inventory and orders shipped. The report included a note from Tom Finley, the purchasing manager: "These are the reports that include data on inventory and performance of customer service. Since we did a complete physical inventory count at the end of last week, we are confident that the inventory information is accurate. For some of the data/information

you requested, we have been informed that no standardized record keeping had been utilized. We would appreciate it if one of the tasks you plan to work on includes creating record keeping structuresfor those areas. Looking forward to working together!"

From the reports and the note, Crowley understood that aggregate inventory information was not available. In order start her analysis, Crowley identified 100 random items and started putting together data on inventory and customer service for those items. She was hoping to achieve a high-level understanding of the inventory dynamics. Through her analysis, she concluded that there were several issues with the way operations were run at Pytec. Inventory was not at the right place. Even though average on-hand inventory seemed be 60 days' worth, they were lagging in customer service. They were not able to fulfill all of the customer's order from on-hand inventory and had to backorder them. This led to a demand loss of 10% due to the customer deciding to go with a competitor to supply their parts on those instances. Crowley knew that experiencing stockouts could be very costly for the company, especially in the long term, so she decided that they should target a cycle service level of 94%.

Initiating changes for a company that has been operating this long is not easy, and Crowley knew that. However, she wanted to start implementing improvements and showing results. Thus, she moved on to focus on two products from the larger portfolio of parts, the CSN120 exhaust system and the SWS108 wing tip light. She realized that if she can achieve significant gains from updating the inventory management structure of these two parts, she would have a chance to convince Briggs and Floyd that a complete overhaul of the inventory management system at Pytec would be very beneficial.

The CSN120 exhaust system is supplied by a company called AirXhaust located. Below is the data on the observed demand for this part for the first 21 weeks of the year (assume Pytec operates 52 weeks per year):

Week Actual Demand

1 76

2 75

3 78

4 77

5 75

6 75

7 74

8 76

9 73

10 73

11 75

12 71

13 72

14 75

15 72

16 75

17 74

18 74

19 76

20 79

21 71

AirXhaust has been shipping orders in lot sizes of 250. The time it took orders to arrive from AirXhaust to Pytec has been, on average, 1.5 weeks. Currently, we are at the end of week 21. We have zero on hand inventory and 11 units backordered. There is a scheduled receipt of 150 units (meaning 150 units have been ordered but was not received yet).

The supplier of SWS108 wing tip light is FlySupport Corp, located in Montana. Below is the data on theobserved demand for this part for weeks 11 to 21 (We don't have observed demand data for this partfor weeks 1-10 since this is a new product that is introduced in week 11):

Week Actual Demand

11 21

12 36

13 56

14 57

15 54

16 56

17 53

18 56

19 57

20 52

21 55

Currently, at the end of week 21, we have 324 on hand inventory (no backorders or scheduled receipts). Lot size for orders coming from FlySupport is currently 1,500, and lead time has been 1.5 week on average.

Pytec has been charging the plane manufacturer $16.50/item as the wholesale price for CSN120 exhaust system and $11.50/item as the wholesale price for SWS108 wing tip light. The profit margin for Pytec is 35% (of the wholesale price) for the CSN120 exhaust system and 45% (of the wholesale price) for the SWS108 wing tip light.

Based on past data, holding cost per item for any part is at 19% of the item's value. This holding costincludes both the physical cost of carrying and storing the parts, and the opportunity cost of investing funds in inventory. Crowley decides that the other expenditures for the warehouse, which was built for $1.5 million, such as utilities and maintenance, can be ignored since they will not have an impact on the inventory policy employed.

Pytec incurs a fixed out-of-pocket cost of ordering supplies each time they place an order. This cost is estimated to be $45 per order for CSN120 exhaust system and $30 per order for SWS108 wing tip light.

QUESTIONS

Suppose you are Laura Crowley and you are developing a recommendation plan for Briggs and Floyd? Specifically:

1) For the CSN 120 Exhaust System:

What would be your plan for inventory ordering strategy (i.e. how much to order)? (8 points)

What would be the safety inventory and reorder point? (8 points)

What would be the total annual costs for this proposed inventory plan? (8 points)

2) For the SWS 108 Wing Tip Light:

What would be your plan for inventory ordering strategy (i.e. how much to order)? (8 points)

What would be the safety inventory and reorder point? (8 points)

What would be the total annual costs for this proposed inventory plan? (8 points)

3) How would the current and proposed plans compare in terms of cost (while recognizing all the relevant costs)? (10 points)

4) By how much do your recommendations for these two itemsimpactannual cycle inventory and safety stock? (4 points)

5) For this question, assume that Pytec implements the updated inventory management system you propose for CSN120 exhaust system.

Pytec has been approached by a small competitor, Triptex with the offer to buy them out. Triptex sells only the CSN120 exhaust system it receives from AirXhaust. The lead time for Triptex to receive CSN120 from the supplier is 1.5 weeks. AirXhaust has been shipping orders in lot sizes of 250.Triptex's only customer is a small helicopter manufacturer in PNW.Triptex's weekly demand forCSN120 for the last 21 weeks is given below (Assume Triptex operates 52 weeks per year):

Week Actual Demand

1 50

2 33

3 52

4 33

5 32

6 50

7 49

8 50

9 48

10 48

11 33

12 31

13 32

14 32

15 32

16 33

17 49

18 49

19 50

20 52

21 31

Triptex currently has no on-hand inventory, backorders or scheduled receipts.

Triptex has been charging helicopter manufacturer $16.50/item as the wholesale price for CSN120 exhaust system. The profit margin for Triptex is 35% (of the wholesale price) for the CSN120 exhaust system. Holding cost per item for Triptex is 19% of the items value for any part. Triptex incurs $45 per

order for CSN 120 exhaust system each time they place an order with AirXhaust. Triptex delivers parts to their customers free of charge.

Pytec is considering this offer and wants to make sure they take into account all the benefits and challenges associated with the deal. The buyout is expected to cost them $1,000,000. Pytec knows that this is a long-term investment and that they may not recoup this cost for a number of years.

Pytec realizes that, in case they buy Triptex out, they will have to decide whether to keep Triptex' inventory disaggregated from Pytec's at Triptex's currentlocation or the aggregate all the CSN120exhaust system inventory at Pytec's warehouses.

If they do buy Triptex out, what would be your plan for inventory ordering strategy (i.e. how much to order)? (8 points)

If they do buy Triptex out, what would be the safety inventory and reorder point? (8 points)

If they do buy Triptex out, what would be the total annual costs for this proposed inventory plan? (8

points)?

If they do buy Triptex out, how would the disaggregated and aggregated costs compare (while

recognizing all the relevant costs)? (6 points)

What are your recommendations on whether Pytec should buyout Triptex or not? Specifically, what

are the pros and cons in terms of their inventory management systems? (8 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing Information Technology

Authors: Carol Brown, Daniel DeHayes, Jeffrey Hoffer, Wainright Marti

7th Edition

132146320, 978-0132146326

More Books

Students also viewed these General Management questions

Question

Explain the benefits of graphs over tables in presenting data.

Answered: 1 week ago

Question

# CG Q 0 # Read in the data from wine.csv

Answered: 1 week ago