Attached is the spreadsheet we are supposed to complete.
However, I ran into a snag. My pretend company sells its beer in six-packs and kegs. Since there is a mixture, I am unsure how to calculate the break-even for the sales and the volume.
Thanks for your help!!
Please see ** ATTACHED ** file(s) for complete details!!
Thank you for using BM.
Below are my answers.
Anna Liza Gaspar
** ANSWERS: Please see attached file for answers.**
Estimation for Demand
Population in Philadelphia Proper 1,500,000 (Per Census Bureau)
50% are between 25 - 45 750,000 (Per Census Bureau)
25% are craft beer drinkers 187,500 (Assumption)
50% of the craft beer drinkers buy 1 six-pack 93,750 (Assumption)
Number of pubs in Philadelphia Proper Area 53 (Not affiliated with a brewery)
50% agree to carry Olde Towne craft beer 27 (Estimation)
Assume the turnover is one keg 2 times per month 648 kegs (Estimated)
Number of six-packs sold at the brewery 5,200 (Estimated, could be low)
Number of ...
The expert examines pricing projects and the weighted average price.