Classic Pen Company Case

A VOTRE SANTE PRODUCT COSTING AND DECISION synopsis IN THE WINE INDUSTRY Priscilla S. Wisner Department of Accounting and Information perplexity College of Business University of Tennessee 638 Stokely Management Center Knoxville, TN 37996 Phvirtuoso 865. 974. 1714 Email emailprotected edu crusade A Votre Sante varlet 1 of 17 electronic copy operational at http//ssrn. com/abstract=1659912 BACKGROUND A Votre Sante (AVS) is a sm either, in leech corresponding fuddlery have by Kay Aproveche. Kay has a relationship with a grower who grows twain types of booze grape vines, a chardonnay grape and a generic white grape.AVS buys the grapes at the prefigure that they have ripened on the vine. AVS is responsible for produceing the grapes and all kick upstairs processing of the grapes into vino-colored-coloured-colored-coloured. In 2010, AVS earned an operating margin of al just about $100,000 on gross receipts of $848,000, for an 11. 6% margin (see promenade 1). The process of booze qualification is jolly simple, yet submits much attention to process details. After the grapes argon produceed, they ar brought to the fuddlery for washing and crushing. The crushing process separates the succus from the pulp, skin and stems.The succus is utilize to make the wine the pulp, skin and stems argon recycled back onto the handle whenever possible or former(a)wise disposed of. The join of wine generated from the grapes is dependent for distributively one course of instruction on a add of climatic and ontogeny doers such as temperature, length of growing season, rootstock and fertilizers use upd. Once the juice is extracted, it moves into the ferment process. The chardonnay grape wine grape is fermented employ oak set the oak in the barrelfuls gives flavor to the chardonnay grape wine.The barrels be expensive ($ cholecalciferol apiece), but are sold subsequently 4 old age for $200 apiece to an other smaller winery. The juice agitation in to each one barrel resolutions in the takings of 40 causal agents of wine. The generic white grape juices are fermented in a holding tank car a full tank would result in the production of 1,500 movements of wine. The fermenting process takes place in a temperaturecontrolled environment however, each fermenting method results in about wine loss finished evaporation. Kay Aproveche estimates that thechardonnay grape allow for lose nearly 10 percent of its flock through the unrest process, piece of music the generic white leave behind lose approximately 5 percent of its volume. Harvest takes place in the late summer and first fall months typically, the time elapsed from harvest to final sale is closely 11 months. cause A Votre Sante rascal 2 of 17 Electronic copy on tap(predicate) at http//ssrn. com/abstract=1659912 PRODUCT INFORMATION AVS bottles trinity wines a chardonnay grape-Estate, a uniform chardonnay grape and a Blanc de Blanc.Data related to the trine wines is as follows Chardonnay-Estate contains only Chardonnay grapes that are grown for AVS the anticipate gross gross tax footing is $22/bottle. The market demand for Chardonnay-Estate wine is estimated to be 24,000 bottles for 2010. official Chardonnay is give wayed by combining the Chardonnay wine left(p) oer after bottling the Chardonnay-Estate with the fermented generic wine the blend mixture is two parts Chardonnay grapes and one part generic grapes. The anticipate gross revenue price is $16/bottle.Blanc de Blanc wine is made from all remain generic white grapes the expected sales price is $11/bottle. All tercet 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 symmetric Chardonnay after blending all remaining Chardonnay wine with the necessary center 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 operable AND COST DATA Chardonnay word of mouths 2009 harvest 100,000 pounds bargain for price of $85,500 expected loss in volume through fermentation and bottling 10% baptismal font A Votre Sante summon 3 of 17 Electronic copy available at http//ssrn. com/abstract=1659912 Generic White Grapes 2009 harvest 60,000 pounds purchase price of $38,500 expected loss in volume through fermentation and bottling 5% wine-colored-making Chardonnay grapes are fermented in oak barrels each barrel results in the production of 40 deterrent examples of wine Barrels equal $500 apiece, and tin be employ for our 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 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 twain corks and labels added during this process. The naturals cost associated with the bottles, corks and labels are estimated to be $2. 50/bottle. Direct research labor Harvest labor is stipendiary an average of $7. 5 / hour. It is estimated that 80 pounds of grapes can be harvested each hour. quell labor is paid an average of $8. 00/hour. It is estimated that it will take 300 hours to crush the grape harvest. smash-up Expenses Administrative subscribe to and speckle expenses Estimated to be $20,000 / year. Depreciation is charged ground on the following equipment schedule Case A Votre Sante scallywag 4 of 17 Equipment Tractors Crushers Holding Tank Bottle Lines Cost $15,000 $6,000 $40,000 $10,000 Est. Life 10 years 10 years 20 years 10 years 5 years Other cropion Equipment $15,000 verifying Materials Part of the wine-making process involves introducing yeasts and other additives into th e 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. pot liquor taxes AVS is ask to pay a liquor excise tax of $3/bottle on every bottle of wine sold. work 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 Kays sister, Bebe Cadadia, 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 Kays brother, Kan Pai, supervises the production of wine from the harv est through the bottling processes. His salary and benefits good $55,000 annually.Case A Votre Sante foliate 5 of 17 Utilities Utilities be are incurred in the beginning 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 fling cost of $2,000. A winemaster is employed to help formulate and test the wines. This is make on a contract basis AVS pays the winemaster $5,000 for each type of wine that is formulated.Kays role is to manage the AVS business. Her annual salary and benefits total $75,000. event QUESTIONS 1. Create a single company-wide donation margin income account for AVS that includes each expense category. Also calculate the average revenue and net income for one bottle of wine. (Note Do not b reak out the variable or the stubborn cost by type of wine. ) 2. Another grower has available 20,000 pounds of Chardonnay grapes from the 2009 harvest. AVS has the probability 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 21 blend formula) to produce a new Chardonnay wine to be priced at $14/bottle, and required a 15% return on sales for this wine, what is the upper limit amount that AVS would pay for a pound of grapes? 3. Other than the cost of the grapes, what factors would you consider to remain firm your purchase of the grapes, and what factors would cause you to reject purchase the grapes? 4. Kay Aproveche recently read an obligate about Activity base Costing ( alphabet) and is intrigued by the costing methodology.She would like to be able to better assign costs to each of AVSs products, and has collected the following information about AVS activities. Use this Cas e A Votre Sante Page 6 of 17 information, along with the information given in the case, to construct a product cost psycho abstract using alphabet. adopt that AVS did not buy the grapes referred to in call into in closing 2. Harvesting action mechanism The Chardonnay grapes can be harvested at the average rate of 71. 5 pounds/hour, while the generic white grapes are harvested at the rate of 100 pounds/hour.Includes costs related to tractors and harvest labor. Crush activity Relates to the pounds of grapes crushed. Includes costs of crusher equipment and crush labor. unrest Activities Barrel costs relate to the Chardonnay wines by the percentage of wine used in each wine type. Holding tanks relate to the Blanc de Blanc and the Chardonnay regular wines by the percentage of wine used in each wine type. Lab and Supervision Activities Kan Pai estimates that these activities are split 60% Chardonnay-Estate, 25% Chardonnay regular and 15% Blanc de Blanc.Other production activitie s and costs not right off associated with a specific wine allocate according to the bend of bottles produced of each wine. Administrative activities Allocate according to sales revenues. 5. Write a truncated memo to Kay Aproveche that explains what alphabet is, and that discusses both the benefits and costs of doing an first principle analysis. What would you recommend to Kay Aproveche regarding the alphabet analysis? Case A Votre Sante Page 7 of 17 manifest 1 A Votre Sante Income dictation 2010Sales Chardonnay Estate Chardonnay (non-Estate) Blanc de Blanc check Revenues Product Costs Grapes Bottle, labels, corks Harvest labor Crush Labor Indirect Materials Depreciation Lab expenses Production office Utilities Waste treatment vino see supervisory program Barrels resume Product Costs coarse Margin Administrative & Sales Costs Administrative rent & office Liquor taxes Sales commissions Sales manager Administrative salary sum total Fixed Costs Operating Margin price $ 22 $ 16 $ 11 bottles 24,000 $ 9,000 16,000 49,000 $ $ 528,000 144,000 176,000 848,000 124,000 122,500 14,500 2,400 6,329 8,100 8,000 12,000 5,500 2,000 15,000 55,000 4,725 380,054 467,946 $ $ 44. 8% 55. 2% $ $ $ 20,000 147,000 98,000 30,000 75,000 370,000 97,946 11. 6% Case A Votre Sante Page 8 of 17 TEACHING NOTE A VOTRE SANTEThe A Votre Sante (AVS) case is multi-faceted in that it requires students to incorporate operational measures into product costing results, and also to translate cost accounting from a variety of perspectives, such as Product versus period costs variable star versus icy costs Activity base costing Relevant costs and opportunity costs surplusly, the case questions require both quantitative and qualitative analyses of the business issues faced by AVS. AVS has been used in a graduate-level managerial accounting class for MBAs, and would be most appropriate for an advanced undergraduate or a graduatelevel accounting or MBA course. The detail in the case is r ich enough to support a variety of analyses.Alternative uses could be to have the student construct a cost of goods manufactured statement or a traditional financial statement, both of which reinforce the digressions between product and period costs. Students must know the difference between product and period costs to successfully complete the first principle analysis, but they could be made more explicit by requiring the statements. Additionally, substitute(a) decision analysis questions could be developed using the variable and fixed cost structures described in the case. Case question itemise two is only one example of a potential decision analysis question. The following discussion contains the answers to the questions listed in the case, and does not detail the solutions to alternative questions. Case A Votre Sante Page 9 of 17Question 1 Contribution Margin Income Statement To develop the contribution margin income statement, you first have to calculate the turning of bott les of wine produced by AVS. This number is dependent upon the yield from the grapes. The relevant calculations are as follows Chardonnay Grapes 100,000 10,000 10% 90,000 Generic Grapes 60,000 3,000 57,000 Yield Pounds harvested Loss in processing Yield Bottles of wine produced 5% Chardonnay Estate habitue pounds of grapes Chardonnay grapes Generic grapes perfect pounds of grapes Bottles (3 lb. / bottle) 72,000 72,000 24,000 18,000 9,000 27,000 9,000 Blanc de Blanc 48,000 48,000 16,000 Total 90,000 57,000 49,000The contribution margin income statement (Teaching Note edge 1) is fairly straightforward, with the following concepts / calculations causing the most problem The inclusion of liquor taxes and sales commissions in variable costs These are both period expenses, but are clearly based upon the number of bottles sold, and on that pointfore are included in the variable costs. Where to include the wine master expense Since the wine master is paid according to number of blends, not number of bottles, this expense is listed as a fixed cost. Arguably, it could be listed as a variable cost, given that the cost will be based on the number of wines produced.As part of the discussion we will take care the rationale behind listing wine master as a fixed or a variable expense. Barrel expense The case states that the barrels produce the equivalent of 40 cases of wine. A case of wine is post-fermentation/bottling and therefore after the 10% loss has occurred. The Case A Votre Sante Page 10 of 17 barrels contain the wine at the fountain of the process. Therefore, there have to be enough barrels to hold all the wine at the beginning of the process, not at the end. This factor results in 63 (62. 5) barrels being required for the harvest1. Question 2 Additional Purchase Opportunity, Quantitative Analysis Case Question 2 asks what is the maximum amount that AVS would pay to buy an extra pound of Chardonnay grapes.There are three parts to calculating this answer the b enefit from the superfluous Chardonnay wine to be sold, the relevant costs related to producing this wine and the opportunity cost of not producing as much Blanc de Blanc wine. Teaching Note Exhibit 2 displays the calculations relevant to this decision. Chardonnay regular wine requires a 2 to 1 mixture of Chardonnay and Blanc de Blanc wine. Therefore, the 18,000 pounds of Chardonnay grapes will be unite with 9,000 pounds of generic grapes. The 27,000 pounds of grapes will result in an additional 9,000 bottles of Chardonnay regular wine being produced. However, it will also result in a 3,000-bottle decrease in the amount of Blanc de Blanc wine produced, since some generic grapes will now be used for the Chardonnayregular wine.Question 3 Additional Purchase Opportunity, qualitative Analysis The following factors would support AVSs decision to purchase the additional grapes Potential increase in market share Diversification of suppliers world power to leverage fixed costs over more p roduction If timbre of purchased grape is perceived to be better To block a rivalry from buying the grapes 1 Each case of wine requires 36 pounds of grapes (post-fermenting). A barrel holds the equivalent of 40 cases of wine (post-fermenting), or 1,440 pounds of grapes (40 x 36). To transform the post-fermenting grapes to prefermenting grapes, they must be divided by . 9, or 1,440 / . 9 equals 1,600 pounds of grapes. The harvest of 100,000 pounds of grapes therefore requires 62. 5 barrels for storage (100,000 / 1,600). Case A Votre Sante Page 11 of 17Ability to focus time and effort on wine making (rather than harvesting and crushing) Creates an incentive for the up-to-date grower to control costs The following factors would support AVSs decision to reject the grape purchase little quality of the grapes An additional AVS Chardonnay wine creates confusion in the food market overlook of control over the harvest and crush process Lack of confidence in the additional sales foreca st Inability of the current capacity (e. g. bottling line, space) to support additional production Inability to use the additional barrels purchased in future years Cannibalization of the current Chardonnay, Chardonnay-Estate or Blanc de Blanc sales Reliability concerns with the new supplier Other hidden costsQuestion 4 ABC Quantitative Analysis Teaching Note Exhibit 3 contains the ABC product costing analysis, and shows both the per product line and per unit costs. The ABC outcome demonstrates that the Chardonnay-Estate is the most profitable wine for AVS, the Chardonnay-Regular is marginally profitable, and the Blanc de Blanc is not profitable. eon Blanc de Blanc is not profitable, a product-line contribution analysis would need to be effected to determine if Blanc de Blanc has a positive contribution margin, and therefore contributes to covering fixed costs of AVS. Case A Votre Sante Page 12 of 17 Question 5 ABC Qualitative Analysis The first part of this question asks for an e xplanation of ABC, and a discussion of the benefits and costs of an ABC analysis.Relevant points are that ABC is a method of assigning costs that first assigns costs to the activities set in the business, and these costs are assigned to the cost aims (in this case, the three wines) in a manner which reflects each cost objects use of the activity. Using ABC to assign costs is especially beneficial where there exists either variation in processes or variations in cost object requirements. It is also useful as a tool to calculate activity or process costs, which can act as a bench mark against which to judge future improvements. A well-defined ABC cost storage allocation will provide more accurate costing information than a less-sophisticated cost allocation system. The costs of ABC are that it is a time-consuming process and it requires a comprehensive knowledge of the entire operation to successfully complete.For a small company such as AVS, software costs would be minimal the ABC system could easily be constructed using a spreadsheet program. After looking at the results of the ABC analysis, it is clear that the Chardonnay-Estate wine is driving the profitability of AVS. The Blanc de Blanc is the poorest performer recommendations to Kay Aproveche would be to explore both determine and cost control opportunities for the Blanc de Blanc wine. One rule of thumb used in the wine diligence is that the price of a bottle of wine is approximately related to the cost of a ton of grapes by a factor of 100 to 1. If you multiply the $11 price per bottle by 100, the result is $1,100.AVS pays $1,283 for a ton of generic grapes, which suggests that AVS is not receiving enough value for Blanc de Blanc wine relative to the price of the grapes. Perhaps AVS is paying too much for this grape, or they are underpricing the wine. The answer to this cannot be fathomed by data in the case, and is proceeds to many other variables (such as strength of the harvest and strength of th e wine market) however, it is mentioned here as performance measure that is used in the industry. Although some students will suggest that AVS discontinue producing Blanc de Blanc, because it has a Case A Votre Sante Page 13 of 17 positive contribution margin it would not be to AVSs benefit to discontinue this wine without having a better substitue.Looking at the line item costs, students should vizor that the costs for bottles, labels and corks are the same for each of the wines, which may not be correct or appropriate. Students should question whether this makes sense, and note that AVS might decrease costs in the Blanc de Blanc line by buying lower-priced bottles, labels and corks. Another interesting piece of information from the cost analysis is the wine-coloured Master cost and how large it is on a per-unit basis when the number of bottles is low. This helps demonstrate to the students how volume creates economies of scale, and often leads into a discussion about how to ref ine product lines without incurring additional fixed costs, especially when initial volume is expected to be low.Summary The AVS case is based upon actual wine industry data, although the data has been simplified to reinforce the teaching points and concepts. It is also true to the wine making process, with the exception of AVSs process of making the Chardonnay regular wine from the fermented Chardonnay and Blanc de Blanc wines. This can be done, but most unremarkably the juice from the wine grapes is combined at the start of the fermenting process, so that they can ferment together. Because of the different yield rates in the fermenting process, the case had the wines ferment separately and blend at the end. The case can be taught in a 75-minute class, or by omitting the decision analysis question 50 minutes would be sufficient.I have also used it to teach the differences between the financial income statement reporting (product and period costs) and the contribution margin income statement reporting (variable and fixed costs), and then assigned decision analysis and/or the ABC costing as an additional assignment. Case A Votre Sante Page 14 of 17 Teaching Note Exhibit 1 Contribution Margin Income Statement Sales Chardonnay Chardonnay Estate Blanc de Blanc Total Revenues Variable costs Grapes Bottle, labels, corks Harvest labor Crush Labor Indirect Materials Liquor taxes Sales Barrels Total Variable Costs Contribution Margin Fixed Costs Administrative rent & office Depreciation Lab expenses Production office Sales Supervisor Utilities Waste treatment Wine Master Administrative salary Total Fixed Costs Operating Margin price $ 22 $ 16 $ 11 bottles 24,000 $ 9,000 16,000 49,000 $ 528,000 144,000 176,000 848,000 avg. revenue per bottle $ 17. 1 $ 124,000 122,500 14,500 2,400 6,329 147,000 98,000 4,725 519,454 328,546 61. 3% 38. 7% $85,500 + 38,500 bottles x $2. 50 2,000 hours x $7. 25/hour 300 hours x $8/hour bottles x 1. 55/12 $3/bottle $2/bottle 63 barrels x $300/4 years $ $ $ 20,000 8,100 8,000 12,000 30,000 55,000 5,500 2,000 15,000 75,000 230,600 97,946 11. 6% $ 2. 00 per bottle $ $ Case A Votre Sante Page 15 of 17 Teaching Note Exhibit 2 Decision Analysis, Additional Grape Purchase Yield Chardonnay grapes 20,000 2,000 18,000 9,000 pounds loss (10%) yield 2 pounds of Chardonnay grapes per bottle (along with 1 pound of generic grapes) 9000 bottles $14 / bottle bottlesAdditional Chardonnay Product Line Revenue $ 126,000 Costs generic grapes $ 6,079 bottles, labels, corks 22,500 indirect material 1,163 liquor taxes 27,000 sales distribution 18,000 barrels 975 wine master 5,000 Total costs $ 80,716 Gain from new Chardonnay $ 45,284 Lost Sales of Blanc de Blanc Wine Revenue $ 33,000 Costs generic grapes $ 6,079 bottles, labels, corks 7,500 indirect material 388 liquor taxes 9,000 sales distribution 6,000 Total costs $ 28,966 Lost Contribution Margin $ 4,034 web Impact Required Return Total Net Benefit Pounds of Grapes utmost Price $ $ 41,250 $ 18,900 $ 22,350 20,000 1. 12 9000 pounds x. 6754 / pound $2. 50 / bottle $1. 55 / case $3 / bottle $2 / bottle 20,000 pounds / 1, 600 each blend 3000 bottles $11 / bottle 9000 pounds x. 6754 / pound $2. 50 / bottle $1. 55 / case $3 / bottle $2 / bottle 15% per poundCase A Votre Sante Page 16 of 17 Teaching Note Exhibit 3 Activity Based Costing Income Statement C Estate Sales Revenue number one wood Grapes pounds of grapes Bottle, labels, corks bottles Harvest labor harvest labor hours 1 Tractor Depreciation harvest labor hours 1 Crush Labor pounds of grape crushed2 Crush Equip. Depr. pounds of grape crushed2 Indirect Materials bottles Lab and Supervision bottles Liquor taxes bottles Sales bottles Wine Master blends Barrels percentage of wine3 Holding Tank percentage of wine4 Other Production Expenses Depreciation bottles Prod. Office bottles Utilities bottles Waste treatment bottles Administrative Expenses Admin.Salary % of sales revenue Admin rent & office % of sales revenue Sales % of sales revenue bottles rev. /bottle 24,000 22 $ 528,000 68,400 60,000 8,117 840 1,200 300 3,100 37,800 72,000 48,000 5,000 3,780 308,537 1,959 5,878 2,694 980 11,510 46,698 12,453 18,679 77,830 Total Expenses Operating Margin 397,877 $ 130,123 24. 6% $ $ product line data C Reg. B de B 9,000 16 144,000 23,180 22,500 2,717 281 442 111 1,163 15,750 27,000 18,000 5,000 945 316 117,403 735 2,204 1,010 367 4,316 12,736 3,396 5,094 21,226 142,946 1,054 0. 7% $ $ 16,000 11 176,000 32,421 40,000 3,666 379 758 189 2,067 9,450 48,000 32,000 5,000 1,684 175,614 1,306 3,918 1,796 653 7,673 15,566 4,151 6,226 25,943 209,231 (33,231) -18. % $ Total 49,000 $ 848,000 124,000 122,500 14,500 1,500 2,400 600 6,329 63,000 147,000 98,000 15,000 4,725 2,000 601,554 4,000 12,000 5,500 2,000 23,500 75,000 20,000 30,000 125,000 750,054 97,946 11. 6% $ $ 22. 00 $ 16. 00 $ 11. 00 2. 85 2. 50 0. 34 0. 03 0. 05 0. 01 0. 13 1. 58 3. 00 2. 00 0. 21 0. 16 0. 00 12. 86 0. 08 0. 24 0. 11 0. 04 0. 48 1. 95 0. 52 0. 78 3. 24 16. 58 5. 42 $ 24. 6% 2. 58 2. 50 0. 30 0. 03 0. 05 0. 01 0. 13 1. 75 3. 00 2. 00 0. 56 0. 11 0. 04 13. 04 0. 08 0. 24 0. 11 0. 04 0. 48 1. 42 0. 38 0. 57 2. 36 15. 88 0. 12 $ 0. 7% 2. 03 2. 50 0. 23 0. 02 0. 05 0. 01 0. 13 0. 59 3. 00 2. 00 0. 31 0. 00 0. 11 10. 98 0. 08 0. 24 0. 11 0. 04 0. 48 0. 97 0. 26 0. 39 1. 62 13. 08 (2. 08) -18. 9% per-unit data C Estate C Reg. B de B Case A Votre Sante Page 17 of 17