Scribd
Upload
77 views

9. Product Sales Forecasting. Xlsx

The document presents sales data for Products A and B from January 2023 to December 2025, showing a consistent upward trend in sales for both products. It includes average sales calculations, a trend analysis, and a linear forecast for early 2024. Additionally, it outlines different profit scenarios based on varying book printing costs and sale prices, providing a summary of expected profits under different cases.

Uploaded by

Shreya Goyal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
77 views

9. Product Sales Forecasting. Xlsx

The document presents sales data for Products A and B from January 2023 to December 2025, showing a consistent upward trend in sales for both products. It includes average sales calculations, a trend analysis, and a linear forecast for early 2024. Additionally, it outlines different profit scenarios based on varying book printing costs and sale prices, providing a summary of expected profits under different cases.

Uploaded by

Shreya Goyal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Seasonality Adjustment

Year Month Product A Sales Product B Sales


2023 Jan 100 180
2023 Feb 130 220
2023 Mar 160 250
2023 Apr 190 280
2023 May 220 310
2023 Jun 250 340
2023 Jul 280 370
2023 Aug 310 400
2023 Sep 340 430
2023 Oct 370 460
2023 Nov 400 490
2023 Dec 430 520
2024 Jan 500 550
2024 Feb 550 580
2024 Mar 600 610
2024 Apr 650 640
2024 May 700 670
2024 Jun 750 700
2024 Jul 800 730
2024 Aug 850 760
2024 Sep 900 790
2024 Oct 950 820
2024 Nov 1000 850
2024 Dec 1050 880
2025 Jan 1100 935
2025 Feb 1150 940
2025 Mar 1200 970
2025 Apr 1250 1000
2025 May 1300 1030
2025 Jun 1350 1060
2025 Jul 1400 1090
2025 Aug 1450 1120
2025 Sep 1500 1150
2025 Oct 1550 1180
2025 Nov 1600 1210
2025 Dec 1650 1240
AVERAGE IF 566.67 555.00
This gave you the average sales for all Januaries in the data.
Data entry and formating
Trend analysis
Line chart
Sales data for pro
1200
Month/Year Product A Sales Product B Sales
Jan-24 465 336 1000
Feb-24 831 354
Mar-24 525 183 800
Apr-24 973 404
May-24 495 369 600
Jun-24 295 544
400
Jul-24 528 320
Aug-24 936 300
200
Sep-24 176 955
Oct-24 416 313 0
Nov-24 773 381 Jan-24 Feb-24Mar-24 Apr-24May-24 Jun-24 Jul
Dec-24 712 298
Product A Sales
FORECAST.LINEAR 612.6739688072 337.2464318849
Sales data for product A & B

Feb-24Mar-24 Apr-24May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24

Product A Sales Product B Sales


Case No. of Books cost to print sale price profit
worse case 10 18 180 20 20
expected case 100 13 1300 20 700
best case 500 10 5000 20 5000
profit %
11.11%
53.85%
100.00%
Scenario Summary
Current Values: worse case expected best case
Changing Cells:
$B$4 10 10 10 10
$C$4 18 18 18 18
$B$5 100 100 100 100
$C$5 13 13 13 13
$B$6 500 500 500 500
$C$6 10 10 10 10
Result Cells:
$G$4 11.11% 11.11% 53.85% 100.00%
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.

You might also like