Review the "Sales Forecast" below and the "Excel Sales Forecast". Then critically analyze them both. Please give the analysis!

Sales Forecast

Secondary research has determined monthly sales for Urban Woof to follow a trend of monthly pet food sales in Canada. According to Statista, there is a trend that pet food sales have every year (see Appendix P). Using this data, we have estimated how many sales per unit our start-up company will have within the first 12 months. Also, Stats Canada shows the average dollar revenue per year of low quartile shops (StatsCan, 2019).

We have computed our yearly estimated sales in units and our monthly dollar sales. Our total annual estimated unit sales are 4971 units which equals $316,500 (see Appendix Q). However, our monthly total dollar sales have equaled $317,825 (see Appendix Q). We assume this slight deviation is due to rounded up dollars and cents from calculations.

Pricing is based on brands that we have URBAN WOOF: PREMIUM NATURAL DOG FOOD 9 decided to carry. Since pricing is highly competitive, our stores pricing is similar to that as of True Carnivores (True Carnivores, 2020).

We forecast monthly sales to start slow in January considering that is the month we open, slow sales in February, and for sales to begin ramping up as brand awareness grows. Sales remain consistent until September, and then jump considerably towards the end of year in December (see Appendix P):

January - $6,356

February - $8,051

March - $14,831

April - $13,348

May - $15,891

June - $18,433

July - $19,069

August - $20,340

September - $31,782

October - $38,139

November - $48,733

December - $82,846

Excel Sales Forecast

MONTHLY UNIT SALES aresereseserasesesese ANNUAL UNIT \& DOLLAR SALES Where did prices come from? \begin{tabular}{|r|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{} & & & & \\ \hline \multicolumn{1}{|l|}{ Sales forecast Anually } & Units sold & \multicolumn{1}{l|}{ Price } & \multicolumn{2}{l|}{ total sales } & percentage \\ \hline Dry food & 1500 & 43.45 & $65,199.00 & 20.60% \\ \hline Wet food & 552 & 93.95 & $51,906.00 & 16.40% \\ \hline Raw Food & 1748 & 55.95 & $97,798.50 & 30.90% \\ \hline Snacks & 1171 & 87.95 & $103,020.75 & 32.55% \\ \hline TOTAL SALES & & 4971 & & $316,500.00 & 100% \\ \hline \end{tabular}