The Cross-Canada Trucking Company has expanded its shipping capacity by purchasing 120 trucks and trailers from...

The Cross-Canada Trucking Company has expanded its shipping capacity by purchasing 120 trucks and trailers from a competitor that went bankrupt. The company subsequently located 40 of the purchased trucks at each of its shipping warehouses in Quebec City, Quebec, Sault Ste. Marie, Ontario and Edmonton, Alberta. The company makes shipments from each of these warehouses to terminals in Montreal, Quebec, Toronto, Ontario and Calgary, Alberta. Each truck is capable of making one shipment per week. The terminal managers have each indicated their capacity for extra shipments. The manager at Montreal can accommodate 40 additional trucks per week, the manager of Toronto can accommodate 60 extra trucks per week and the manager at Calgary can accommodate 50 additional trucks. The company makes the following profit per truckload shipment from each warehouse to each terminal. The profits differ as a result of differences in products shipped, shipping costs, and transport rates Terminal Warehouse Montreal Toronto Calgary Quebec City $1,800.00 $2,100.00 $1,600.00 Sault Ste. Marie $1,000.00 $ 700.00 $ 900.00 Edmonton $1,400.00 $ 800.00 $2,200.00 The company wants to know how many trucks to assign to each route (i.e., warehouse to terminal) to maximize profit. Formulate the linear programming model for this problem and solve it.

Solutions

Expert Solution

Setting up in excel,

Initial formulation:

Solver constraints:

Clicking solve, we get:

PLEASE LEAVE A LIKE. IT REALLY HELPS ME A LOT. THANK YOU!!!

keosha answered 9 months ago

Next > < Previous

Related Solutions

OTR Trucking Company runs a fleet of long-haul trucks and has recently expanded into the Midwest,...

OTR Trucking Company runs a fleet of long-haul trucks and has recently expanded into the Midwest, where it has decided to build a maintenance facility. This project will require an initial cash outlay of $ 19.5million and will generate annual cash inflows of$3.8million per year for Years 1 through 3. In Year 4, the project will provide a net negative cash flow of $4.5million due to anticipated expansion of and repairs to the facility. During Years 5 through 10, the...

(Calculating MIRR) OTR Trucking Company runs a fleet of long-haul trucks and has recently expanded into...

(Calculating MIRR) OTR Trucking Company runs a fleet of long-haul trucks and has recently expanded into the Midwest, where it has decided to build a maintenance facility. This project will require an initial cash outlay of $ 18.5 million and will generate annual cash inflows of $4.8 million per year for Years 1 through 3. In Year 4, the project will provide a net negative cash flow of $5.5 million due to anticipated expansion of and repairs to the facility....

Keith’s Trucking Company is replacing part of their fleet of trucks by purchasing them under a...

Keith’s Trucking Company is replacing part of their fleet of trucks by purchasing them under a note agreement with Kenworthy on January 1, 2018. The note agreement will require $6 million in annual payments starting on December 31, 2018 and continuing for a total of six years (final payment December 31, 2023). Kenworthy will charge Keith’s Trucking the market interest rate of 8% compounded annually. (Round to the nearest dollar). A). (2-1/2 pts) How much will Keith’s Trucking record as...

A trucking company has GPS (global positioning satellite) locators on its repair trucks to track the...

A trucking company has GPS (global positioning satellite) locators on its repair trucks to track the location of each truck in its repair fleet. Every 15 minutes, the GPS sends the company the location (latitude and longitude) of each truck. In response to complaints about a repairman’s slow response times, senior managers were able to plot the movement of his truck. They found that the driver made long side trips to the same house at roughly the same time each...

The Crossett Trucking Company claims that the mean mass of its delivery trucks when they are...

The Crossett Trucking Company claims that the mean mass of its delivery trucks when they are fully loaded is 3000 kg and the standard deviation is 79 kg. Assume that the population follows the normal distribution. Forty trucks are randomly selected and their masses measured. Within what limits will 95% of the sample means occur? (Round the final answers to the nearest whole number.) Sample means

The Crossett Trucking Company claims that the mean mass of its delivery trucks when they are...

The Crossett Trucking Company claims that the mean mass of its delivery trucks when they are fully loaded is 2550 kg and the standard deviation is 63 kg. Assume that the population follows the normal distribution. Forty trucks are randomly selected and their masses measured. Within what limits will 98% of the sample means occur? (Round the final answers to the nearest whole number.) Sample means to

Crossett Trucking Company claims that the mean weight of its delivery trucks when they are fully...

Crossett Trucking Company claims that the mean weight of its delivery trucks when they are fully loaded is 5,650 pounds and the standard deviation is 240 pounds. Assume that the population follows the normal distribution. Forty-five trucks are randomly selected and weighed. Within what limits will 90% of the sample means occur? (Round your z-value to 2 decimal places and final answers to 1 decimal place.) Sample means _______ to _______

Crossett Trucking Company claims that the mean weight of its delivery trucks when they are fully...

Crossett Trucking Company claims that the mean weight of its delivery trucks when they are fully loaded is 5,300 pounds and the standard deviation is 170 pounds. Assume that the population follows the normal distribution. Thirty trucks are randomly selected and weighed. Within what limits will 99 percent of the sample means occur? (Round your z-value to 2 decimal places and final answers to 1 decimal place.) Sample means ____ to _____

Dorsey Co. has expanded its operations by purchasing a parcel of land with a building on...

Dorsey Co. has expanded its operations by purchasing a parcel of land with a building on it from Bibb Co. for $89,000. The appraised value of the land is $24,000, and the appraised value of the building is $102,000. information Required: a. Assuming that the building is to be used in Dorsey Co.’s business activities, what cost should be recorded for the land? (Do not round intermediate calculations.) b. Indicate why, for income tax purposes, management of Dorsey Co. would...

X-Cee-Ski Company recently expanded its manufacturing capacity, which will allow it to produce up to 21,000...

X-Cee-Ski Company recently expanded its manufacturing capacity, which will allow it to produce up to 21,000 pairs of cross-country skis of the mountaineering model or the touring model. The Sales Department assures management that it can sell between 9,000 and 14,000 pairs of either product this year. Because the models are very similar, X-Cee-Ski will produce only one of the two models. The following information was compiled by the Accounting Department: Per-Unit (Pair) Data Mountaineering Touring Selling price $180 $120...

Subjects