Golden Star Winery Case

Question # 00001776 Posted By: expert-mustang Updated on: 09/29/2013 07:23 AM Due on: 09/29/2013
Subject Economics Topic General Economics Tutorials:
Question
Dot Image

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
Dot Image
Tutorials for this Question
  1. Tutorial # 00001619 Posted By: expert-mustang Posted on: 09/29/2013 07:23 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Solution to Golden Star Winery Case...
    Attachments
    Golden_Star_Winery_Case.xls (46.5 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    st...0110 Rating Professional and helpful tutors 07/12/2014

Great! We have found the solution of this question!

Whatsapp Lisa