Subject: Economics   / Macroeconomics
Question
Golden Star Winery Case
Using Excel, prepare a graph showing the breakeven point and any profit or loss at the current price of $7. Explain to the Golden Star management the implications of this analysis.
Let us separate out fixed and variable expenses first.
Fixed Expenses
Fixed Manufacturing expenses   $45,000
Advertising   $10,000
Fixed adminsitrative/selling expenses   $15,000
Total
$70,000
Variable Expenses
Materials   $180,000
Labor   $225,000
Delivery   $30,000
Commissions   $50,000
Travel   $5,000
Total   $490,000

