21. The Tampa Division of Awercamp Manufacturing produces and markets two product lines: Racquets and Gloves. The following data were gathered on activities last month:
Sales in Units 1,000 5,000
Selling Price Per Unit $100 $40
Variable Costs Per Unit $31 $10
Traceable Fixed Costs $30,000 $60,000
Common Fixed Costs ($30,000)
Prepare a segmented income statement for last month showing columns for the division as a whole and for each product line.© BrainMass Inc. brainmass.com June 4, 2020, 4:48 am ad1c9bdddf
A segmented Income Statement was created for each product line and the division. Each calculation is explained with the Microsoft Excel spreadsheet.