Create single company-wide contribution margin income

Assignment Help Accounting Basics
Reference no: EM131590058

Problem -

A Votre Santé (AVS) is a small, independent winery owned by Kay Aproveche. Kay has a relationship with a grower who grows two types of wine grapes, a Chardonnay and a generic white grape. AVS buys the grapes at the point at which they have ripened on the vine. AVS is responsible for harvesting the grapes and all further processing of the grapes into wine. In 2010, AVS earned an operating margin of almost $100,000 on sales of $848,000, for an 11.6% margin. The process of winemaking is fairly simple, yet requires much attention to process details. After the grapes are harvested, they are brought to the winery for washing and crushing. The crushing process separates the juice from the pulp, skin, and stems. The juice is used to make the wine; the pulp, skin, and stems are recycled back onto the fields whenever possible or otherwise disposed of. The amount of wine generated from the grapes is dependent each year on a number of climatic and growing factors such as temperature, length of growing season, rootstock, and fertilizers used.

Once the juice is extracted, it moves into the fermenting process. The Chardonnay wine grape is fermented using oak barrels; the oak in the barrels gives flavor to the Chardonnay wine. The barrels are expensive ($500 each), but are sold after four years for $200 apiece to another smaller winery. The juice fermenting in each barrel results in the production of 40 cases of wine. The generic white grape juices are fermented in a holding tank; a full tank would result in the production of 1,500 cases of wine. The fermenting process takes place in a temperature-controlled environment; however, each fermenting method results in some wine loss through evaporation. Kay Aproveche estimates that the Chardonnay will lose approximately 10% of its volume through the fermentation process, while the generic white will lose approximately 5% of its volume. Harvest takes place in the late summer and early fall months; typically, the time elapsed from harvest to final sale is about 11 months.

AVS bottles three wines: a Chardonnay-Estate, a regular Chardonnay, and a Blanc de Blanc. Data related to the three wines is as follows:

  • Chardonnay-Estate contains only Chardonnay grapes that are grown for AVS; the expected sales price is $22/bottle. The market demand for Chardonnay-Estate wine is estimated to be 24,000 bottles for 2010.
  • Regular Chardonnay is blended by combining the Chardonnay wine left over after bottling the

Chardonnay-Estate with the fermented generic wine; the blend mixture is two parts Chardonnay grapes (after fermentation) and one part generic grapes (after fermentation). The different grapes are fermented separately and blended at the end. The expected sales price is $16/bottle.

  • Blanc de Blanc wine is made from all remaining generic white grapes; the expected sales price is $11/bottle.

All three wines are bottled at AVS using one bottling line. In a typical year, AVS bottles enough

Chardonnay-Estate to meet the predicted market demand, then bottles the regular Chardonnay after blending all remaining Chardonnay wine with the necessary amount of generic grapes. The

Blanc de Blanc is the last wine to be bottled, using all remaining generic white grapes. Kay again expects the wines from this harvest year to sell out.

Additional Operational and Cost Data

Chardonnay Grapes

  • 2009 harvest: 100,000 pounds
  • Purchase price of $85,500
  • Expected loss in volume through fermentation and bottling: 10%

Generic White Grapes

  • 2009 harvest: 60,000 pounds
  • Purchase price of $38,500
  • Expected loss in volume through fermentation and bottling: 5%

Winemaking

  • Chardonnay grapes are fermented in oak barrels; each barrel results in the production of 40 cases of wine.
  • Barrels cost $500 apiece, and can be used for four years and sold for $200 each at the end of four years; assume that you have to purchase all new barrels for the 2009 harvest. The barrels are depreciated over 4 years.
  • Generic white grapes are fermented in the holding tank; the tank can hold up to the equivalent of 1,500 cases of wine.

Bottling

  • Requires 36 pounds of grapes (post-fermenting) for one case (12 bottles) of wine.
  • In the bottling process, the wine is put into bottles, with both corks and labels added during this process. The materials costs associated with the bottles, corks, and labels are estimated to be $2.50/bottle.

Direct Labor

  • Harvest labor is paid an average of $7.25/hour. It is estimated that 80 pounds of grapes can be harvested each hour.
  • Crush labor is paid an average of $8.00/hour. It is estimated that it will take 300 hours to crush the grape harvest.

Overhead Expenses

  • Administrative rent and office expenses: estimated to be $20,000/year.
  • Depreciation is charged based on the following equipment schedule:
  • Indirect materials: Part of the winemaking process involves introducing yeasts and other additives into the wine to help the fermentation process and to help balance the flavors in the wine.

Indirect production materials average $1.55 per case of wine.

  • Lab expenses: Lab expenses of $8,000 are incurred for lab supplies and equipment. The lab is used by the production supervisor and the wine master to test the grapes and wine at various stages of production.
  • Liquor taxes: AVS is required to pay a liquor excise tax of $3/bottle on every bottle of wine sold.
  • Production office: AVS pays a part-time person to help administer the production function. This person orders supplies, reviews and approves production invoices, and performs other administrative functions. The production office budget is estimated to be a flat rate of $12,000.
  • Sales and related: Kay's sister, Maria, is paid $30,000/year on a contract basis to sell AVS wines.

She works through distributors, who are paid $2/bottle for each bottle sold.

  • Supervision: Kay's brother, Luis, supervises the production of wine from the harvest through the bottling processes. His salary and benefits total $55,000 annually.
  • Utilities: Utility costs are incurred primarily to maintain a constant temperature in the fermenting process. These are expected to be $5,500.
  • Waste treatment: After crushing, the pulp, skins, and stems that are left over must be disposed of. One-half of the waste can be recycled back onto the fields as a compost material; the other one-half must be disposed of at a landfill dumping cost of $2,000.
  • A wine master is employed to help formulate and test the wines. This is done on a contract basis;

AVS pays the wine master $5,000 for each type of wine that is formulated.

  • Kay's role is to manage the AVS business. Her annual salary and benefits total $75,000.

Required

(a) Create a single company-wide contribution margin income statement (as in the "Total" column in Exhibit 3-6) for AVS that includes each expense category. Also calculate the average revenue and net income for one bottle of wine. (Note: Do not break out the variable or fixed costs by type of wine.)

(b) Another grower has available 20,000 pounds of Chardonnay grapes from the 2009 harvest.

AVS has the opportunity to buy the juice from these grapes (they have already been harvested and crushed). If AVS could blend these grapes with the generic white grapes (using the 2:1 blend formula) to produce a new Chardonnay wine to be priced at $14/bottle, and require a 15% return on sales for this wine, what is the maximum amount that AVS would pay for a pound of Chardonnay grapes?

(c) Other than the cost of the grapes seen in part b, what factors would you consider to support your purchase of the grapes, and what factors would cause you to reject buying the grapes?

Reference no: EM131590058

Questions Cloud

Discuss what advocacy activities are currently taking place : Discuss what advocacy activities are currently taking place.How might these activities be consistent with or contradict points made in the article.
Identifying problems and solution strategies : To revise and reinforce subject content taught up to and including week 5. This assessment contributes to Learning Outcome
Difference between actual and standard overhead costs : What is the difference between actual overhead costs and standard overhead costs allocated to products
Five year period which ends with the sale of the machine : What is the after-tax equivalent annual worth of this investment over the five year period which ends with the sale of the machine?
Create single company-wide contribution margin income : Create a single company-wide contribution margin income statement for AVS that includes each expense category
How to report suspected child abuse in the state of texas : Explain the procedure for reporting suspected child abuse in your state.
Examine the economics of the pharmaceutical industry : Examine the economics of the pharmaceutical industry. How has this regulatory change affected the market for pharmaceuticals?
How does this topic impact the individuals family : What is the impact to cognitive, social, emotional, relationship, and/or moral dimensions of development?At what age and stage does this issue typically impact?
Indicate tamil diaspora has created transitional government : In your view, what does he mean? Do you believe this to be a correct statement? Explain why you agree or don't agree.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Show how the balance will appear in the balance sheet

A. Jones bought a motor car on Hire Purchase terms from M.B.J. Ltd. on the 1st January, 1959. The H.P. Price was £2,075 payable by an immediate deposit of £500.

  Calculate the unit manufacturing cost of the us and eu

wedig diagnostics manufactures two laser photometers that are used in preparing dna tests. the u.s. model is designed

  Gross profit ratio

Dexter Inc. recorded net sales of $50,000 during the period, and its cost of goods sold amounted to $30,000. Compute the company's gross profit ratio.

  Stock in red corporation

On September 3, 2009, Able purchased S 1244 stock in Red Corporation for $6,000. On December 31, 2009 the stock was worth $8,500. On August 15,2010 Able was notified that the stock was worthless. How should able report this item on his 2009 and 20..

  Madlem inc produces and sells a single product whose

madlem inc. produces and sells a single product whose selling price is 240.00 per unit and whose variable expense is

  What is the amount of the purchasing costs

What is the amount of the purchasing costs that should be allocated to Vendor B, assuming Rogers uses number of shipments received to compute activity-based costs?

  Mario and john, who run the best barber

Mario and John, who run the best barber shop in Westchester, decided to expand their business. They sold their old equipment and moved to larger quarters in the Arcadian Mall, doing business as the Arcadian Barber Shop.

  Determine the missing amounts

At the beginning of 2011, Quentin and Kopps (Q&K) adopted the dollar-value LIFO (DVL) inventory method.

  A company needs to estimate its ending inventory using the

a company needs to estimate its ending inventory. using the data below compute the companys estimated cost of ending

  Kind exchange except for amount of boot

Assume that this transfer qualifies as a like-kind exchange except for the amount of boot (if any). Bert assumes the $240,000 mortgage on the strip mall. Show your work!

  Determine the amount of reliant schedule

Reliant Corp., an accrual-basis calendar-year C corporation, filed its 2016 federal income tax return on April 15, 2017.

  Tax position of the parties

a. Calculate Elisa and Clyde's AGI. b. Can Chelsie deduct the $1,000 payment on her tax return? Explain. c. How could the tax position of the parties be improved?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd