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.