Question: Please explain your process for this load planning using Excel Find out weight of each customer shipments by number of pallets x weight of the

Please explain your process for this load planning using Excel

Please explain your process for this load

Find out weight of each customer shipments by number of pallets x weight of the pallet. Then sum the weight for each day. After that figure out which one you can do TL for by determining which load is under 35,000 lbs limit. Decide whether it is cheaper to do another TL load or do an LTL load for shipments that are over 35,000 lbs.

AICE Load Planning You are a transportation planner in Anderson Logistics Services; your manager has just handed you a customer shipments file with customer orders, you have to plan the loads to meet the customer required delivery dates (RDD). You are given information on the rates per 100 km for both TL and LTL in the different lanes, North, South, East and West. You are also provided with weight and capacity limitations of TL, there are no limitations on LTL. Shipments cannot be early or late. You are to analyze the customer orders and decide the optimum use of TL and LTL and provide your manager with the load plan for all trips and the total cost for the transportation of the customer orders. TL Rate LTL Rate per pallet/ per 100km Per 100km Destination Kms Hwy 2 North S 300.00 S 26.00 Edmonton 300 Hwy 2 South $ 350.00 $ 26.00 Lethbridge 200 Hwy 1 East 375.00 $ 23.00 Regina 750 $ $ Hwy 1 West 300.00 $ 20.00 Vancouver 1000 TL Drop-Off $ 100.00 per stop For TL you only get one free drop-off, so if you are shipping to more than 1 customer, the remaining customer drop-offs will cost $100 each TL Capacity 21 Pallets per TL Weight Capacity 35,000 lbs Pallets 6 11 8 6 6 10 4 8 2 4 6 2 4 4 8 6 4 8 6 Customer Destination 100074 Edmonton 100114 Edmonton 100143 Edmonton 100187 Edmonton 100049 Edmonton 100095 Edmonton 100139 Edmonton 100146 Edmonton 100032 Edmonton 100120 Edmonton 100178 Edmonton 100003 Edmonton 100064 Edmonton 100072 Edmonton 100126 Edmonton 100146 Edmonton 100147 Edmonton 100200 Edmonton 100029 Lethbridge 100034 Lethbridge 100197 Lethbridge 100131 Lethbridge 100196 Lethbridge 100133 Lethbridge 100001 Lethbridge 100058 Lethbridge 100076 Lethbridge 100189 Lethbridge 100106 Regina 100156 Regina 100161 Regina 100012 Regina 100146 Regina 100162 Regina 100168 Regina 100061 Regina 100065 Regina 100049 Regina 100178 Regina 100017 Vancouver 100040 Vancouver 100052 Vancouver 100116 Vancouver 100166 Vancouver 100176 Vancouver 100046 Vancouver 100127 Vancouver 100156 Vancouver 100053 Vancouver 100159 Vancouver 100177 Vancouver 100198 Vancouver 100124 Vancouver 100003 Vancouver 100007 Vancouver 100039 Vancouver 100166 Vancouver 11 6 10 4 6 8 4 10 6 2 8 Average Required Weight per Delivery Date Pallet (lbs (RDD) 1 2533 2020-11-18 2190 2020-11-18 1141 2020-11-18 1876 2020-11-18 2700 2020-11-19 2716 2020-11-20 1818 2020-11-20 2279 2020-11-20 1216 2020-11-21 3071 2020-11-21 1574 2020-11-21 2594 2020-11-22 2913 2020-11-22 2968 2020-11-22 1238 2020-11-22 3038 2020-11-22 2759 2020-11-23 2266 2020-11-23 2463 2020-11-18 2809 2020-11-18 2000 2020-11-18 2625 2020-11-20 1099 2020-11-20 1147 2020-11-21 2655 2020-11-23 2224 2020-11-23 1847 2020-11-23 1257 2020-11-23 2469 2020-11-18 2934 2020-11-18 1384 2020-11-18 3180 2020-11-20 3005 2020-11-20 1278 2020-11-20 1744 2020-11-20 2887 2020-11-21 2800 2020-11-21 1681 2020-11-22 2812 2020-11-22 2582 2020-11-18 1043 2020-11-18 3421 2020-11-18 1502 2020-11-18 2155 2020-11-18 1226 2020 11 18 1722 2020-11-19 2922 2020-11-19 2091 2020-11-19 2069 2020-11-20 2678 2020-11-20 2869 2020-11-20 2671 2020-11-20 1986 2020-11-22 2044 2020-11-22 1109 2020-11-22 3018 2020-11-23 2645 2020-11-23 2 9 4 10 4 No 2 6 4 4 6 8 2 4 9 6 4 8 6 4 8 10 12 12 6 8 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Our project aims to introduce a cutting-edge product to meet the evolving needs of modern photography enthusiasts. With advancements in technology and a growing demand for high-quality imagery, our...

USTRIAL PACKAGING Assignment Module 14 - Chapter 18 Industrial Packaging The role of industrial packaging in Inventory & Distribution Management can be widely misunderstood or managed very well....

The Acme Corporation considers increasing its recycling efforts as a part of the green manufacturing initiative by the local government. The Acme Corp. prides itself on being agood corporate citizen...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

PROBLEM DESCRIPTION Many of THE HOME DEPOTs products are low in value but high volume. Transportation costs form a large part of the total cost of many of the products, which makes it important for...

For the following activity, you will explain the most efficient trailer loading pattern. Please show your work when answering the questions. (10 marks) Load a 53-foot tandem axle air ride dry van for...

please answer this as soon as possible. Brightspace xExam ITT MID-TERM Exam Question 3 of 50 / Time Remaining: 01:59:30 Answe 66el- Quest What type of insurance is usually arranged by the exporter or...

Week 3: No Plagiarism No content from other students papers. Post should be in APA 6th edition format, I will need References and in-text citations. This website should be useful for all APA...

In an e-commerce company, it is desired to report the number of sales, returns and cancellations made in the last day and week, on the basis of the digital channel reached by the customer, of the...

The Medical Center has a single operating room that is used by local physicians to perform surgical procedures. The cost of using the operating room is accumulated by each patient procedure and...

airline tickets in advance. In this way, I can charge all these expenditures to July's budget. This would cause my actual expenses to come close to budget for July. Moreover, when the big advertising...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...