Forecasting - How to use given numbers?

{content deleted by user.}

Please do NOT delete posts - even if you dont like the response you get. I am reinstating your deleted posts, further occurrences could result in your privileges being suspended.

Hi all - have a homework assignment involving forecasting.
- We're given transactions and revenue for four months in 2022 (Apr - Jul), and need to forecast those values for the 2023 fiscal year (Apr - Mar). In a new tab.
- We're also given a tab with the number of passengers who board a plane per month. 23-24 is a projection based on the decimals below, which are ratios of the total in O7.

I know how to use the Data --> Forecast Sheet tool, where you select both the date cells and the value cells, select the dates to forecast, and can create a new results tab with forecasted values. I also know about the FORECAST function.

I'm curious how I'd use the data in the "People Boarding Planes" tab to forecast the revenue and transaction data. And what would be the most efficient way to complete this problem?

Appreciate any help!

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

{content deleted by user.}

Modified the title to include tutoring/coaching.
Leaning how to use forecasting to solve with the given numbers was my question. Never just asked for the answer. Thanks!

How much of this is an Excel/spreadsheet specific question, and how much is a broader financial model question? This

I'm curious how I'd use the data in the "People Boarding Planes" tab to forecast the revenue and transaction data.

seems more about the overall financial model and doesn't seem specific to the chosen programming language (spreadsheet/Excel in this case) that you are using to perform the analysis. I spent a few minutes trying to reverse engineer the spreadsheet, but there's a lot in the file that just overwhelmed me.

We are usually pretty good at Excel/spreadsheet programming stuff, but we don't often have the expertise needed to develop a data model. I can kind of see how "number of people boarding planes" would possibly be part of a "transaction and revenue" projection for someone in the airline industry. We will likely need you to help us understand in more detail how you want to connect those two parts of the analysis before we can help you program those into the spreadsheet.