Truck Utilization Database

In Progress

Background:

Open the file called "GT Truck [url removed, login to view]"

This file contains our order information and we would like to start optimizing the number of trucks we use to pickup and deliver the orders. You will need to create a database that helps us know how many Trucks are needed each day for a 5 day period to handle the shipments in Tab "DailyOrders"

Tabs Explained:

DailyOrders: This contains the orders being shipped. 1 order = 1 Trip & will need 1 Truck

- This will be an input and can change by Day. Currently the input schedule is Friday orders come in for the next week's shipments and during the week orders are updated based on production.

Columns: - Customer: is the customer to whom the order will be going to

- Sch Date: Is the Date the shipment is scheduled to leave our Plant for delivery to Customer. Date is imported as "yymmdd" this would need to be converted to "ddmmyy" This date also gives us the filter for the 5Day period

- APPT TIME: This is the Time the shipment is scheduled to leave the Plant for delivery to Customer

DriveTime: This is the standard time in Minutes it takes to Drive From the Plant to the Customer and back to the Plant round trip

TruckType: This is the Type of Truck available. 2 types: Single and Team. Single can only drive for 4200Minutes/5Days and Team only 6600Minutes/5Days. We're using 5 days because max time a driver can be out on the road is 5 days

Assumptions:

- Orders are imported into the database every Friday and can be updated through out the week

- Each customer order means the truck is full so no mix shipments

- # of trucks needed is not known until orders come in

TASK:

Develop a database allows us to import the DailyOrders and lets us know how many trucks will be needed per day for a 5 day period and of those trucks needed which ones will deliver which Customer order.

Hint: The trucks are to be allocated based on the orders so one truck can do (orders 3,6,9,10) it does not have to be Order (1,2,3,4...)

Requirement:

- Project should be done in MS Access (2003).

Output Reports:

Excel output is accessible but Access is prefered.

1. Ghant chart showing the Customer Names and Which Truck and Type of Truck will deliver the shipment (I can help with thid design once you win the project)

2. A Delivery Schedule by Truck and Type of Truck (This will act as a Job card for the driver so he knows his duty for the next 5 days)

3. A form showing when a Truck will be available next based on Orders it's scheduled to run. Form should be sorted by first available

I HAVE GIVEN ALL INFORMATION THAT I HAVE CURRENTLY TO ALLOW YOU TO BID ACCURATELY.

MS ACCESS AND VBA EXPERT IS A MUST. I WOULD LIKE TO CLOSE THIS PROJECT VERY SOON SO IF YOU HAVE MANY PROJECTS AND WONT BE ABLE TO DEDICATE TIME KINDLY BE RESPECTFUL AND DON'T BID.

Additional Requirements; (not a must but is a plus)

- Skype with head set

- English knowledge is prefered but not a must as long as we can communicate

HAPPY BIDDING!!

Thank You

Skills: Data Processing, Excel, Microsoft Access, Visual Basic

See more: truck utilization, truck utilization chart, truck utilization database, project truck utilization, truck database access, delivery truck database access, trucks utilization, truck utilization excel, xls excel expert, truck driver job, sorted data set, skype help for excel, need expert excel help, ms access excel vba, job in act, import ms project, how to develop database in access, how to design a job card, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, how can i expert in excel, expert help with excel, driver job, design expert output use excel

Project ID: #933634

Awarded to:

fedalal2

Hi, I have more 10 years experience with MS Access and VB, so I'm realy GURU in this. I can help you with this project. This price NOT include reports as we discuss Best Regards, Alex

$100 USD in 2 days
(35 Reviews)
5.6

18 freelancers are bidding on average $154 for this job

djucuti

Hi, please check PM

$110 USD in 10 days
(27 Reviews)
5.0
binaryromel

Lets start. Please check PM. Thanks.

$150 USD in 5 days
(38 Reviews)
5.0
eperfections

Hello Sir, We can automate and optimize your Truck database. For details please check PMB! Thanks ePerfections

$250 USD in 5 days
(31 Reviews)
5.0
florinserban

Hi. Please check PM for details. Thanks!

$150 USD in 7 days
(13 Reviews)
4.2
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

$270 USD in 21 days
(3 Reviews)
4.1
proitagent

Hi There, I ama aprofessional database developer and ms access guru and can easily do the task and am sure I can help you in this. I do have over 12 years experience in application development and implementation More

$130 USD in 2 days
(1 Review)
1.7
bojan1979

Hello I have all you need, see PMB

$75 USD in 10 days
(1 Review)
1.0
kristiawan

Hello, I name my ardhianto kristiawan three graduate diploma in management informatics gunadarma universities that I have my master microsoft office (excel, word, acces and SQL Server 2000), mastering visual basic and More

$100 USD in 10 days
(0 Reviews)
0.0
hkit711

will do th job for you.

$200 USD in 5 days
(0 Reviews)
0.0
Ravencrt

Hello I develop access applications on a daily basis, I can start right away. Hope to hear from you. Have a nice day. Bye.

$100 USD in 10 days
(0 Reviews)
0.0
abdfajar

I have a lot of experience in vb & ms access programming, I understand about scheduling problem especially in fleet management.

$100 USD in 7 days
(0 Reviews)
0.0
myejob

Please check PM. Thanks.

$75 USD in 7 days
(1 Review)
0.0
Rakibbbc

i interested

$250 USD in 5 days
(0 Reviews)
0.0
arsalan701

Please check PM!

$250 USD in 12 days
(0 Reviews)
0.0
muhammadibaad

Sir, Plz see your pmb for more detail.

$170 USD in 15 days
(0 Reviews)
0.0
LajosArpad

Hello, please read PM. Best regards, Lajos Arpad.

$200 USD in 1 day
(0 Reviews)
0.0
abdulgutha

I can do this

$100 USD in 5 days
(0 Reviews)
0.0