Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Graphic Corporation Inc. Graphic Corporation Inc. (GC) is one of the leading producers of semiconductor chips in the USA. The semiconductor industry is a highly

Graphic Corporation Inc.

Graphic Corporation Inc. (GC) is one of the leading producers of semiconductor chips in the USA. The semiconductor industry is a highly dynamic industry, which often results in product becoming obsolete very quickly. GC, founded in 1986, is located in Charlotte, NC. GC has had a good run since its inception, primarily due to its innovation and high service levels. GC's profits and market share have recently declined due to increased competition. GC is currently trying to raise capital to enter newer Asian markets, but cash flow issues have come to light with the increase in competition. John, GCs chief operations officer, conducted a simple capital expenditure breakdown and found that much of the capital was locked up in the form of finished goods inventory. Moreover, John recognized that each of the past five years GC had to write-off several million dollar worths of inventory as they became obsolete. John attributed the supply-demand mismatch to the variability in demand for their products, which are classified as innovative.

GC's success is contingent upon providing high service-levels and holding safety stock is necessary to provide high service-levels for their products, which are currently set at 98%. Carrying too much inventory in the form of finished goods safety stock was hurting GCs operational performance. To improve GCs inventory position, John has hired Tom Brown as the senior inventory manager and has given him three months to show progress.

Tom came into GC with 20 years of experience as an inventory manager at Dell. Tom quickly realized that GC was dealing with 1150 different product types at any given time, and held safety stock for each of them to buffer against uncertainty in demand. With his experience at Dell, Tom understood that most of GCs 1150 unique products were manufactured from a few standardized wafers. This understanding prompted Tom to examine the benefits of postponement strategy (i.e., delaying the differentiation of a product and thereby combining demand streams into standardized products) at GC. To make a compelling case for the meeting with the top management scheduled for next week, Tom, identified a set of seven representative products made using various combinations of wafers A, B, & C (see excel document for product architecture). Tom then put together some cost and demand information for his analysis from the past year (see Excel attachment), and found that the average daily demand for each of the representative products was normally distributed and independent of each other. The seven products constitute about 1% of the overall sales for GCs NC facility. GC currently holds $50,000 worth of safety stock for these seven products combined.

Instructions:

  1. Please complete the answer form provided below based on your excel work and upload the answer form and excel sheet to the submissions folder.
  2. Please try to label excel sheets to correspond with those questions that require excel computation.
  3. Highlight your answers in the excel sheet.

Please fill in the answer to the questions provided below:

  1. What is the safety stock related costs for each of the seven products at 98% service level?

(List the product number and safety stocks dollar value below) (7 points)

  1. Does the $50,000 worth of inventory in the form of safety stock reflect a 98% service level or more for the seven products combined? ( Please respond below in 2 to 3 lines) (3 points)

  1. What is the safety stock related cost for each of wafers A, B, & C at 98% service level?

(List the wafer and the safety stocks dollar value below) (12 points)

  1. What is the potential cost saving due to the proposed postponement strategy achieved via product risk pooling? (List the dollar value below) (3 points)

  1. What are other aspects could influence the top managements willingness to adopt the proposed postponement strategy despite cost savings? ( Please respond below in four to six lines) (5 points)

image text in transcribedimage text in transcribedimage text in transcribed

x f A B C E F G I 1 J Product ic-207+ Raw Material Input (Wafers Used) A ic-250+ B ic-2454 ic-425 B B ic-455 A ic-495 A ic-750 B Product Architecture Cost Information Demand Information (2) + HA Cell Styles Form: 9 x fx A B D E F G H 1 Information on Representative Products ic-207 Annual carrying cost {i} Unit cost {C} Optimal service level ic-250 14% 14% $396.00 $376.00 98.00% ic-245 14% $384.00 98.00% ic-425 ic-455 ic-495 ic-750 Wafer A Wafer_A Wafer_B Wafer_C 17% 17% 17% 20% 25.00% 25.00% 25.00% $456.00 $472.00 $472.00 $494.00 $744.00 $50.00 $50.00 $50.00 98.00% 98.00% 98.00% 98.00% 98.00% Formulas Safety Stock zo Inventory Holding Cost for a unit i Product Architecture Cost Information Demand Information (2) + Paste $ % 9 00 > 0 Cell Styles 1 Format 368 fx ESTDEV.S(Table 13(ic-207]) A . B D E F G H 1 j K L ic-207 ic-245 ic-495 ic-750 245 216 ic-250 365 345 356 351 393 ic-455 459 465 399 225 283 276 225 Day 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 Mean Demand Standard Deviation of Demand 320 334 358 371 360 311 340 349 324 350 319 361 347 24.54 316 264 212 222 248 282 246 311 242 227 220 250 24.39 ic-425 222 248 201 236 255 246 268 257 259 282 252 264 07 234 245 * 256 239 217 245 19.37 410 443 401 430 430 427 399 450 - 416 416 418 411 466 451 424 28.50 426 421 423 429 394 394 401 435 425 447 385 415 380 392 447 421 445 428 31.13 757 865 667 774 717 612 658 657 720 727 687 688 768 670 861 716 653 728 62.50 114 123 125 140 107 146 163 --- 91 124 157 120 132 126 124 99 115 99 126 18.02 Product Architecture Cost Information Demand Information (2) + Average: 29.78 Count: 7 Sum: 208.44 x f A B C E F G I 1 J Product ic-207+ Raw Material Input (Wafers Used) A ic-250+ B ic-2454 ic-425 B B ic-455 A ic-495 A ic-750 B Product Architecture Cost Information Demand Information (2) + HA Cell Styles Form: 9 x fx A B D E F G H 1 Information on Representative Products ic-207 Annual carrying cost {i} Unit cost {C} Optimal service level ic-250 14% 14% $396.00 $376.00 98.00% ic-245 14% $384.00 98.00% ic-425 ic-455 ic-495 ic-750 Wafer A Wafer_A Wafer_B Wafer_C 17% 17% 17% 20% 25.00% 25.00% 25.00% $456.00 $472.00 $472.00 $494.00 $744.00 $50.00 $50.00 $50.00 98.00% 98.00% 98.00% 98.00% 98.00% Formulas Safety Stock zo Inventory Holding Cost for a unit i Product Architecture Cost Information Demand Information (2) + Paste $ % 9 00 > 0 Cell Styles 1 Format 368 fx ESTDEV.S(Table 13(ic-207]) A . B D E F G H 1 j K L ic-207 ic-245 ic-495 ic-750 245 216 ic-250 365 345 356 351 393 ic-455 459 465 399 225 283 276 225 Day 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 Mean Demand Standard Deviation of Demand 320 334 358 371 360 311 340 349 324 350 319 361 347 24.54 316 264 212 222 248 282 246 311 242 227 220 250 24.39 ic-425 222 248 201 236 255 246 268 257 259 282 252 264 07 234 245 * 256 239 217 245 19.37 410 443 401 430 430 427 399 450 - 416 416 418 411 466 451 424 28.50 426 421 423 429 394 394 401 435 425 447 385 415 380 392 447 421 445 428 31.13 757 865 667 774 717 612 658 657 720 727 687 688 768 670 861 716 653 728 62.50 114 123 125 140 107 146 163 --- 91 124 157 120 132 126 124 99 115 99 126 18.02 Product Architecture Cost Information Demand Information (2) + Average: 29.78 Count: 7 Sum: 208.44

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Finance questions