Excel File for Marketing Metrics Case 3 - Breakeven Analysis \begin{tabular}{|l|ll|} \hline Retail Price per gram & $ & 9.00 \\ \hline \end{tabular} Table 1: Fire \& Flower's Business Costs \begin{tabular}{|l|lr|} \hline Cost of product per gram & $ & 5.00 \\ \hline Rent per month & $ & 2,800 \\ \hline Utilities per month & $ & 445 \\ \hline Salaries of employees per month & $ & 4,800 \\ \hline TOTAL Fixed Costs per month & $ & 8,045 \\ \hline \end{tabular} Calculate the Breakeven Point in Units: \begin{tabular}{|l|r|} \hline (Calculate) Grams to be sold per month to break even: & 2,011.3 \\ \hline (Rounded) Grams to be sold per month to break even: & 2,012 \\ \hline \end{tabular} Breakeven Revenue: \begin{tabular}{l|ll|} Calculate Total Revenue at Breakeven Point: & 5 & 18,108 \\ \hline \end{tabular} Table 2: New Supplier Scenario \begin{tabular}{|l|rr|} \hline Cost of product per gram & $ & 4.00 \\ \hline TOTAL Fixed Costs per month & $ & 8,045 \\ \hline Breakeven Point in Grams (calculated) & & 1,609.0 \\ \hline Breakeven Point in Grams (rounded) & & 1,609 \\ \hline \end{tabular} Table 3: New Location Scenario \begin{tabular}{|l|lr|} \hline Cost of product per gram & $ & 5.00 \\ \hline Rent per month & $ & 2,100 \\ \hline Utilities per month & $ & 445 \\ \hline Salaries of employees per month & $ & 4,800 \\ \hline TOTAL Fixed Costs per month & $ & 7,345 \\ \hline Breakeven Point in Grams (calculated) & & 1,836.3 \\ \hline Breakeven Point in Grams (rounded) & & 1,837 \\ \hline \end{tabular} Table 4: New Price Scenario \begin{tabular}{|l|rr|} \hline Retail Price per gram & $ & 9.45 \\ \hline Cost of product per gram & $ & 5.00 \\ \hline TOTAL Fixed Costs per month & $ & 8,045 \\ \hline Breakeven Point in Grams (calculated) & & 1,807.9 \\ \hline Breakeven Point in Grams (rounded) & & 1,808 \\ \hline & & \\ \cline { 2 - 2 } & & \end{tabular} List all other possible ideas for reducing the breakeven point quantity for the Fire & Flower store, other than changing location, finding a new supplier, or increasing price. Explain each idea. \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{32} & \multicolumn{4}{|c|}{ working with excel marketing metrics case two - conversion rate } & & \\ \hline & & & & & & \\ \hline 4 & Table 1: web analytics results & & & & & \\ \hline 5 & steps in the shopping process & \begin{tabular}{l} \# of people who \\ completed step \end{tabular} & \begin{tabular}{|l|} conversion rate \\ per step \end{tabular} & & & \\ \hline 6 & Visit Home page & 3,923 & N/A & & & \\ \hline 7 & Store page & 2,034 & 52% & & & \\ \hline 8 & \begin{tabular}{|l|} Add to Shopping Cart \\ \end{tabular} & 687 & 34% & & & \\ \hline 9 & Proceed to Checkout & 244 & 36% & & & \\ \hline 10 & Enter Shipping Address & 202 & 83% & & & \\ \hline 11 & Enter Billing Address & 183 & 91% & & & \\ \hline 12 & Enter Credit Card & 54 & 30% & & & \\ \hline 13 & Confirm Purchase & 52 & 96% & & & \\ \hline 14 & & & & & & \\ \hline 15 & \begin{tabular}{l} Which steps in the shopping pr \\ improve THREE of these conve \end{tabular} & \begin{tabular}{l} rocess are problem a \\ ersion rates, which w \end{tabular} & \begin{tabular}{l} areas for your e-st \\ vould you focus on \end{tabular} & \begin{tabular}{l} tore? If you could \\ n? \end{tabular} & only & \\ \hline 16 & & & & & & \\ \hline 17 & & & & & & \\ \hline 18 & & & & & & \\ \hline 19 & & & & & & \\ \hline 20 & & & & & & \\ \hline 21 & & & & & & \\ \hline 22 & & & & & & \\ \hline 23 & Table 2: overall conversion rate & & & & & \\ \hline 24 & steps in the shopping process & \begin{tabular}{l} \# of people who \\ completed step \end{tabular} & & & & \\ \hline 25 & Visit Home page & 3,923 & & & & \\ \hline 26 & Store page & 2,034 & & & & \\ \hline 27 & Add to Shopping Cart & 687 & & & & \\ \hline 28 & Proceed to Checkout & 244 & & & & \\ \hline 29 & \begin{tabular}{|l|l|} Enter Shipping Address \\ \end{tabular} & 202 & & & & \\ \hline 30 & Enter Billing Address & 183 & & & & \\ \hline 31 & Enter Credit Card & 54 & overall conversio & ion rate: & & \\ \hline 32 & Confirm Purchase & 52 & 1.33% & & & \\ \hline 33 & & & & & & \\ \hline 34 & Table 3: Break-even Scenario & & & & & \\ \hline 35 & steps in the shopping process & \begin{tabular}{l} \# of people who \\ completed step \end{tabular} & \begin{tabular}{|l|} conversion rate \\ per step \end{tabular} & & & \\ \hline 36 & \begin{tabular}{|l|} Visit Home page \\ \end{tabular} & & N/A & 7,544.23 & & \\ \hline 37 & \begin{tabular}{l} Store page \\ \end{tabular} & & 52% & - These cells will & update a & utomatically once you po \\ \hline 38 & Add to Shopping Cart & & 34% & & & \\ \hline 39 & Proceed to Checkout & & 36% & & & \\ \hline 40 & Enter Shipping Address & & 83% & & & \\ \hline 41 & Enter Billing Address & & 91% & & & \\ \hline 42 & Enter Credit Card & & 30% & overall conversi & on rate: & \\ \hline 43 & Confirm Purchase & 100 & 96% & 1.33% &