Transportation

Todd has personally delivered most of Rocket Science$$s sales using the family van. $($He does ship some small packages.$)$ Now that customers are reaching out to him from different states and countries, Todd has no idea how to fulfill these orders. Todd knows next to nothing about transportation and needs your recommendation on how to build a transportation strategy. Please help Todd by completing the following sections:

Create a transportation map showing how you plan to service each region, state, or demographic of the U$.$S$.$ You will have to segment your regions. Identify on the map which mode of transportation will service each region. Please provide a detailed explanation for your mode decisions.

Todd just got a call from a major retailer wanting to put his fireworks in$-$store. He is ecstatic! The retailer wants $120,000$ firework kits sent to their warehouse in Seattle Washington where they will distribute the kits to their stores. Todd needs your help in figuring out how to ship this order. Todd plans on shipping the whole order using full truckload service. Using the Spam Jam workshop case study as your guide, answer the following questions for Todd: $($Please note that the Firework Kit dimensions are stated in the intro section of this assignment.$)$

How many Firework Kits will fit on a pallet?

How many total pallets will be needed for the order?

What is the weight per pallet?

How many truckload shipments and what size are needed?

How many pallets legally fit on a $20\text{'}$ and $40\text{'}$ trailer from a weight standpoint?

Complete all work in an excel file and submit it with the rest of the assignment.

Submit your Rocket Science Part $5$ by including the following:

A total of $2$ files should be uploaded

A Doc with the map along with the note explanations

Excel file with the answers to TL questions. Please put all the answers to the questions in the file