An asterisk (*) will appear to the right of an incorrect entry.
Revenues
Cost of goods sold
Gross profit
Operating expenses
Income from operations before
service department charges
Less service department charges:
Tech Support Dept.
Purchasing Dept.
Income from continuing operations
Income from operations
Score:
Key Code:
Instructions
Exercise 24-7
Name:
Section:
0%
Consumer Division
Commercial Division
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
YOZAMBA TECHNOLOGY
Divisional Income Statements
For the Year Ended December 31, 2016
An asterisk (*) will appear to the right of an incorrect entry.
Revenues 7,430,000$ 6,184,000$
Cost of goods sold 4,123,000 3,125,000
Cells with non-gray backgrounds are protected and cannot be edited.
For the Year Ended December 31, 2016
YOZAMBA TECHNOLOGY
Divisional Income Statements
Consumer Division
Commercial Division
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
Exercise 24-7
Name:
Solution
Section:
ON
An asterisk (*) will appear to the right of an incorrect entry.
Winter Summer
Sports Sports
Division Division
Sales
Cost of goods sold
Gross profit
Divisional expenses:
Divisional selling expenses
Divisional administrative expenses
Total
Income from operations before service department charges
Less service department charges:
Advertising expense
Transportation expense
Accounts receivable collection expense
Warehouse expense
Total
Income from operations
Score:
Key Code:
Instructions
Exercise 24-9
Name:
Section:
0%
Divisional Income Statements
For the Year Ended December 30, 2016
[Key code here]
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
XSPORT SPORTING GOODS CO.
Supporting schedule:
Winter Summer
Sports Sports
Division Division Total
Advertising expense
Number of bills of lading
Transportation rate per bill of lading
Transportation expense
Number of sales invoices
Accounts recievable collection rate
Accounts receivable collection expense
Number of warehouse square feet
Warehouse rate per square foot
Warehouse expense
Service Department Charges
An asterisk (*) will appear to the right of an incorrect entry.
Winter Summer
Sports Sports
Division Division
Sales 10,500,000$ 13,600,000$
Cost of goods sold
6,300,000 7,888,000
Gross profit 4,200,000$ 5,712,000$
Divisional expenses:
Divisional selling expenses
1,680,000$ 1,904,000$
Less service department charges:
Advertising expense 216,900$ 265,100$
Transportation expense 115,200 124,800
Accounts receivable collection expense
XSPORT SPORTING GOODS CO.
Divisional Income Statements
ON
Cells with non-gray backgrounds are protected and cannot be edited.
Exercise 24-9
Name:
Solution
Section:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
For the Year Ended December 30, 2016
Supporting schedule:
Winter Summer
Sports Sports
Division Division Total
Advertising expense 216,900$ 265,100$ 482,000$
Number of bills of lading 14,400 15,600
Transportation rate per bill of lading $8.00 $8.00
Service Department Charges