Oriole Equipment sells equipment to sports enthusiasts. Doug Oriole, the company's president, just received the following income
Question:
Oriole Equipment sells equipment to sports enthusiasts. Doug Oriole, the company's president, just received the following income statement reporting the results of the past year.
Baseball | Soccer | Basketball | Total | |||||||
Sales revenue | $1,290,000 | $3,690,000 | $2,427,000 | $7,407,000 | ||||||
Variable cost of goods sold | 870,000 | 2,398,500 | 1,953,600 | 5,222,100 | ||||||
Fixed cost of goods sold | 117,500 | 191,700 | 168,900 | 478,100 | ||||||
Gross profit | 302,500 | 1,099,800 | 304,500 | 1,706,800 | ||||||
Variable operating expenses | 174,000 | 590,400 | 242,700 | 1,007,100 | ||||||
Fixed operating expenses | 81,000 | 86,100 | 74,700 | 241,800 | ||||||
Common fixed costs | 61,500 | 132,000 | 99,300 | 292,800 | ||||||
Operating income | ($14,000) | $291,300 | ($112,200) | $165,100 |
Doug is concerned that two of the company's divisions are showing a loss, and he wonders if the company should stop selling baseball and basketball gear to concentrate solely on soccer gear.
(a)
Do a segment margin income statement. Fixed cost of goods sold and fixed operating expenses can be traced to each division. (If the amount is negative then enter with a negative sign preceding the number, e.g. -5,125 or parenthesis, e.g. (5,125).)
Baseball | Soccer | Basketball | Total | |||||
select an income statement item Common Fixed ExpensesOperating ExpensesContribution MarginOperating IncomeSales RevenueTraceable Fixed ExpensesCost of Goods SoldSegment MarginVariable Expenses | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | $enter a dollar amount | ||||
select between addition and deduction LessAdd:select an opening name for section one Contribution MarginSegment MarginCommon Fixed ExpensesVariable ExpensesSales RevenueTraceable Fixed ExpensesOperating ExpensesCost of Goods SoldOperating Income | ||||||||
select an income statement item Segment MarginTraceable Fixed ExpensesContribution MarginVariable ExpensesSales RevenueCommon Fixed ExpensesOperating IncomeOperating ExpensesCost of Goods Sold | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
select an income statement item Traceable Fixed ExpensesSegment MarginCost of Goods SoldSales RevenueContribution MarginOperating ExpensesCommon Fixed ExpensesOperating IncomeVariable Expenses | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
select a summarizing line for the first part Cost of Goods SoldSegment MarginCommon Fixed ExpensesOperating IncomeContribution MarginOperating ExpensesVariable ExpensesTraceable Fixed ExpensesSales Revenue | enter a total amount for the first part | enter a total amount for the first part | enter a total amount for the first part | enter a total amount for the first part | ||||
select an opening name for section two Traceable Fixed ExpensesSegment MarginVariable ExpensesContribution MarginOperating IncomeSales RevenueCost of Goods SoldCommon Fixed ExpensesOperating Expenses | ||||||||
select an income statement item Segment MarginTraceable Fixed ExpensesVariable ExpensesSales RevenueOperating IncomeContribution MarginCost of Goods SoldCommon Fixed ExpensesOperating Expenses | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
select an income statement item Traceable Fixed ExpensesSegment MarginCost of Goods SoldVariable ExpensesOperating ExpensesSales RevenueOperating IncomeCommon Fixed ExpensesContribution Margin | enter a dollar amount | enter a dollar amount | enter a dollar amount | enter a dollar amount | ||||
select a summarizing line for the second part Operating IncomeVariable ExpensesTraceable Fixed ExpensesCommon Fixed ExpensesCost of Goods SoldSales RevenueOperating ExpensesContribution MarginSegment Margin | $enter a total amount for the second part | $enter a total amount for the second part | $enter a total amount for the second part | enter a total amount for the second part | ||||
select an income statement item Variable ExpensesCost of Goods SoldCommon Fixed ExpensesContribution MarginOperating IncomeOperating ExpensesSegment MarginTraceable Fixed ExpensesSales Revenue | enter a dollar amount | |||||||
select a closing name for this statement Traceable Fixed ExpensesOperating IncomeVariable ExpensesCost of Goods SoldSegment MarginOperating ExpensesCommon Fixed ExpensesSales RevenueContribution Margin |