Planning notes from the 20X5 launch of the Skinny-Bar 20X5 actual sales Total manufacturing costs $288,600...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Planning notes from the 20X5 launch of the Skinny-Bar 20X5 actual sales Total manufacturing costs $288,600 230,880 (Total manufacturing cost consists of $115,440 in prime costs and $147,186 in conversion costs.) The contribution margin ratio for this product was 35%. 156,000 bars were sold at $1.85 per bar. This was a pilot project of the product, so there were no beginning or ending inventories associated with the product. All non-manufacturing costs relating to this product are fixed. The margin of safety percentage for the product at this sales level was -15%. The profit margins on the company s current products can be found below in Exhibit 2. The most profitable product is the Salt-Lick bar at 25.9%, followed by Alamonde at 19.3% and The-Bar at 18.8%. Budgeted margins were 14.3%, 27.5%, and 35.2% for The-Bar, Alamonde, and Salt-Lick, respectively. a) (7 marks) Determine the break-even in sales dollars for the Skinny-Bar product and prepare a variable costing income statement based on the information provided in Exhibit 1 for actual sales. The income statement must include the cost of direct materials, direct labour, variable manufacturing overhead, fixed manufacturing overhead, and fixed general and administrative costs. Prepare a lifetime cost analysis of Skinny-Bar and propose a selling price for this new product based on BBCC s markup policy. The overhead costs, the batch size, the machine hours per batch, the number of inspections per batch, set up times and the number of product lines should be based on the activity-based analysis prepared in requirement 1 using the batch size for the The-Bar product. Direct labour hours per batch is 22.5. Product costs are based on one product line. Lifetime research and development costs are $900,000 for the Skinny-Bar. Use the activity rates calculated in requirement 1 as well. Compare the proposed price with the selling price set at the time of the initial introduction of this product. Discuss the adequacy of this new proposed price. Exhibit 2 Volume Sales Cost of goods sold Gross margin Selling and administrative expenses Operating income Gross margin % Volumes Sales Cost of goods sold Gross margin Selling and administrative expenses Operating income Gross margin % Actual operating income statement For the year ended December 31, 20X7 The-Bar Per bar 776,000 $1,164,000 $1.50 945,595 $ 218,405 18.8% Alamonde Per bar 774,400 $1,161,600 $1.50 996.034 $ 165,566 14.3% 528,000 $897,600 724,672 $172,928 19.3% $1.70 Budgeted operating income statement For the year ended December 31, 20X7 The-Bar Salt-Lick 529,100 $952,380 $1.80 690.756 $261,624 27.5% 302,500 $605,000 $2.00 448,187 $156,813 25.9% I Per Alamonde Per Salt-Lick Per bar bar bar Per bar 301,400 $602,800 $2.00 390.297 $212,503 35.2% Total 1,606,500 $2,666,600 2,118,454 $ 548,146 541,681 6.465 20.6% Total 1,604,900 $2,716,780 2.077.087 $ 639,693 542.554 $97.139 23.5% Planning notes from the 20X5 launch of the Skinny-Bar 20X5 actual sales Total manufacturing costs $288,600 230,880 (Total manufacturing cost consists of $115,440 in prime costs and $147,186 in conversion costs.) The contribution margin ratio for this product was 35%. 156,000 bars were sold at $1.85 per bar. This was a pilot project of the product, so there were no beginning or ending inventories associated with the product. All non-manufacturing costs relating to this product are fixed. The margin of safety percentage for the product at this sales level was -15%. The profit margins on the company s current products can be found below in Exhibit 2. The most profitable product is the Salt-Lick bar at 25.9%, followed by Alamonde at 19.3% and The-Bar at 18.8%. Budgeted margins were 14.3%, 27.5%, and 35.2% for The-Bar, Alamonde, and Salt-Lick, respectively. a) (7 marks) Determine the break-even in sales dollars for the Skinny-Bar product and prepare a variable costing income statement based on the information provided in Exhibit 1 for actual sales. The income statement must include the cost of direct materials, direct labour, variable manufacturing overhead, fixed manufacturing overhead, and fixed general and administrative costs. Prepare a lifetime cost analysis of Skinny-Bar and propose a selling price for this new product based on BBCC s markup policy. The overhead costs, the batch size, the machine hours per batch, the number of inspections per batch, set up times and the number of product lines should be based on the activity-based analysis prepared in requirement 1 using the batch size for the The-Bar product. Direct labour hours per batch is 22.5. Product costs are based on one product line. Lifetime research and development costs are $900,000 for the Skinny-Bar. Use the activity rates calculated in requirement 1 as well. Compare the proposed price with the selling price set at the time of the initial introduction of this product. Discuss the adequacy of this new proposed price. Exhibit 2 Volume Sales Cost of goods sold Gross margin Selling and administrative expenses Operating income Gross margin % Volumes Sales Cost of goods sold Gross margin Selling and administrative expenses Operating income Gross margin % Actual operating income statement For the year ended December 31, 20X7 The-Bar Per bar 776,000 $1,164,000 $1.50 945,595 $ 218,405 18.8% Alamonde Per bar 774,400 $1,161,600 $1.50 996.034 $ 165,566 14.3% 528,000 $897,600 724,672 $172,928 19.3% $1.70 Budgeted operating income statement For the year ended December 31, 20X7 The-Bar Salt-Lick 529,100 $952,380 $1.80 690.756 $261,624 27.5% 302,500 $605,000 $2.00 448,187 $156,813 25.9% I Per Alamonde Per Salt-Lick Per bar bar bar Per bar 301,400 $602,800 $2.00 390.297 $212,503 35.2% Total 1,606,500 $2,666,600 2,118,454 $ 548,146 541,681 6.465 20.6% Total 1,604,900 $2,716,780 2.077.087 $ 639,693 542.554 $97.139 23.5%
Expert Answer:
Answer rating: 100% (QA)
Solution Bars sold 156000 Unit Price 185 Total Sales in 288600 1 B... View the full answer
Related Book For
Financial Accounting An Introduction to Concepts, Methods and Uses
ISBN: 978-1133591023
14th edition
Authors: Roman L. Weil, Katherine Schipper, Jennifer Francis
Posted Date:
Students also viewed these accounting questions
-
Contribution Margin and Contribution Margin Ratio For a recent year, Wicker Company-owned restaurants had the following sales and expenses (in millions): Sales $33,500 Food and packaging $13,995...
-
Determine the break-even contribution margin ratio for a company with a fixed overhead of $115,000 and revenues of $1,500,000.
-
Determine the break-even contribution margin ratio for a company with a fixed overhead of $92,000 and revenues of $450,000.
-
What responsibilities can a Crew Boss delegate to a subordinate supervisor? (Select all that apply) Re-supplying crew and equipment Communicating crew wake up time for next operational period...
-
How do financial statement assertions relate to audit procedures?
-
Two uniform 75.0-g marbles 2.00 cm in diameter are stacked as shown in Fig. 11.55 in a container that is 3.00 cm wide. (a) Find the force that the container exerts on the marbles at the points of...
-
From the balance sheet, what are the total liabilities?
-
Atlantic Ocean Kamp grounds, Inc. (Atlantic) borrowed $ 60,000 from Camden National Bank (Camden National) and executed a note and mortgage on property located in Camden, Maine, securing that amount....
-
ed k ces Compute the component percentages for Trixy Magic's income statement below. (Enter your answers as a percentage rounded to 2 decimal place (i.e. 0.1234 should be entered as 12.34). Enter all...
-
Annapolis Company purchased a $2,000, 7%, 9-year bond at 99 and held it to maturity. The straight line method of amortization is used for both premiums & discounts. What is the net cash received...
-
question about derivative 7. The current spot price of oil is $52 per barrel. The risk free rate is 6% per annum. Storage costs are $2.20 per barrel per year, payable in arrears. Compute the correct...
-
9. A ping pong ball is smashed straight down the centre line of the table at 60.0 km/h. However, the game is outdoors and a crosswind of 25.0 km/h sweeps across the table parallel to the net. How...
-
Suppose the economy is populated by many identical agents. They live for two periods: t and t + 1. They act as price takers and receive exogenous amounts of current and future income, Yt and Yt+1....
-
Purpose : The purpose of this exercise is to allow students to take a "hands on" approach to research Training and Development in corporate Canada, and to foster teamwork among students. ...
-
Lan Learning Tfinal= The specific heat of a certain type of metal is 0.128 J/(g- C). What is the final temperature if 305 J of heat is added to 83.0 g of this metal, initially at 20.0C? C
-
In a summary of John Maynard Keyes with the outline given Introduction: Introduce your movie with a short summary. Main Points: Explain 5 key points in a short concise paragraph and make it...
-
Exit Refer to the following lease amortization schedule. The 10 payments are made annually starting with the beginning of the lease. Title does not transfer to the lessee and there is no purchase...
-
(a) Use integration by parts to show that (b) If f and g are inverse functions and f' is continuous, prove that (c) In the case where f and t are positive functions and b > a > 0, draw a diagram to...
-
Cat Incorporated manufactures machinery and engines for the construction, agriculture, and forestry industries. It follows U.S. GAAP and reports its results in millions of U.S. dollars ($). For the...
-
Why does every accounting transaction have two effects?
-
Why might it be difficult to compare two otherwise similar firms in terms of their operating profits?
-
Transatlantic Arbitrage. A corporate treasury working out of Vienna with operations in New York simultaneously calls Citibank in New York City and Barclays in London. The banks give the following...
-
Venezuelan Bolivar (A). The Venezuelan government officially floated the Venezuelan bolivar (Bs) in February 2002. Within weeks, its value had moved from the pre-float fix of Bs778/$ to Bs1025/$. a....
-
Venezuelan Bolivar (B). The Venezuelan political and economic crisis deepened in late 2002 and early 2003. On January 1, 2003, the bolivar was trading at Bs1400/$. By February 1, its value had fallen...
Study smarter with the SolutionInn App