Question: Please answer in excel format with formulas included. 1. Complete the following spreadsheet. (a) What was the sales total for the season last year? (b)

Please answer in excel format with formulasPlease answer in excel format with formulas included.

1. Complete the following spreadsheet. (a) What was the sales total for the season last year? (b) What was the percent of sales for each month last year? (c) If the goal is to gain a 1.3% increase in season sales next year, what are the planned season sales? (d) What is the percentage change in sales for each month? (6 pts) FALL SALES August September October November December January SEASON TOTAL $43,856 $47,023 $36,224 $49,216 $60,989 $39,099 LY Sales PL Sales % Change % of LY Sales % of PL Sales 16.00% 17.00% 13.00% 18.00% 22.00% 14.00%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!