Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the annual inventory cost of the current system in which product is produced, labeled, and packed in Malaysia before being shipped to the

What is the annual inventory cost of the current system in which product is produced, labeled, and packed in Malaysia before being shipped to the DC? 2. How would the inventory cost change if labeling and packaging were moved to the DC? Evaluate the change in inventory costs as the correlation coefficient of demand between any pair of customers varies from 0 to 0.5 to 1.0. 3. How should PE set up its production, labeling, and packaging processes? Does your answer change if the additional cost of labeling and packaging at the DC is reduced to $1 (from the current value of $2)?

Distribution of Weekly Demand by Product and Customer

Computers Printers Scanners

Mean SD Mean SD Mean SD

Target

1000

700

2000

1000

4000

1000

Best Buy

700

600

1500

800

4500

900

Office Max

800

600

1200

600

2000

700

Staples

500

400

900

500

1400

500

Penang Electronics (PE) is a contract manufacturer that produces and packages private-label products for several retail chains, including Target, Best Buy, Staples, and Office Max. In each case, the basic products are identical, with the only difference being the labeling and the packaging. Thus, the labeled and packed version of the product destined for Target cannot be sent to Best Buy. Currently, a production facility in Malaysia is used to manufacture, label, and pack all products. The manufacturing facility replenishes a DC in St. Louis, from which the contract manufacturer fills all customer orders. The manufacturing and transportation lead time from Penang to St. Louis is nine weeks. PE uses a continuous review policy to manage inventories at its DC and aims to provide a cycle service level of 95 percent for each product to every customer. The previous month had been very challenging because Best Buy requested 5,000 additional units beyond what was available at the DC, whereas Target ordered 3,500 fewer units and Staples ordered 4,000 fewer units. Even though there was sufficient product inventory available at the DC (in the form of the basic product), PE could not meet the Best Buy request because the excess inventory available was labeled and packed for other customers. The DC had leftover inventory from Target and Staples, which unfortunately could not be used to serve Best Buy. PE had lost business and surplus inventory all because of the wrong labels and packaging. Labeling and Packaging at the DC The vice president of supply chain at PE proposed postponing the final labeling and packaging to the DC. Her logic was that postponing labeling and packaging to the DC would allow PE to use all available inventories to serve any customer. In particular, the situation that arose in the previous month when Best Buy did not get its entire order could have been avoided through postponement. If packaging was shifted to the DC, the lead time of manufacturing and transporting the basic product from Malaysia would continue to be about nine weeks. Labeling and packaging were relatively quick steps and the response time from the DC to the customer was not expected to change. The DC management was opposed to this idea because it would add additional work that was different from what they had done so far. A detailed study of the production process had shown that labeling and packaging at the DC cost $2 per unit more than the cost of labeling and packaging in Malaysia. DC management believed that this increase in cost would be held against them once the process was changed, and they would be under constant pressure to lower cost. They also believed it would complicate the work they did when filling an order and could adversely impact customer service.

Evaluating the Two Options To evaluate the two options, a team from both manufacturing and the DC was set up. The team decided to focus its analysis on three major product categoriescomputers, printers, and scanners, and four major customersTarget, Best Buy, Staples, and Office Max. Weekly demand for each product and customer is shown in Table 12-9. In each case, "Mean" indicates the average weekly demand, and "SD" indicates the standard deviation of weekly demand. All demand was assumed to be normally distributed. PE incurred a total cost of $1,000 per computer, $300 per printer, and $100 per scanner. Given the short life cycle of these products, PE used a holding cost of 30 percent when making its inventory decisions. The team analyzed the impact of postponement on safety inventories before making a final recommendation.

For both questions, only calculate the total annual holding cost of safety inventory.

For Question 2, assume the correlation coefficient of demand between any pair of customers is zero, and use the following formula to determine safety inventory:

Di Mean weekly demand at customer i (Target, Best Buy, etc.)

sI Standard deviation of weekly demand at customer i

Mean aggregate weekly demand of k customers

Standard deviation of aggregate demand of k customers

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

Theory And Applications Of Partial Functional Differential Equations

Authors: Abrar A Khan

1st Edition

9353141915, 9789353141912

More Books

Students also viewed these Mathematics questions

Question

=+ How about one you felt had acted in a hypocritical way?

Answered: 1 week ago