Question

QUESTIONS
O 1) A camping site owner keeps at least 30 motovans and 20 tents in his camping site to rent the campers one of these spaces depending on their choices. According to his accountant he should at least rent 60 rental space in total consisting of tents and motovans.
Each tent in average bringing him a cost average TRY 250 for maintanence, and a motovan brings cost TRY 300. How many motovans and tents should be kept in camping site in order to keep costs as minimum? (Use excel solver add in in order to find, optimal solution) (35 p. Use the attached excel file and put your results in it.

Answer 1

Final-Answer:

The following is the solution to the problem:

Solver Parameters

Solve: Min

Objective: C1 = 250T + 300M

Constraints:

T \geq 20

M \geq 30

T + M \geq 60

T, M \geq 0

Solution

Variable Value

T 40

M 20

Reduced Cost

0

Constraint Status

Slack/Surplus

T >= 20 0

M >= 30 0

T + M >= 60 0

The optimal solution is to keep 40 tents and 20 motovans. The total cost is 20,000 TRY.

The following is the Excel file with the results:

| Variable | Value | Reduced Cost | Constraint Status | Slack/Surplus |

|---|---|---|---|---|

| T | 40 | 0 | T >= 20 | 0 |

| M | 20 | 0 | M >= 30 | 0 |

| T + M | 60 | 0 | T + M >= 60 | 0 |

| C1 | 20,000 | 0 | Minimize | 0 |

``

Solver Parameters

Solve: Min

Objective: $C1 = 250T + 300M$

Constraints:

$T \geq 20$

$M \geq 30$

$T + M \geq 60$

$T, M \geq 0$

Solution

Variable Value

T 40

M 20

Reduced Cost

0

Constraint Status

Slack/Surplus

T >= 20 0

M >= 30 0

T + M >= 60 0

The optimal solution is to keep 40 tents and 20 motovans. The total cost is 20,000 TRY.