No.

Sheet Name Column Name

1 BOM & COGS RATIO Level

Part Code
Part Name
Parent Code

Quantity

Unit
Supplier
Origin
Product Item Code
COGS Ratio (%)

COGS Value (USD)

2 SUPPLIER PROFILE Part Code
Part Name
Supplier
Origin
Supply Ratio (%)

Minimum Order Quantity (pieces)

Production Lead Time (days)

Shipping Time Origin Countries ->

Phu Tho (days)
Unit Price (USD/piece)
3 FACTORY INFORMATION Line
Part Code
Part Name
Cycle Time (second/piece)
Monthly Capacity (piece)
Overall Equipment Effectiveness (%)

Utilization (%)

Production Waste Rate (%)

 Explanation
The hierarchy level of each part in the Bill of Materials (BOM). Level 1 represents
components’ level and level 2 represents raw materials’ level in one front brake
part.
Code of each component or raw material in the BOM.
Name of each component or raw material.
Code of the parent assembly to which the part belongs. Used to establish parent–
child relationships in the BOM.
Number of units of the component/raw materials required in the parent assembly.

Measurement unit of the quantity.

Code of each component or raw material in the BOM.
Name of each component or raw material.
Internal product code linking the component/raw material to the finished part.
Percentage of the component/raw material’s cost in the total Cost of Goods Sold
(COGS) of the front brake part.
Absolute Cost of Goods Sold (COGS) of the component/raw material in USD.
Code of each component or raw material in the BOM.
Name of each component or raw material.
Code of each component or raw material in the BOM.
Name of each component or raw material.
Proportion of supply volume covered by each supplier compared to total
procurement of that material.
Minimum order size required by the supplier for each purchase.
Number of days needed by the supplier to produce and prepare the material for
shipping.
Shipping time in days from the supplier’s origin country to the Phu Tho factory.

Purchase price of one unit of material in USD.

Production line in the factory.
Code of each component or raw material in the BOM.
Name of each component or raw material.
Average time required to produce one piece, measured in seconds.
Maximum number of units a line can produce in one month.
Overall efficiency of the production line in percentage.

Percentage of the production capacity actually utilized compared to the maximum

capacity.
Percentage of input material wasted during the production of the part.
Supplier Sum of COGS Value (USD)
ChemLube Ltd. 2.7816
FrictionTech Co. 20.946
GlobalSteel Industries
MetalWorks Co. 3.8586
Nihon Metal Works
PolyRubber Inc. 19.8534
SteelCorp Ltd. 232.9604 42%
(empty) 280.4
Total Result 560.8
Part Name Sum of COGS Value (USD)
Bearing Inner Wheel 20
Bearing Outer Wheel 20
Bearing Steel 40
Brass 3.8586
Caliper Disc Front LH 50
Caliper Disc Front RH 50
Cap Dust 2
Cotter Key 0.4
Engineering Plastic 1.1882
Friction Material 20.946
High Temp Grease 2.7816
Hose Caliper Front LH 12
Hose Caliper Front RH 12
Pads - Disc Kit 30
Retain Clip Hose Frame Attach 1
Rotor Disc Brake 50
Seal - Brass Hydraulic 6
Seal Grease 4
Stainless Brake Lines 16
Stainless Steel 31.5064 6% %COGS tăng
Steel Alloy 161.454 29% 2%
Synthetic Rubber 18.6652
Tube Hyd Front Distribution 6
Washer Retainer Outer Bearing 1
(empty)
Total Result 560.8
 COGS
Part Name Sum of COGS Value (USD) %Profitability Number of suppliers %COGS tăng 1
Bearing Steel 80 19.4% 1 0% 125360
Brass 15.4344 3.7% 1 0% 24185.7
Engineering Plastic 2.3764 0.6% 1 0% 3723.819
Friction Material 20.946 5.1% 1 0% 32822.38
High Temp Grease 5.5632 1.3% 1 0% 8717.534
Stainless Steel 47.5064 11.5% 3 0.69% 74442.53
Steel Alloy 213.854 51.8% 2 2.59% 335109.2
Synthetic Rubber 27.1196 6.6% 1 0% 42496.41

(empty) 3.28%
Total Result 412.8
 2 3 4 5 6 7 8 9 10 11
129360
24957.42
12
Level Part Code Part Name Parent Code Quantity Unit
1 FB-001 Hose Caliper Front LH 1 pcs
1 FB-002 Hose Caliper Front RH 1 pcs
1 FB-003 Seal - Brass Hydraulic 4 pcs
1 FB-004 Retain Clip Hose Frame Attach 2 pcs
1 FB-005 Stainless Brake Lines 2 pcs
1 FB-006 Caliper Disc Front LH 1 pcs
1 FB-007 Caliper Disc Front RH 1 pcs
1 FB-008 Rotor Disc Brake 2 pcs
1 FB-009 Bearing Inner Wheel 2 pcs
1 FB-010 Bearing Outer Wheel 2 pcs
1 FB-011 Washer Retainer Outer Bearing 2 pcs
1 FB-012 Cotter Key 2 pcs
1 FB-013 Seal Grease 2 pcs
1 FB-014 Cap Dust 2 pcs
1 FB-015 Pads - Disc Kit 1 set
1 FB-016 Tube Hyd Front Distribution 1 pcs
2 RM-SS-TUBE-316L Stainless Steel FB-001 1 pcs

2 RM-RUBBER-EPDM/NBR Synthetic Rubber FB-001 1 pcs

2 RM-SS-TUBE-316L Stainless Steel FB-002 1 pcs

2 RM-RUBBER-EPDM/NBR Synthetic Rubber FB-002 1 pcs

2 RM-BRASS Brass FB-003 1 pcs
2 RM-RUBBER-EPDM/NBR Synthetic Rubber FB-003 1 pcs
2 RM-STEEL-ALLOY Steel Alloy FB-004 1 pcs

2 RM-SS-TUBE-316L Stainless Steel FB-005 1 pcs

2 RM-STEEL-ALLOY Steel Alloy FB-006 1 pcs

2 RM-STEEL-ALLOY Steel Alloy FB-007 1 pcs

2 RM-STEEL-ALLOY Steel Alloy FB-008 1 pcs

2 RM-BEARING-STEEL Bearing Steel FB-009 1 pcs

2 RM-BEARING-STEEL Bearing Steel FB-010 1 pcs
2 RM-STEEL-ALLOY Steel Alloy FB-011 1 pcs

2 RM-STEEL-ALLOY Steel Alloy FB-012 1 pcs

2 RM-GREASE High Temp Grease FB-013 1 pcs

2 RM-RUBBER-EPDM/NBR Synthetic Rubber FB-013 1 pcs
2 RM-PLASTIC-POM Engineering Plastic FB-014 1 pcs
2 RM-RUBBER-EPDM/NBR Synthetic Rubber FB-014 1 pcs
2 RM-FRICTION-MAT Friction Material FB-015 1 pcs
2 RM-STEEL-ALLOY Steel Alloy FB-015 1 pcs

2 RM-SS-TUBE-316L Stainless Steel FB-016 1 pcs

 Supplier Origin Product Item Code COGS Ratio (%) COGS Value (USD)
FB_SET_001 4.28% 12
FB_SET_001 4.28% 12
FB_SET_001 2.14% 6
FB_SET_001 0.36% 1
FB_SET_001 5.71% 16
FB_SET_001 17.83% 50
FB_SET_001 17.83% 50
FB_SET_001 17.83% 50
FB_SET_001 7.13% 20
FB_SET_001 7.13% 20
FB_SET_001 0.36% 1
FB_SET_001 0.14% 0.4
FB_SET_001 1.43% 4
FB_SET_001 0.71% 2
FB_SET_001 10.70% 30
FB_SET_001 2.14% 6
SteelCorp Ltd. Japan FB_SET_001 39.61% 4.7532
Nihon Metal Works Japan
GlobalSteel Industries South Korea
PolyRubber Inc. Vietnam FB_SET_001 60.39% 7.2468
SteelCorp Ltd. Japan FB_SET_001 39.61% 4.7532
Nihon Metal Works Japan
GlobalSteel Industries South Korea
PolyRubber Inc. Vietnam FB_SET_001 60.39% 7.2468
MetalWorks Co. Vietnam FB_SET_001 64.31% 3.8586
PolyRubber Inc. Vietnam FB_SET_001 35.69% 2.1414
SteelCorp Ltd. Japan FB_SET_001 100% 1
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 16
Nihon Metal Works Japan
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 50
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 50
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 50
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 20
SteelCorp Ltd. Japan FB_SET_001 100% 20
SteelCorp Ltd. Japan FB_SET_001 100% 1
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 0.4
GlobalSteel Industries South Korea
ChemLube Ltd. Vietnam FB_SET_001 69.54% 2.7816
PolyRubber Inc. Vietnam FB_SET_001 30.46% 1.2184
PolyRubber Inc. Vietnam FB_SET_001 59.41% 1.1882
PolyRubber Inc. Vietnam FB_SET_001 40.59% 0.8118
FrictionTech Co. Japan FB_SET_001 69.82% 20.946
SteelCorp Ltd. Japan FB_SET_001 30.18% 9.054
GlobalSteel Industries South Korea
SteelCorp Ltd. Japan FB_SET_001 100% 6
Nihon Metal Works Japan
GlobalSteel Industries South Korea
 Level
2

2
2

2
2
2
2

2
4.7532
2

7.2468 2
4.7532
2
2
7.2468 2
15.4344
8.5656 2
2
2
32 2
2
2
50 2
2
50
2
100

40
40
2

0.8

5.5632
2.4368
2.3764
1.6236
20.946
9.054

6
 Part Code Part Name Parent Code Quantity Unit Supplier
RM-SS-TUBE-316LStainless Steel FB-001 1 pcs SteelCorp Ltd.
Nihon Metal Work
GlobalSteel Indust
RM-RUBBER-EPD Synthetic Rubber FB-001 1 pcs PolyRubber Inc.
RM-SS-TUBE-316LStainless Steel FB-002 1 pcs SteelCorp Ltd.
Nihon Metal Work
GlobalSteel Indust
RM-RUBBER-EPD Synthetic Rubber FB-002 1 pcs PolyRubber Inc.
RM-BRASS Brass FB-003 1 pcs MetalWorks Co.
RM-RUBBER-EPD Synthetic Rubber FB-003 1 pcs PolyRubber Inc.
RM-STEEL-ALLOY Steel Alloy FB-004 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-SS-TUBE-316LStainless Steel FB-005 1 pcs SteelCorp Ltd.
Nihon Metal Work
GlobalSteel Indust
RM-STEEL-ALLOY Steel Alloy FB-006 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-STEEL-ALLOY Steel Alloy FB-007 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-STEEL-ALLOY Steel Alloy FB-008 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-BEARING-STEEBearing Steel FB-009 1 pcs SteelCorp Ltd.
RM-BEARING-STEEBearing Steel FB-010 1 pcs SteelCorp Ltd.
RM-STEEL-ALLOY Steel Alloy FB-011 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-STEEL-ALLOY Steel Alloy FB-012 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-GREASE High Temp GreaseFB-013 1 pcs ChemLube Ltd.
RM-RUBBER-EPD Synthetic Rubber FB-013 1 pcs PolyRubber Inc.
RM-PLASTIC-POMEngineering PlastiFB-014 1 pcs PolyRubber Inc.
RM-RUBBER-EPD Synthetic Rubber FB-014 1 pcs PolyRubber Inc.
RM-FRICTION-MAFriction Material FB-015 1 pcs FrictionTech Co.
RM-STEEL-ALLOY Steel Alloy FB-015 1 pcs SteelCorp Ltd.
GlobalSteel Indust
RM-SS-TUBE-316LStainless Steel FB-016 1 pcs SteelCorp Ltd.
Nihon Metal Work
GlobalSteel Indust
 Origin Product Item Code COGS Ratio (%) COGS Value (USD)
Japan FB_SET_001 39.61% 4.7532
Japan
South Korea
Vietnam FB_SET_001 60.39% 7.2468
Japan FB_SET_001 39.61% 4.7532
Japan
South Korea
Vietnam FB_SET_001 60.39% 7.2468
Vietnam FB_SET_001 64.31% 15.4344
Vietnam FB_SET_001 35.69% 8.5656
Japan FB_SET_001 100%
South Korea 2
Japan FB_SET_001 100%
Japan
South Korea 32
Japan FB_SET_001 100%
South Korea 50
Japan FB_SET_001 100%
South Korea 50
Japan FB_SET_001 100%
South Korea 100
Japan FB_SET_001 100% 40
Japan FB_SET_001 100% 40
Japan FB_SET_001 100%
South Korea 2
Japan FB_SET_001 100%
South Korea 0.8
Vietnam FB_SET_001 69.54% 5.5632
Vietnam FB_SET_001 30.46% 2.4368
Vietnam FB_SET_001 59.41% 2.3764
Vietnam FB_SET_001 40.59% 1.6236
Japan FB_SET_001 69.82% 20.946
Japan FB_SET_001 30.18%
South Korea 9.054
Japan FB_SET_001 100%
Japan
South Korea 6
 Part Code Part Name Supplier Origin Supply Ratio (%) Minimum Order Quantity (pieces)
Quantity
RM-SS-TUBE-316L Stainless Steel SteelCorp Ltd. Japan 40%
### 20000
Nihon Metal Works Japan 30%
### 15000
GlobalSteel Industries South Korea 30%
### 25000
RM-RUBBER-EPDM/NBR Synthetic Rubber PolyRubber Inc. Vietnam 100%### 30000
RM-BRASS Brass MetalWorks Co. Vietnam 100%### 10000
RM-STEEL-ALLOY Steel Alloy SteelCorp Ltd. Japan 60%
### 20000
GlobalSteel Industries South Korea 40%
### 25000
RM-BEARING-STEEL Bearing Steel SteelCorp Ltd. Japan 100%### 20000
RM-GREASE High Temp Grease ChemLube Ltd. Vietnam 100%### 10000
RM-PLASTIC-POM Engineering Plastic PolyRubber Inc. Vietnam 100%### 20000
RM-FRICTION-MAT Friction Material FrictionTech Co. Japan 100%### 15000

Supply ratio of Stainless Steel Unit Price of Stainless Leadtim

Steel
GlobalSteel Industries
SteelCorp Ltd. 4.45
30% Nihon Metal Works
40% GlobalSteel Indus- Nihon Metal Works
tries 4.15
4.10
30% SteelCorp Ltd.
SteelCorp Ltd. Nihon Metal GlobalSteel
Works Industries 0 5

Supply ratio of Steel Alloy Unit Price of Steel Alloy

Leadtim
8.93

SteelCorp Ltd. GlobalSteel Industries

40% GlobalSteel Indus-
tries
60%
8.40
SteelCorp Ltd.

SteelCorp Ltd. GlobalSteel Industries 0

 8.93

SteelCorp Ltd. GlobalSteel Industries

40% GlobalSteel Indus-
tries
60%
8.40
SteelCorp Ltd.

SteelCorp Ltd. GlobalSteel Industries 0

 Production Lead Time (days) Shipping Time Origin Countries -> Phu Tho (days) Leadtime Unit Price (USD/piece)
40 12 52 4.20
35 12 47 4.10
45 14 59 4.15
20 3 23 2.90
18 3 21 3.60
40 12 52 8.50
45 14 59 8.40
42 12 54 9.5
22 4 26 2.5
18 3 21 1.1
40 15 55 19.5

Leadtime & Shipping time

14
GlobalSteel Industries 52.6666666666667
45

12
Nihon Metal Works 55.5
35

12
SteelCorp Ltd.
40
0 5 10 15 20 25 30 35 40 45 50

Leadtime & Shipping time

59
GlobalSteel Industries
14

52
SteelCorp Ltd.
12

0 10 20 30 40 50 60 70
 59
GlobalSteel Industries
14

52
SteelCorp Ltd.
12

0 10 20 30 40 50 60 70
New Unit Price (USD/piece)
4.45
4.10
4.15
2.90
3.60
8.93
8.40
9.5
2.5
1.1
19.5
 Line Part Code Part Name Cycle Time (second/piece)
L0 FB_SET_001 Front Brake Assembly 90
L1 FB-008 Rotor Disc Brake 90
L2 FB-001 Hose Caliper Front LH 60
FB-002 Hose Caliper Front RH 60
L3 FB-005 Stainless Brake Lines 45
L4 FB-016 Tube Hyd Front Distribution 40
L5 FB-006 Caliper Disc Front LH 80
FB-007 Caliper Disc Front RH 80
L6 FB-009 Bearing Inner Wheel 50
L7 FB-010 Bearing Outer Wheel 50
L8 FB-003 Seal - Brass Hydraulic 35
L9 FB-004 Retain Clip Hose Frame Attach 20
L10 FB-014 Cap Dust 25
L11 FB-015 Pads - Disc Kit 70
L12 FB-011 Washer Retainer Outer Bearing 20
L13 FB-012 Cotter Key 15
L14 FB-013 Seal Grease 30
Note: Each line runs for 24 hours.
Monthly Capacity (piece) Overall Equipment Effectiveness (%) Utilization (%)
24000 85% 85%
24000 85% 85%
30000 85% 87%

34000 85% 88%

45000 86% 87%
30000 90% 86%

35000 87% 85%

35000 87% 86%
57000 88% 90%
100000 85% 90%
84000 91% 90%
33000 90% 85%
98000 90% 88%
140000 86% 90%
60000 85% 86%
Production Waste Rate (%) Actual output Final product Month Actual output
2.5% 16907 16907 1 8453
2.5% 16907 8453.25 2 8453
3.0% 3 8453
21463.9875 21463.9875
3.5% 4 8453
2.0% 24923.36 12461.68 5 8453
2.5% 32827.275 32827.275 6 8453
2.4% 7 8453
22639.5 22639.5
2.6% 8 8453
3.1% 25080.1425 12540.07125 9 8453
4.5% 25008.585 12504.2925 10 8453
4.0% 43338.24 10834.56 11 8453
2.0% 74970 37485 12 8453
2.4% 67144.896 33572.448
3.0% 24487.65 24487.65
2.7% 75520.368 37760.184
2.5% 105651 52825.5
2.5% 42763.5 21381.75
Production demand Actual output Production demand
2169 9000
2238 8000
2313 7000
2392
6000
2480
2569 5000

2662 4000
2758 3000
2861 2000
2965
1000
3074
0
3188 1 2 3 4 5 6 7 8 9 10 11 12
 Month SEDAN_001 HATCHBACK_001 SUV_001 Total demand Total Production
1 940 392 235 1567
2 970 404 243 1617
3 1002 418 251 1671
4 1037 432 259 1728
5 1075 448 269 1792
6 1114 464 278 1856
7 1154 481 288 1923
8 1196 498 299 1993
9 1240 517 310 2067
10 1285 536 321 2142
11 1333 555 333 2221
12 1382 576 345 2303
13728 5721 3431

The Sale forecast of 2026

1600 Cơ cấu doanh
1400
1200
1000 15%
800
600 25%
60%
400
200
0
1 2 3 4 5 6 7 8 9 10 11 12

SEDAN_001 HATCHBACK_001 SUV_001

 Current price Total Sales Revenue (USD)
SEDAN_001 310 13728 4255680
HATCHBACK_001 330 5721 1887930
SUV_001 315 3431 1080765

Forecast
Jan 1567
Feb 1617
Mar 1671
Apr 1728
May 1792
Jun 1856
Jul 1923
Aug 1993
Sep 2067
Oct 2142
Cơ cấu doanh số Nov 2221
Dec 2303

15% SEDAN_001 SS
HATCHBACK_001
Jan 7835
SUV_001
% Feb 8085
60%
Mar 8355
Apr 8640
May 8960
Jun 9280
Jul 9615
Aug 9965
Sep 10335
Oct 10710
Nov 11105
Dec 11515
 1 2 3 4 5
1567 1567 6268 3134 3134
1617 1617 6468 3234 3234
1671 1671 6684 3342 3342
1728 1728 6912 3456 3456
1792 1792 7168 3584 3584
1856 1856 7424 3712 3712
1923 1923 7692 3846 3846
1993 1993 7972 3986 3986
2067 2067 8268 4134 4134
2142 2142 8568 4284 4284
2221 2221 8884 4442 4442
2303 2303 9212 4606 4606

SR Brass SA Bearing Grease

15670 6268 17237 6268 3134
16170 6468 17787 6468 3234
16710 6684 18381 6684 3342
17280 6912 19008 6912 3456
17920 7168 19712 7168 3584
18560 7424 20416 7424 3712
19230 7692 21153 7692 3846
19930 7972 21923 7972 3986
20670 8268 22737 8268 4134
21420 8568 23562 8568 4284
22210 8884 24431 8884 4442
23030 9212 25333 9212 4606
 6 7 8 9 10 11
1567 1567 3134 3134 3134 3134
1617 1617 3234 3234 3234 3234
1671 1671 3342 3342 3342 3342
1728 1728 3456 3456 3456 3456
1792 1792 3584 3584 3584 3584
1856 1856 3712 3712 3712 3712
1923 1923 3846 3846 3846 3846
1993 1993 3986 3986 3986 3986
2067 2067 4134 4134 4134 4134
2142 2142 4284 4284 4284 4284
2221 2221 4442 4442 4442 4442
2303 2303 4606 4606 4606 4606

Plastic Friction
3134 1567
3234 1617
3342 1671
3456 1728
3584 1792
3712 1856
3846 1923
3986 1993
4134 2067
4284 2142
4442 2221
4606 2303
12 13 14 15 16
3134 3134 3134 1567 1567
3234 3234 3234 1617 1617
3342 3342 3342 1671 1671
3456 3456 3456 1728 1728
3584 3584 3584 1792 1792
3712 3712 3712 1856 1856
3846 3846 3846 1923 1923
3986 3986 3986 1993 1993
4134 4134 4134 2067 2067
4284 4284 4284 2142 2142
4442 4442 4442 2221 2221
4606 4606 4606 2303 2303
 DEC JAN

PERIOD W4 W1 W2

Forecast 391.75 391.75

Orders 391.75 391.75

Projected available balance 0 69.1323529 138.264706

Available-to-promise
69.1323529 138.264706
(cumulative)

Production for demand 460.882353 460.882353

Production for safety stock 0 0

Total production 460.882353 460.882353

Safety Stock

2551.5978017505
JAN FEB

W3 W4 W1 W2 W3

391.75 391.75 404.25 404.25 404.25

391.75 391.75 404.25 404.25 404.25

207.397059 276.529412 347.867647 419.205882 490.544118

207.397059 276.529412 347.867647 419.205882 490.544118

460.882353 460.882353 475.588235 475.588235 475.588235

0 0 0 0 0

460.882353 460.882353 475.588235 475.588235 475.588235

 MAR

W4 W1 W2 W3 W4

404.25 417.75 417.75 417.75 417.75

404.25 417.75 417.75 417.75 417.75

561.882353 635.602941 709.323529 783.044118 856.764706

561.882353 635.602941 709.323529 783.044118 856.764706

475.588235 491.470588 491.470588 491.470588 491.470588

0 0 0 0 0

475.588235 491.470588 491.470588 491.470588 491.470588

 ss Nov Dec

Period W2 W3 W4 W1

Gross Requirement

Projected
0
On Hand

Net Requirement

Planned Order
Receipt

Planned Order
20000
Released

sr Nov Dec

Period W2 W3 W4 W1

Gross Requirement

Projected
0
On Hand

Net Requirement

Planned Order
Receipt

Planned Order
Released
 Dec Jan FEB

W2 W3 W4 W5 W6 W7 W8 W9

1958.75 1958.75 1958.75 1958.75 2021.25

18041.25 16082.5 14123.75 12165 10143.75

1958.75 0 0 0 0

20000

20000

Dec Jan FEB

W2 W3 W4 W5 W6 W7 W8 W9

3917.5 3917.5 3917.5 3917.5 4042.5

26082.5 22165 18247.5 14330 10287.5

3917.5 0 0 0 0

30000

30000 30000
 FEB MAR

W10 W11 W12 W9 W10 W11 W12

2021.25 2021.25 2021.25 2088.75 2088.75 2088.75 2088.75

8122.5 6101.25 4080 1991.25 33993.75 12035 10076.25

0 0 0 0 97.5 0 0

20000

20000

FEB MAR

W10 W11 W12 W9 W10 W11 W12

4042.5 4042.5 4042.5 4177.5 4177.5 4177.5 4177.5

6245 2202.5 28160 23982.5 17987.5 14070 10152.5

0 0 1840 0 0 0 0

30000

30000
 APR MAY

W9 W10 W11 W12 W9

2160 2160 2160 2160 2240

7983.75 5962.5 3941.25 1920 19751.25

0 0 0 0 320

20000

APR MAY

W9 W10 W11 W12 W9

4320 4320 4320 4320 2240

5967.5 1925 27882.5 23840 21742.5

0 0 2395 0 0

30000
 MAY JUN JUL

W10 W11 W12 W9 W10 W11 W12 W9 W10

2240 2240 2240 2320 2320 2320 2320 2403.75 2403.75

31754 9795 7836.3 5663.8 3642.5 1621.3 19600 17347.5 29350

0 0 0 0 0 0 698.75 0 0

20000

20000

MAY JUN JUL

W10 W11 W12 W9 W10 W11 W12 W9 W10

2240 2240 2240 2320 2320 2320 2320 2403.75 2403.75

15747.5 11830 7912.5 3647.5 -395 25563 21520 19339 13344

0 0 0 0 0 2715 0 0 0
JUL

W11 W12

2403.8 2403.8

7391.3 5432.5

0 0

JUL

W11 W12

2403.8 2403.8

9426.3 5508.8

0 0
Month Actual output Stainless Steel Synthetic Rubber Brass Steel Alloy Bearing Steel
1 8453 42266 84533 33813 92986 33813
2 8453 42266 84533 33813 92986 33813
3 8453 42266 84533 33813 92986 33813
4 8453 42266 84533 33813 92986 33813
5 8453 42266 84533 33813 92986 33813
6 8453 42266 84533 33813 92986 33813
7 8453 42266 84533 33813 92986 33813
8 8453 42266 84533 33813 92986 33813
9 8453 42266 84533 33813 92986 33813
10 8453 42266 84533 33813 92986 33813
11 8453 42266 84533 33813 92986 33813
12 8453 42266 84533 33813 92986 33813
High Temp Grease Engineering Plastic Friction Material
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
16907 16907 8453
 w
Quality 1 5 3 2 7 3 2.927903
Pricing 0.20 1 0.333333 0.50 3 0.5 0.606962
Delivery Timeliness 0.333333 3 1 0.5 5 2 1.30766
Continuous Capability 0.142857 2 2 1 7 3 1.513086
Transaction Response 0.5 3 0.2 0.142857 1 0.5 0.527026
Environment 0.333333 2 0.5 0.333333 2 1 0.778272
Standardize
0.38218744
0.07922848
0.17069258
0.19750732
0.0687942
0.10158998