Reference no: EM13221405
Golden Star Winery produces midlevel wines consumed primarily in North America. Given below is the projected income statement for the company for 2011. Projected Income Statement (2011) Sales (100,000 cases at $7 per case) $700,000 Cost of goods sold: Materials $180,000 Labor $225,000 Fixed manufacturing expenses $45,000 Administrative and selling expenses: Delivery $30,000 Commissions $50,000 Advertising $10,000 Travel $5,000 Fixed administrative and selling expenses $15,000 Total expenses $560,000 Net income before taxes $140,000 Create a report answering the following questions:
Complete the following table in a fully functional Microsoft Excel spreadsheet. Price Quantity Total Revenue Total Variable Cost Total Fixed Cost Total Cost Profit $8.00 65,000 $7.75 75,000 $7.50 80,000 $7.25 90,000 $7.00 100,000 $6.75 115,000 $6.50 120,000
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.
What is the elasticity coefficient for each price between $6.50 and $7.50? Is the demand elastic or inelastic at these points? How can this information be useful to management in its pricing and output decisions?
On the basis of your calculations and the information above, what recommendations would you make to Golden Star in terms of price and output levels?
|
Explain saturated solution of sodium hydrogen carbonate
: Calculate the molarity of a saturated solution of sodium hydrogen carbonate, NaHCO3 (aq) that contains 69.0 grams in 1.00 liter of solution.
|
|
What might happen if apple cannot recoup its losses
: From a managerial perspective, what happened and why? Also, why is it so important for Apple to increase its market value? What might happen if Apple cannot recoup its losses? Thoughts on Director and Executive compensation at Apple?
|
|
Explain the vapor pressure of its isomer n-butanol
: At 25?°C, the vapor pressure of diethyl ether is higher than the vapor pressure of its isomer n-butanol, because A. diethyl ether has a higher density than n-butanol.
|
|
Prepare your recommendation for bushwood
: Prepare your recommendation for Bushwood if their objective is to minimize costs. Assume that service times for each option follow exponential distributions.
|
|
Determine what is the elasticity coefficient for each price
: Golden Star Winery produces midlevel wines consumed primarily in North America. Given below is the projected income statement for the company for 2011. Projected Income Statement (2011) Sales (100,000 cases at $7 per case) $700,000 Cost of goods s..
|
|
Explain what mass of ko2 in grams is required to react
: what mass of KO2 in grams is required to react with 8.90-L of CO2 at 22.0 C and 767mm Hg? first calculate the number of moles of CO2 (R=0.08026 L*atoms/ mol*K) find moles of Co2 and mass of KO2 in grams?
|
|
Key issues and obligations as moral challenges
: What are the key issues and obligations as moral challenges including associated risks, dangers, uncertaintles and/or opportunities and what are the competing moral claims and obligations and how will you assess and prioritize them?
|
|
Discuss why social optima are hard to achieve
: Definitions of externality and public goods, Source of inefficiency under externalities and public good, find the socially optimum output if there is negative externality and suggest policies to attain this social optimum. Be able to discuss why s..
|
|
Describe how occupation affects morbidity and mortality
: Describe how occupation affects morbidity and mortality.
|