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 900 pounds of cargo in a 2,500-cubic-foot 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 400
pounds in a 500-cubic-foot space and another that can carry 800 pounds in a 1,500-cubic-
foot space. The first additional truck costs $440 to hire and the second truck costs $850 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
 please only answer question B and show steps in excel. A

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!