Devam Ediyor

Using Excel formula 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 bus 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.

Beceriler: İş Analizi, Veri Girişi, Veri İşleme, Excel

Daha fazlasını görün: excel formula scheduling, formula job scheduling, resource scheduling using excel, formula calculate paint using, 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 using excel, jobs use excel, jobs available line, end work freelancer

İşveren Hakkında:
( 6 değerlendirme ) singapore, Singapore

Proje NO: #4395019

Seçilen:

javed1705

i can do this job comfortably for detail please check pm

3 gün içinde 30$ SGD
(33 Değerlendirme)
5.0

9 freelancer bu iş için ortalamada 32$ teklif veriyor

mtthardy4

i m ready to do this project check pm thank nitya

in 2 gün içinde40$ SGD
(7 Değerlendirme)
4.1
Wassy24

Its a very easy job for me.I am fully conversant with excel.Lately I am using Excel 2013,which have mind-blowing features which will assist you for your work.Just hire me and you will see what I do for you.I have posit Daha fazlası

in 2 gün içinde30$ SGD
(1 Değerlendirme)
1.4
haiyenle

I can do it, give this job to me I will do exactly as you wanted

1 gün içinde 37$ SGD
(0 Değerlendirme)
0.0
myteknologi

I'm interest to do your project, thank you..

in 2 gün içinde36$ SGD
(0 Değerlendirme)
0.0
rpanuganti

Hi, Please read my PM Note.

in 6 gün içinde30$ SGD
(0 Değerlendirme)
0.0
Ginamipa

I have skill in excel and i believe i can help you

in 3 gün içinde36$ SGD
(0 Değerlendirme)
0.0
UPCsoftware

We have big experience in software development. We can make this task at high level.

in 2 gün içinde30$ SGD
(0 Değerlendirme)
0.0
Jitesh13

I am new here but well versed with this kind of task...looking forward to work with you.

in 2 gün içinde30$ SGD
(0 Değerlendirme)
0.0
Sirbreno

Fairly simple project I can start right away.

in 2 gün içinde30$ SGD
(0 Değerlendirme)
0.0