Home / Questions / CVP ANALYSIS AND BEP Respond to Brett’s requests by developing an excel workbook. 2. By u...
CVP ANALYSIS AND BEP
. Respond to Brett’s requests by developing an excel workbook.
2. By using your excel workbook, determine the breakeven point in number of kegs for the existing product mix based on the 2017 information.
2. Determine the target profit for 2018 and calculate which of the existing lagers should be promoted more aggressively than the others.
3. Perform market research into the craft beer brewing industry in Tasmania (there are +20 craft brewers in Tasmania) and advise Brett through a written business report if he (a) should expand by producing Brett’s Pale Ale or (b) should increase profitability through changes in the sales prices and/or mix of existing ales. Your advice must be supported by your excel workbook calculations and qualitative evidence.
4. Advise Brett on the environmental costs related to waste products and suggest innovate ways, taking into account cost considerations, in which to re-purpose the waste products for sustainable use.
5. As an appendix, briefly reflect on the leadership style your group followed in coordinating the team effort. All members must sign the appendix electronically as proof of their contribution and to show agreement that all members contributed to the team effort. It is anticipated that the majority of your team must hold one meeting at a brewery (open to the public), to develop your team and to conduct research into brewing processes. External mode students are urged to visit a brewery to develop an understanding of the production process.
BFA612 Assignment - Group written business report. Due date: Week 10 Decision making for constrained resources, make versus buy, and new product development (Loosely based on Samuels, JA & Sawers, KM 2016, 'Arizona Microbrewery, Inc.: An Instructional Case on Management Decision Making', Issues in Accounting Education, vol. 31, no. 4, pp. 409-415.) As a result of David Tucker’s success story (see background in publication), Brett Lee decided to quit his job to start his own brewery, Tassie B, in Tasmania, Australia. The start-up was funded by Brett’s savings and financial assistance from his family. Tassie B’s operations started on January 10, 2017 and the brewery produces three labels of specialty beers (Tassie Lager, Lonnie Lager and Hobart Lager). Brett employs one salesperson who receives a monthly salary plus a 10 percent commission. All beer is sold in kegs (returnable containers) to hotels, pubs and restaurants. Tassie B has 3 machines/vessels with a total practical capacity of 2,500 hours. All the equipment are used continuously in production runs. Current utilities (heating and refrigeration) can cope with the existing sales mix at practical capacity. Product sales, cost information and additional information for the 2017 calendar year are shown in the following table: Tassie LagerLonnie LagerHobart LagerTotalSales price per keg$300$350$325Number of kegs sold1,1514586322,241Direct labour hours per keg0.8751.2250.875Total direct labour hours - 20172,121Machine hours per keg0.701.401.225Total Machine hours - 20172,221Brett has not taken a salary since the business started. The business has generated a small profit for 2017. The following costs pertain to the 2017 calendar year: Accounting staff to assist Brett26,662.83Advertising and Marketing Costs22,994.91Brew Master/Quality Control Manager 70,293.15Depreciation11,712.10Direct materials93,537.20Direct Labour120,393.25Facility costs (rent,...
Jun 22 2020 View more View Less
Offhaus Manufacturing produces office supplies but outsources the delivery of its products to third-party carriers. Offhaus ships to 20 cities from its Dayton, Ohio, manu...
May 06 2020An atom with a number of 11 contains 36 subatomic particles. How many of these subatomic particles have each of the following characteristics?a. carry a chargeb. carry no...
Jun 18 2021Suppose the government removes a tax on buyers of a good and levies a tax of the same size on sellers of thegood. How does this change in tax policy affect the price that...
Jul 12 2021Decide whether the following sentences are true or false by selecting T or F.Sentences asking direct questions that require answers are concluded with question marks.
Jun 09 2021What assumptions are necessary for the CAPM, and what impact does relaxing those assumptions have?
Nov 27 2019A share of stock with a beta of .68 now sells for $43. Investors expect the stock to pay a year-end dividend of $2. The T-bill rate is 3%, and the market risk premium is ...
Sep 07 2020Theory of Demand (4 points) Amy chooses between two goods, x and y, with prices Pz and Py, respectively. She has an income I and her preferences are represented by the ut...
May 08 2021In addition to outlining 12 standards of ethical behaviour, the FASEA Code of Ethics makes two other important observations. Firstly, that collectively, financial advise...
Nov 23 2019After years of research, your company develops a product that might revolutionize the green (environmentally conscious) building industry. e product is made from relative...
Jul 06 2021Form a differential equation for the parabola y^2 =4ax >
Aug 04 2020