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

Про роботодавця:
( 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

\$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

\$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