*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PERFORMANCE EVALUATION REPORT, MONTH 2 PAGE 1
*****************************************************************************
+------+------Industry ------+
| Firm 6 | Worst Average Best |
------+------+------+
FINANCIAL | | |
Net Income to Revenues | 8.5%| 7.4% 7.7% 8.5%|
Change in Net Income to Revenues | 0.6%| -0.5% -0.2% 0.6%|
Return on Assets | 25.5%| 20.7% 22.5% 25.5%|
Net Asset Turns | 3.0 | 2.8 2.9 3.0 |
------+------+------+
OPERATIONAL | | |
Inventory Turnover | 9.0 | 6.7 8.1 9.1 |
Fill Rate | 100.0%| 100.0% 100.0% 100.0%|
Unplanned Production | 3.3%| 4.8% 2.9% 0.0%|
Failure Rate | 7.0%| 7.4% 7.0% 6.8%|
Controllable Procure&Mfg to Revenues | 1.3%| 1.4% 1.3% 1.0%|
Transportation Expenses Per Unit Sold | 30.0 | 31.6 31.1 30.0 |
Forecasting Accuracy | 91.7%| 86.1% 89.0% 91.7%|
(Marketing + Service) to Revenues | 8.7%| 9.3% 8.9% 8.7%|
------+------+------+
CUSTOMER | | |
Change in Market Share | 0.5%| -0.6% 0.0% 0.5%|
Customer Satisfaction | 24.9%| 24.9% 25.6% 26.4%|
------+------+------+
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
LINKS DASHBOARD, MONTH 2 PAGE 1
*****************************************************************************
Month 1 Month 2
+------+------+
Sales Volume | 56,587 | 59,361 |
Unfilled Orders | 0 | 0 |
------+------+------+
Price | 430 | 430 |
------+------+------+
Revenues | 24,357,155 100.0% | 25,529,070 100.0% |
Product Costs | 11,416,878 46.9% | 11,887,723 46.6% |
Gross Margin | 8,315,964 34.1% | 8,996,003 35.2% |
Net Income | 1,923,680 7.9% | 2,169,723 8.5% |
+------+------+
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
CORPORATE P&L STATEMENT, MONTH 2 PAGE 2
*****************************************************************************
All Products Product 6-1 Product 6-2
------
Sales Volume 59,361 38,672 20,689
Unfilled Orders 0 0 0
Price 430 397 491
Revenues 25,529,070 15,357,640 10,171,430
- Product Costs 11,887,723 6,477,554 5,410,169
- Order Processing 813,004 525,528 287,476
- Replacement Parts 106,336 44,512 61,824
- RFID Costs 336,413 221,430 114,983
- Transportation Costs 1,813,194
+ Transportation Rebates 32,000
+ Volume Discounts 66,365
- Duties & Tariffs 1,674,762 1,001,309 673,453
------
Gross Margin 8,996,003 7,087,307 3,623,525
Gross Margin % 35.2% 46.1% 35.6%
Fixed & Other Costs:
Administrative O/H 1,200,000 600,000 600,000
Consulting Fees 0
Corporate O/H 500,000
Cross-Docking 0
Disposal Sales 0
Distribution FC 75,000
Emergency Procurement 115,526
Emergency Production 76,361
Forecast Inaccuracy 103,395 46,373 57,022
Information Technology 18,000
Introductions 0
Inventory Charges 60,593
Marketing 1,440,000 720,000 720,000
Plant Capacity FC 200,000
Price Changes 0 0 0
Procurement FC 20,000
Production FC 47,000
Reconfiguration 0
Research Studies 0
Service Outsourcing 791,344 507,283 284,061
Unfilled Handling 0
Total Fixed & Other 4,647,219 1,873,656 1,661,083
------
Operating Income 4,348,784 5,213,651 1,962,442
------
Non-Operating Income -9,338
Patent Royalties 0
Taxes -2,169,723
======
Net Income 2,169,723
======
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
HISTORICAL CORPORATE P&L STATEMENT, MONTH 2 PAGE 3
*****************************************************************************
Previous (Month 1) Current (Month 2)
------
Sales Volume 56,587 59,361
Unfilled Orders 0 0
Price 430 430
Revenues 24,357,155 100.0% 25,529,070 100.0%
- Product Costs 11,416,878 46.9% 11,887,723 46.6%
- Order Processing 767,088 3.1% 813,004 3.2%
- Replacement Parts 102,866 0.4% 106,336 0.4%
- RFID Costs 325,050 1.3% 336,413 1.3%
- Transportation Costs 1,869,258 7.7% 1,813,194 7.1%
+ Transportation Rebates 34,149 0.1% 32,000 0.1%
+ Volume Discounts 79,369 0.3% 66,365 0.3%
- Duties & Tariffs 1,673,569 6.9% 1,674,762 6.6%
------
Gross Margin 8,315,964 34.1% 8,996,003 35.2%
Fixed & Other Costs:
Administrative O/H 1,200,000 4.9% 1,200,000 4.7%
Consulting Fees 0 0.0% 0 0.0%
Corporate O/H 500,000 2.1% 500,000 2.0%
Cross-Docking 0 0.0% 0 0.0%
Disposal Sales 0 0.0% 0 0.0%
Distribution FC 75,000 0.3% 75,000 0.3%
Emergency Procurement 143,220 0.6% 115,526 0.5%
Emergency Production 52,914 0.2% 76,361 0.3%
Forecast Inaccuracy 0 0.0% 103,395 0.4%
Information Technology 0 0.0% 18,000 0.1%
Introductions 0 0.0% 0 0.0%
Inventory Charges 23,901 0.1% 60,593 0.2%
Marketing 1,440,000 5.9% 1,440,000 5.6%
Plant Capacity FC 200,000 0.8% 200,000 0.8%
Price Changes 0 0.0% 0 0.0%
Procurement FC 20,000 0.1% 20,000 0.1%
Production FC 47,000 0.2% 47,000 0.2%
Reconfiguration 0 0.0% 0 0.0%
Research Studies 0 0.0% 0 0.0%
Service Outsourcing 766,570 3.1% 791,344 3.1%
Unfilled Handling 0 0.0% 0 0.0%
Total Fixed & Other 4,468,605 18.3% 4,647,219 18.2%
------
Operating Income 3,847,359 15.8% 4,348,784 17.0%
------
Non-Operating Income 0 0.0% -9,338 0.0%
Patent Royalties 0 0.0% 0 0.0%
Taxes -1,923,679 -7.9% -2,169,723 -8.5%
======
Net Income 1,923,680 7.9% 2,169,723 8.5%
======
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PRODUCT 6-1 P&L STATEMENT, MONTH 2 PAGE 4
*****************************************************************************
All Regions Region 1 Region 2 Region 3
(TOTAL ) ( U.S.A.) ( Europe) ( Pacific)
------
Active? Ch#1,2 Yes Yes Yes Yes Yes Yes
Sales Volume, Ch#1 20,130 8,834 3,614 7,682
Sales Volume, Ch#2 18,542 5,678 6,587 6,277
Unfilled Orders 0 0 0 0
Price, Ch#1,2 330 470 330 470 330 470 330 470
Revenues 15,357,640 5,583,880 4,288,510 5,485,250
- Product Costs 6,477,554 2,430,758 1,708,665 2,338,131
- Order Processing 525,528 171,608 172,544 181,376
- Replacement Parts 44,512 16,521 11,310 16,681
- RFID Costs 221,430 97,174 39,754 84,502
- Duties & Tariffs 1,001,309 0 343,080 658,229
------
Gross Margin 7,087,307 2,867,819 2,013,157 2,206,331
Gross Margin % 46.1% 51.4% 46.9% 40.2%
Fixed Costs:
Administrative O/H 600,000 200,000 200,000 200,000
Forecast Inaccuracy 46,373 17,094 26,212 3,067
Marketing, Ch#1 360,000 120,000 120,000 120,000
Marketing, Ch#2 360,000 120,000 120,000 120,000
Price Changes 0 0 0 0
Service Outsourcing 507,283 160,200 136,548 210,535
Total Fixed Costs 1,873,656 617,294 602,760 653,602
------
Operating Income 5,213,651 2,250,525 1,410,397 1,552,729
======
Distribution Center? 2 Owned 1 3rd-Party 0 None
RFID Outsource/Insource? 0 Outsourced 0 Outsourced 0 Outsourced
Emergency Carrier N N
Sales Volume Forecast, Ch#1 7,518 3,452 7,894
Sales Volume Forecast, Ch#2 5,433 5,345 6,322
Service: Service Outsourcing 2 Standard 2 Standard 2 Standard
Product 6-1 Configuration: H55111
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PRODUCT 6-2 P&L STATEMENT, MONTH 2 PAGE 5
*****************************************************************************
All Regions Region 1 Region 2 Region 3
(TOTAL ) ( U.S.A.) ( Europe) ( Pacific)
------
Active? Ch#1,2 Yes Yes Yes Yes Yes Yes
Sales Volume, Ch#1 10,453 2,754 2,619 5,080
Sales Volume, Ch#2 10,236 4,840 1,509 3,887
Unfilled Orders 0 0 0 0
Price, Ch#1,2 410 575 410 575 410 575 410 575
Revenues 10,171,430 3,912,140 1,941,465 4,317,825
- Product Costs 5,410,169 1,985,829 1,079,471 2,344,869
- Order Processing 287,476 127,176 46,692 113,608
- Replacement Parts 61,824 21,014 12,642 28,168
- RFID Costs 114,983 30,294 28,809 55,880
- Duties & Tariffs 673,453 0 155,316 518,137
------
Gross Margin 3,623,525 1,747,827 618,535 1,257,163
Gross Margin % 35.6% 44.7% 31.9% 29.1%
Fixed Costs:
Administrative O/H 600,000 200,000 200,000 200,000
Forecast Inaccuracy 57,022 20,467 26,273 10,282
Marketing, Ch#1 360,000 120,000 120,000 120,000
Marketing, Ch#2 360,000 120,000 120,000 120,000
Price Changes 0 0 0 0
Service Outsourcing 284,061 85,190 55,572 143,299
Total Fixed Costs 1,661,083 545,657 521,845 593,581
------
Operating Income 1,962,442 1,202,170 96,690 663,582
======
Distribution Center? 2 Owned 1 3rd-Party 0 None
RFID Outsource/Insource? 0 Outsourced 0 Outsourced 0 Outsourced
Emergency Carrier N N
Sales Volume Forecast, Ch#1 2,611 2,493 5,582
Sales Volume Forecast, Ch#2 4,182 1,791 3,964
Service: Service Outsourcing 2 Standard 2 Standard 2 Standard
Product 6-2 Configuration: M55532
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
BALANCE SHEET, MONTH 2 PAGE 6
*****************************************************************************
ASSETS
------
Cash 1,284,462
Marketable Securities 0
Finished Goods and Postponed Production Inventory:
Plant & DC1: Product 6-0 ( 0 units @ 0.00/unit) 0
Product 6-1 ( 0 units @ 0.00/unit) 0
Product 6-2 ( 0 units @ 0.00/unit) 0
DC2: Product 6-0 ( 0 units @ 0.00/unit) 0
Product 6-1 ( 1,599 units @ 167.50/unit) 267,832
Product 6-2 ( 3,588 units @ 261.50/unit) 938,261
Plant Investment 100,000,000
Procurement Inventory:
Plant & DC1: Alpha ( 0 units @ 0.00/unit) 0
Beta ( 0 units @ 0.00/unit) 0
Gamma ( 3,390 units @ 22.00/unit) 74,580
Delta ( 1,573 units @ 24.00/unit) 37,752
Epsilon ( 5,890 units @ 29.00/unit) 170,810
DC2: Gamma ( 1,158 units @ 22.00/unit) 25,476
Delta ( 794 units @ 24.00/unit) 19,056
Epsilon ( 1,626 units @ 29.00/unit) 47,154
Total Assets 102,865,383
LIABILITIES AND EQUITIES
------
Corporate Capitalization 100,000,000
Dividends, Current Month -650,916
Dividends, Cumulative Prior To This Month -577,104
Loans 0
Retained Earnings, Current Month 2,169,723
Retained Earnings, Cumulative Prior To This Month 1,923,680
Total Liabilities and Equities 102,865,383
Note: These epsilon components are on-order, for delivery next month :
Region 1: 30,000Ds 30,000Da
Region 2: 600Ds 600Da
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
CASH FLOW ANALYSIS REPORT, MONTH 2 PAGE 7
*****************************************************************************
Starting "Cash" Balance (Final "Cash" Balance, Month 1) 1,217,857
+ Marketable Securities (Converted To "Cash" In Month 1) 0
- "Loans" (Liquidated During Month 1) -933,899
+ "Finished Goods Inventory" Changes:
Product 6-0 (From 0 To 0) 0
Product 6-1 (From 301,499 To 267,832) 33,667
Product 6-2 (From 448,734 To 938,261) -489,527
+ "Plant Investment" Changes 0
+ "Procurement Inventory" Changes:
Alpha (From 0 To 0) 0
Beta (From 0 To 0) 0
Gamma (From 56,980 To 100,056) -43,076
Delta (From 57,480 To 56,808) 672
Epsilon (From 197,925 To 217,964) -20,039
+ "Net Income" 2,169,723
= Preliminary "Cash" Balance 1,935,378
- "Dividends" (Paid at End of Month 2) -650,916
= Actual "Cash" Balance (End of Month 2) 1,284,462
- Operating "Cash" Excess (To "Marketable Securities") 0
+ Operating "Cash" Deficit (From "Loans") 0
= Final "Cash" Balance (End of Month 2) 1,284,462
Notes:
(1) "Marketable Securities" and "Loans" refer to the values on last
month's balance sheet.
(2) Investment changes can be positive, negative, or zero. A positive
(negative) {zero}. Investment change corresponds to an increase (a
decrease) {no change} in the dollar value of the investment from last
month to this month which leads to a decrease (an increase)
(no change) in current-month "Cash" balance.
(3) At most, one of Operating "Cash" Excess and Operating "Cash" Deficit will
be non-zero; it is possible for both to be zero. Recall that "Cash" must
be between 5.0% and 10.0% of current-month sales revenues. Excess
"Cash" (above 10.0% of revenues) is invested in "Marketable Securities";
shortfalls in "Cash" (below 5.0% of revenues) result in "Loans."
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
FINISHED GOODS INVENTORY REPORT, MONTH 2 PAGE 8
*****************************************************************************
Product Product Product
6-0 6-1 6-2
------
PLANT/DC1 FG INVENTORY
------
Beginning Inventory 0 0 0
+ Regular Production 0 37,000 22,000
+ Emergency Production 0 1,471 561
Postponed Production 0 0 0
= Available Inventory 0 38,471 22,561
- Shipments To DC2:
Surface 0 -10,000 -6,000
Air 0 0 0
Emergency 0 0 0
- Sales, Region 1 -14,512 -7,594
- Sales, Other Regions -13,959 -8,967
= Ending Inventory 0 0 0
DC2 FG INVENTORY
------
Beginning Inventory 0 1,800 1,716
+ Shipments From DC1:
Surface 0 8,547 4,401
Air 0 0 0
Emergency 0 0 0
Postponed Production 0 0 0
= Available Inventory 0 10,347 6,117
- Sales, Region 2 -10,201 -4,128
+ Delayed Shipments 0 1,453 1,599
= Ending Inventory 0 1,599 3,588
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PROCUREMENT INVENTORY REPORT, MONTH 2 PAGE 9
*****************************************************************************
Alpha Beta Gamma Delta Epsilon
------
PLANT & DC1
------
Beginning Inventory 0 0 2,000 1,999 5,999
+ Purchases, Surface 260,000 260,000 16,610 8,427 24,110
+ Purchases, Air 20,000 10,000 30,000
+ Purchases, Emergency 45,160 45,160 545 3,307 2,275
= Available Inventory 305,160 305,160 39,155 23,733 62,384
- Production:
Product 6-0 0 0
Product 6-1 -185,000 -185,000 -37,000 0 -37,000
Product 6-2 -110,000 -110,000 0 -22,000 -22,000
- Emergency Production:
Product 6-0 0 0
Product 6-1 -7,355 -7,355 -1,471 0 -1,471
Product 6-2 -2,805 -2,805 0 -561 -561
- Postponed Production 0 0 0
- Replacement Parts -684 -1,172 -1,352
+ Purchases, Delayed 3,390 1,573 5,890
= Ending Inventory 0 0 3,390 1,573 5,890
DC2
---
Beginning Inventory 590 396 826
+ Purchases, Surface 346 279 518
+ Purchases, Air 400 350 600
+ Purchases, Emergency 0 0 0
= Available Inventory 1,336 1,025 1,944
- Postponed Production 0 0 0
- Replacement Parts -232 -302 -400
+ Purchases, Delayed 54 71 82
= Ending Inventory 1,158 794 1,626
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SERVICE CENTER OPERATIONS REPORT, MONTH 2 PAGE 10
*****************************************************************************
All Region Region Region
Regions 1 2 3
------
======
ACTIVITY REPORT
======
PRODUCT 6-1
Calls 43,594 16,020 11,379 16,195
CSR Cost/Call 11.64 10.00 12.00 13.00
PRODUCT 6-2
Calls 24,173 8,519 4,631 11,023
CSR Cost/Call 11.75 10.00 12.00 13.00
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
OTHER DECISION VARIABLES REPORT, MONTH 2 PAGE 11
*****************************************************************************
======
PROCUREMENT, RAW MATERIALS
======
DC1: Alpha 260,000
DC1: Beta 260,000
======Supplier
PROCUREMENT, SUB------
ASSEMBLY COMPONENTS A B C D E F G
======------
DC1: Gamma, Surface 0 0 0 20,000
DC1: Gamma, Air 0 0 0 20,000
DC1: Delta, Surface 0 0 10,000 0 0
DC1: Delta, Air 0 0 10,000 0 0
DC1: Epsilon, Surface 30,000 0 0 0
DC1: Epsilon, Air 30,000 0 0 0
DC2: Gamma, Surface 0 0 0 400
DC2: Gamma, Air 0 0 0 400
DC2: Delta, Surface 0 0 350 0 0
DC2: Delta, Air 0 0 350 0 0
DC2: Epsilon, Surface 600 0 0 0
DC2: Epsilon, Air 600 0 0 0
Note: Only non-zero sub-assembly component procurements are reported.
======
MANUFACTURING 6-0 6-1 6-2
======------
Production 0 37,000 22,000
Emergency Production Limit 5,000 5,000
Production Flexibility 0 0 0
======Region Region Region
DISTRIBUTION 1 2 3
======------
Cross-Docking, Carrier K 0 0
Cross-Docking, Carrier L 0 0
Cross-Docking, Carrier M 0 0
Cross-Docking, Carrier N 0 0
FGI Surface Shipping 2 2
SAC Surface Shipping 2 2 2
======Carrier
TRANSPORTATION, PLANT/DC1 ------
SHIPMENTS TO OTHER DCs I J K L M N
======------
To DC2: Product 6-1, Surface 0 0 0 0 0 10,000
To DC2: Product 6-2, Surface 0 0 0 0 0 6,000
Note: Only non-zero plant/DC1 shipments to other DCs are reported.
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
OTHER DECISION VARIABLES REPORT, MONTH 2 PAGE 12
*****************************************************************************
======
INFORMATION TECHNOLOGY
======
IT Synchronization With Carriers? 000000
IT Synchronization With Suppliers? 0000000
Procurement Transactions Report? 0
Product Cost Report? 0
Replacement Parts Demand Report? 0
Retail Pipeline Report? 0
Transportation Cost Report? 0
Transportation Report? 0
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
FORECASTING ACCURACY REPORT, MONTH 2 PAGE 13
*****************************************************************************
Region Forecast Actual Accuracy
------
Product 6-1, Channel 1 1 7,518 8,834 85.1%
Product 6-1, Channel 2 1 5,433 5,678 95.7%
Product 6-1, Channel 1 2 3,452 3,614 95.5%
Product 6-1, Channel 2 2 5,345 6,587 81.1%
Product 6-1, Channel 1 3 7,894 7,682 97.2%
Product 6-1, Channel 2 3 6,322 6,277 99.3%
Product 6-2, Channel 1 1 2,611 2,754 94.8%
Product 6-2, Channel 2 1 4,182 4,840 86.4%
Product 6-2, Channel 1 2 2,493 2,619 95.2%
Product 6-2, Channel 2 2 1,791 1,509 81.3%
Product 6-2, Channel 1 3 5,582 5,080 90.1%
Product 6-2, Channel 2 3 3,964 3,887 98.0%
SUMMARY: For 12 forecasts, average forecasting accuracy is 91.7%
Note: Forecasts count within the calculation of forecasting accuracy only
if the "actual" value being forecast is greater than 100 for sales volumes
(to not penalize you for "small" forecasts). Otherwise, the relevant values
of "forecast" and "actual" are only reported for reference purposes, but such
forecasts are not counted for forecasting accuracy scoring. This is the
reason why the number of forecasts referenced in "SUMMARY" may be less than
the detailed line-by-line reporting of forecasts.
Product-Specific Product Product
Forecasting Accuracy Overall 6-1 6-2
------
Forecasting Accuracy 91.7% 92.3% 91.0%
Number of Forecasts 12 6 6
Region-Specific Region Region Region
Forecasting Accuracy Overall 1 2 3
------
Forecasting Accuracy 91.7% 90.5% 88.3% 96.2%
Number of Forecasts 12 4 4 4
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
FORECASTING ACCURACY REPORT, MONTH 2 PAGE 14
*****************************************************************************
Month Month
SALES HISTORY 1 2
------
REGION 1
Product 6-1H, Ch#1 7,518 8,834
Product 6-1H, Ch#2 5,433 5,678
Product 6-2M, Ch#1 2,611 2,754
Product 6-2M, Ch#2 4,182 4,840
REGION 2
Product 6-1H, Ch#1 3,452 3,614
Product 6-1H, Ch#2 5,345 6,587
Product 6-2M, Ch#1 2,493 2,619
Product 6-2M, Ch#2 1,791 1,509
REGION 3
Product 6-1H, Ch#1 7,894 7,682
Product 6-1H, Ch#2 6,322 6,277
Product 6-2M, Ch#1 5,582 5,080
Product 6-2M, Ch#2 3,964 3,887
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SET-TOP BOX INDUSTRY BULLETIN, MONTH 2 PAGE 15
*****************************************************************************
Welcome to the month 2 issue of the Set-Top Box Industry Bulletin.
Notable set-top box industry developments are highlighted in the Bulletin.
INDUSTRY NEWS HEADLINES
Total industry SCM profits were 11,490,956 this month.
Firm 6 leads industry SCM in market share (17.2%).
Firm 1 has the second-highest market share in industry SCM (16.9%).
Industry SCM inventory investment increased from 6,375,708 to
10,942,806 this month.
Total industry SCM research study spending was 0 this month.
DISTRIBUTION CENTER ACTIVITY
No distribution centers were opened this month.
No distribution centers were closed this month.
PRODUCT LAUNCHES AND "UNLAUNCHES"
No products were introduced this month.
No products were "unlaunched" (dropped) this month.
RECONFIGURATIONS
No products were reconfigured this month.
PLANT-DC SURFACE TRANSPORTATION DELIVERY RELIABILITY
------
Carrier I Carrier J Carrier K Carrier L Carrier M Carrier N
------
Region 2 75.7% ++ 45.7% ++ 75.7% ++ 80.7% ++ 70.7% ++ 74.9% --
Region 3 70.0% 30.0% 60.0% 60.0% 75.0% 76.3% -
Notes: These estimates of plant-DC surface transportation delivery
reliability (performance) are derived from shipping industry benchmarking
studies for product categories like set-top boxes. "+" ("-") after a figure
denotes an increase (a decrease) since last month of at least 1% but no
more than 2.5%; "++" ("--") after a figure denotes an increase (a decrease)
since last month of more than 2.5%.
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SET-TOP BOX INDUSTRY BULLETIN, MONTH 2 PAGE 16
*****************************************************************************
PLANT-DC-CUSTOMER TRANSPORTATION/SHIPPING COSTS: Month 3
Channel 1 Channel 2
------
Surface Air Surface Air
------
Region 1 Costs
------
DC1 To Region 1 Customers 4.00 8.00
DC1 To Region 2 Customers 18.00 28.00
DC1 To Region 3 Customers 26.00 36.00
Region 2 Costs (With DC2)
------
DC1 To DC2 Via Carrier I 6.00 8.00 6.00 8.00
DC1 To DC2 Via Carrier J 4.00 10.00 4.00 10.00
DC1 To DC2 Via Carrier K 6.00 8.00 6.00 8.00
DC1 To DC2 Via Carrier L 8.00 10.00 8.00 10.00
DC1 To DC2 Via Carrier M 6.00 8.00 6.00 8.00
DC1 To DC2 Via Carrier N 10.00 12.00 10.00 12.00
DC2 To Region 2 Customers 6.00 12.00
Region 3 Costs (With DC3)
------
DC1 To DC3 Via Carrier I 10.00 14.00 10.00 14.00
DC1 To DC3 Via Carrier J 4.00 14.00 4.00 14.00
DC1 To DC3 Via Carrier K 6.00 14.00 6.00 14.00
DC1 To DC3 Via Carrier L 6.00 14.00 6.00 14.00
DC1 To DC3 Via Carrier M 8.00 16.00 8.00 16.00
DC1 To DC3 Via Carrier N 12.00 18.00 12.00 18.00
DC3 To Region 3 Customers 8.00 16.00
Notes: These plant-DC-customer transportation/shipping costs include "local"
and DC1 sourcing options for all available carriers (I,J,K,L,M,N), channels,
and regions (R1-R3) for finished goods inventory. These costs update the
corresponding costs in Exhibits 9 and 10 in the LINKS participant's manual.
SUB-ASSEMBLY COMPONENT COSTS: Month 3
Supplier
------
A B C D E F G
------
Gamma 11 - 14 12 - 23 +
Delta n/a 15 - 25 + 13 - 13
Epsilon 30 + 19 - 19 20 -
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SET-TOP BOX INDUSTRY BULLETIN, MONTH 2 PAGE 17
*****************************************************************************
Notes: "n/a" denotes unavailable spot-market suppliers. A "+" ("-") after
a cost denotes an increase (a decrease) since last month.
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SPECIAL MESSAGES ABOUT YOUR LINKS VERSION, MONTH 2 PAGE 18
*****************************************************************************
------
PLANT-DC SURFACE TRANSPORTATION DELIVERY RELIABILITY
------
Plant-DC surface transportation delivery reliability may vary through time.
Best estimates of current plant-DC surface transportation performance for all
carriers are shown in the "Set-Top Box Industry Bulletin."
------
PLANT-DC TRANSPORTATION/SHIPPING COSTS
------
Plant-DC shipping costs (including direct shipments from the plant to final
customers in region 1 and in other regions without a "local" DC) change
through time in response to general economic conditions and demand-supply
conditions in transportation/shipping markets. See the "Set-Top Box Industry
Bulletin" for the current shipping costs in the set-top box industry.
------
SUB-ASSEMBLY COMPONENT COSTS
------
Sub-assembly component suppliers tend to change their prices (i.e., your
costs) through time in response to market demand. These changes are
typically increases or decreases of $1/month, although larger changes
occasionally occur. See the "Set-Top Box Industry Bulletin" for the
current spot-market prices (i.e., your costs) for all sub-assembly components
suppliers. A quoted price of "n/a" denotes temporary inability of a sub-
assembly component supplier to service new customers, so that no spot-market
orders will be accepted from non-current customers. However, orders continue
to be accepted from current customers. Sub-assembly component supplier
availability varies through time, so a currently-unavailable sub-assembly
component supplier may become available again in the future.
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
DECISION VARIABLE CHECKS AND MESSAGES, MONTH 2 PAGE 19
*****************************************************************************
FORECASTING DECISION VARIABLE CHECKS [Firm SCM6]
12 forecasts are unchanged. Forecasts are normally changed every month .
RESEARCH STUDIES DECISION VARIABLE CHECKS [Firm SCM6]
No research studies have been ordered.
Research studies are normally ordered every month .
TRANSPORTATION REBATES DETAILS
FGI Shipments To DCs 32,000
Total Transportation Rebates 32,000
VOLUME DISCOUNTS (Raw Materials and Sub-Assembly Components Procurements)
DC1: Raw Material #1 (Alpha) [total RM units: 305,160] 12,576
DC1: Raw Material #2 (Beta) [total RM units: 305,160] 16,768
DC1: SAC Epsilon, Supplier D [total SAC units: 62,275] 37,021
Total Volume Discounts (Reported on Corporate P&L Statement) 66,365
INVENTORY CHARGES DETAILS
$ Begin $ End $ Average Inventory Inventory
Inventory Inventory Inventory Cost (%) Charges
------
DC1: SAC Gamma 44,000 74,580 59,290 3.0 1,778
DC1: SAC Delta 47,976 37,752 42,864 3.0 1,285
DC1: SAC Epsilon 173,971 170,810 172,390 3.0 5,171
DC2: SAC Gamma 12,980 25,476 19,228 5.0 961
DC2: SAC Delta 9,504 19,056 14,280 5.0 714
DC2: SAC Epsilon 23,954 47,154 35,554 5.0 1,777
DC2: FinGoods 6-1 301,499 267,832 284,665 5.0 14,233
DC2: FinGoods 6-2 448,734 938,261 693,497 5.0 34,674
Total Inventory Charges (Reported on the Corporate P&L Statement) 60,593
PRODUCTION SHIFTS AND PLANT CAPACITY FC CALCULATION DETAILS
Production 6-1 = 37,000 units.
Emergency Production 6-1 = 1,471 units.
Production 6-2 = 22,000 units.
Emergency Production 6-2 = 561 units.
Total Production = 61,032 units.
Production Shifts = 2.
Plant Capacity FC = 200,000.