Can someone help me finish? thanks. not clicking.

Exercise 22-2 Departmental expense allocation-spreadsheet LO P2

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 following amount of floor space.

Department

Direct Expenses

Square Feet

Advertising

$

15,000

1,540

Administrative

22,000

700

Shoes

118,000

5,180

Clothing

19,000

6,580

The advertising department developed and distributed 230 advertisements during the year. Of these, 23 promoted shoes and 207 promoted clothing. The store sold $260,000 of merchandise during the year. Of this amount, $145,600 is from the shoes department, and $114,400 is from the clothing department. The utilities expense of $66,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 $66,000 of utilities expense to the four departments on the basis of floor space occupied, (3) the advertising departments expenses to the two operating departments on the basis of the number of ads placed that promoted a departments products, and (4) the administrative departments expenses to the two operating departments based on the amount of sales.

Utilities	Allocation Base	Percent of Allocation Base			Cost to be Allocated	Allocated Cost
Department	Floor space occupied	Numerator	Denominator	% of Total
Advertising	1,540	1,540	14,000	11.00	$66,000	$7,260
Administrative	700	700	14,000	5.00	66,000	3,300
Shoes	5,180	5,180	14,000	37.00	66,000	24,420
Clothing	6,580	6,580	14,000	47.00	66,000	31,020
Totals	14,000			100.00		$66,000
Advertising	Allocation Base	Percent of Allocation Base			Cost to be Allocated	Allocated Cost
Department	Number of ads	Numerator	Denominator	% of Total
Shoes	23	23	230	10.00
Clothing	207	207	230	90.00
Totals	230			100.00
Administrative	Allocation Base	Percent of Allocation Base			Cost to be Allocated	Allocated Cost
Department		Numerator	Denominator	% of Total
Shoes				0
Clothing				0
Totals				0
MARATHON RUNNING SHOP
Departmental Expense Allocation Spreadsheet
For Year Ended December 31, 2015
	Expense Totals	Advertising	Administrative	Shoes	Clothing
Direct expense
Indirect utilities expenses	0
Total dept. exp.	0	0	0	0	0
Service Dept. Expenses
Advertising Dept.		0
Administrative Dept.			0
Total expenses allocated	$0	$0	$0	$0	$0