Suoritettu

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

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

Taidot: Excel, Matematiikka, tietojenkäsittely, Tilastotiede, Visual Basic

Näytä lisää: hello i need to create a logo and a name to put on my clothing brand, i need to create a video, what do i need to create developer android app company, who do i need to create xml feed, i need to create a logo for my business, know i need to create website, how can i develop my own website or what do i need to create a website, how do i need to create online shopping website, how much do i need to create a website, how much money i need to create an ecommerce website, i need expert advice in excel, i need help create a fyler, i need to create a business logo, i need to create a concierge website, i need to create a design, i need to create a flyer, i need to create a leave excel sheet, i need to create a logo, i need to create a logo for free, i need to create a logo for my shope

Tietoa työnantajasta:
( 0 arvostelua ) Summerfield, United States

Projektin tunnus: #20236745

Myönnetty käyttäjälle:

mateenbhatti94

Dear sir I have read the requirements and completely understand the project.I have checked the description and in that excel there will macros that will do all of this job and it will give you final results. I have be Lisää

$150 USD 1 päivässä
(69 Arvostelua)
6.1

9 freelanceria on tarjonnut keskimäärin 161$ tähän työhön

zekovicm

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 Lisää

$220 USD 4 päivässä
(117 arvostelua)
7.2
elqueabandona

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 proje Lisää

$250 USD 7 päivässä
(224 arvostelua)
6.9
younus15

I can do your project according to your description (If your project is Excel with formulas) with full delivery and without error. I would also complete your project with the highest precision and quality. We have exte Lisää

$100 USD 6 päivässä
(107 arvostelua)
5.9
usmanhassan123

Having seven years of experience in Excel vba and Excel macros. I already done many Excel complex projects like: Excel models designing. Excel dashboards designing. Excel Reporting systems. Excel complex calculat Lisää

$250 USD 1 päivässä
(90 arvostelua)
6.2
valor312

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/projects/excel/Build-apprais Lisää

$69 USD 3 päivässä
(34 arvostelua)
5.3
susanna2018

⭐⭐⭐ Hi, Dear client. ⭐⭐⭐ I'm very interested your project. I read your description carefully. I'm very talented Excel & VBA developer. if you assign to me this project, you can get a cool result. please contact me Lisää

$120 USD 7 päivässä
(7 arvostelua)
3.4
holdenzorianna

Proven track record. Innate data skills.

$138 USD 2 päivässä
(0 arvostelua)
0.0
$155 USD 3 päivässä
(0 arvostelua)
0.0