Required 1 Required 2 For Year 5, prepare departmental income statements for Skis and Snowboards. Important!...

Transcribed Image Text:

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 Total expenses Income (loss) Skis Snowboards Combined 0 0 0 0 SA $ 0 $ < Required 1 0 0 $ 0 Required 2 > Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Skis Sales: $180,000 Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales Skis Snowboards Cost of Skis Goods Sol Cost of Goods Sold: $75,600 Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Snowboards Sales: $135,000 Sales Cost of Goods Sold Sales Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards SKI Snowboards Cost of Goods Sold: $108,000 SNOWBOARD Sales Cost of Goods Sold Sales Cost Goods Sola Square Feet Occupied Snowboards Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI Skis 15 employees SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 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 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Snowboards 10 employees Snowboards Skis $12,000 $10,000 $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Sales Goods Sold Cost of Goods Sold SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 Snowboards $8,000 6,000 square feet $6,000 SKIS $4,000 $2,000 Indirect Expense Allocation Base Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Salaries Supplies Used Expense Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Sales Goods Sold Cost of Goods Sold SNOWBOARD Square Feet Occupied Snowboards Direct Expenses Skis Snowboards $12,000 $10,000 $8.000 Skis 00 Ski: 14,000 square feet 00 Indirect Expense Allocation Base $2,000 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Salaries Supplies Used Expense Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Skis Salaries Expense: $12,600 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Used Expense Supplies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Skis Supplies Used: $5,400 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Suppl.__ Used Expense -plies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Snowboards Indirect Expense Allocation Base Salaries Expense: $9,000 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Used Salaries Expense Supplies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Goods Sold Sales Cost of Goods Sold SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Supplies Expense Used Snowboards Supplies Used: $4,500 Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share 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 Total expenses Income (loss) Skis Snowboards Combined 0 0 0 0 SA $ 0 $ < Required 1 0 0 $ 0 Required 2 > Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Skis Sales: $180,000 Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Sales Skis Snowboards Cost of Skis Goods Sol Cost of Goods Sold: $75,600 Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Snowboards Sales: $135,000 Sales Cost of Goods Sold Sales Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards SKI Snowboards Cost of Goods Sold: $108,000 SNOWBOARD Sales Cost of Goods Sold Sales Cost Goods Sola Square Feet Occupied Snowboards Direct Expenses Skis Snowboards $12,000 $10,000 Burton Company requests assistance allocating costs and determining the profitability of its two departments: Skis and Snow Shared indirect expenses include rent and supervisor salaries. Use the Tableau Dashboard, with information from Burton's De 31 year-end reports, for our analysis. Select Year Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI Skis 15 employees SNOWBOARD Direct Expenses Skis Snowboards $12,000 $10,000 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 Year 7 Year 8 Year 9 Year 10 Sales & Costs of Goods Sold Number of Employees $175,000 $150,000 $125,000 $100,000 $75,000 $50,000 $25,000 Skis Snowboards Sales Cost of Goods Sold Sales Cost of Goods Sold Square Feet Occupied Snowboards SKI SNOWBOARD Direct Expenses Snowboards 10 employees Snowboards Skis $12,000 $10,000 $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Sales Goods Sold Cost of Goods Sold SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 Snowboards $8,000 6,000 square feet $6,000 SKIS $4,000 $2,000 Indirect Expense Allocation Base Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Salaries Supplies Used Expense Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Sales Goods Sold Cost of Goods Sold SNOWBOARD Square Feet Occupied Snowboards Direct Expenses Skis Snowboards $12,000 $10,000 $8.000 Skis 00 Ski: 14,000 square feet 00 Indirect Expense Allocation Base $2,000 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Salaries Supplies Used Expense Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Skis Salaries Expense: $12,600 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Used Expense Supplies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Skis Supplies Used: $5,400 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Suppl.__ Used Expense -plies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 Sales Cost of Goods Sold Sales Cost of Goods Sold SKI SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Snowboards Indirect Expense Allocation Base Salaries Expense: $9,000 Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Expense Supplies Used Salaries Expense Supplies Used Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share $125,000 $100,000 $75,000 $50,000 $25,000 SKI Sales Cost of Goods Sold Sales Cost of Goods Sold SNOWBOARD Square Feet Occupied Direct Expenses Skis Snowboards Snowboards $12,000 $10,000 $8,000 $6,000 Skis $4,000 $2,000 Indirect Expense Allocation Base Indirect Expense Cost Allocation Base Rent $14,400 Square feet occupied Salaries Supplies Expense Used Snowboards Supplies Used: $4,500 Supervisor salaries $27,000 Number of employees View on Tableau Public DC D Share