19) 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.