ROI Calculator Formula Development

$30-250 USD

Đã đóng

Đã đăng vào

gần 8 năm trước

$30-250 USD

Thanh toán khi bàn giao

We require a person with a strong background in mathematics as well as Microsoft Excel to develop the formulas for a Return on Investment calculator being developed for a client's website. There are approximately 12 final calculations to be determined which will be comprised of approximately 50 to 75 formula's of varying complexity. In order to assist us in choosing a provider with the ability to deliver this project correctly, please provide the answer to the following. Minutes of reduced idling per day: 50 Engine Size: 3.2 litre Fuel Cost: .92 cents per litre Days of operation per week: 6 Liters of fuel used per hour of idling: .60 Engine Size calculation is size multiplied by fuel use per hour. What is total value of reduced idling in a month ? Note: This is one of the more complex calculations on the spread sheet and not necessarily typical of all of the calculations. Our goal is to ensure that you are able to come up with the right answer for this harder formula.

Data Processing

Excel

Mã dự án: 10993585

Về dự án

31 đề xuất

Dự án từ xa

Hoạt động 8 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

31 freelancer chào giá trung bình $173 USD cho công việc này

@schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience . I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.

$150 USD trong 3 ngày

4,9

(366 nhận xét)

8,1

@cgullapalli

Hi, I am good at Excel and formulas. Looking forward to work on this project and like to work understand further problems. Happy to provide the solution given in the description. Calculation: Reduced idling per day 50 min/day Engine size 3.2 litre Fuel cost 0.92 cents per litre Days of operation 6 days per week Litres of fuel used per hour 60 litres per hour Fuel cost per hour 55.2 cents For Engine size 176.64 cents Per day 50 min Per day 147.2 cents Per week 883.2 cents Per Month 4 weeks Per month 3532.8 cents

$200 USD trong 3 ngày

5,0

(929 nhận xét)

8,1

@someka

You have already given liters of fuel used per hour of idling. So I didnt use the Engine size in my calculation. (or am I missing something) Anyway, result should be $11.04 I can set the necessary algorithms and formulas in spreadsheets. ( I have an engineering background) I have built several ROI calculators so far. Lets discuss more at chat. Thanks

$242 USD trong 3 ngày

5,0

(148 nhận xét)

7,2

@priyal1997

Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel and finance based models for various clients and businesses. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio, and if you are comfortable with those please contact me. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal Answers - Value liters saved per day - 0.5 (50*0.6/60) Cost saving per day - 0.46 (0.5*0.92) Week - 2.76 (0.46*6) Month (assume 4 weeks per month)-11.04 (2.76*4)

$400 USD trong 5 ngày

5,0

(194 nhận xét)

6,8

@datasolutionind

answer is 529.92

$250 USD trong 3 ngày

5,0

(76 nhận xét)

6,0

@johncarteratfl

I am Microsoft Certified Excel Professional with a Finance majors degree. I understand the concept of return on investment and have done some calculators for yield percentages and maturity amounts in the past. Let me know your requirements in detail. Thanks.

$205 USD trong 3 ngày

5,0

(57 nhận xét)

6,1

@workerbee1974

The formula I believe is =((((0.6/60)*50)*6)*4)*0.92 .60 and hour / by 60 min in an hour=.10 *50 min of reduced idling per day=.50 * 6 days a week = 3* 4 weeks in a month =12 * .92 a liter= $11.04 per vehicle I have taken all of the excel classes from 03 to 13 and I am a bookkeeper by trade. Thanks Donna

$177 USD trong 3 ngày

4,8

(21 nhận xét)

6,1

@Yapson

Hi there, I am analytical and enjoy to solve problems. Being a Mathematician and conversant to MS Excel, i believe that i am the right person for your project. I am ready to start with your project. Please contact me as soon as you can. Yapson

$177 USD trong 3 ngày

5,0

(19 nhận xét)

5,2

@madhurna

Greetings! I am qualified accountant with nine years of experience in costing, financial analysis and accounting. Please PM me to discuss the project further. Thank you.

$115 USD trong 3 ngày

5,0

(10 nhận xét)

4,8

@yogesh701

Hello there! I am a Chartered Accountant ( equivalent to US CPA ) who have worked with Price Waterhouse Coopers and have gained immense exposure towards financial analysis and computations. I am an excel expert who can produce amazing results using excel tools. Should you have any query, please feel free to contact. Kind Regards, Yogesh

$100 USD trong 3 ngày

4,9

(19 nhận xét)

4,8

@humayoonsheikh4u

dear sir: i am an MBA having hands on expertise on financial calculations as well on excel analysis and formula building i can do your project as per requirement. Total value of reducing is 13824. best regards

$250 USD trong 3 ngày

4,7

(12 nhận xét)

4,2

@jnekam

Hi, This is my calculation process: 1- Consumption per day = 60 l/ 60 min * 50 min = 50 l 2- Cost per day = 92 cents / l * 50 cents = 4600 cents = 46 $ 3- Cost per week = 46$ / day * 6 days / week = 276 $ 4- Cost per month = 276 $ / week * 4 weeks / month = 1104 $ Please this is how I work, clear so that your can see the details and any error Thanks

$155 USD trong 3 ngày

4,6

(12 nhận xét)

3,8

@oguzyilmaz

Hello, if yo uare asking about the cost of idling in a month; 24 working days in a month, 50 min idling in a day means ; 1200 min. idling total. if 60 min idling takes 0,6 liters, 1200 min will take 12 liters. multiplying with 0,92, it will cost for a month as 11,04 dollars. Hope to hear from you Oguz

$200 USD trong 0 ngày

5,0

(3 nhận xét)

3,1

@MLBSA

Good day. As requested I have worked out the information that you have requested. To calculate the value I had make the assumption that a month is 4 weeks: There are 20 hours of "Reduced Idling" in a month. Per your calculation this equates to 12 liters of fuel used in this time. Thus the value is $11.04 (assumed currency unit is dollars due to the project budget). I come from a background of Engineering Calculus, Linear Algebra with strong statistical knowledge. I also have a strong knowledge in practical use of logic coinciding with machine learning to assist with decision making choices of formulas based on set parameters. Also with my recent employment I have a very strong manual writing experience, thus I will be able to properly tabulate the exact steps and thinking behind the formula creations. I believe I will be able to complete the project in a timely fashion with all of the expectations met.

$111 USD trong 3 ngày

4,9

(3 nhận xét)

2,4

@nsabale

Hi All, We are ready to give FREE trial for one day. if you like and give us 5 stars rating then we can work for less than the proposal cost. We are team of software eng. and we provide automation solutions for data entry work. With this, you can finish your work in few time with high quality. This solution you can use multiple times.

$175 USD trong 10 ngày

5,0

(1 nhận xét)

1,6

@torrecillas

11.82 total value for a month of idling. I'm an engineer with solid maths and Excel background. Sure I can help!

$55 USD trong 10 ngày

0,0

(0 nhận xét)

0,0

@paulath

$1,059.84 is the answer to your test calculation . I have written an employee spread sheet which calculates Net , Tax to be paid , Superannuation to be contributed , yearly gross , yearly net and yearly Superannuation . I used - IF statements , Lookup and Roundup functions . Also Credit and debit functions. Thank you , Paul

$155 USD trong 3 ngày

0,0

(0 nhận xét)

0,0

@KellyKW

$11.04. I would be happy to provide these formulas in Excel for you. I would prefer to have at least two sample sets of data for each formula for testing if possible. I can finish in 3 days. If you need sooner, just ask. For a small fee, I can rush ahead of another project....not a problem. Thank you!

$250 USD trong 3 ngày

0,0

(0 nhận xét)

0,0

@im040314

Hi Sirs, The answer is 11.04, if calculate based on 4 weeks per month. If based on days per month, the answer is 11.96 for 2016 Jul and 12.42 for 2016 Aug. The Engine Size is not calculated and the days counted as Sunday is no operation. Thank you and Best Regards, Teh

$155 USD trong 3 ngày

0,0

(0 nhận xét)

0,0

@Vanishedman

Assuming a month is consist of 4 weeks. No of operating days= 24days No of operating minutes= 24*50=1200 No of operating hours=1200/60=20 Fuel require=3.2*0.6*20=38.4 Fuel cost=38.4*0.92=35.328

$30 USD trong 2 ngày