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:

Recessionary Gap

A situation where the real GDP is lower than the potential GDP at full employment, indicating underutilized resources in an economy.

Short-Run Aggregate Supply Curve

A graphical representation that shows the relationship between the total production of goods and services at different price levels in the short term.

Cost of Production

The total expense incurred in manufacturing a product or providing a service, including raw materials, labor, and overhead costs.

Actual Price Level

The current index of the price of goods and services in an economy, reflecting the purchasing power of money and the cost of living at a certain time.