Assignment Prompt & Instructions
– ## WeekFourPowerPointPresentationInstructionsAssignment5HM.docx
– ## EXAMPLEWeek4PowerPoint.pptm
– Week3AssigmentSupplyChainDashboardDescriptionsandTables.docx
– Assignment3CreatetheSupplyChainDashboard.xlsx
**## WeekFourPowerPointPresentationInstructionsAssignment5HM.docx**
Assignment 5: Develop a Presentation
Top of Form
| | |
| — | — |
| |
| INSTRUCTIONS | |
| · <br>**Using** Assignment 3: Create the Supply Chain Dashboard with/ explanations in Wk 3 (Word doc and Excel doc. Please see attachments.)<br> <br>· <br>**Complete Assignment 5: Develop a Presentation.**<br>***PLEASE SEE THE EXAMPLE POWERPOINT SLIDE ATTACHED***<br>**Instructions**<br>The presentation should explain the details from your dashboard, Excel, and explanations of the dashboard to the VP of Supply Chain.<br>Requirements and guidelines:<br>· The presentation should consist of 8-12 PowerPoint slides in the body, with speaking notes on each slide.<br>· 150-word minimum added into the “Notes” area of each slide.<br>· <br>**A cover slide and list of references slide are required (not included in the required slide count).**<br>· Slides Design<br>· What we want to avoid is our slides being too wordy. We want a limit of 3 to 5 bullet points per slide. We want only 3 to 6 words per bullet point. Ultimately, you are the expert in your presentation. We want the audience to pay attention to you — not read your slides.<br>· Okay, this is a tough one. You've got the right information…but ask yourself, "Hey, I'm an audience member, right? Would I dig looking at these financial statements on a slide during a presentation? Would this be too much information for one slide? Perhaps I should demonstrate (what I consider) the most important information from those statements."<br>· Legible: use large enough fonts, colors should be high contrast for projectors (light text on dark background or dark text on light background).<br>· Simple background (other than white or black).<br>· Effective use of graphics, such as company logos, photos of products, etc.<br>· Effective use of animation — build slides to keep your audience focused on what you are saying.<br>**Grading**<br>This assignment is worth 12 points<br>**RUBRIC** |
Bottom of Form
## image1.png
## image2.png
**## EXAMPLEWeek4PowerPoint.pptm**
Interpreting and Employing Data
PRESENTATION TITLE
1
Interpreting and Employing Data
2
Overview of ACME Corporation's challenge and product focus.
Executive Summary
Choice of:
Regional Distribution Centers (DC)
Centralized Fulfillment Center (FC)
As a leader in Voice Assistant IoT Add-on Boxes, ACME Corporation faces a soaring demand from manufacturers for smart appliances. This report examines their top product, the 1GB Voice Assistant IoT Box (SKU AB-1035-G). The South region dominates sales and has prompted decentralization into regional DCs. Centralized fulfillment in West Plains MO could help cut costs but would affect responsiveness to customer needs.
2
Introduction
Interpreting and Employing Data
3
Evaluation of the supply chain for voice assistant AB-1035-G.
Evaluates ACME Corporation's supply chain
Identify four regional distribution centers
Leverage U.S. Census Data
Identify centralized fulfillment center
This report evaluates ACME Corporation's supply chain for the AB-1035-G voice assistant. It will identify four regional distribution centers to enhance inventory decentralization using U.S. Census data from 2019 to 2022. The objective is to improve shipping efficiencies and respond to increasing demand while considering current manufacturing processes and the limitations of the ERP system.
3
Interpreting and Employing Data
4
Key assumptions made for the report.
Packaging Size
Shipping Crate Size
Shipping Cost
Assumptions
This report relies on several critical assumptions.
It assumes that the voice assistant SKU AB-1035-G dimensions are 8 inches in height, 6 inches in width, and 2 inches in depth.
Additionally, a quarter pallet crate is presumed to measure 24 inches by 20 inches by 42 inches, allowing nine packages per layer across twenty-one layers, amounting to 189 units maximum per crate. Lastly, it's anticipated that all customers—retailers and wholesalers alike—will bear the shipping costs from selected distribution centers or fulfillment centers.
4
Logistics – Purchasing
5
Voice assistant AB-1035-G has 19 orders with lead-times varying from 30 to 49 days and purchase order cost range of $77.69 to $111.84. Standardizing order quantities to EOQ and re-order points (ROPs) can reduce these costs.
In comparison of all SKUs in Tables 1 and 2 on this slide, it can be seen that voice assistant AB-1035-G has the longest total lead time and the second highest total order processing cost.
All SKUs had a total of 18 or 19 orders apiece.
5
Table 1: Total Lead-time by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 750 747 707 714 748 753
Table 2: Total Order Process Cost by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 1886.1205823618795 1821.6709146890175 1656.7215456399438 1773.1311295189794 1784.1833575711089 1830.4055626409879
| | | |
| — | — | — |
| REGION | TRANSPORT TYPE | ADVANTAGES |
| New York, NY | Truck LTL | New York/Newark port proximity |
| Chicago, IL | Intermodal (Rail + Truck LTL) | Central rail access |
| Atlanta, GA | Truck LTL | Near Savannah port |
| Los Angeles, CA | Truck LTL | Port city with shipping facilities |
Logistics – Transportation
6
Four regional DCs are proposed to enhance responsiveness: New York, NY; Chicago, IL; Atlanta, GA; and Los Angeles, CA. These locations align with regional demand and port connectivity.
6
Logistics – Transportation Cont.
7
| | |
| — | — |
| Distribution Center | City, State |
| Northeast Region | Philadelphia, PA |
| Midwest Region | Chicago, IL |
| South Region | Atlanta, GA |
| West Region | Los Angeles, CA |
| Centralized Fulfillment Center | West Plains, MO |
Four regional DCs are proposed to enhance responsiveness: New York, NY (Northeast), which has the New York/Newark port; Chicago, IL (Midwest), which has central rail access from Los Angeles, CA and Newark, NJ; Atlanta, GA (South), which is approximately 4 to 5 hours by truck to Savannah, GA; and Los Angeles, CA (West), which is its own port town.
These locations align with regional demand and port connectivity.
Table 3 gives their geographical coordinates which were used with their projected sales by regional population to determine the West Plains, MO location for a potential centralized fulfillment center.
7
| | | | |
| — | — | — | — |
| MODE | COST | SPEED | FLEXIBILITY |
| Truck | Medium | High | High |
| Rail | High | Medium | Low |
| Air | High | High | Medium |
| Water | High | Low | Low |
| Intermodal | Medium | Medium | Medium |
Comparison of Modes
8
Table 4 on this slide shows six potential shipping modes for a quarter pallet crate of voice assistant AB-1035-G.
Water offers low variable costs which are ideal for international bulk shipments, however, they are slow speed with the lowest flexibility.
If something were to go wrong with a trans-oceanic shipment, a high-cost air shipment could be sent paid for. In this case, due to higher inventory, the timeframe for the subsequent water shipment would be adjusted further out.
Truck LTL provides high speed and flexibility, perfect for domestic EOQ-sized orders.
Intermodal balances cost and speed for longer routes, while Air supports urgent needs despite high costs. Rail and Pipeline are impractical for small electronics.
8
Comparison of Modes Cont.
9
| | | | |
| — | — | — | — |
| Region | Distribution Center | Port of Entry (from Africa) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Newark, NJ | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
| Region | Distribution Center | Port of Entry (from Asia) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Los Angeles, CA | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
Table 5 outlines shipping modes from the closest POEs for Africa and Asia to each DC.
From Africa, Newark, NJ, serves Northeast and Midwest (via Intermodal to Chicago), Savannah, GA, serves South, and Long Beach, CA, serves West.
From Asia, Long Beach serves West and Midwest, Newark serves Northeast, and Savannah serves South.
Truck LTL is used for short routes (e.g., Long Beach to Los Angeles), leveraging high flexibility for half pallets matching EOQ. Intermodal (Water + Rail + Truck LTL) serves longer routes (e.g., Long Beach to Chicago), balancing cost and speed.
9
Sales by Region
10
Table 6 shows projected voice assistant AB-1035-G orders by region, with South leading, followed by West, Midwest, and Northeast.
In Table 7, sales mirror this order.
If Acme chooses the FC path, a demand-centric fulfillment center location, calculated using regional demands and DC coordinates would best fit in West Plains, MO.
10
Table 6: AB-1035-G Orders per Year by Region
Total
1 2 3 4 25 27 36 29
Table 7: AB-1035-G Sales Percentage by Region
Total
Northeast Region Midwest Region South Region West Region 1 2 3 4 0.17011287107567388 0.20762881501630429 0.36322587452158456 0.24066165537255396
Conclusion
Interpreting and Employing Data
11
Summary of findings and suggested actions.
Use Regional DCs
Do not use Centralized FC
Order Quarter Pallet Crates at EOQs
This report shows lead-time and cost variability for voice assistant SKU AB-1035-G.
It also shows projections of regional sales data with South leading demand (35%).
Regional DCs in New York, Chicago, Atlanta, and Los Angeles enhance responsiveness, and likely outperform a centralized FC in West Plains, MO, due to the proximity of the Ports of Entry.
This is based on retail and wholesale customers paying for shipping from either the regional DC’s or centralized FC.
In the case of regional DC’s, the highest cost is Chicago, since the other DCs are close to port.
However, all incoming shipments would have to go to the central FC before the customer, ultimately costing Acme more for national shipping.
Shipping in quarter pallet crate sizes for EOQs optimize logistics.
Recommendations include decentralizing DCs, automating order processing, and enhancing ERP with supplier data to meet customer needs.
11
References
Freight Rate. (2024, May 27). LTL dimensions and weight restrictions.
[https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/](https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/)
Hugos, M. (2018). Essentials of supply chain management. Wiley.
National University. (n.d.). Business case study recommendations Unpublished manuscript.
National University. (n.d.). M4 final project: Interpreting and employing data to build a business case – MGT608. Unpublished manuscript.
STU Supply Chain. (2022, November 23). List of major ports in US and port rankings.
[https://stusupplychain.com/major-ports-in-us.html](https://stusupplychain.com/major-ports-in-us.html)
U.S. Census Bureau. (2022). Population and Housing Unit Estimates Datasets.
[https://www.census.gov/programs-surveys/popest/data/data-sets.html](https://www.census.gov/programs-surveys/popest/data/data-sets.html)
12
12
## image1.jpeg
## image2.png
## image3.png
## image4.jpeg
## image5.jpeg
## image6.jpeg
## image7.png
## image8.svg
## image9.jpeg
**Week3AssigmentSupplyChainDashboardDescriptionsandTables.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week3assigmentsupplychaindashboarddescriptionsandtables-docx)
**Assignment3CreatetheSupplyChainDashboard.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/assignment3createthesupplychaindashboard-xlsx-10407191)
**Assignment3CreatetheSupplyChainDashboard.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/assignment3createthesupplychaindashboard-xlsx-10407191)
**## WeekFourPowerPointPresentationInstructionsAssignment5HM.docx**
Assignment 5: Develop a Presentation
Top of Form
| | |
| — | — |
| |
| INSTRUCTIONS | |
| · <br>**Using** Assignment 3: Create the Supply Chain Dashboard with/ explanations in Wk 3 (Word doc and Excel doc. Please see attachments.)<br> <br>· <br>**Complete Assignment 5: Develop a Presentation.**<br>***PLEASE SEE THE EXAMPLE POWERPOINT SLIDE ATTACHED***<br>**Instructions**<br>The presentation should explain the details from your dashboard, Excel, and explanations of the dashboard to the VP of Supply Chain.<br>Requirements and guidelines:<br>· The presentation should consist of 8-12 PowerPoint slides in the body, with speaking notes on each slide.<br>· 150-word minimum added into the “Notes” area of each slide.<br>· <br>**A cover slide and list of references slide are required (not included in the required slide count).**<br>· Slides Design<br>· What we want to avoid is our slides being too wordy. We want a limit of 3 to 5 bullet points per slide. We want only 3 to 6 words per bullet point. Ultimately, you are the expert in your presentation. We want the audience to pay attention to you — not read your slides.<br>· Okay, this is a tough one. You've got the right information…but ask yourself, "Hey, I'm an audience member, right? Would I dig looking at these financial statements on a slide during a presentation? Would this be too much information for one slide? Perhaps I should demonstrate (what I consider) the most important information from those statements."<br>· Legible: use large enough fonts, colors should be high contrast for projectors (light text on dark background or dark text on light background).<br>· Simple background (other than white or black).<br>· Effective use of graphics, such as company logos, photos of products, etc.<br>· Effective use of animation — build slides to keep your audience focused on what you are saying.<br>**Grading**<br>This assignment is worth 12 points<br>**RUBRIC** |
Bottom of Form
## image1.png
## image2.png
**## EXAMPLEWeek4PowerPoint.pptm**
Interpreting and Employing Data
PRESENTATION TITLE
1
Interpreting and Employing Data
2
Overview of ACME Corporation's challenge and product focus.
Executive Summary
Choice of:
Regional Distribution Centers (DC)
Centralized Fulfillment Center (FC)
As a leader in Voice Assistant IoT Add-on Boxes, ACME Corporation faces a soaring demand from manufacturers for smart appliances. This report examines their top product, the 1GB Voice Assistant IoT Box (SKU AB-1035-G). The South region dominates sales and has prompted decentralization into regional DCs. Centralized fulfillment in West Plains MO could help cut costs but would affect responsiveness to customer needs.
2
Introduction
Interpreting and Employing Data
3
Evaluation of the supply chain for voice assistant AB-1035-G.
Evaluates ACME Corporation's supply chain
Identify four regional distribution centers
Leverage U.S. Census Data
Identify centralized fulfillment center
This report evaluates ACME Corporation's supply chain for the AB-1035-G voice assistant. It will identify four regional distribution centers to enhance inventory decentralization using U.S. Census data from 2019 to 2022. The objective is to improve shipping efficiencies and respond to increasing demand while considering current manufacturing processes and the limitations of the ERP system.
3
Interpreting and Employing Data
4
Key assumptions made for the report.
Packaging Size
Shipping Crate Size
Shipping Cost
Assumptions
This report relies on several critical assumptions.
It assumes that the voice assistant SKU AB-1035-G dimensions are 8 inches in height, 6 inches in width, and 2 inches in depth.
Additionally, a quarter pallet crate is presumed to measure 24 inches by 20 inches by 42 inches, allowing nine packages per layer across twenty-one layers, amounting to 189 units maximum per crate. Lastly, it's anticipated that all customers—retailers and wholesalers alike—will bear the shipping costs from selected distribution centers or fulfillment centers.
4
Logistics – Purchasing
5
Voice assistant AB-1035-G has 19 orders with lead-times varying from 30 to 49 days and purchase order cost range of $77.69 to $111.84. Standardizing order quantities to EOQ and re-order points (ROPs) can reduce these costs.
In comparison of all SKUs in Tables 1 and 2 on this slide, it can be seen that voice assistant AB-1035-G has the longest total lead time and the second highest total order processing cost.
All SKUs had a total of 18 or 19 orders apiece.
5
Table 1: Total Lead-time by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 750 747 707 714 748 753
Table 2: Total Order Process Cost by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 1886.1205823618795 1821.6709146890175 1656.7215456399438 1773.1311295189794 1784.1833575711089 1830.4055626409879
| | | |
| — | — | — |
| REGION | TRANSPORT TYPE | ADVANTAGES |
| New York, NY | Truck LTL | New York/Newark port proximity |
| Chicago, IL | Intermodal (Rail + Truck LTL) | Central rail access |
| Atlanta, GA | Truck LTL | Near Savannah port |
| Los Angeles, CA | Truck LTL | Port city with shipping facilities |
Logistics – Transportation
6
Four regional DCs are proposed to enhance responsiveness: New York, NY; Chicago, IL; Atlanta, GA; and Los Angeles, CA. These locations align with regional demand and port connectivity.
6
Logistics – Transportation Cont.
7
| | |
| — | — |
| Distribution Center | City, State |
| Northeast Region | Philadelphia, PA |
| Midwest Region | Chicago, IL |
| South Region | Atlanta, GA |
| West Region | Los Angeles, CA |
| Centralized Fulfillment Center | West Plains, MO |
Four regional DCs are proposed to enhance responsiveness: New York, NY (Northeast), which has the New York/Newark port; Chicago, IL (Midwest), which has central rail access from Los Angeles, CA and Newark, NJ; Atlanta, GA (South), which is approximately 4 to 5 hours by truck to Savannah, GA; and Los Angeles, CA (West), which is its own port town.
These locations align with regional demand and port connectivity.
Table 3 gives their geographical coordinates which were used with their projected sales by regional population to determine the West Plains, MO location for a potential centralized fulfillment center.
7
| | | | |
| — | — | — | — |
| MODE | COST | SPEED | FLEXIBILITY |
| Truck | Medium | High | High |
| Rail | High | Medium | Low |
| Air | High | High | Medium |
| Water | High | Low | Low |
| Intermodal | Medium | Medium | Medium |
Comparison of Modes
8
Table 4 on this slide shows six potential shipping modes for a quarter pallet crate of voice assistant AB-1035-G.
Water offers low variable costs which are ideal for international bulk shipments, however, they are slow speed with the lowest flexibility.
If something were to go wrong with a trans-oceanic shipment, a high-cost air shipment could be sent paid for. In this case, due to higher inventory, the timeframe for the subsequent water shipment would be adjusted further out.
Truck LTL provides high speed and flexibility, perfect for domestic EOQ-sized orders.
Intermodal balances cost and speed for longer routes, while Air supports urgent needs despite high costs. Rail and Pipeline are impractical for small electronics.
8
Comparison of Modes Cont.
9
| | | | |
| — | — | — | — |
| Region | Distribution Center | Port of Entry (from Africa) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Newark, NJ | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
| Region | Distribution Center | Port of Entry (from Asia) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Los Angeles, CA | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
Table 5 outlines shipping modes from the closest POEs for Africa and Asia to each DC.
From Africa, Newark, NJ, serves Northeast and Midwest (via Intermodal to Chicago), Savannah, GA, serves South, and Long Beach, CA, serves West.
From Asia, Long Beach serves West and Midwest, Newark serves Northeast, and Savannah serves South.
Truck LTL is used for short routes (e.g., Long Beach to Los Angeles), leveraging high flexibility for half pallets matching EOQ. Intermodal (Water + Rail + Truck LTL) serves longer routes (e.g., Long Beach to Chicago), balancing cost and speed.
9
Sales by Region
10
Table 6 shows projected voice assistant AB-1035-G orders by region, with South leading, followed by West, Midwest, and Northeast.
In Table 7, sales mirror this order.
If Acme chooses the FC path, a demand-centric fulfillment center location, calculated using regional demands and DC coordinates would best fit in West Plains, MO.
10
Table 6: AB-1035-G Orders per Year by Region
Total
1 2 3 4 25 27 36 29
Table 7: AB-1035-G Sales Percentage by Region
Total
Northeast Region Midwest Region South Region West Region 1 2 3 4 0.17011287107567388 0.20762881501630429 0.36322587452158456 0.24066165537255396
Conclusion
Interpreting and Employing Data
11
Summary of findings and suggested actions.
Use Regional DCs
Do not use Centralized FC
Order Quarter Pallet Crates at EOQs
This report shows lead-time and cost variability for voice assistant SKU AB-1035-G.
It also shows projections of regional sales data with South leading demand (35%).
Regional DCs in New York, Chicago, Atlanta, and Los Angeles enhance responsiveness, and likely outperform a centralized FC in West Plains, MO, due to the proximity of the Ports of Entry.
This is based on retail and wholesale customers paying for shipping from either the regional DC’s or centralized FC.
In the case of regional DC’s, the highest cost is Chicago, since the other DCs are close to port.
However, all incoming shipments would have to go to the central FC before the customer, ultimately costing Acme more for national shipping.
Shipping in quarter pallet crate sizes for EOQs optimize logistics.
Recommendations include decentralizing DCs, automating order processing, and enhancing ERP with supplier data to meet customer needs.
11
References
Freight Rate. (2024, May 27). LTL dimensions and weight restrictions.
[https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/](https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/)
Hugos, M. (2018). Essentials of supply chain management. Wiley.
National University. (n.d.). Business case study recommendations Unpublished manuscript.
National University. (n.d.). M4 final project: Interpreting and employing data to build a business case – MGT608. Unpublished manuscript.
STU Supply Chain. (2022, November 23). List of major ports in US and port rankings.
[https://stusupplychain.com/major-ports-in-us.html](https://stusupplychain.com/major-ports-in-us.html)
U.S. Census Bureau. (2022). Population and Housing Unit Estimates Datasets.
[https://www.census.gov/programs-surveys/popest/data/data-sets.html](https://www.census.gov/programs-surveys/popest/data/data-sets.html)
12
12
## image1.jpeg
## image2.png
## image3.png
## image4.jpeg
## image5.jpeg
## image6.jpeg
## image7.png
## image8.svg
## image9.jpeg
**Week3AssigmentSupplyChainDashboardDescriptionsandTables.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week3assigmentsupplychaindashboarddescriptionsandtables-docx)
**Assignment3CreatetheSupplyChainDashboard.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/assignment3createthesupplychaindashboard-xlsx-10407191)
**## WeekFourPowerPointPresentationInstructionsAssignment5HM.docx**
Assignment 5: Develop a Presentation
Top of Form
| | |
| — | — |
| |
| INSTRUCTIONS | |
| · <br>**Using** Assignment 3: Create the Supply Chain Dashboard with/ explanations in Wk 3 (Word doc and Excel doc. Please see attachments.)<br> <br>· <br>**Complete Assignment 5: Develop a Presentation.**<br>***PLEASE SEE THE EXAMPLE POWERPOINT SLIDE ATTACHED***<br>**Instructions**<br>The presentation should explain the details from your dashboard, Excel, and explanations of the dashboard to the VP of Supply Chain.<br>Requirements and guidelines:<br>· The presentation should consist of 8-12 PowerPoint slides in the body, with speaking notes on each slide.<br>· 150-word minimum added into the “Notes” area of each slide.<br>· <br>**A cover slide and list of references slide are required (not included in the required slide count).**<br>· Slides Design<br>· What we want to avoid is our slides being too wordy. We want a limit of 3 to 5 bullet points per slide. We want only 3 to 6 words per bullet point. Ultimately, you are the expert in your presentation. We want the audience to pay attention to you — not read your slides.<br>· Okay, this is a tough one. You've got the right information…but ask yourself, "Hey, I'm an audience member, right? Would I dig looking at these financial statements on a slide during a presentation? Would this be too much information for one slide? Perhaps I should demonstrate (what I consider) the most important information from those statements."<br>· Legible: use large enough fonts, colors should be high contrast for projectors (light text on dark background or dark text on light background).<br>· Simple background (other than white or black).<br>· Effective use of graphics, such as company logos, photos of products, etc.<br>· Effective use of animation — build slides to keep your audience focused on what you are saying.<br>**Grading**<br>This assignment is worth 12 points<br>**RUBRIC** |
Bottom of Form
## image1.png
## image2.png
**## EXAMPLEWeek4PowerPoint.pptm**
Interpreting and Employing Data
PRESENTATION TITLE
1
Interpreting and Employing Data
2
Overview of ACME Corporation's challenge and product focus.
Executive Summary
Choice of:
Regional Distribution Centers (DC)
Centralized Fulfillment Center (FC)
As a leader in Voice Assistant IoT Add-on Boxes, ACME Corporation faces a soaring demand from manufacturers for smart appliances. This report examines their top product, the 1GB Voice Assistant IoT Box (SKU AB-1035-G). The South region dominates sales and has prompted decentralization into regional DCs. Centralized fulfillment in West Plains MO could help cut costs but would affect responsiveness to customer needs.
2
Introduction
Interpreting and Employing Data
3
Evaluation of the supply chain for voice assistant AB-1035-G.
Evaluates ACME Corporation's supply chain
Identify four regional distribution centers
Leverage U.S. Census Data
Identify centralized fulfillment center
This report evaluates ACME Corporation's supply chain for the AB-1035-G voice assistant. It will identify four regional distribution centers to enhance inventory decentralization using U.S. Census data from 2019 to 2022. The objective is to improve shipping efficiencies and respond to increasing demand while considering current manufacturing processes and the limitations of the ERP system.
3
Interpreting and Employing Data
4
Key assumptions made for the report.
Packaging Size
Shipping Crate Size
Shipping Cost
Assumptions
This report relies on several critical assumptions.
It assumes that the voice assistant SKU AB-1035-G dimensions are 8 inches in height, 6 inches in width, and 2 inches in depth.
Additionally, a quarter pallet crate is presumed to measure 24 inches by 20 inches by 42 inches, allowing nine packages per layer across twenty-one layers, amounting to 189 units maximum per crate. Lastly, it's anticipated that all customers—retailers and wholesalers alike—will bear the shipping costs from selected distribution centers or fulfillment centers.
4
Logistics – Purchasing
5
Voice assistant AB-1035-G has 19 orders with lead-times varying from 30 to 49 days and purchase order cost range of $77.69 to $111.84. Standardizing order quantities to EOQ and re-order points (ROPs) can reduce these costs.
In comparison of all SKUs in Tables 1 and 2 on this slide, it can be seen that voice assistant AB-1035-G has the longest total lead time and the second highest total order processing cost.
All SKUs had a total of 18 or 19 orders apiece.
5
Table 1: Total Lead-time by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 750 747 707 714 748 753
Table 2: Total Order Process Cost by SKU
Total 84325322 123-456789 13-23423 14-34222 654-2-34 AB-1035-G 1886.1205823618795 1821.6709146890175 1656.7215456399438 1773.1311295189794 1784.1833575711089 1830.4055626409879
| | | |
| — | — | — |
| REGION | TRANSPORT TYPE | ADVANTAGES |
| New York, NY | Truck LTL | New York/Newark port proximity |
| Chicago, IL | Intermodal (Rail + Truck LTL) | Central rail access |
| Atlanta, GA | Truck LTL | Near Savannah port |
| Los Angeles, CA | Truck LTL | Port city with shipping facilities |
Logistics – Transportation
6
Four regional DCs are proposed to enhance responsiveness: New York, NY; Chicago, IL; Atlanta, GA; and Los Angeles, CA. These locations align with regional demand and port connectivity.
6
Logistics – Transportation Cont.
7
| | |
| — | — |
| Distribution Center | City, State |
| Northeast Region | Philadelphia, PA |
| Midwest Region | Chicago, IL |
| South Region | Atlanta, GA |
| West Region | Los Angeles, CA |
| Centralized Fulfillment Center | West Plains, MO |
Four regional DCs are proposed to enhance responsiveness: New York, NY (Northeast), which has the New York/Newark port; Chicago, IL (Midwest), which has central rail access from Los Angeles, CA and Newark, NJ; Atlanta, GA (South), which is approximately 4 to 5 hours by truck to Savannah, GA; and Los Angeles, CA (West), which is its own port town.
These locations align with regional demand and port connectivity.
Table 3 gives their geographical coordinates which were used with their projected sales by regional population to determine the West Plains, MO location for a potential centralized fulfillment center.
7
| | | | |
| — | — | — | — |
| MODE | COST | SPEED | FLEXIBILITY |
| Truck | Medium | High | High |
| Rail | High | Medium | Low |
| Air | High | High | Medium |
| Water | High | Low | Low |
| Intermodal | Medium | Medium | Medium |
Comparison of Modes
8
Table 4 on this slide shows six potential shipping modes for a quarter pallet crate of voice assistant AB-1035-G.
Water offers low variable costs which are ideal for international bulk shipments, however, they are slow speed with the lowest flexibility.
If something were to go wrong with a trans-oceanic shipment, a high-cost air shipment could be sent paid for. In this case, due to higher inventory, the timeframe for the subsequent water shipment would be adjusted further out.
Truck LTL provides high speed and flexibility, perfect for domestic EOQ-sized orders.
Intermodal balances cost and speed for longer routes, while Air supports urgent needs despite high costs. Rail and Pipeline are impractical for small electronics.
8
Comparison of Modes Cont.
9
| | | | |
| — | — | — | — |
| Region | Distribution Center | Port of Entry (from Africa) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Newark, NJ | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
| Region | Distribution Center | Port of Entry (from Asia) | Mode from POE to DC |
| Northeast Region | Philadelphia, PA | Newark, NJ | Truck LTL |
| Midwest Region | Chicago, IL | Los Angeles, CA | Intermodal (Rail + Truck LTL) |
| South Region | Atlanta, GA | Savannah, GA | Truck LTL |
| West Region | Los Angeles, CA | Los Angeles, CA | Truck LTL |
Table 5 outlines shipping modes from the closest POEs for Africa and Asia to each DC.
From Africa, Newark, NJ, serves Northeast and Midwest (via Intermodal to Chicago), Savannah, GA, serves South, and Long Beach, CA, serves West.
From Asia, Long Beach serves West and Midwest, Newark serves Northeast, and Savannah serves South.
Truck LTL is used for short routes (e.g., Long Beach to Los Angeles), leveraging high flexibility for half pallets matching EOQ. Intermodal (Water + Rail + Truck LTL) serves longer routes (e.g., Long Beach to Chicago), balancing cost and speed.
9
Sales by Region
10
Table 6 shows projected voice assistant AB-1035-G orders by region, with South leading, followed by West, Midwest, and Northeast.
In Table 7, sales mirror this order.
If Acme chooses the FC path, a demand-centric fulfillment center location, calculated using regional demands and DC coordinates would best fit in West Plains, MO.
10
Table 6: AB-1035-G Orders per Year by Region
Total
1 2 3 4 25 27 36 29
Table 7: AB-1035-G Sales Percentage by Region
Total
Northeast Region Midwest Region South Region West Region 1 2 3 4 0.17011287107567388 0.20762881501630429 0.36322587452158456 0.24066165537255396
Conclusion
Interpreting and Employing Data
11
Summary of findings and suggested actions.
Use Regional DCs
Do not use Centralized FC
Order Quarter Pallet Crates at EOQs
This report shows lead-time and cost variability for voice assistant SKU AB-1035-G.
It also shows projections of regional sales data with South leading demand (35%).
Regional DCs in New York, Chicago, Atlanta, and Los Angeles enhance responsiveness, and likely outperform a centralized FC in West Plains, MO, due to the proximity of the Ports of Entry.
This is based on retail and wholesale customers paying for shipping from either the regional DC’s or centralized FC.
In the case of regional DC’s, the highest cost is Chicago, since the other DCs are close to port.
However, all incoming shipments would have to go to the central FC before the customer, ultimately costing Acme more for national shipping.
Shipping in quarter pallet crate sizes for EOQs optimize logistics.
Recommendations include decentralizing DCs, automating order processing, and enhancing ERP with supplier data to meet customer needs.
11
References
Freight Rate. (2024, May 27). LTL dimensions and weight restrictions.
[https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/](https://freightrate.com/blog/ltl-dimensions-and-weight-restrictions/)
Hugos, M. (2018). Essentials of supply chain management. Wiley.
National University. (n.d.). Business case study recommendations Unpublished manuscript.
National University. (n.d.). M4 final project: Interpreting and employing data to build a business case – MGT608. Unpublished manuscript.
STU Supply Chain. (2022, November 23). List of major ports in US and port rankings.
[https://stusupplychain.com/major-ports-in-us.html](https://stusupplychain.com/major-ports-in-us.html)
U.S. Census Bureau. (2022). Population and Housing Unit Estimates Datasets.
[https://www.census.gov/programs-surveys/popest/data/data-sets.html](https://www.census.gov/programs-surveys/popest/data/data-sets.html)
12
12
## image1.jpeg
## image2.png
## image3.png
## image4.jpeg
## image5.jpeg
## image6.jpeg
## image7.png
## image8.svg
## image9.jpeg
**Week3AssigmentSupplyChainDashboardDescriptionsandTables.docx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/week3assigmentsupplychaindashboarddescriptionsandtables-docx)
**Assignment3CreatetheSupplyChainDashboard.xlsx**
This file is too large to display. [View in new window](https://www.sweetstudy.com/files/assignment3createthesupplychaindashboard-xlsx-10407191)
– 1
– 2
– 3
– 4