Find Jobs
Hire Freelancers

I need an excel expert to create inputs in an excel spreadsheet to allow us to track status on engine accruals -- 2

$30-250 USD

Closed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
The project is to devise an algorithm in Excel that will determine month to month how much money needs to be in an engine accrual fund so that when an engine has to be replaced the club has a sufficient amount of money in the fund to cover the cost. As you know, I’ve already done this, but it would be interesting to see if someone else with the same mission would come up with something that would predict similar amounts of money or something totally different. If it’s similar then I would be reasonably confident that what I’ve done will work. If not, then maybe I’ve missed something and we’d need to understand the differences. In any case, don’t look at what I’ve done, start with a clean slate. 1. Must have monthly results that are updated based on actual flight hours by airplane for the month. 2. Future month forecasts are based on monthly average flight hours by airplane that should be variables in the spreadsheet so that they can be changed as needed. 3. Starting points for each aircraft are: a. N6NS 841.49 hours b. N6026Y 364.88 hours c. N199RN 1016.10 hours 4. TBOH for each aircraft are: a. N6NS 2000 hours b. N6026Y 1800 hours c. N199RN 2000 hours 5. Today’s costs for each engine overhaul a. N6NS $25,000 b. N6026Y $36,000 c. N199RN $31,000 6. Must be able to account for inflation rates for the aircraft engine as a variable. Inflation rates to be defined annually but applied on a monthly basis. 7. Must account for annual interest earned on money already in the engine fund as a variable in the algorithm. 8. To have some monthly flight times to start with, use the what I have below. Keep in mind that your algorithm needs to be able to apply actual flight times each month and be able to adapt to changes in the average flight times for future forecast. The numbers below are the 1 year trailing average and presumably we would need to be able to change this each month based on new data. a. N6NS 17.17 hours b. N6026Y 18.92 hours c. N199RN 16.13 hours
Project ID: 20264684

About the project

11 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
11 freelancers are bidding on average $175 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD in 5 days
4.9 (364 reviews)
8.0
8.0
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .
$155 USD in 3 days
5.0 (83 reviews)
7.5
7.5
User Avatar
"I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 8 years of experience in Sales, Marketing and Advertising. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$200 USD in 7 days
4.9 (266 reviews)
7.0
7.0
User Avatar
Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Excel Programming. I'm really confident about your project, and very eager to join your project. If we have a chance to cooperate, I'll do my best to provide wonderful result. Looking forward to your response. Best Regards.
$200 USD in 7 days
4.9 (63 reviews)
6.5
6.5
User Avatar
I am excel vba expert, I am interested in your project. please review my profile. Mohsan
$250 USD in 2 days
5.0 (88 reviews)
6.3
6.3
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .
$155 USD in 3 days
4.8 (11 reviews)
5.2
5.2
User Avatar
Hello, I read through the job details of your project and I am absolutely sure that I can do this project very well, I have more than 5 years of experience in it. I Provide - - 24x7 Services to My Clients(The Reason why My Clients Loves me and Rises) - 1 Month Free Service after the Project Completion - Development on Our Test Server at Start and will do Migration after all Completed and Approved It's been more than 5 Years that I am Providing Services here I have gathered more than 1000 Reviews in my Offline Market, Completed more than 1500 Projects Being on the Top Rankings on Freelancer I have Worked on all Sort of Projects being Small, Medium or Long Ping me anytime, I am always there for help (24x7) Thank You
$100 USD in 7 days
5.0 (3 reviews)
1.6
1.6
User Avatar
Hi, I think you need an accumulated depreciation system for your organization. Please chat with me for details. Thanks
$250 USD in 3 days
3.2 (1 review)
0.8
0.8
User Avatar
Hi! I'm Dhanica Dawn Lanaban, a very experienced in Microsoft and also good at analysis that differs to identify and understand issues, problems and opportunities like comparing a data from different sources to draw a conclusions and i'm good at communication that clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message. I've been on a BPO , Telecom Company and a Government Agencies that gives knowledge and enhance my skills more. I promise to work hard with a passion, to do multitask with a determination and work under pressure and meet deadlines.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a business analyst and your project sounds very interesting. I have an accounting degree. I could have the project completed in a few days. My bid is a flat rate.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Summerfield, United States
5.0
1
Payment method verified
Member since Jul 6, 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.