Analyzing Creative Cake Revenue: Sales, Costs, and Contributions

W03 Practice Exercise Creative Cake Revenue Section and Key Creative Cakes Projected Profit and Loss Statement For the Period of January 1 - December 31 20XX CLV - CA Assumptionscakes Sales Average Cake Price$ 25 cakes/custo Average Cake Cost$ 14 Gross profi Cakes Per Customer1.0 cakes Con Subscription Rate8%Subscriptio Average Number Months Subscribed6 Subscriptio Average Subscription Price$ 4.99 Subscriber Initial Number of Clicks Per Month750 Months of Conversion Rate10%<-- Name this cellSubscript Growth Rate Per Month0.3%Customer L Cost Per Click$ 0.65 Customer A Contributio 1234 Sales in unitsJanFebMarApr PPC Clicks750 752 755 757 Number of Cakes Sold 75 75 75 76 New Subscriptions this Month6 6 6 6 Subscriptions Ended this Month- - - - Subscriptions Sold Each Month6 12 18 24 Revenue Subscription Sales$ 30 $ 60 $ 90 $ 120 Cake Sales 1875188118861892 Total Sales1905194119762012 Cost of Goods Sold1850185618611867 Gross Profit$ 55 $ 85 $ 115 $ 145