Decision Support System

make it with excel

Love-Drive-line (LDL) is a new Transportation Company owned established to facilitate the transportation within the different countries of the GCC. As starting stage for this project, a plan for transportation line includes four of the GCC countries: Bahrain, Kuwait, Saudi Arabia and Qatar was established. They have one trip per day and only if there are 6 customers or more. After six months the manager of the company has met with the shareholders to investigate the situation of their company. As a result of their investigation the following information has been provided: 1. Information on each trip, expenses and fees Destination 1 2 3 4 5 6 From BAH BAH KWT KWT SUD SUD to SUD KWT BAH SUD BAH KWT Fee/trip (BD) 10 15 12 20 12 25 2. Information on the number and capacity of the cars and buss available in the company: Vehicle/type Capacity (Person) Fuel/trip/Day in Maintenance/day BD In BD Mini Bus 6 60 70 Car 4 40 40 Van 20 50 60 3. Information on the daily trip that has been conducted in the previous six months: 1 6 6 3 2 1 3 3 2 3 2 3 5 2 3 2 3 5 2 4 1 3 5 3 4 1 3 1 3 5 1 3 5 2 6 6 2 6 2 6 4 5 2 2 2 3 6 1 1 1 The monthly customers are normally distributed with a mean on 200 customers and a Standard Deviation of 30.89. Use the given information and develop a risk analysis model for the monthly profit of the company (30 Trials). Do you think that this is a profitable project? o Which trip is the most frequently run by the company? Which is the costliest trip based on your model? How many times the company will cancel their trips