Question
Burton Co. requests assistance allocating costs and determining the profitability of its two departments: Skis and Snowboards. Shared indirect expenses include rent and supervision. Use
Burton Co. requests assistance allocating costs and determining the profitability of its two departments: Skis and Snowboards. Shared indirect expenses include rent and supervision. Use the Tableau Dashboard, with information from Burtons December 31 year-end reports, for our analysis.
Ski sales 100,000
Ski cost of goods sold 42,000
snowboard sales 75,000
snowboard cost of goods sold 60,000
skis number of employees 15
snowboards number of employees 10
skis square feet occupied 14,000
snowboards square feet occupied 6,000
skis salaries expense 7,000
skis supplies expense 3,000
snowboards salaries expense 5,000
snowboards supplies expense 2,500
1. Prepare a departmental contribution report that displays each departments contribution to overhead. 2. Based on contribution to overhead, do we recommend the Snowboard department be closed?
Number of Employees Sales & Costs of Goods Sold Skis Snowboards $100,000 $80,000 SKI $60,000 $40,000 $20,000 SNOWBOARD $0 Sales Cost of Ga.. Salles Cost of Go.. Square Feet Occupied Direct Expenses Snowboards Skis $7,000 Snowboards $6,000 $5,000 $4,000 Skls $3.000 $2,000 Indirect Expense Allocation Base $1,000 $0 Salarie Indirect Expense Cost Allocation Base Rent expense $0,000 square feet occupied Supervision expense $15,000 Number of employees tableau Supplie Salarie Supplie.. Required 1 Required 2 Prepare a departmental contribution report that displays each department's contribution to overhead. BURTON Departmental Contribution Statements For Year Ended December 31 Skis Snowboards Combined Direct expenses 0 0 0 Total direct expenses Departmental contributions to overhead Indirect expenses $ O 0 $ $ Total indirect expenses 0 $ 0 Required 1 Required 2 Based on contribution to overhead, do we recommend the Snowboard department be closed? Based on contribution to overhead, do we recommend the Snowboard department be closed
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started