Required 1 Required 2 For Year 5, allocate each of the indirect expenses (rent and supervisor...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required 1 Required 2 For Year 5, allocate each of the indirect expenses (rent and supervisor salaries) to the two departments: Skis and Snowboards. Important! Be sure to click the correct Year at the top of the dashboard. Rent Department Skis Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numerator Denominator Percent of Total 0% Snowboards 0% Totals 0% Supervisor salaries Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Numerator Denominator Percent of Total Skis 0% Snowboards Totals 0% 0% < Required 1 Required 2 > Required 1 Required 2 For Year 5, prepare departmental income statements for Skis and Snowboards. Important! Be sure to click the correct Year at the top of the dashboard. BURTON Co. Departmental Income Statements For Year Ended December 31 Expenses Skis Snowboards Combined 0 0 0 Total expenses 0 0 0 Income (loss) $ 0 0 0 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snowboards. Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's December 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Ye Sales & Costs of Goods Sold Skis Snowboards $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 Skis Sales: $180,000 $25,000 Sales Cost of Sales Goods Sold Cost of Goods Sold Sales & Costs of Goods Sold Skis Snowboards $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost Goods Skis Cost of Goods Sold: $75,600 $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales & Costs of Goods Sold Skis Snowboards Sales Cost of Goods Sold Sale Snowboards Sales: $135,000 $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales & Costs of Goods Sold Skis Snowboards Number of Emplo SKI Snowboards Sales Cost of Goods Sold Sales Cost o Goods S Cost of Goods Sold: $108,000 BOARD Number of Employees SKI Skis 15 employees Number of Employees SKI SNOWBOARD Snowboards 10 employees Square Feet Occupied Snowboards Snowboards 6,000 square feet Skis Square Feet Occupied Snowboards $12, $10, $8, 6 4 $2, Skis $ 14,000 square feet Indirect Expense Allocation Base $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Sal Skis es Supplies Ex Salaries Expense: $12,600 Used $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Salaries Expense Suppl Skis lies Use Supplies Used: $5,400 ed 5 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Snowboards Salaries Expense: $9,000 Supplies Used Salaries Supplies Salaries d Expense Used Expense es C L S Direct Expenses Skis Snowboards $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Snowboards Salaries Supplies Supplies Used: $4,500 Expense Used Indirect Expense Allocation Base Indirect Expense Allocation Base $2 Cost Rent $14,400 Square feet occupied Supervisor salaries $27,000 Number of employees Required 1 Required 2 For Year 5, allocate each of the indirect expenses (rent and supervisor salaries) to the two departments: Skis and Snowboards. Important! Be sure to click the correct Year at the top of the dashboard. Rent Department Skis Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numerator Denominator Percent of Total 0% Snowboards 0% Totals 0% Supervisor salaries Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Numerator Denominator Percent of Total Skis 0% Snowboards Totals 0% 0% < Required 1 Required 2 > Required 1 Required 2 For Year 5, prepare departmental income statements for Skis and Snowboards. Important! Be sure to click the correct Year at the top of the dashboard. BURTON Co. Departmental Income Statements For Year Ended December 31 Expenses Skis Snowboards Combined 0 0 0 Total expenses 0 0 0 Income (loss) $ 0 0 0 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snowboards. Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's December 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Ye Sales & Costs of Goods Sold Skis Snowboards $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 Skis Sales: $180,000 $25,000 Sales Cost of Sales Goods Sold Cost of Goods Sold Sales & Costs of Goods Sold Skis Snowboards $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost Goods Skis Cost of Goods Sold: $75,600 $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales & Costs of Goods Sold Skis Snowboards Sales Cost of Goods Sold Sale Snowboards Sales: $135,000 $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales & Costs of Goods Sold Skis Snowboards Number of Emplo SKI Snowboards Sales Cost of Goods Sold Sales Cost o Goods S Cost of Goods Sold: $108,000 BOARD Number of Employees SKI Skis 15 employees Number of Employees SKI SNOWBOARD Snowboards 10 employees Square Feet Occupied Snowboards Snowboards 6,000 square feet Skis Square Feet Occupied Snowboards $12, $10, $8, 6 4 $2, Skis $ 14,000 square feet Indirect Expense Allocation Base $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Sal Skis es Supplies Ex Salaries Expense: $12,600 Used $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Salaries Expense Suppl Skis lies Use Supplies Used: $5,400 ed 5 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Direct Expenses Skis Snowboards Snowboards Salaries Expense: $9,000 Supplies Used Salaries Supplies Salaries d Expense Used Expense es C L S Direct Expenses Skis Snowboards $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 Snowboards Salaries Supplies Supplies Used: $4,500 Expense Used Indirect Expense Allocation Base Indirect Expense Allocation Base $2 Cost Rent $14,400 Square feet occupied Supervisor salaries $27,000 Number of employees
Expert Answer:
Related Book For
College Accounting Chapters 1-30
ISBN: 978-0077862398
14th edition
Authors: John Price, M. David Haddock, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
How is this done in excel and also on a financial calculator? Your estimate of the market risk premium is 7%. The risk-free rate of return is 3.8% and the firm has a beta of 1.1. According to the...
-
Inventories Problem, Create your own Excel workbook for this task. Please calculate each of the inventory methods on a separate worksheet within the same workbook. Our Poultry Farmer is stockpiling...
-
In a two-player, one-shot simultaneous-move game each player can choose strategy A or strategy B. If both players choose strategy A, each earns a payoff of $500. If both players choose strategy B,...
-
Suppose A is an m ( n matrix with the property that for all b in the equation Ax = b has at most one solution. Use the definition of linear independence to explain why the columns of A must be...
-
In Exercises, find the absolute extrema of the function on the closed interval. g(x) = 2x + 5 cos x, [0, 2]
-
Suppose we have a volume of nitrogen plus a small amount of water vapor at \(1.0 \mathrm{~atm}\). The walls of the container are at \(25^{\circ} \mathrm{C}\), and there is a hot pipe at \(105^{\circ}...
-
On January 1, 20X5, Piper Ltd. purchased 100% of the shares of Sutton Ltd. for $ 1,085,000. At that time Sutton Ltd. had the following SFP: The bonds were issued at par and will mature in 10 years....
-
A transport company purchased a truck for $89,000. The company depreciated the truck at the end of each year at the rate of 19% of its current value. What is the value of the truck at the end of the...
-
After categorizing the assets to be protected, a security program must then identify the risks to these assets, so that they are secured and protected from harm. Research to learn the processes used...
-
How would a credit officer verify personal information provided by a credit applicant?
-
The constraint for resource 1 is 5 X1 + 4 X2 200. If X1 = 40 and X2 = 20, how many additional units, if any, of resource 1 are employed above the minimum of 200?
-
1. A projectile is fired into a gas in which the pressure is 320 kPa and the density is 4.33 kg/m3. It is observed experimentally that a Mach cone emanates from the projectile with a total angle...
-
Use 1 xhubut 121.2. What is the monopolist's profit maximizing output? What is the profit Bamzing profit. On Exlubit 123.2 draw the profit box. Cost and price per unil $20- $15 Exhibit T23.4 $5- T 1...
-
Pixel Studio, Incorporated, is a small company that creates computer-generated animations for films and television. Much of the company's work consists of short commercials for television, but the...
-
The weights (in pounds) of six people before taking a weight reduction program w ere 350, 249, 260, 195, 275, and 295. The weights of these same people after the weight reduction program are 345,...
-
$10,000 was borrowed at 3.5% on July 17. The borrower repaid $5000 on August 12, and $2000 on September 18. What final payment is required on November 12 to fully repay the loan?
-
Give the entry in general journal form to record the issuance of the manufacturing supplies into production. During May 2016, Caty Co. purchased and issued the following materials and supplies. Use...
-
Bette Springer is president of Springer Company, a manufacturer of toys for children. For the past 10 years, the company has sold its product both to wholesale and to retail dealers of toys in the...
-
Pacific Corporation has been authorized to issue 10,000 shares of 10 percent noncumulative, nonparticipating preferred stock with a par value of $100 per share and 10,000 shares of common stock with...
-
Which of the following items would be most useful in analyzing the separation of duties and functions in an application system? (a) document flowchart (b) program flowchart (c) HIPO chart (d) source...
-
An important omission from flowcharts and matrix techniques is ( ___________________ ). (a) the ability to represent decisions (b) the ability to include internal control considerations (c) the...
-
In the preparation of a logical data flow diagram for a payroll processing application, which of the following symbols should be used to indicate the payroll data? (a) terminator symbol (b) data...
Study smarter with the SolutionInn App