An Excel Spread Sheet to calculate optimal resource for job scheduling

CLOSED
Bids
17
Avg Bid (SGD)
$36
Project Budget (SGD)
$30 - $30

Project Description:
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.

Skills required:
Data Entry, Data Processing, Excel
Hire claireclaire
Project posted by:
claireclaire Singapore
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
Hire javed1705
$ 35
in 1 days
Hire Pichart
$ 36
in 2 days
$ 50
in 1 days
Hire haiyenle
$ 31
in 1 days
Hire asisdev
$ 30
in 3 days
Hire randoly77
$ 30
in 3 days
$ 30
in 1 days
Hire hinkelandras
$ 30
in 2 days
$ 40
in 3 days