A Company Wants to Purchase Large and Small Delivery Trucks

Essay

A company wants to purchase large and small delivery trucks. The company wants to purchase about 10 large and 15 small trucks. Each large truck costs $30,000 and has a 10 ton capacity. Each small truck costs $20,000 and has a 7 ton capacity. The company wants to have about 200 tons of capacity and spend about $600,000.
Based on the following formulation and associated integer solution, what values should go in cells B2:E16 of the spreadsheet?
$\begin{array}{|l|l|c|c|c|c|}\hline & {\text { A }} & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & \text { Problem Data } & \text { Large } & \text { Small } & & \\\hline 2 & \text { Cost } & & & & \\\hline 3 & \text { Capacity } & & & & \\\hline 4 & & & & &\\\hline 5 & \text { Goal Constraints } & \text { Large } & \text { Small } & \text { Cost } & \text { Capacity } \\\hline 6 & \text { Actual Amount } & & & & \\\hline 7 & + \text { Under } & & & & \\\hline 8 & - \text { Over } & & & & \\\hline 9 & =\text { Goal } & & & & \\\hline 10 & \text { Target Value } & & & & \\\hline 11 & & & & & \\\hline 12 & \text { Weights } & & & & \\\hline 13 & \text { Under } & & & & \\\hline 14 & \text { Over } & & & & \\\hline 15 & & & & & \\\hline 16 & \text { Objective } & & & & \\\hline\end{array}$