8-12 PowerPoint slide. with min. of 150 words in notes sections per slide to explain each slide. PLEASE SEE INSTRUCTIONS ATTACHED.

dream86
  • a year ago
  • 45
files (4)

WeekFourPowerPointPresentationInstructionsAssignment5HM.docx

Assignment 5: Develop a Presentation

Top of Form

INSTRUCTIONS

· Using Assignment 3: Create the Supply Chain Dashboard with/ explanations in Wk 3 (Word doc and Excel doc. Please see attachments.)

· Complete Assignment 5: Develop a Presentation.

***PLEASE SEE THE EXAMPLE POWERPOINT SLIDE ATTACHED***

Instructions

The presentation should explain the details from your dashboard, Excel, and explanations of the dashboard to the VP of Supply Chain.

Requirements and guidelines:

· The presentation should consist of 8-12 PowerPoint slides in the body, with speaking notes on each slide.

· 150-word minimum added into the “Notes” area of each slide.

· A cover slide and list of references slide are required (not included in the required slide count).

· Slides Design

· 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.

· 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."

· Legible: use large enough fonts, colors should be high contrast for projectors (light text on dark background or dark text on light background).

· Simple background (other than white or black).

· Effective use of graphics, such as company logos, photos of products, etc.

· Effective use of animation — build slides to keep your audience focused on what you are saying.

Grading

This assignment is worth 12 points

RUBRIC

A screenshot of a computer AI-generated content may be incorrect.
Bottom of Form

A screenshot of a computer AI-generated content may be incorrect.

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/

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

U.S. Census Bureau. (2022). Population and Housing Unit Estimates Datasets. 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
Assignment3CreatetheSupplyChainDashboard.xlsx
This file is too large to display.View in new window