arathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2019. Department Direct Expenses Square Feet Sales Advertising $ 15,000 1,080 Administrative 28,000 990 Shoes 123,000 3,330 $ 166,400 Clothing 18,000 3,600 93,600 The advertising department developed and distributed 240 advertisements during the year. Of these, 72 promoted shoes and 168 promoted clothing. Utilities expense of $45,000 is an indirect expense to all departments. Complete a departmental expense allocation spreadsheet for Marathon Running Shop.
The spreadsheet should assign (1) direct expenses to each of the four departments, (2) the $45,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising department’s expenses to the two operating departments on the basis of the number of ads placed that promoted a department’s products, and (4) the administrative department’s expenses to the two operating departments based on the amount of sales.
Departmental expense allocation spreadsheet | ||||||
Expenses total | Advertising | Administrative | Shoes | Clothing | ||
Direct expenses | $184000 | $15000 | $28000 | $123000 | $18000 | |
Utilities expense | $45000 | $5400 | $4950 | $16650 | $18000 | |
Total department expense | $229000 | $20400 | $32950 | $139650 | $36000 | |
Service department expense | ||||||
Advertising department | ($20400) | $6120 | $14280 | |||
Administrative department | ($32950) | $21088 | $11862 | |||
Total expenses allocated | $229000 | $0 | $0 | $166858 | $62142 | |
Allocation of cost for each department is as shown below | ||||||
Utilities | Allocation base | percent of allocation base | Cost to be allocated | Allocated cost | ||
Department | Numerator | Denominator | % total | |||
Advertising | Floor space | 1080 | 9000 | 12 | 45000 | $5400 |
Administrative | Floor space | 990 | 9000 | 11 | 45000 | $4950 |
Shoes | Floor space | 3330 | 9000 | 37 | 45000 | $16650 |
Clothing | Floor space | 3600 | 9000 | 40 | 45000 | $18000 |
Total | 9000 | |||||
Advertising | Allocation base | percent of allocation base | Cost to be allocated | Allocated cost | ||
Department | Numerator | Denominator | % total | |||
Shoes | No. of ads | 72 | 240 | 30 | $20400 | $6120 |
Clothing | No. of ads | 168 | 240 | 70 | $20400 | $14280 |
Total | 240 | $20400 | ||||
Administrative | Allocation base | percent of allocation base | Cost to be allocated | Allocated cost | ||
Department | Numerator | Denominator | % total | |||
Shoes | sales | 166400 | 260000 | 64 | $32950 | $21088 |
Clothing | sales | 93600 | 260000 | 36 | $32950 | $11862 |
Total | 260000 | $32950 |
arathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017. Department Direct Expenses Square Feet Sales Advertising $ 16,000 900 Administrative 29,000 500 Shoes 110,000 3,400 $ 139,200 Clothing 14,000 5,200 100,800 The advertising department developed and distributed 120 advertisements...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017. Department Direct Expenses Square Feet Sales Advertising $ 13,000 1,710 Administrative 26,000 1,710 Shoes 130,000 9,500 $ 186,000 Clothing 15,000 6,080 124,000 The advertising department developed and distributed 230 advertisements during the...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017 Square Feet Department Advertising Administrative Shoes Clothing Direct Expenses $12.00 31,000 85,000 16,000 2.340 2.600 $135,290 124,300 The advertising department developed and distributed 140 advertisements during the year. Of these, 14 promoted...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2019. Sales Department Advertising Administrative Shoes Clothing Direct Expenses $ 13,000 26,000 130,000 15,000 Square Feet 1,710 1,710 9,500 $186,000 124, een 6,089 The advertising department developed and distributed 230 advertisements during the...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017 Direct Expenses $ 20,000 30,000 128,000 19,000 Square Feet 1,680 1,260 10,290 7,770 Sales Department Advertising Administrative Shoes $179,800 130,200 Clothing The advertising department developed and distributed 130 advertisements during the year....
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017 Square Feet Sales Advertising Administrative Shoes clothing 13,000 26,000 130,000 15,000 1,710 1,710 9,500 6,080 $186,000 124,000 The advertising department developed and distributed 230 advertisements during the year. Of these, 69 promoted...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2019 Sales Direct Expenses $15,000 22,000 118,000 19,000 Department Advertising Administrative Square Feet 1,540 700 $145,600 114,400 5,180 6,580 Shoes clothing The advertising department developed and distributed 230 advertisements during the year. Of...
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017. Square Feet 600 Sales Department Advertising Administrative Shoes clothing Direct Expenses $ 12,000 31,000 85,000 16,000 420 2,340 2,640 $135,200 124,800 The advertising department developed and distributed 140 advertisements during the year....
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). The table that follows shows the direct expenses incurred and square footage occupied by all four departments, as well as total sales for the two operating departments for the year 2017 Sales Department Advertising Administrative Shoes Clothing Direct Expenses $ 15,000 27.000 103,90 13,00 Square Feet 500 700 4,100 4,700 $124,000 186,000 The advertising department developed and distributed 190 advertisements during the year....
Marathon Running Shop has two service departments (advertising and administrative) and two operating departments (shoes and clothing). During 2015, the departments had the following direct expenses and occupied the folowing amount of floor space. Department Advertising Administrative Shoes Clothing Direct Expenses $ 19,000 34.000 112,000 17,000 Square Feet 850 1,530 5.780 8.840 The advertising department developed and distributed 200 avertisements during the year. Of these, 20 promoted shoes and 180 promoted clothing. The store sold $290,000 of merchandise during the...