Brian is the operating manager of Oriole, a company that manufactures three different types of all-terrain...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Brian is the operating manager of Oriole, a company that manufactures three different types of all-terrain vehicles: four-wheelers, personal watercraft, and snowmobiles. Naturally, Brian has the opportunity to test all of these products for quality-control purposes. At the end of the year, Brian needs to perform a profitability analysis for each product line to better evaluate the company's pricing strategy. He has a gut feeling that the company has room to increase selling prices in the snowmobile category, but he wants to see what the financials look like before he makes a case to the CEO. He has gathered the following information. The costs for the three support departments, Payroll, Maintenance, and IT, are allocated to the product lines according to number of employees, maintenance hours used, and IT hours used, respectively. Sales Costs Four-Wheelers IT hours $1,117,000 Number of employees Maintenance hours Personal Watercraft Payroll $94,000 2 100 150 $1,402,000 Maintenance 3 200 Snowmobiles $114,000 $250,000 40 $1,984,000 IT 4 150 220 Four-Wheelers Watercraft $856,000 $1,138,000 20 1,800 800 18 750 1,250 Snowmobiles $1,764,000 27 1,300 900 Use Excel to allocate the three support department costs to the three product lines using the reciprocal method. (Round answers to 2 decimal places, e.g. 15.25.) (b) GA 4-Wheelers Operating income Operating Units Watercraft Profit margin Determine operating income amounts and profit margin percentages for each product line after accounting for the allocated support costs. (Round answers to 2 decimal places, e.g. 15.25 or 15.25%.) Snowmobiles Four-Wheelers Personal Watercraft Total % Snowmobiles % Brian is the operating manager of Oriole, a company that manufactures three different types of all-terrain vehicles: four-wheelers, personal watercraft, and snowmobiles. Naturally, Brian has the opportunity to test all of these products for quality-control purposes. At the end of the year, Brian needs to perform a profitability analysis for each product line to better evaluate the company's pricing strategy. He has a gut feeling that the company has room to increase selling prices in the snowmobile category, but he wants to see what the financials look like before he makes a case to the CEO. He has gathered the following information. The costs for the three support departments, Payroll, Maintenance, and IT, are allocated to the product lines according to number of employees, maintenance hours used, and IT hours used, respectively. Sales Costs Four-Wheelers IT hours $1,117,000 Number of employees Maintenance hours Personal Watercraft Payroll $94,000 2 100 150 $1,402,000 Maintenance 3 200 Snowmobiles $114,000 $250,000 40 $1,984,000 IT 4 150 220 Four-Wheelers Watercraft $856,000 $1,138,000 20 1,800 800 18 750 1,250 Snowmobiles $1,764,000 27 1,300 900 Use Excel to allocate the three support department costs to the three product lines using the reciprocal method. (Round answers to 2 decimal places, e.g. 15.25.) (b) GA 4-Wheelers Operating income Operating Units Watercraft Profit margin Determine operating income amounts and profit margin percentages for each product line after accounting for the allocated support costs. (Round answers to 2 decimal places, e.g. 15.25 or 15.25%.) Snowmobiles Four-Wheelers Personal Watercraft Total % Snowmobiles %
Expert Answer:
Answer rating: 100% (QA)
To allocate the three support department costs Payroll Maintenance and IT to the three product lines FourWheelers Personal Watercraft and Snowmobiles ... View the full answer
Related Book For
Advanced Financial Accounting
ISBN: 978-0137030385
6th edition
Authors: Thomas Beechy, Umashanker Trivedi, Kenneth MacAulay
Posted Date:
Students also viewed these accounting questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
A space-filling curve is a continuous curve in the unit square that passes through every point. Write a recursive Turt le client that produces these recursive patterns, which approach a space-filling...
-
An object with mass m moves along the x-axis. Its position as a function of time is given by x (t) = At Bt3, where A and B are constants. Calculate the net force on the object as a function of time.
-
A trucking company leases a hauling rig from the manufacturer for a three-year period. The trucking company pays a monthly rental and guarantees a certain minimum resale value of the rig at the end...
-
How do stakeholder groups relevant to environmental management accounting and environmentally induced financial accounting differ?
-
Some critics of GASB Statement No. 14 (even as amended) believe that it casts too wide a netthat it requires governments to include in their reporting entity organizations over which the primary...
-
Assume a private equity fund only holds 2 investments. Investment A (purchased for $150M) is sold for $110M in year 1. Investment B (purchased for $330M) is sold for $350M in year 2. The fund has an...
-
Amy Lloyd is interested in leasing a new car and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36 month lease with no down payment due at the...
-
Find the current in the 12-2 resistor in the figure below. (Assume R = R3 = 2.22, R = R4 = 7.2, AV = 23 V.) A R www R w RA R3 www www 4.0 w 12 2.0 www + AV
-
Identify a few challenges and constraints of trust SAP that are not listed in this chapter.
-
Is anxiety pattern stable and application specific?
-
List ten different constraints in the temptation analysis pattern.
-
List three challenges in formulating the temptation analysis pattern.
-
How reusable is the competition stable analysis pattern?
-
Doe Co. is a merchandise retailer. The company had the following transactions during the month of April: April 2 Purchased merchandise from MAP Corp. for $12,000 under credit terms of 2/10,N/30 April...
-
Why can wastewater treatment requirements in Hawaii be less stringent than those in most locations on the U.S. mainland?
-
Aztec Corporation purchased 70% of the outstanding shares of Inca Limited on January 1, 20X2, at a cost of $ 80,000. Aztec has always used the cost method to account for its investments. On January...
-
Parch Ltd. purchased 100% of the voting shares of Subbet Ltd. for $ 1,400,000 on October 1, 20X6. The SFP of Subbet Ltd. at that date was: Required What are the eliminations and adjustments required...
-
Persaud Ltd. acquired 100% of the voting shares of Singh Ltd. on January 1, 20X6, for $ 1,255,000. The financial statement of Singh Ltd. on the date of acquisition was as follows: The inventory will...
-
The reciprocating mass, crank radius, and connecting-rod length of each of the cylinders in a two-cylinder in-line engine are given by \(m, r\), and \(l\), respectively. The crank angles of the two...
-
The force transmitted by an internal combustion engine of mass \(500 \mathrm{~kg}\), when placed directly on a rigid floor, is given by \[F_{t}(t)=(18,000 \cos 300 t+3600 \cos 600 t) \mathrm{N}\]...
-
Is it always advantageous to include a damper in the secondary system of a dynamic vibration absorber?
Study smarter with the SolutionInn App