AN ASSIGNMENT ON

“Comprehensive Assignment Report on Business Analytics (Including

Descriptive & Visualization, Dashboard, Decision-Making under
Uncertainty and Simulation, and Modeling & Forecasting)

PREPARED BY:

MEETGIRI GOSWAMI- 24SOMBA21469

FOR:
MBA SEM – 3 CIE II EXAMINATION

GUIDED BY:
Dr. KRISHNA VYAS

SUBJECT:
Business Analytics (MBC305)
 INDEX

Sr. No. Title of Assignment Type of Task Page No.

1 Descriptive and Visualization Excel-Based 2-6
Task

2 Dashboard Design and Development Excel-Based 7-7

Task

3 Decision Making under Uncertainty and Risk Hand Written Hand

& Simulation Techniques Task Written
Attached

4 Modeling and Forecasting Excel-Based 8 - 13

Task
 Assignment 1: Descriptive and Visualization (Excel-based task)

1. Foreign direct investment, net inflows (BoP, current US$) BENIN & BURKINA FASO

Country Code BENIN MEXICO

Foreign direct investment, net inflows Foreign direct investment, net inflows
Indicator Name
(BoP, current US$) (BoP, current US$)
Indicator Code [Link] [Link]
Country Name Benin Mexico
2020 174019952 11,90,00,00,00,000
2021 345985236 24,20,00,00,00,000
2022 375988902 18,90,00,00,00,000
2023 442960064 9,73,56,00,00,000
2024 543007400 15,60,00,00,00,000

LINE CHART & INTERPRETATION

FDI NET INFLOWS BOP,

CURRENT US$)
3E+12
2.5E+12
2E+12
1.5E+12
1E+12
5E+11
0
1 2 3 4 5

Year
FDI Net Inflows BoP, current US$) Benin
FDI Net Inflows BoP, current US$) Mexico

From 2020 to 2024, Benin’s FDI showed steady growth, rising from about US$174 million to US$543 million,
reflecting stable investor confidence and consistent economic progress. In contrast, Mexico’s FDI fluctuated
sharply—starting at US$11.9 billion in 2020, peaking at US$24.2 billion in 2021, then dropping to US$9.7
billion in 2023 before rebounding to US$15.6 billion in 2024. While Mexico attracted much larger inflows
overall, its investment pattern was volatile compared to Benin’s stable upward trend.
2. Foreign direct investment, net outflows (BoP, current US$) BENIN & BURKINA FASO

Country Code BENIN MEXICO

Indicator Name Foreign direct investment, net Foreign direct investment, net
outflows (BoP, current US$) outflows (BoP, current US$)
Indicator Code [Link] [Link]
Country Name Benin Burkina Faso
2020 21526689 10,10,00,00,00,000
2021 42902137 25,50,00,00,00,000
2022 46569698 21,90,00,00,00,000
2023 13009932 10,80,00,00,00,000
2024 60282780 17,50,00,00,00,000

LINE CHART & INTERPRETATION

FDI NET OUTFLOWS BOP,
CURRENT US$)
3E+12
2.5E+12
2E+12
1.5E+12
1E+12
5E+11
0
1 2 3 4 5

Year
FDI Net Outflows BoP, current US$) Benin
FDI Net Outflows BoP, current US$) Mexico

From 2020 to 2024, Benin’s FDI outflows remained relatively low but showed gradual growth,
increasing from about US$21.5 million in 2020 to US$60.3 million in 2024. This steady rise suggests
a slow but consistent expansion of Beninese investments abroad, reflecting growing participation in
international markets. In contrast, Mexico’s FDI outflows were significantly higher and more
volatile—rising sharply from US$10.1 billion in 2020 to a peak of US$25.5 billion in 2021, then
declining to US$10.8 billion in 2023 before rebounding to US$17.5 billion in 2024. While Benin’s
outward investment indicates gradual economic strengthening, Mexico’s large but fluctuating
outflows point to an active yet variable investment environment influenced by changing global and
domestic economic conditions.
 Comparison Of Inflow & Outflow for BENIN

Country Name Benin Benin

Foreign direct investment, net Foreign direct investment, net
Indicator Name
inflows (BoP, current US$) outflows (BoP, current US$)
2020 174019952 21526689
2021 345985236 42902137
2022 375988902 46569698
2023 442960064 13009932
2024 543007400 60282780

BAR CHART & INTERPRETATION

Foreign direct investment, net inflows (BoP, current

US$) and net outflows (BoP, current US$) for Benin
600000000

500000000

400000000
US$

300000000

200000000

100000000

0
1 2 3 4 5
Years

Series2 Series3

This chart compares foreign direct investment (FDI) net inflows and net outflows for Benin between
2020 and 2024. The most noticeable trend is that FDI inflows, represented by the orange bars, are
consistently and significantly higher than outflows, shown by the green bars. Benin’s inflows steadily
increase from around US$17 million in 2020 to about US$54 million in 2024, suggesting growing
foreign investor confidence and stronger economic attraction. In contrast, FDI outflows remain
relatively small throughout the period, fluctuating slightly but never approaching inflow levels.
Overall, Benin is clearly a net receiver of foreign investment, with inward investment growth far
outpacing the amount of capital invested abroad.
 Comparison of Inflow & Outflow for MEXICO

Country Name MEXICO MEXICO

Foreign direct investment, net Foreign direct investment, net
Indicator Name
inflows (BoP, current US$) outflows (BoP, current US$)
2020 11,90,00,00,00,000 10,10,00,00,00,000
2021 24,20,00,00,00,000 25,50,00,00,00,000
2022 18,90,00,00,00,000 21,90,00,00,00,000
2023 9,73,56,00,00,000 10,80,00,00,00,000
2024 15,60,00,00,00,000 17,50,00,00,00,000

Foreign direct investment,

net inflows (BoP, current
US$) and net outflows (BoP,
current US$) for Mexico
3E+12

2.5E+12

2E+12

1.5E+12

1E+12

5E+11

0
1 2 3 4 5

Country Name Indicator Name

Mexico Foreign direct investment, net inflows (BoP, current US$)
Mexico Foreign direct investment, net outflows (BoP, current US$)

From 2020 to 2024, Mexico’s FDI inflows and outflows both showed large volumes with notable fluctuations.
FDI inflows rose from about US$11.9 billion in 2020 to a peak of US$24.2 billion in 2021, then declined to
US$9.7 billion in 2023 before recovering to US$15.6 billion in 2024. Similarly, FDI outflows followed a
comparable pattern, increasing from US$10.1 billion in 2020 to US$25.5 billion in 2021, dropping to US$10.8
billion in 2023, and rising again to US$17.5 billion in 2024. These trends indicate that Mexico remains a
major participant in global investment flows—both as a destination and a source—but experiences high
volatility, reflecting sensitivity to global market conditions and shifts in domestic economic policies.
 Descriptive Statistics

Descriptive statistics
Benin Mexico
Mean 42851189574 Mean 1.60671E+12

Median 44727277563 Median 1.56E+12

Standard Deviation 15663304762 Standard Deviation 5.74108E+11

Range 37222511616 Range 1.44644E+12

Minimum 27139853378 Minimum 9.7356E+11

Maximum 64362364994 Maximum 2.42E+12

Coefficient of variation 2.45339E+20 Coefficient of 3.296E+23

variation

Descriptive statistics
Benin Mexico
Mean 42851189574 Mean 1.716E+12

Median 44727277563 Median 1.75E+12

Standard Deviation 15663304762 Standard Deviation 6.75337E+11

Range 37222511616 Range 1.54E+12

Minimum 27139853378 Minimum 1.01E+12

Maximum 64362364994 Maximum 2.55E+12

Coefficient of variation 2.45339E+20 Coefficient of 6.75337E+11

variation
Assignment 2: Dashboard (Excel-based task)
 Assignment 4: Modeling and Forecasting (Excel-based task)

Case 1 : FreshSip
Sales ('000 3-month SMA
Month Ad Spend ('000)
units) forecast
Jan 187 #N/A 42
Feb 202 #N/A 45
Mar 212 200.3333 47
Apr 231 215 51
May 250 231 55
Jun 258 246.3333 58
Jul 266 258 60
Aug 275 266.3333 62
Sep 288 276.3333 64
Oct 299 287.3333 67
Nov 313 300 71
Dec 324 312 74

FreshSip
400

350

300

250
Sales

200

150

100

50

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Months

Sales ('000 units) 3-month SMA forecast

 Business Insights
The chart shows that FreshSip’s sales increased steadily throughout the year, rising from about 180,000 units
in January to over 340,000 units in December. The 3-month SMA forecast closely follows this upward trend
but slightly lags behind the actual sales, indicating that demand is consistently growing faster than predicted.

For production and inventory planning, this suggests the need for a gradual increase in output and stock levels
each month to meet rising demand. Maintaining a small safety stock is advisable to prevent shortages,
especially during the latter half of the year. Overall, the consistent growth trend reflects stable market
expansion and supports steady production scaling.
 Case 2 : Speedo
Exponential
Sales Exponential smoothing
Month smoothing Ad Spend ('000)
('000 forecast α=0.5
forecast α=0.2
units)
Jan 128 #N/A #N/A 33
Feb 141 128 128 35
Mar 154 138.4 134.5 36
Apr 159 150.88 144.25 38
May 170 157.376 151.625 40
Jun 189 167.4752 160.8125 41
Jul 207 184.69504 174.9063 43
Aug 223 202.539008 190.9531 45
Sep 230 218.9078016 206.9766 48
Oct 235 227.7815603 218.4883 51
Nov 242 233.5563121 226.7441 52
Dec 253 240.3112624 234.3721 55

Speedo
300

250

200
Sales

150

100

50

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Months

Sales ('000 units)

Exponential smoothing forecast α=0.2
Exponential smoothing forecast α=0.5
 Business Interpretation
The exponential smoothing forecast with α = 0.2 gives a smoother short-term prediction. This lower alpha
value places more weight on past data and less on recent changes, resulting in a stable, less fluctuating forecast
line. In contrast, the α = 0.5 forecast responds more quickly to recent variations, making it better for capturing
short-term shifts but less smooth overall.

Based on the forecast trend showing consistent sales growth, Speedo should gradually increase its advertising
budget rather than making sudden spikes. A steady rise in marketing spending will support the upward sales
momentum without overspending. However, during peak sales months (e.g., late in the year), a slightly higher
budget allocation could help capitalize on growing demand and strengthen brand presence, ensuring sustained
sales growth.
 Case 3 : CozyHome
Sales ('000 units) Ad Spend ('000)
Month Month no.

Jan 101 28 1
Feb 106 29 2
Mar 112 32 3
Apr 124 35 4
May 135 36 5
Jun 142 39 6
Jul 153 42 7
Aug 162 43 8
Sep 166 45 9
Oct 179 46 10
Nov 187 49 11
Dec 201 51 12

Regression Statistics
Multiple R 0.9913344738
R Square 0.9827440389
Adjusted R Square 0.9789093809
Standard Error 3.844483091
Observations 12

ANOVA
Significance
df SS MS F F
Regression 2 9495.341033 4747.670516 875.4241949 4.28003E-10
Residual 8 43.38623989 5.423279987
Total 10 9538.727273

Coefficient Standard Lower Upper

s Error t Stat P-value Lower 95% Upper 95% 95.0% 95.0%
84.448110 26.909048 3.1382792 0.0138411 22.395732 146.50048 22.395732 146.50048
Intercept 87 83 98 38 99 88 99 88
9.1217620 2.2151727 4.1178559 0.0033541 4.0135646 14.229959 4.0135646 14.229959
1 85 19 16 01 36 54 36 54
- -
0.0798548 1.0405226 0.0767448 0.9407111 2.3195948 2.4793044 2.3195948 2.4793044
28 09 93 99 13 23 42 23 42
Forecast Next Month (Month = 13) Using Regression

 Regression Coefficients:
Intercept (a) = 84.45
Month Coefficient (b1) = 0.08
Ad Spend Coefficient (b2) = 9.12

We assume next month’s Ad Spend = $28,000

 Regression Equation:
Sales = a + b1 (Month No.) + b2 (Ad Spend)

 Step-by-Step Calculation:
Sales = 84.45 + 0.54 (Ad Spend) + 9.12(Month No.)
Sales = 84.45 + 0.54 (28) + 9.12(13)
Sales = 84.45 + 118.56 + 2.24
Sales = 205.25 (‘000 units)

Predicted Sales for next month (Month 13): 205.25 (‘000 units)

 Regression Output Interpretation:

The regression model shows that both ad spend and time (month number) have a positive impact on sales. The large
coefficient for ad spend (9.12) indicates that higher marketing investment leads to a strong rise in sales. Based on the
model, with an ad spend of $28,000 in month 13, the predicted sales are 205.25 (‘000 units), showing steady growth
and strong marketing effectiveness.
 Business Recommendations:
CozyHome should continue investing in advertising, as it has a major influence on increasing sales. The
company can also optimize ad strategies to get maximum returns from each dollar spent. Additionally,
planning consistent monthly campaigns can help maintain this upward sales trend and strengthen brand
presence in the market.