# 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.

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

İşveren Hakkında:
( 0 değerlendirme ) Singapore

Proje NO: #4394997

## 16 freelancer bu iş için ortalamada 36\$ teklif veriyor

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.

1 gün içinde 30\$ SGD
(15 Değerlendirme)
4.5
javed1705

1 gün içinde 35\$ SGD
(14 Değerlendirme)
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.

in 2 gün içinde36\$ SGD
(14 Değerlendirme)
4.0
priyal1997

ITS DONE.. PLEASE CHECK PM AND CONFIRM

1 gün içinde 50\$ SGD
(7 Değerlendirme)
3.2
haiyenle

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

1 gün içinde 31\$ SGD
(1 Değerlendirme)
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.

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

Give me a chance I am ready to work.

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

I can do it

in 3 gün içinde40\$ SGD
(0 Değerlendirme)
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 Daha fazlası

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

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

work will say everything ..

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

Hi, I am ready to do this job.

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

Yes, I can do this job

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

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

1 gün içinde 30\$ SGD
(0 Değerlendirme)
0.0
anamaria1979

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

in 3 gün içinde35\$ SGD
(0 Değerlendirme)
0.0
muhajira91

very interesting job

in 3 gün içinde36\$ SGD
(0 Değerlendirme)
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.

in 3 gün içinde56\$ SGD
(0 Değerlendirme)
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 Daha fazlası

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