Encerrado

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

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

Habilidades: Processamento de dados, Excel, Matemática, Estatísticas, Visual Basic

Veja mais: 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

Acerca do Empregador:
( 1 comentário ) Summerfield, United States

ID do Projeto: #20264684

16 freelancers estão ofertando em média $172 para esse trabalho

schoudhary1553

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. Pl Mais

$220 USD in 5 dias
(342 Comentários)
7.9
liveexperts123

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 Mais

$155 USD in 3 dias
(76 Comentários)
7.2
Tanmoy236

"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 maj Mais

$200 USD in 7 dias
(226 Comentários)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Mais

$155 USD in 3 dias
(86 Comentários)
6.6
dinhfreedom

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 t Mais

$200 USD in 7 dias
(61 Comentários)
6.4
MohsanEijaz

I am excel vba expert, I am interested in your project. please review my profile. Mohsan

$250 USD in 2 dias
(83 Comentários)
6.3
umg536

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 Mais

$155 USD in 3 dias
(10 Comentários)
5.2
ninestar801

Hi, Hope you are doing well! I would like to work on your project. I have excellent in skills with more than 6 Years experience. I'm sure that I will complete with high quality in the shortest time. I am always availab Mais

$140 USD in 7 dias
(14 Comentários)
3.9
sergeyprince

Hello. I can do your project perfectly. I have got 8 years of rich experience in VBA. I can do VBA programming as fast as you want. I am Data Processing, Excel VBA Expert who knows the value of time, very hard workin Mais

$150 USD in 7 dias
(10 Comentários)
2.7
rabinusd

Hi, I think you need an accumulated depreciation system for your organization. Please chat with me for details. Thanks

$250 USD in 3 dias
(1 Comentário)
0.8
RachitGroup

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 Mais

$100 USD in 7 dias
(1 Comentário)
0.0
finest2019

Hello. I am an exporter in C, C++, C# fields. And my hobby is in math. In childhood, I have taken the best high Olympic competition several times. It would be interesting to see my profile. I have just read your propos Mais

$250 USD in 7 dias
(0 Comentários)
0.0
ERPGenius

[login to view URL] are you? I have just read your description carefully. As an experienced developer, I am sure that I can handle your project perfectly. Even If you don't hire me, I can give you my opinion related with this jo Mais

$140 USD in 7 dias
(0 Comentários)
0.0
VittorioLombardo

Hey. How are you today? I have got 5 years of rich experience in VBA and SPREATSHEET I can work urgently for you. Let us discuss and move ahead. I am ready to start. Please reply so that we can move ahead

$150 USD in 7 dias
(0 Comentários)
0.0
dhanicadawnlanab

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 Mais

$140 USD in 7 dias
(0 Comentários)
0.0
sjmaloney

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 dias
(0 Comentários)
0.0