Supply Chain Management

profilellulu677
SCM355Analyses1.xlsx
Home>Business & Finance homework help>Operations Management homework help>Supply Chain Management

Sheet1

Financial Data (Numerical) Financial Data Interpretation Relative to Industry Average (Unweighted) Financial Data Interpretation Relative to Industry Average (Weighted)
Asia-Pac CanDo Davis Dihachi Asia-Pac CanDo Davis Dihachi Asia-Pac CanDo Davis Dihachi Weight
Asset Utilization Asset Utilization Asset Utilization 30%
Asset Turnover 1.316 1.571 1.643 1.383 Asset Turnover 1 4 5 2 Asset Turnover 1.8 7.2 9 3.6 9%
Inventory Turnover 5.781 6.46 17.04 8.621 Inventory Turnover 1 2 5 3 Inventory Turnover 2.2 4.4 11 6.6 11%
Receivable Days 49.23 29.45 64.17 46.362 Receivable Days 2 5 1 2 Receivable Days 2 5 1 2 5%
Payable Days 31.164 55.727 38.028 35.899 Payable Days 5 1 3 3 Payable Days 5 1 3 3 5%
Unweighted Total 9 12 14 10 Weighted Total 11 17.6 24 15.2 30%
Capitalization
Leverage 2.045 2.028 2.28 2.095 Capitalization Capitalization 30%
ROE 0.093 0.217 0.168 0.099 Leverage 4 5 1 3 Leverage 4 5 1 3 5%
LTD to E 0.308 0.318 0.392 0.353 ROE 1 5 4 2 ROE 1 5 4 2 5%
LTD to A 0.15 0.157 0.172 0.421 LTD to E 5 4 1 2 LTD to E 3 2.4 0.6 1.2 3%
Current Ratio 1.215 1.338 1.35 1.129 LTD to A 5 3 3 1 LTD to A 3 1.8 1.8 0.6 3%
Quick Ratio 0.62 0.726 1.12 0.71 Current Ratio* 3 5 5 1 Current Ratio 3.6 6 6 1.2 6%
EBIT Coverage 5.25 6.46 3.61 2.846 Quick Ratio* 1 3 5 3 Quick Ratio 0.8 2.4 4 2.4 4%
EBIT Coverage 4 5 2 1 EBIT Coverage 3.2 4 1.6 0.8 4%
Profitability Unweighted Total 23 30 21 13 Weighted Total 18.6 26.6 19 11.2 30%
Operating Margin 0.008 0.012 0.0016 0.002
Profit Margin 0.0346 0.068 0.045 0.034 Profitability Profitability 40%
ROA 0.045 0.107 0.074 0.047 Operating Margin 4 5 2 1 Operating Margin 9.6 12 4.8 2.4 12%
Profit Margin 2 5 3 2 Profit Margin 7.2 18 10.8 7.2 18%
ROA 2 5 3 2 ROA 4 10 6 4 10%
Unweighted Total 8 15 8 5 Weighted Total 20.8 40 21.6 13.6 30%
Results Results
Total Points (Out of 70) 40 57 43 28 Total Points (Out of 100) 50.4 84.2 64.6 40
Percentage Score 57% 81% 61% 40% Percentage Score 50.4% 84.2% 64.6% 40%

Sheet2

Performance Category Comparative Analysis (Weighted) Performance Category Comparative Analysis (Unweighted)
Asia-Pac CanDo Davis Dihachi Weights (%) Asia-Pac CanDo Davis Dihachi
Supplier Quality 25% Supplier Quality
Management and Personnel Capability 2 3 2 5 5% Management and Personnel Capability 2 3 2 5
Information Systems Capability 3 0.6 3 1.8 3% Information Systems Capability 5 1 5 3
Process and Tech. Capability 6 3.6 6 6 6% Process and Tech. Capability 5 3 5 5
Long-term Partnership Potential 1.6 3.2 3.2 3.2 4% Long-term Partnership Potential 2 4 4 4
Previous History and Performance 4 0.8 1.6 4 4% Previous History and Performance 5 1 2 5
Supply Management Efforts 0.6 3 1.8 2.4 3% Supply Management Efforts 1 5 3 4
Weighted Total 17.2 14.2 17.6 22.4 25% Unweighted Total 20 17 21 26
Product Quality 20% Product Quality
Product Quality Performance 4.8 1.6 4.8 8 8% Product Quality Performance 3 1 3 5
Percentage of Business Devoted to PC Production 3.2 2.4 2.4 4 4% Percentage of Business Devoted to PC Production 4 3 3 5
Tolerance for Defects 4.8 1.6 8 6.4 8% Tolerance for Defects 3 1 5 4
Weighted Total 12.8 5.6 15.2 18.4 20% Unweighted Total 10 5 11 14
Delivery Reliability 20% Delivery Reliability
Delivery Performance 7.2 5.4 9 5.4 9% Delivery Performance 4 3 5 3
Lead Time 1.4 4.2 5.6 1.4 7% Lead Time 1 3 4 1
Frequency of Shipment 0.8 2.4 4 0.8 4% Frequency of Shipment 1 3 5 1
Weighted Total 9.4 12 18.6 7.6 20% Unweighted Total 6 9 14 5
Responsiveness to Demand and Cust. Needs 20% Responsiveness to Demand and Cust. Needs
Demand Flexibility 7.8 5.2 10.4 10.4 13% Demand Flexibility 3 2 4 4
Customization Flexibility 4.2 5.6 4.2 2.8 7% Customization Flexibility 3 4 3 2
Weighted Total 12 10.8 14.6 13.2 20% Unweighted Total 6 6 7 6
Cost Competitiveness 15% Cost Competitiveness
Product Cost Competitiveness 5 1 2 4 5% Product Cost Competitiveness 5 1 2 4
Total Cost Competitiveness 4.2 4.2 1.4 4.2 7% Total Cost Competitiveness 3 3 1 3
Potential to Negotiate Lower Costs 1.2 1.2 2.4 1.8 3% Potential to Negotiate Lower Costs 2 2 4 3
Weighted Total 10.4 6.4 5.8 10 15% Unweighted Total 10 6 7 10
Results Results
Total Points (Out of 100) 61.8 49 71.8 71.6 Total Points (Out of 85) 52 43 60 61
Percentage Score 61.8% 49% 71.8% 71.6% Percentage Score 61% 51% 71% 72%