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...
-
Solve the following problem by branch and bound method. Maximize $f=x_{1}+x_{2}$ subject to the constraints $2 x_{1}+5 x_{2} \leq 16$ $6 x_{1}+5 x_{2} \leq 30$ $x_{1}, x_{2} \geq 0$ and Integer
-
Which state legislated the first CPA law?
-
The book balance in the checking account of Johnson Enterprises as of October 31 is $5,718. The bank statement shows an ending balance of $5,217. The following information is discovered by (1)...
-
Saved Help Save & Exit Submit As you plan for your post-graduation new car, you have a few different investment options each offering annually compounding interest. Each investment has a different...
-
2 (5 Marks) A student borrowed an educational loan of $100,000 at an interest rate of 10% per year and repaired equal payment of S1000 at the end of cach year starting from year 2 to year S The...
-
Determine the currents I, I and I, in the following circuit = 24.0 V Home d 0,10 R 5.0 R 78 a g = 48.0 V W 0.50 = 6.0 V Pag 1005 h R 40 R - 20 *0,20 2. = 36.0 V
-
what excel formula is used to solve the question. Newtown wants to accumulate money for a new library. The building is estimated to cost $1,000,000 today. Construction inflation is 4%. What will the...
-
How does the integration of renewable energy sources into existing energy infrastructure pose challenges for grid stability and reliability, and what are the advanced grid management strategies to...
-
Find position, velocity, acceleration 6. A 25-ft ladder is leaning against a wall. If we push the ladder toward the wall at a rate of 1 ft/sec, and the bottom of the ladder is initially 20 ft away...
-
1. You and two other students carpool to class each day. The driver has recently taken to playing a new radio station quite loudly. You do not like the music, or the loudness. Using one of the...
-
Transactions for the Oleg Thorn Company for the month of June are presented as follows. June 1 Oleg Thorn invests $5,000 cash in a small welding business of which he is the sole proprietor. 2...
-
Write the given system without the use of matrices. D) - ()- d (x sin t + 8 (2+ 1)
-
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...
-
Using divisibility rules, determine if 342,887 is divisible by 9 .
-
Using divisibility rules, determine if 87,762 is divisible by 10 .
-
Can 43,568 pieces of mail be separated into 6 bins with the same number of pieces of mail per bin?
Study smarter with the SolutionInn App