Question: Term Project 1 Integrating Techsofts New Vision Graphics Card into the Supply Chain Company Background Techsoft, a leading technology company specializing in graphics processing, has











AutoSave Tem Project 1 (1) - Fle Home Insert Draw Page Layout Formulas Data View Help Search Share X out Copy - Paste Format Painter - 11 - ' 15 Wap Text F Merge SA 2 General $ . % 9 A. + It Out Clipboard Conditional Format CHI Home Styles Styles Tent M R2 du A B D F G 1 K 1 M N 0 P Techsolt in the past has outlined four major factors to evaluate suppliers. All the four suppliers have been ranked on a scale of 1 to 5, 5 being the best based on their performance in the past Leaders from Category A and Category have been surveyed to understand the importance of each of the factors for its customers. For Category A, the importance of each of the factors can be best outlined though a ratio of 1:12:2 whereas for 2 Category through 12:21 Tecture des from all the four aplies it tooking to reconstruction to one app Category Technotects the uncertainty insurely to be similar to the past performance even after the scale up of the cheese Techroexpects each of the supplies to have fulfillment target of Marine Flexit Maxeine Worldcomm Nanotech enotech Orderplaced by Tech for the material of Mase ine World Nanotech umentament uitment the the date the due dan 12 24 100 25 ION of Werdem hatch Factor 3 4 Quality the due to the fue date date 22 77 1 4 101N 5 1 5 4 4 4 4 4 79 25 25 25 75 3 17 14 97 LOON Week W W Web Week Weeks Week Week Weeks Week Week 10 Week 11 Week 12 25 26 7 25 74 M 22 to 100 104N 101N 72 78 10 IN 101N 25 13 75 5 104 104 24 6 Service 7 Delivery B 9 10 11 12 13 14 15 16 17 18 19 M 77 M 104 72 25 71 25 Production Service levels actor Warehouse Sales Shipping & Transportation Supplier information + o e C Type here to search Page Layout Formulas Data Review View Help Search Calibri X cut In Copy Format Painter Paste -AA == . 25 Wrap Text M.A. Merge & Center - General BIU. $ . % 849 Clipboard Condi Forma Font Alignment Number G20 fx A B C D F 1 Figure 2. First Quarter Sales Projections for 2019 2 Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) Category B (90%) 187 96 187 186 140 167 159 136 146 177 157 101 159 186 168 139 98 170 137 164 185 186 127 166.7 144.8 179 283 373 307 295 323 258 338 354 237 307 349 313 File Home Insert Draw Page Layout Formats Data Review Help Search Xul Copy - Format Calibri 13 Weaplex A. 3 Merge Center Chboard $ - % Confort 29 o A22 C 1 Figure 3. Current Shipping and Transportation Costs for Vale Grape Card There is currently no import taillon Graphics Cards into the US from Singapore D Mume War Time Direction Asian Plant to Warehe Alan Warehouse to North America Air Expedited Asian Warehouse to North America Air Cargo Asian Warehouets North Amedea Domestic Houte press Domestic Route Party Domestic wote Ground Cost 0.01 65 15 Unit Card Per Card Per Card 30 PerCard Per Card 2 40 . Due to last minute finaleation of order quantities met cards are current Add to US import Tarif Second 4 Service level &z factor Sales Warehouse Production Supplier information Shipping & Transportation e - O Type here to search Home Insert Draw Page Layout Formulas Data Review View Paste 11 X cut In Copy Format Painter Clipboard Calibri - A 2 Wrap Te BIU...A. Merge & Font D20 Alignment D A 1 Figure 7. Warehousing costs including operations and handling B 2 3 4 Warehouse Facility 5 Area (SqM) Singapore, SG 15000 6 Monthly Operating Costs (Per SqM) 2.3 7 Handling Costs (S/per Item) 1.95 8 % of Warehouse Dedicated to Vision Card 35% 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Supplier information Sales Shipping & Transportation Warehouse Production Ready Hi Type here to search 21 e Data Review View Calibri Paste - 11 X Cut [Copy Format Painter Clipboard == BIU. A a A 2 Wrap Te Merge & Font K20 *** Alignment fx A B 1 C D E F G Service Level 85.00% 86.00% 87.00% 88.00% 89.00% 90.00% 91.00% 92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 99.50% 99.60% 99.70% 99.80% 99.90% 99.99% Service Factor (z) 1.04 1.08 1.13 1.17 1.23 1.28 1.34 1.41 1.48 1.55 1.64 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 1.75 1.88 2.05 2.33 2.58 2.65 2.75 2.88 3.09 3.72 Supplier information Sales Shipping & Transportation Warehouse Production Ready Type here to search e Customer Survey 2018 Result Supplier information Sales Shipping & Tr Figure I. Customer Surwy Data Based on the recent survey of all of its 200 customers, Techsoft Sales team has prepared the following report: Currently Techsoft has an exceptionally high customer service level of 98%, much higher than any of its competitors. Customers showed positive response towards a possible lower but acceptable service level. Results of the survey showed 45 of the customers would be serviced at 90% (classified heroen as Category B) and the rest would have to be serviced at 95% (Category A). Ses Categwy BOON No Category 1 Category B Category A (95%) 153 14 2 1 200 Question What is your order lead time? Customers willing to submit freeze orders 6 weeks before receipt Customers willing to submit freeze orders 4 weeks before receipt Customers willing to submit/freeze your orders 2 weeks before you receive them! 152 42 3 200 50 42 105 3 200 Customer Survey 2018 Result Supplier information S Figure 3. Supplier related information Figure 4. Supplier Techsoft in the past has outlined four major factors to evaluate its suppliers. All the four suppliers have been ranked (on a scale of 1 to 5,5 being the best) based on their performance in the past. Leaders from Techsoft currently Category A and Category B have been surveyed to understand the expects the uncerta importance of each of the factors for its customers. For Category A, the to have a fulfillmei importance of each of the factors can be best outlined through a ratio of 1:1:2:2 whereas for Category B through 1:2:2:1. Factor Flexit Maxo Inc Worldcomm Nanotech Week To Quality Price Service Delivery 5 3 5 4 3 4 4 3 5 5 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 vey 2018 Result Supplier information Pipare & Supplier antalety related information Sales Shipping & Transportation War Techsoft currently onders ww materials from all the four suppliers. It is looking to see the expects the uncertainty in apply to be similar to the past performance caller to have a fulfillment target of into one appli per Category Techo edhesenli Techsoll expects each of the suppliers Werk Flest Mare Inc fulfillment fulfillment sill the destill the de Fulfillment Fulfillment. Fulfillment Masal World of Nanotect 90 1015 WE 25 74 77 74 75 w Order placed by Techielt for the materials 75 75 75 75 75 75 75 75 75 75 75 75 100% 100% 100% WORS Week 6 Wok? Ws TOUS 77 75 72 78 78 75 100% 1019 74 74 78 76 14 78 72 14 100 Work 10 We Werk TO 996 TO 75 71 55 95 TO TO To Door Customer Survey 2018 Result Supplier information Sa Figure 2. First Owarter Sales Projections for 2019 Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week Weck ! Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) Category 8 (90%) 187 96 187 186 140 167 159 136 146 177 157 101 179 159 186 168 139 98 170 137 164 185 186 127 166.7 144.8 283 373 307 295 323 258 338 354 237 307 349 313 Sales Shippir Customer Survey 2018 Result Supplier information Figure. Current Shipping and Transportation Costs for Vision Graphics Card There is currently no import tarriffon Graphics Cards into the US from Singapore Time Cest 0.01 2 Days 5 days Direction Asian Plant to Warehouse Asian Warehouse to North America Air Expedited Asian Warehouse to North America Air Cargo Asian Warehouse to North America - Sea Domestic Route - Express Domestie Route Fiority Domestie Route - Ground 2.19 Per Card Per Card Per Card Per Card | Per Card Per Card 4.35 4 Days Dus Due to last minute finalization of order quantities most cards are currently sent via Air Expedited to North America Simon Twitter Searchewwwporn.com impende Warehouse upplier information Sales Shipping & Transportation Figure 6. Map of Sheping Rates from Singapore Washes 2-day Singapore Customer Survey 2018 Result Supplier inte Figure 7. Warehousing costs including operations and handling Warehouse Facility Area (SqM) Monthly Operating Costs (Per SqM) Handling Costs (S/per Item) % of Warehouse Dedicated to Vision Card Singapore, SG 15000 2.3 1.95 35% Customer Survey 2018 Result Supplier information Service Factor (2) 1.04 1.08 1.13 1.17 1.23 1.28 1.34 Service Level 85.00% 86.00% 87.00% 88.00% 89.00% 90.00% 91.00% 92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 99.50% 99.60% 99.70% 99.80% 99.90% 99.99% 1.48 1.55 1.64 1.75 1.88 2.05 2.33 2.58 2.63 2.75 2.88 3.09 3.72 AutoSave Tem Project 1 (1) - Fle Home Insert Draw Page Layout Formulas Data View Help Search Share X out Copy - Paste Format Painter - 11 - ' 15 Wap Text F Merge SA 2 General $ . % 9 A. + It Out Clipboard Conditional Format CHI Home Styles Styles Tent M R2 du A B D F G 1 K 1 M N 0 P Techsolt in the past has outlined four major factors to evaluate suppliers. All the four suppliers have been ranked on a scale of 1 to 5, 5 being the best based on their performance in the past Leaders from Category A and Category have been surveyed to understand the importance of each of the factors for its customers. For Category A, the importance of each of the factors can be best outlined though a ratio of 1:12:2 whereas for 2 Category through 12:21 Tecture des from all the four aplies it tooking to reconstruction to one app Category Technotects the uncertainty insurely to be similar to the past performance even after the scale up of the cheese Techroexpects each of the supplies to have fulfillment target of Marine Flexit Maxeine Worldcomm Nanotech enotech Orderplaced by Tech for the material of Mase ine World Nanotech umentament uitment the the date the due dan 12 24 100 25 ION of Werdem hatch Factor 3 4 Quality the due to the fue date date 22 77 1 4 101N 5 1 5 4 4 4 4 4 79 25 25 25 75 3 17 14 97 LOON Week W W Web Week Weeks Week Week Weeks Week Week 10 Week 11 Week 12 25 26 7 25 74 M 22 to 100 104N 101N 72 78 10 IN 101N 25 13 75 5 104 104 24 6 Service 7 Delivery B 9 10 11 12 13 14 15 16 17 18 19 M 77 M 104 72 25 71 25 Production Service levels actor Warehouse Sales Shipping & Transportation Supplier information + o e C Type here to search Page Layout Formulas Data Review View Help Search Calibri X cut In Copy Format Painter Paste -AA == . 25 Wrap Text M.A. Merge & Center - General BIU. $ . % 849 Clipboard Condi Forma Font Alignment Number G20 fx A B C D F 1 Figure 2. First Quarter Sales Projections for 2019 2 Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) Category B (90%) 187 96 187 186 140 167 159 136 146 177 157 101 159 186 168 139 98 170 137 164 185 186 127 166.7 144.8 179 283 373 307 295 323 258 338 354 237 307 349 313 File Home Insert Draw Page Layout Formats Data Review Help Search Xul Copy - Format Calibri 13 Weaplex A. 3 Merge Center Chboard $ - % Confort 29 o A22 C 1 Figure 3. Current Shipping and Transportation Costs for Vale Grape Card There is currently no import taillon Graphics Cards into the US from Singapore D Mume War Time Direction Asian Plant to Warehe Alan Warehouse to North America Air Expedited Asian Warehouse to North America Air Cargo Asian Warehouets North Amedea Domestic Houte press Domestic Route Party Domestic wote Ground Cost 0.01 65 15 Unit Card Per Card Per Card 30 PerCard Per Card 2 40 . Due to last minute finaleation of order quantities met cards are current Add to US import Tarif Second 4 Service level &z factor Sales Warehouse Production Supplier information Shipping & Transportation e - O Type here to search Home Insert Draw Page Layout Formulas Data Review View Paste 11 X cut In Copy Format Painter Clipboard Calibri - A 2 Wrap Te BIU...A. Merge & Font D20 Alignment D A 1 Figure 7. Warehousing costs including operations and handling B 2 3 4 Warehouse Facility 5 Area (SqM) Singapore, SG 15000 6 Monthly Operating Costs (Per SqM) 2.3 7 Handling Costs (S/per Item) 1.95 8 % of Warehouse Dedicated to Vision Card 35% 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Supplier information Sales Shipping & Transportation Warehouse Production Ready Hi Type here to search 21 e Data Review View Calibri Paste - 11 X Cut [Copy Format Painter Clipboard == BIU. A a A 2 Wrap Te Merge & Font K20 *** Alignment fx A B 1 C D E F G Service Level 85.00% 86.00% 87.00% 88.00% 89.00% 90.00% 91.00% 92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 99.50% 99.60% 99.70% 99.80% 99.90% 99.99% Service Factor (z) 1.04 1.08 1.13 1.17 1.23 1.28 1.34 1.41 1.48 1.55 1.64 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 1.75 1.88 2.05 2.33 2.58 2.65 2.75 2.88 3.09 3.72 Supplier information Sales Shipping & Transportation Warehouse Production Ready Type here to search e Customer Survey 2018 Result Supplier information Sales Shipping & Tr Figure I. Customer Surwy Data Based on the recent survey of all of its 200 customers, Techsoft Sales team has prepared the following report: Currently Techsoft has an exceptionally high customer service level of 98%, much higher than any of its competitors. Customers showed positive response towards a possible lower but acceptable service level. Results of the survey showed 45 of the customers would be serviced at 90% (classified heroen as Category B) and the rest would have to be serviced at 95% (Category A). Ses Categwy BOON No Category 1 Category B Category A (95%) 153 14 2 1 200 Question What is your order lead time? Customers willing to submit freeze orders 6 weeks before receipt Customers willing to submit freeze orders 4 weeks before receipt Customers willing to submit/freeze your orders 2 weeks before you receive them! 152 42 3 200 50 42 105 3 200 Customer Survey 2018 Result Supplier information S Figure 3. Supplier related information Figure 4. Supplier Techsoft in the past has outlined four major factors to evaluate its suppliers. All the four suppliers have been ranked (on a scale of 1 to 5,5 being the best) based on their performance in the past. Leaders from Techsoft currently Category A and Category B have been surveyed to understand the expects the uncerta importance of each of the factors for its customers. For Category A, the to have a fulfillmei importance of each of the factors can be best outlined through a ratio of 1:1:2:2 whereas for Category B through 1:2:2:1. Factor Flexit Maxo Inc Worldcomm Nanotech Week To Quality Price Service Delivery 5 3 5 4 3 4 4 3 5 5 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 vey 2018 Result Supplier information Pipare & Supplier antalety related information Sales Shipping & Transportation War Techsoft currently onders ww materials from all the four suppliers. It is looking to see the expects the uncertainty in apply to be similar to the past performance caller to have a fulfillment target of into one appli per Category Techo edhesenli Techsoll expects each of the suppliers Werk Flest Mare Inc fulfillment fulfillment sill the destill the de Fulfillment Fulfillment. Fulfillment Masal World of Nanotect 90 1015 WE 25 74 77 74 75 w Order placed by Techielt for the materials 75 75 75 75 75 75 75 75 75 75 75 75 100% 100% 100% WORS Week 6 Wok? Ws TOUS 77 75 72 78 78 75 100% 1019 74 74 78 76 14 78 72 14 100 Work 10 We Werk TO 996 TO 75 71 55 95 TO TO To Door Customer Survey 2018 Result Supplier information Sa Figure 2. First Owarter Sales Projections for 2019 Below is the historical 1st quarter sales for the past year. The future demand is expected to follow the same pattern Week Weck ! Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Actual Graphics Cards Sales Category A (95%) Category 8 (90%) 187 96 187 186 140 167 159 136 146 177 157 101 179 159 186 168 139 98 170 137 164 185 186 127 166.7 144.8 283 373 307 295 323 258 338 354 237 307 349 313 Sales Shippir Customer Survey 2018 Result Supplier information Figure. Current Shipping and Transportation Costs for Vision Graphics Card There is currently no import tarriffon Graphics Cards into the US from Singapore Time Cest 0.01 2 Days 5 days Direction Asian Plant to Warehouse Asian Warehouse to North America Air Expedited Asian Warehouse to North America Air Cargo Asian Warehouse to North America - Sea Domestic Route - Express Domestie Route Fiority Domestie Route - Ground 2.19 Per Card Per Card Per Card Per Card | Per Card Per Card 4.35 4 Days Dus Due to last minute finalization of order quantities most cards are currently sent via Air Expedited to North America Simon Twitter Searchewwwporn.com impende Warehouse upplier information Sales Shipping & Transportation Figure 6. Map of Sheping Rates from Singapore Washes 2-day Singapore Customer Survey 2018 Result Supplier inte Figure 7. Warehousing costs including operations and handling Warehouse Facility Area (SqM) Monthly Operating Costs (Per SqM) Handling Costs (S/per Item) % of Warehouse Dedicated to Vision Card Singapore, SG 15000 2.3 1.95 35% Customer Survey 2018 Result Supplier information Service Factor (2) 1.04 1.08 1.13 1.17 1.23 1.28 1.34 Service Level 85.00% 86.00% 87.00% 88.00% 89.00% 90.00% 91.00% 92.00% 93.00% 94.00% 95.00% 96.00% 97.00% 98.00% 99.00% 99.50% 99.60% 99.70% 99.80% 99.90% 99.99% 1.48 1.55 1.64 1.75 1.88 2.05 2.33 2.58 2.63 2.75 2.88 3.09 3.72
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
