Required 1 Required 2 For Year 5, allocate each of the indirect expenses (rent and supervisor...

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