Advertising department expenses of $26,700 and purchasing department expenses of $46,700 of Cozy Bookstore are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows. Department Sales Purchase Orders
Books $180,400 1,290
Magazines 123,000 690
Newspapers 106,600 1,020
Total $410,000 3,000
Complete a table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments.

The advertising department expense allocated to each department are as follows:

Books Dept = $11,748

Magazines Dept = $8,010

Newspapers Dept = $6,942

Totals advertising department expenses allocated = $26,700

The purchasing department expenses allocated to each department are as follows:

Books Dept = $20,081

Magazines Dept = $10,741

Newspapers Dept = $15,878

Total purchasing department expenses allocated = $46,700

Explanation:

Note: See the attached excel for the completed table used in allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments.

From the attached excel, the advertising department expense allocated to each department are as follows:

Books Dept = $11,748

Magazines Dept = $8,010

Newspapers Dept = $6,942

Totals advertising department expenses allocated = $26,700

From the attached excel, the purchasing department expenses allocated to each department are as follows:

Books Dept = $20,081

Magazines Dept = $10,741

Newspapers Dept = $15,878

Total purchasing department expenses allocated = $46,700