Explore BrainMass

# Pricing Project: Weighted Average Price

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

Please see ** ATTACHED ** file(s) for complete details!!

© BrainMass Inc. brainmass.com October 2, 2020, 12:33 am ad1c9bdddf

#### Solution Preview

++++++++++++++++++++
PROBLEM

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 kegs sold at the brewery 200 (Estimated, could be ...

#### Solution Summary

The solution examines pricing projects and the weighted average price.

\$2.19