128
196) Boiano Corp. operates a retail store and has two service departments and two operating
departments, Hardware and Automotive. During the current year, the departments had the
following direct expenses and occupied the following amount of floor space.
The advertising department developed and aired 150 spots. Of these spots, 60 spots were for
Hardware and 90 spots were for Automotive. The store sold $1,500,000 of merchandise during
the year; $675,000 in Hardware and $825,000 in Automotive. Indirect expenses include rent,
utilities, and insurance expense. Total indirect expenses of $220,000 are allocated to all
departments. Prepare a departmental expense allocation spreadsheet for Boiano. The spreadsheet
should assign (1) direct expenses to each of the four departments, (2) allocate the indirect
expenses to each department on the basis of floor space occupied, (3) the advertising
department’s expenses to the two operating departments on the basis of ad spots placed
promoting each department’s products, (4) the administrative department’s expenses based on the
amount of sales. Complete the departmental expense allocation spreadsheet below. Provide
supporting computations for the expense allocations below the spreadsheet.
Departmental Expense Allocations
For Year Ended December 31