You are required to plan sales for the Spring Season this year and you know that you must

acknowledge the Easter Holiday shift when planning sales for March and April. Easter is a

moving holiday that changes dates each year and often changes months. To help you in your

planning, you gathered the following information about sales last year:

$$ Easter was in April last year.

$$ Sales in the month of April last year: $$575,086$

$$ April has $4$ fiscal weeks in the period.

$$ Stores are open $7$ days a week except for Good Friday and Easter Sunday.

$$ Sales in the month of March last year: $$639,605.$

$$ March has $5$ fiscal weeks in the period.

This year, Easter will be in March. You are expecting no sales change for March and April

combined this year over last year. In the Excel worksheet, calculate:

i$.$ March Planned $ Sales TY$,$ and $\%$ chg to LY

ii$.$ April Planned $ Sales TY$,$ and $\%$ chg to LY