Question: 1. In the table below, you have been given the Percent of Annual Sales by Period contribution for the Kids Clothing Department. Percent (%) of
1. In the table below, you have been given the Percent of Annual Sales by Period contribution for the Kids Clothing Department. Percent (%) of Annual Sales by Period, Kids Clothing Department % of Annual Sales Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Jan Total Year 4.0% 6.0% 8.0% 9.0% 10.0% 8.0% 13.0% 9.0% 8.0% 9.0% 11.0% 5.0% 100.0% You have been provided with the following information. In the Excel worksheet, complete the following sales forecasts. a) Actual sales for August are $ 1,235,965. What are the total forecasted annual sales? b) Based on the forecasted annual sales you calculated in question A, what are the forecasted sales for November
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
