Find Jobs
Hire Freelancers

Scenario Capacity Tool in Excel

$30-250 USD

Closed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I want to build a scenario tool for our manufacting capacity for each line we have. If we have the labor hours it takes to build one machine, I want to play out different scenarios if we want to build 5, 10 or 20 machines. How long it would take and how much labor do we need to add.
Project ID: 20087353

About the project

18 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $169 USD for this job
User Avatar
Dear Employer, I perfectly understand your job and I will create a tool to measure the capacity of Labors. Infact I have done a similar job in which another client wanted to know how many lines shall he run to reach the target in time period. Please message me, I am an expert. Thanks and Regards, Ash
$250 USD in 7 days
5.0 (231 reviews)
7.9
7.9
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 2 days
4.9 (404 reviews)
7.6
7.6
User Avatar
Hi there,I am excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$168 USD in 7 days
4.9 (168 reviews)
7.6
7.6
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$200 USD in 5 days
5.0 (268 reviews)
7.0
7.0
User Avatar
Hi, Would you like to see a quick demo of your project on building a scenario tool that will calculate the time it will take to build certain number of machines completed before you award the project? You can consider it professionally done in less than 24 hrs. Rather than just show you past similar projects, I want to exceed your expectations by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks.
$200 USD in 7 days
4.9 (57 reviews)
6.5
6.5
User Avatar
I have many experiences in java, excel vba development. I can show you my projects via chatting. I'm software engineer. I can complete your project successfully.
$140 USD in 7 days
4.9 (46 reviews)
5.6
5.6
User Avatar
$ 30 ONLY !!!!! Sir, I understand your requirements very well, and it is quite basic to me. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will deliver your project within very short time and for VERY CHEAP rate. Please CONTACT me before closing the project, I will send you a DRAFT project file to ensure my expertise. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$30 USD in 1 day
5.0 (114 reviews)
5.4
5.4
User Avatar
I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, scenario analysis, sensitivity analysis, advanced excel and VBA automation. I have completed similar projects, please have a look at my portfolio for more details. I have previously worked for Ernst & Young also for scenario based financial modeling and model automation. You can get your work done with highest quality at lowest price. Looking forward to work with you
$80 USD in 3 days
4.9 (41 reviews)
5.6
5.6
User Avatar
Hello I have enormous experience in scenario analysis and excel calculations and have developed both complex and simple excel tools in the past. By profession I am a Chartered Accountant /CPA, a Diploma in IFRS and Bachelors in Finance having 10 years of experience in Finance and accounting domain. I can assist you on the task. Looking forward to discussing more. Kind regards, Anjul
$100 USD in 2 days
5.0 (30 reviews)
5.3
5.3
User Avatar
Hi mychaelevans, I am interested to your project. I am an Excel expert and have a great experiences in Excel automation with formula and vba since my first career 15 years ago as industrial engineer. I assured that you will be get high quality / high accuracy / high turn around service with best price. I can create capacity simulation as per your need in excel with drop down option for easier simulate. with my industrial engineering background i will able to create simulation with considering takttime and manual/auto time. please contact me to discuss further details. Thank you Best Regards, Garbo
$150 USD in 3 days
4.9 (27 reviews)
4.2
4.2
User Avatar
Hi there, I can create exactly what you are after with some more details. However can create it so everything works in the background and is modifiable by you and you see a front sheet with the items your need to select. I can create it so that if you add to it later, it will remain current.
$166 USD in 3 days
5.0 (2 reviews)
2.4
2.4
User Avatar
Hi, I´m a Business Consultant, with plenty of similar deliverables. I´ve done hundreds of scenario simulators to analyze outcomes. I´d need to have a quick Skype call to make sure we´re aligned in terms of deliverables. Once agreed, I´ll need 7 days to deliver. A 50% retainer will be charged before our Skype call, and the remaining 50% once the deliverable is approved by you. If any concern comes up, please feel free to send me a private message, I´ll be glad to clarify anything needed. Best, Tom Papantos
$300 USD in 7 days
5.0 (1 review)
1.6
1.6
User Avatar
Right now, the requirements are very generic and simple. This application can be developed in MS Excel using VBA macros if required. One sheet 1, you can enter current labor capacity for every LOB, productivity metrics for each machine in LOB, manufacturing targets/projections. One sheet 2, you can graphs showing current labor capacity, projected capacity, delta. We can make it a bit complex and use constraint-based scheduling - if you want to see "what if" you did not increase labor? We can add cost analysis too.
$150 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there, hope you are doing well. I wanted to know somethings that were unclear to me in the description, like how frequent the excel file would be updated, what exactly would be the decisive factor for building machines, also if you could provide some sample files and the output/logic you want. And I request you to reach me out so that we can discuss it further more. Thanks.
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm interested to take this project. I am an expert with Excel, Data Analysis, Presentation and Data Visualization. I have worked in a reputed MNC, my 10 years of professional experience includes analyzing & interpreting large amounts of data; creating effective and innovative presentations; formulating business plans and conducting market research. I believe my skills would be ideal for your project. I would be happy to set up a convenient time to discuss the work. Regards, Gagan
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Minneapolis, United States
0.0
0
Member since Jun 24, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.