Kapalı

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

Daha fazlasını görün: 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, use of graph, to bus, step for freelancer, scheduling jobs, resource freelancer, paint jobs for cars, Paint jobs, optimal design, on line cars, meaning of data entry work, make a spread sheet, machine design jobs, line graph design, learn how to design, learn how to be a freelancer, jobs that use 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

ready to do this job , please check pm for detail

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

hi i have good experience about this [url removed, login to view] can check my PM.

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