Question

How do I calculate the following:

Sales and MD Planning Spring 2020				All sales are in millions	Sales provided are based on Spring 2019 due to the pandemic
Apparel-
Seasonal Planned Sales % change				2.15%
	TY Sales $	LY Sales $	TY Sales % To Total Season	LY Sales % To Total Season	% Change	MD % TY	MD $ TY	MD % LY	MD $ LY
Feb		$998.5						29.2%
March		$1,135.6						34.6%
April		$1,057.9						44.0%
May		$2,245.7						68.9%
June		$2,950.0						85.2%
July		$3,210.2						108.0%
Total		$11,597.9

Answer 1

Hi

Pls see below snips for understanding.

Snip 1: Shows the forumulas that have been used in excel to solve.

Snip 2: Shows the answer.

Before proceeding, since the question did not say anything about 2.15% whether it's a increase or decrease, I assumed that the % change in sales is an increase each month.

Snip 1: Shows the forumulas that have been used in excel to solve.

E5 fr A B с D E F i.e 2019 Sales Total change TY 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Feb March April May June July Total Change % 0.0215 =F6*$C$5 =F7*$C$5 =F8*$C$5 =F9*$C$5 =F10*$C$5 =F11*$C$5 =F12*$C$5 =C6+F6 =C7+F7 =C8+F8 =C9+F9 =C10+F10 =C11+F11 =C12+F12 LY Sales $ 998.5 1135.6 1057.9 2245.7 2950 3210.2 11597.9

Snip 2: Shows the answer.

Clipboard Font Alignment Number 34 X fx A B D E F G H 1 J 1 2 3 1 i.e 2019 Sales 7 3 Feb March April May June July Total Change % 2.15% 21.47 24.42 22.74 48.28 63.43 69.02 249.35 Total change TY 1,019.97 1,160.02 1,080.64 2,293.98 3,013.43 3,279.22 11,847.25 LY Sales $ 998.5 1,135.6 1,057.9 2,245.7 2,950.0 3,210.2 11,597.9 0 1 2. 3 4 5 6 7