Closed

An Excel Spread Sheet to calculate optimal resource for job scheduling

Hi I am looking for a powerful excel user to make use of "Excel Solver" to help me calculate my optimal resource to facilitate my job scheduling.

I am doing some paint work for customer vehicle and I need to find out how many paint job orders I can take in every day if I have 7 spray paint machine to work concurrently.

My spray paint machine takes 5.5 hrs to spray a bus and 1 hr to spray a normal saloon car. I need to know how many jobs I can take every day with based on 16 man hrs a day.

The spread sheet show be present in general data form as well as line graph form. Eg. If the end calculation of my resource is that I can either take in 100 or 20 cars a day, By adding or subtracting either to bus/car, the graph should auto increase or decrease the remaining available resource.

I will need the freelancer to provide me a detailed print screen on every step you took to design and write this spread sheet formula. Meaning I must be able to replicate and learn myself through the screen shot guide.

Pls let me know if you are able to take this job.

Skills: Data Entry, Data Processing, Excel

See more: calculate optimal resource excel, optimal scheduling excel, excel resource scheduling, excel resource spread, job scheduling sheet, resource scheduling excel sheet, scheduling excel, resource sheet excel, calculate resource job, to bus, step freelancer, scheduling jobs, resource freelancer, paint jobs cars, paint jobs, optimal design, line cars, meaning data entry work, make spread sheet, machine design jobs, line graph design, jobs use excel, jobs available line, need excel freelancer

About the Employer:
( 0 reviews ) Singapore

Project ID: #4394997

16 freelancers are bidding on average $36 for this job

satsin7

I I love working on excel and using Solver especially real life problems. I have done many transportation, travelling salesman type linear programming assignments. I am sure I can help you.

$30 SGD in 1 day
(15 Reviews)
4.5
javed1705

ready to do this job , please check pm for detail

$35 SGD in 1 day
(14 Reviews)
4.3
Pichart

I saw you project awarded last night, but it still open now...any way for I have done something on you project, so I send you via PM.

$36 SGD in 2 days
(14 Reviews)
4.0
priyal1997

ITS DONE.. PLEASE CHECK PM AND CONFIRM

$50 SGD in 1 day
(7 Reviews)
3.2
haiyenle

i can solve it in very quick time and design it just as you want, so please give this job

$31 SGD in 1 day
(1 Review)
1.5
hinkelandras

I'm an university student and have just recently done a quite similar exercise. I would be honoured to help you with your job scheduling.

$30 SGD in 2 days
(0 Reviews)
0.0
randoly77

Give me a chance I am ready to work.

$30 SGD in 3 days
(0 Reviews)
0.0
shimaahosni

I can do it

$40 SGD in 3 days
(0 Reviews)
0.0
asisdev

Working with excel/excel VBA for last 10 years. I am new in this freelancer site. Really interested to do this job. I love to do any time of challenging automated excel. Price is not matter as I love to do excel VBA. I More

$30 SGD in 3 days
(0 Reviews)
0.0
ifranhosen

hi i have good experience about this project.you can check my PM.

$33 SGD in 2 days
(0 Reviews)
0.0
batshritesh

work will say everything ..

$36 SGD in 3 days
(0 Reviews)
0.0
amanjotg3

Hi, I am ready to do this job.

$36 SGD in 3 days
(0 Reviews)
0.0
Ezzat

Yes, I can do this job

$30 SGD in 3 days
(0 Reviews)
0.0
nirwanamarjit

I am well experienced and can complete the project in one day with accuracy.

$30 SGD in 1 day
(0 Reviews)
0.0
anamaria1979

Hy! I am a teacher and I want to work in this project.I. Thank You!

$35 SGD in 3 days
(0 Reviews)
0.0
muhajira91

very interesting job

$36 SGD in 3 days
(0 Reviews)
0.0
LunguAndrei

Hello! Honest and hard working user. I would like to work with you to calculate your optimal resource to facilitate the job scheduling.

$56 SGD in 3 days
(0 Reviews)
0.0
dzoshua

I am very much interested for this project. Ready to start immediately. I will follow all instructions. If you have any question related to budget, deadline of work and any other issue please let me know. Looking for h More

$30 SGD in 1 day
(0 Reviews)
0.0