Advertising | Allocation Base | Percent of Allocation Base | Cost to be Allocated | Allocated Cost | ||
Department | Sales | Numerator | Denominator | % of Total | ||
Books Dept | 184,900 | 184,900 | 430000 | 43% | 57800 | 24854 |
Magazines Dept | 107,500 | 107,500 | 430000 | 25% | 57800 | 14450 |
Newspapers Dept | 137,600 | 137,600 | 430000 | 32% | 57800 | 18496 |
Totals | 430000 | 100% | 57800 | |||
Purchasing | Allocation Base | Percent of Allocation Base | Cost to be Allocated | Allocated Cost | ||
Department | Number of orders | Numerator | Denominator | % of Total | ||
Books Dept | 816 | 816 | 1700 | 48% | 57800 | 27744 |
Magazines Dept | 476 | 476 | 1700 | 28% | 57800 | 16184 |
Newspapers Dept | 408 | 408 | 1700 | 24% | 57800 | 13872 |
Totals | 1700 | 100% | 57800 | |||
2 | ||||||
COZY BOOKSTORE | ||||||
Departmental Expense Allocation Spreadsheet | ||||||
Allocation Base | Expense Totals | Advertising | Purchasing | Books | Magazines | Newspapers |
Total department expenses | 578000 | 57800 | 57800 | 138700 | 115600 | 208100 |
Service Dept. expenses | ||||||
Advertising Dept. | -57800 | 24854 | 14450 | 18496 | ||
Purchasing Dept. | -57800 | 27744 | 16184 | 13872 | ||
Total expenses allocated | 578000 | 0 | 0 | 191298 | 146234 | 240468 |
Advertising department expenses of $57,800 and purchasing department expenses of $57,800 of Cozy Bookstore are allocated...
Advertising department expenses of $57,800 and purchasing department expenses of $57,800 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. Purchase Orders Department Books Magazines Newspapers $184,900 107,500 137,600 $430,000 408 Total Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Complete this question by entering your answers...
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 Books Magazines Newspapers Total Sales $180,400 123,000 106,600 $410,000 Purchase Orders 1,290 690 1,020 3,000 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Allocation of Exp...
Advertising department expenses of $36,600 and purchasing department expenses of $26,200 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. Purchase Orders 644 Department Books Magazines Newspapers Total Sales $ 179,400 81,900 128,709 $ 390,000 406 350 1,400 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Complete...
Exercise 9-3 Service department expenses allocated to operating departments LO P2 Advertising department expenses of $57,800 and purchasing department expenses of $57,800 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. Purchase Orders 816 Books Magazines Newspapers sales $184,900 107,500 137.600 $430,000 476 Total Complete the following table by allocating the expenses of the two service departments (advertising and purchasing)...
Advertising department expenses of $38,900 and purchasing department expenses of $38,900 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 Books Magazines Newspapers Total Sales $180,000 108,000 72,000 $360,000 Purchase Orders 984 600 816 2,400 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing to the three operating departments Complete this question...
Advertising department expenses of $25,300 and purchasing department expenses of $20,200 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. Sales Purchase Orders Department Books Magazines Newspapers Total $182,400 87,400 110,200 $ 380,0ee 1,025 625 850 2,500 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Complete this...
Ch 09 Ex 9-3 Exercise 09-3 Service department expenses allocated to operating departments LO P2 points Advertising department expenses of $57,800 and purchasing department expenses of $57,800 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. eBook Department Books Magazines Newspapers Total Sales $ 184,900 107,500 137,600 $ 430,000 Purchase Orders 816 476 408 1,700 Hint Complete the following table...
Advertising department expenses of $88,600 and purchasing department expenses of $44,300 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 Books Magazines Newspapers Total Sales $ 202,400 123,200 114,400 $440,000 Purchase Orders 861 609 630 2,100 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. Complete this...
Check my Advertising department expenses of $24,000 and purchasing department expenses of $34,000 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 Books Magazines Newspapers Total Sales $495,000 198,000 207,000 $900,000 Purchase Orders 516 360 324 1,200 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments. res...
Advertising department expenses of $48,200 and purchasing department expenses of $40,200 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 $ 167,700 1,232 Magazines 89,700 756 Newspapers 132,600 812 Total $ 390,000 2,800 Complete the following table by allocating the expenses of the two service departments (advertising and purchasing) to the three operating...