Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Exercise 1

PROBLEM DATA
Ottawa Scuba Supply, Inc., has divided its operations into two departments: Supplies, devoted to selling scuba tanks and supplies; and Apparel, devoted to selling sports clothing and underwater apparel. Departmental expense accounts are kept for direct expenses, but indirect (common) expenses are not allocated until the end of the accounting period. Selected data at June 30, the end of the current fiscal year, are as follows:

The bases for allocating indirect expenses are as follows:

REQUIREMENT
As the accountant for Ottawa Scuba Supply, you have been asked to prepare a departmental income statement. Review the worksheet DEPT that follows these requirements. All of the problem information relating to direct expenses has been entered into the Answer Section. You will be allocating the indirect expenses to the appropriate departments.