Solved

A Company Wants to Purchase Large and Small Delivery Trucks

question 43

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?
$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}$ $\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}$

Definitions:

Thermodynamics

The branch of physics that deals with the relationships between heat and other forms of energy, and how these affect matter, encompassing laws that describe energy conservation and entropy.

Energy Conversion

The process of transforming energy from one form into another, such as converting kinetic energy into electrical energy.

Law

A system of rules that are created and enforced through social or governmental institutions to regulate behavior.

Nuclear Changes

Transformations at the atomic level, including reactions in nuclear power generation and atomic bombs, which can alter the composition of atomic nuclei.