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
Expert's Answer
Chat with our Experts
Want to contact us directly? No Problem. We are always here for you
Your future, our responsibilty submit your task on time.
Order NowGet Online
Assignment Help Services