Question: please only answer question B and show steps in excel. A small trucking company is determining the composition of its next trucking job. The load
please only answer question B and show steps in excel.
A small trucking company is determining the composition of its next trucking job. The load
master has her choice of seven different types of cargo, which may be loaded in full or in
part. The specifications of the cargo types are shown in the following table.
The goal is to maximize the amount of freight, in terms of dollars, for the trip. The truck can
hold up to pounds of cargo in a cubicfoot space.
a What cargo should be loaded, and what will be the total freight charged?
b Now consider that two additional smaller trucks can be added: one that can carry
pounds in a cubicfoot space and another that can carry pounds in a cubic
foot space. The first additional truck costs $ to hire and the second truck costs $ to
hire. Is it a profitable decision to hire either or both of the additional trucks? Why or why
not? Hint: This will require additional models.PlPl
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
