Закрито

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.

Навички: Введення даних, Обробка даних, Excel

Показати більше: 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

Про роботодавця:
( 0 відгуки(-ів) ) Singapore

ID проекту: #4394997

16 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $36

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 за 1 день
(15 відгуків(-и))
4.5
javed1705

ready to do this job , please check pm for detail

$35 SGD за 1 день
(14 відгуків(-и))
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 за 2 дні(-в)
(14 відгуків(-и))
4.0
priyal1997

ITS DONE.. PLEASE CHECK PM AND CONFIRM

$50 SGD за 1 день
(7 відгуків(-и))
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 за 1 день
(1 відгук)
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 за 2 дні(-в)
(0 відгуків(-и))
0.0
randoly77

Give me a chance I am ready to work.

$30 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
shimaahosni

I can do it

$40 SGD за 3 дні(-в)
(0 відгуків(-и))
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 Більше

$30 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
ifranhosen

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

$33 SGD за 2 дні(-в)
(0 відгуків(-и))
0.0
batshritesh

work will say everything ..

$36 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
amanjotg3

Hi, I am ready to do this job.

$36 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
Ezzat

Yes, I can do this job

$30 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
nirwanamarjit

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

$30 SGD за 1 день
(0 відгуків(-и))
0.0
anamaria1979

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

$35 SGD за 3 дні(-в)
(0 відгуків(-и))
0.0
muhajira91

very interesting job

$36 SGD за 3 дні(-в)
(0 відгуків(-и))
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 за 3 дні(-в)
(0 відгуків(-и))
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 Більше

$30 SGD за 1 день
(0 відгуків(-и))
0.0