An Excel Spread Sheet to calculate optimal resource for job scheduling

$30 SGD

Imefungwa

Imechapishwa

about 11 years ago

$30 SGD

Kulipwa wakati wa kufikishwa

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.

Data Entry

Data Processing

Excel

Kitambulisho cha mradi: 4394997

Kuhusu mradi

14 mapendekezo

Mradi wa mbali

Inatumika 11 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

14 wafanyakazi huru wana zabuni kwa wastani $36 SGD kwa kazi hii

@javed1705

ready to do this job , please check pm for detail

$35 SGD ndani ya siku 1

4.9

(117 hakiki)

6.8

@priyal1997

ITS DONE.. PLEASE CHECK PM AND CONFIRM

$50 SGD ndani ya siku 1

5.0

(197 hakiki)

6.7

@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 ndani ya siku 1

4.9

(25 hakiki)

5.5

@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 ndani ya siku 2

5.0

(41 hakiki)

5.5

@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 healthy and long term business relationship with you. Check out my Portfolio and please provide further details.

$30 SGD ndani ya siku 1