Total Volume Seasonal Planned Sales % change				3.30%
	TY Planned Sales $	2021 Actual Sales $	TY Plan Sales % To Total Season	LY Actual Sales % To Total Season	Planned % Change YOY (2022 v. 2021)
Feb	#4	$753.2	#3	#2	#5
March		$988.5
April		$1,067.9
May		$3,335.8
June		$3,464.2
July		$2,455.0
Total	#1	$12,064.6	100%	100%	3.30%

STEPS	ALL HIGHLIGHTED AREAS (#1 through 5) ON THE CHART MUST BE COMPLETED
#1	Based on the Total Volume Seasonal Planned Sales % change( highlighted in yellow), calculate TY Planned Sales $ Total.
#2	Calculate LY Actual Sales % to total season by month.
#3	Plan TY Sales % to Total season by month.(create the percents yourself)
#4	Calculate TY Planned $ dollars by month based on the percents you created in Step #3.
#5	After Steps #1 through 4 are complete, calculate each months Planned % Change YOY (year -on-year) of Sales $ (2021 to 2022.)

Please help and show all work, not the formulas used in excel spreadsheet. I need to know how to work this out on paper. What formulas do I use to get my answers. thanks in advance