Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Total Volume Seasonal Planned Sales % change 3.30% TY Planned Sales $ 2021 Actual Sales $ TY Plan Sales % To Total Season LY Actual
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 | $753.2 | ||||
March | $988.5 | ||||
April | $1,067.9 | ||||
May | $3,335.8 | ||||
June | $3,464.2 | ||||
July | $2,455.0 | ||||
Total | $12,064.6 | 100% | 100% | 3.30% |
Please help and show all work. Thank you
#1 | Based on the Total Volume Seasonal Planned Sales % change( 3.30%), 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.) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started