Results 1 to 4 of 4

Forecasting - How to use given numbers?

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2022
    Location
    United States
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20148) 64-bit
    Posts
    2

    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!
    Last edited by FDibbins; 09-26-2022 at 12:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with forecasting
    By rob.callaghan in forum Excel General
    Replies: 4
    Last Post: 10-12-2017, 09:09 AM
  2. Forecasting
    By rs1aj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2014, 02:27 PM
  3. [SOLVED] Forecasting
    By dianaschar in forum Excel General
    Replies: 4
    Last Post: 10-21-2013, 10:26 AM
  4. Forecasting
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2013, 02:34 PM
  5. Forecasting
    By Figboot in forum Excel General
    Replies: 2
    Last Post: 08-07-2010, 05:15 PM
  6. Replies: 3
    Last Post: 03-20-2009, 02:48 AM
  7. help with forecasting
    By superspurs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2009, 05:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1