*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PERFORMANCE EVALUATION REPORT, MONTH 1 PAGE 1
*****************************************************************************
+------+------Industry ------+
| Firm 6 | Worst Average Best |
------+------+------+
FINANCIAL | | |
Net Income to Revenues | 7.9%| 7.9% 7.9% 7.9%|
Change in Net Income to Revenues | 0.0%| 0.0% 0.0% 0.0%|
Return on Assets | 23.1%| 23.1% 23.1% 23.1%|
Net Asset Turns | 2.9 | 2.9 2.9 2.9 |
------+------+------+
OPERATIONAL | | |
Inventory Turnover | 10.7 | 10.7 10.7 10.7 |
Fill Rate | 100.0%| 100.0% 100.0% 100.0%|
Unplanned Production | 1.8%| 1.8% 1.8% 1.8%|
Failure Rate | 7.1%| 7.1% 7.1% 7.1%|
Controllable Procure&Mfg to Revenues | 1.2%| 1.2% 1.2% 1.2%|
Transportation Expenses Per Unit Sold | 32.4 | 32.4 32.4 32.4 |
Forecasting Accuracy | 100.0%| 100.0% 100.0% 100.0%|
(Marketing + Service) to Revenues | 9.1%| 9.1% 9.1% 9.1%|
------+------+------+
CUSTOMER | | |
Change in Market Share | 0.0%| 0.0% 0.0% 0.0%|
Customer Satisfaction | 24.8%| 24.8% 24.8% 24.8%|
------+------+------+
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
CORPORATE P&L STATEMENT, MONTH 1 PAGE 2
*****************************************************************************
All Products Product 6-1 Product 6-2
------
Sales Volume 56,587 35,964 20,623
Unfilled Orders 0 0 0
Price 430 396 489
Revenues 24,357,155 14,262,120 10,095,035
- Product Costs 11,416,878 6,023,968 5,392,910
- Order Processing 767,088 485,856 281,232
- Replacement Parts 102,866 41,554 61,312
- RFID Costs 325,050 207,504 117,546
- Transportation Costs 1,869,258
+ Transportation Rebates 34,149
+ Volume Discounts 79,369
- Duties & Tariffs 1,673,569 961,265 712,304
------
Gross Margin 8,315,964 6,541,973 3,529,731
Gross Margin % 34.1% 45.9% 35.0%
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 143,220
Emergency Production 52,914
Forecast Inaccuracy 0 0 0
Information Technology 0
Introductions 0
Inventory Charges 23,901
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 766,570 482,621 283,949
Unfilled Handling 0
Total Fixed & Other 4,468,605 1,802,621 1,603,949
------
Operating Income 3,847,359 4,739,352 1,925,782
------
Non-Operating Income 0
Patent Royalties 0
Taxes -1,923,679
======
Net Income 1,923,680
======
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PRODUCT 6-1 P&L STATEMENT, MONTH 1 PAGE 3
*****************************************************************************
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 18,864 7,518 3,452 7,894
Sales Volume, Ch#2 17,100 5,433 5,345 6,322
Unfilled Orders 0 0 0 0
Price, Ch#1,2 330 470 330 470 330 470 330 470
Revenues 14,262,120 5,034,450 3,651,310 5,576,360
- Product Costs 6,023,968 2,169,292 1,473,496 2,381,180
- Order Processing 485,856 160,464 142,088 183,304
- Replacement Parts 41,554 14,998 10,130 16,426
- RFID Costs 207,504 82,698 37,972 86,834
- Duties & Tariffs 961,265 0 292,103 669,162
------
Gross Margin 6,541,973 2,606,998 1,695,521 2,239,454
Gross Margin % 45.9% 51.8% 46.4% 40.2%
Fixed Costs:
Administrative O/H 600,000 200,000 200,000 200,000
Forecast Inaccuracy 0 0 0 0
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 482,621 148,370 121,272 212,979
Total Fixed Costs 1,802,621 588,370 561,272 652,979
------
Operating Income 4,739,352 2,018,628 1,134,249 1,586,475
======
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 1 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 10,686 2,611 2,493 5,582
Sales Volume, Ch#2 9,937 4,182 1,791 3,964
Unfilled Orders 0 0 0 0
Price, Ch#1,2 410 575 410 575 410 575 410 575
Revenues 10,095,035 3,475,160 2,051,955 4,567,920
- Product Costs 5,392,910 1,776,368 1,120,265 2,496,277
- Order Processing 281,232 110,812 52,956 117,464
- Replacement Parts 61,312 20,200 12,632 28,480
- RFID Costs 117,546 28,721 27,423 61,402
- Duties & Tariffs 712,304 0 164,155 548,149
------
Gross Margin 3,529,731 1,539,059 674,524 1,316,148
Gross Margin % 35.0% 44.3% 32.9% 28.8%
Fixed Costs:
Administrative O/H 600,000 200,000 200,000 200,000
Forecast Inaccuracy 0 0 0 0
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 283,949 78,360 57,636 147,953
Total Fixed Costs 1,603,949 518,360 497,636 587,953
------
Operating Income 1,925,782 1,020,699 176,888 728,195
======
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 1 PAGE 5
*****************************************************************************
ASSETS
------
Cash 1,217,857
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,800 units @ 167.50/unit) 301,499
Product 6-2 ( 1,716 units @ 261.50/unit) 448,734
Plant Investment 100,000,000
Procurement Inventory:
Plant & DC1: Alpha ( 0 units @ 0.00/unit) 0
Beta ( 0 units @ 0.00/unit) 0
Gamma ( 2,000 units @ 22.00/unit) 44,000
Delta ( 1,999 units @ 24.00/unit) 47,976
Epsilon ( 5,999 units @ 29.00/unit) 173,971
DC2: Gamma ( 590 units @ 22.00/unit) 12,980
Delta ( 396 units @ 24.00/unit) 9,504
Epsilon ( 826 units @ 29.00/unit) 23,954
Total Assets 102,280,475
LIABILITIES AND EQUITIES
------
Corporate Capitalization 100,000,000
Dividends, Current Month -577,104
Dividends, Cumulative Prior To This Month 0
Loans 933,899
Retained Earnings, Current Month 1,923,680
Retained Earnings, Cumulative Prior To This Month 0
Total Liabilities and Equities 102,280,475
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 1 PAGE 6
*****************************************************************************
Starting "Cash" Balance (Final "Cash" Balance, Month 0) 0
+ Marketable Securities (Converted To "Cash" In Month 0) 0
- "Loans" (Liquidated During Month 0) 0
+ "Finished Goods Inventory" Changes:
Product 6-0 (From 0 To 0) 0
Product 6-1 (From 0 To 301,499) -301,499
Product 6-2 (From 0 To 448,734) -448,734
+ "Plant Investment" Changes 0
+ "Procurement Inventory" Changes:
Alpha (From 0 To 0) 0
Beta (From 0 To 0) 0
Gamma (From 0 To 56,980) -56,980
Delta (From 0 To 57,480) -57,480
Epsilon (From 0 To 197,925) -197,925
+ "Net Income" 1,923,680
= Preliminary "Cash" Balance 861,062
- "Dividends" (Paid at End of Month 1) -577,104
= Actual "Cash" Balance (End of Month 1) 283,958
- Operating "Cash" Excess (To "Marketable Securities") 0
+ Operating "Cash" Deficit (From "Loans") 933,899
= Final "Cash" Balance (End of Month 1) 1,217,857
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 1 PAGE 7
*****************************************************************************
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 764 339
Postponed Production 0 0 0
= Available Inventory 0 37,764 22,339
- Shipments To DC2:
Surface 0 -10,000 -6,000
Air 0 0 0
Emergency 0 -597 0
- Sales, Region 1 -12,951 -6,793
- Sales, Other Regions -14,216 -9,546
= Ending Inventory 0 0 0
DC2 FG INVENTORY
------
Beginning Inventory 0 0 0
+ Shipments From DC1:
Surface 0 8,200 4,920
Air 0 0 0
Emergency 0 597 0
Postponed Production 0 0 0
= Available Inventory 0 8,797 4,920
- Sales, Region 2 -8,797 -4,284
+ Delayed Shipments 0 1,800 1,080
= Ending Inventory 0 1,800 1,716
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
PROCUREMENT INVENTORY REPORT, MONTH 1 PAGE 8
*****************************************************************************
Alpha Beta Gamma Delta Epsilon
------
PLANT & DC1
------
Beginning Inventory 0 0 0 0 0
+ Purchases, Surface 260,000 260,000 18,000 8,001 24,001
+ Purchases, Air 20,000 10,000 30,000
+ Purchases, Emergency 40,515 40,515 412 5,506 7,406
= Available Inventory 300,515 300,515 38,412 23,507 61,407
- 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 -3,820 -3,820 -764 0 -764
Product 6-2 -1,695 -1,695 0 -339 -339
- Postponed Production 0 0 0
- Replacement Parts -648 -1,168 -1,304
+ Purchases, Delayed 2,000 1,999 5,999
= Ending Inventory 0 0 2,000 1,999 5,999
DC2
---
Beginning Inventory 0 0 0
+ Purchases, Surface 360 281 481
+ Purchases, Air 400 350 600
+ Purchases, Emergency 0 0 0
= Available Inventory 760 631 1,081
- Postponed Production 0 0 0
- Replacement Parts -210 -304 -374
+ Purchases, Delayed 40 69 119
= Ending Inventory 590 396 826
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SERVICE CENTER OPERATIONS REPORT, MONTH 1 PAGE 9
*****************************************************************************
All Region Region Region
Regions 1 2 3
------
======
ACTIVITY REPORT
======
PRODUCT 6-1
Calls 41,326 14,837 10,106 16,383
CSR Cost/Call 11.68 10.00 12.00 13.00
PRODUCT 6-2
Calls 24,020 7,836 4,803 11,381
CSR Cost/Call 11.82 10.00 12.00 13.00
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
OTHER DECISION VARIABLES REPORT, MONTH 1 PAGE 10
*****************************************************************************
======
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 1 PAGE 11
*****************************************************************************
======
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 1 PAGE 12
*****************************************************************************
Region Forecast Actual Accuracy
------
Product 6-1, Channel 1 1 7,518 7,518 100.0%
Product 6-1, Channel 2 1 5,433 5,433 100.0%
Product 6-1, Channel 1 2 3,452 3,452 100.0%
Product 6-1, Channel 2 2 5,345 5,345 100.0%
Product 6-1, Channel 1 3 7,894 7,894 100.0%
Product 6-1, Channel 2 3 6,322 6,322 100.0%
Product 6-2, Channel 1 1 2,611 2,611 100.0%
Product 6-2, Channel 2 1 4,182 4,182 100.0%
Product 6-2, Channel 1 2 2,493 2,493 100.0%
Product 6-2, Channel 2 2 1,791 1,791 100.0%
Product 6-2, Channel 1 3 5,582 5,582 100.0%
Product 6-2, Channel 2 3 3,964 3,964 100.0%
SUMMARY: For 12 forecasts, average forecasting accuracy is 100.0%
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 100.0% 100.0% 100.0%
Number of Forecasts 12 6 6
Region-Specific Region Region Region
Forecasting Accuracy Overall 1 2 3
------
Forecasting Accuracy 100.0% 100.0% 100.0% 100.0%
Number of Forecasts 12 4 4 4
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
FORECASTING ACCURACY REPORT, MONTH 1 PAGE 13
*****************************************************************************
Month
SALES HISTORY 1
------
REGION 1
Product 6-1H, Ch#1 7,518
Product 6-1H, Ch#2 5,433
Product 6-2M, Ch#1 2,611
Product 6-2M, Ch#2 4,182
REGION 2
Product 6-1H, Ch#1 3,452
Product 6-1H, Ch#2 5,345
Product 6-2M, Ch#1 2,493
Product 6-2M, Ch#2 1,791
REGION 3
Product 6-1H, Ch#1 7,894
Product 6-1H, Ch#2 6,322
Product 6-2M, Ch#1 5,582
Product 6-2M, Ch#2 3,964
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SET-TOP BOX INDUSTRY BULLETIN, MONTH 1 PAGE 14
*****************************************************************************
Welcome to the month 1 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,542,080 this month.
Firm 1 leads industry SCM in market share (16.7%).
Firm 2 has the second-highest market share in industry SCM (16.7%).
Industry SCM inventory investment increased from 0 to
6,375,708 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 70.0% 40.0% 70.0% 75.0% 65.0% 82.0%
Region 3 70.0% 30.0% 60.0% 60.0% 75.0% 78.0%
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 1 PAGE 15
*****************************************************************************
PLANT-DC-CUSTOMER TRANSPORTATION/SHIPPING COSTS: Month 2
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 2
Supplier
------
A B C D E F G
------
Gamma 12 14 13 22
Delta 15 16 24 14 13
Epsilon 29 20 19 21
*****************************************************************************
FIRM 6: ?????????????????????????????????????????????????? INDUSTRY SCM
SET-TOP BOX INDUSTRY BULLETIN, MONTH 1 PAGE 16
*****************************************************************************
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 1 PAGE 17
*****************************************************************************
------
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 1 PAGE 18
*****************************************************************************
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 34,149
Total Transportation Rebates 34,149
VOLUME DISCOUNTS (Raw Materials and Sub-Assembly Components Procurements)
DC1: Raw Material #1 (Alpha) [total RM units: 300,515] 11,517
DC1: Raw Material #2 (Beta) [total RM units: 300,515] 15,356
DC1: SAC Epsilon, Supplier D [total SAC units: 67,406] 52,496
Total Volume Discounts (Reported on Corporate P&L Statement) 79,369
INVENTORY CHARGES DETAILS
$ Begin $ End $ Average Inventory Inventory
Inventory Inventory Inventory Cost (%) Charges
------
DC1: SAC Gamma 0 44,000 22,000 3.0 659
DC1: SAC Delta 0 47,976 23,988 3.0 719
DC1: SAC Epsilon 0 173,971 86,985 3.0 2,609
DC2: SAC Gamma 0 12,980 6,490 5.0 324
DC2: SAC Delta 0 9,504 4,752 5.0 237
DC2: SAC Epsilon 0 23,954 11,977 5.0 598
DC2: FinGoods 6-1 0 301,499 150,749 5.0 7,537
DC2: FinGoods 6-2 0 448,734 224,367 5.0 11,218
Total Inventory Charges (Reported on the Corporate P&L Statement) 23,901
PRODUCTION SHIFTS AND PLANT CAPACITY FC CALCULATION DETAILS
Production 6-1 = 37,000 units.
Emergency Production 6-1 = 764 units.
Production 6-2 = 22,000 units.
Emergency Production 6-2 = 339 units.
Total Production = 60,103 units.
Production Shifts = 2.
Plant Capacity FC = 200,000.