During the primordial beginnings of the sixth month, between the ninth and eleventh hour, we undertook a punctilious excursion: spending our time fastidiously beefing up our analysis by crafting an Excel table representing the customer acquisition cost given certain variables (price per deal, semi-burdened cost of hiring a salesperson, commission rates, marketing expenses, and dead period length). Today we mainly focused on forging multi-imbedded IF statements in Excel to show how a variable dead period length would alter the marketing expenses, sales expenses, new customers, and CAC over 12 months. In the afternoon, we hope to use our data to show how gradual yearly changes in the input variables change the CAC.
