Question

In: Accounting

Marathon 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 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.

Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost
Department Numerator Denominator % of Total
Advertising 0
Administrative 0 0
Shoes 0 0
Clothing 0
Totals 0
Advertising Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost
Department Numerator Denominator % of Total
Shoes 0
Clothing 0
Totals 0
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, 2019
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

Solutions

Expert Solution

  • [1]

Utilities

Allcocation base

Numerator

Denominator

% of total

Cost to be allocated

Allocated Cost

Department:

Square feet

Advertising

Square feet

1080

9000

12%

$45,000

$5,400

Administrative

Square feet

990

9000

11%

$45,000

$4,950

Shoes

Square feet

3330

9000

37%

$45,000

$16,650

Clothing

Square feet

3600

9000

40%

$45,000

$18,000

Totals

9000

100%

$45,000

Advertising

Allcocation base

Numerator

Denominator

% of total

Cost to be allocated

Allocated Cost

Department:

No. of ads

Shoes

No. of ads

72

240

30%

$20,400

$6,120

Clothing

No. of ads

168

240

70%

$20,400

$14,280

Totals

240

100%

$20,400

Administrative

Allcocation base

Numerator

Denominator

% of total

Cost to be allocated

Allocated Cost

Department:

Amount of sales

Shoes

Amount of sales

166400

260000

64%

$32,950

$21,088

Clothing

Amount of sales

93600

260000

36%

$32,950

$11,862

Totals

260000

100%

$32,950

  • [2]

Expense Totals

Advertising

Administrative

Shoes

Clothing

Direct Expenses

$184,000

$15,000

$28,000

$123,000

$18,000

Indirect Utilities expense

$45,000

$5,400

$4,950

$16,650

$18,000

Total Dept Expense

$229,000

$20,400

$32,950

$139,650

$36,000

Service Depart Expenses:

Advertising Dept

$0

($20,400)

$6,120

$14,280

Administrative dept

$0

($32,950)

$21,088

$11,862

Total Expense allocated

$229,000

$0

$0

$166,858

$62,142


Related Solutions

Marathon 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 2019. Department Direct Expenses Square Feet Sales Advertising $ 14,000 1,350 Administrative 30,000 750 Shoes 116,000 7,200 $ 100,800 Clothing 17,000 5,700 109,200 The advertising department developed and distributed 140 advertisements during the...
Marathon 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 $ 18,000 1,120 Administrative 25,000 1,400 Shoes 103,000 7,140 $ 273,000 Clothing 15,000 4,340 77,000 The advertising department developed and distributed 120 advertisements during the...
Journalize all entries required for Marathon Running Shoes.
  Question Journalizing credit card sales 2018 Sep. 1 Recorded National Express credit card sales for $96,000, net of processor fee of 1%. Ignore Cost of Goods Sold. 15 Recorded ValueMax credit card sales of $80,000. Processor charges a 1.5% fee. ValueMax charges the fee at the end of the month, therefore Marathon uses the gross method for these credit card sales. Ignore Cost of Goods Sold. 30 ValueMax collected the fees for the month of September. Assume the September...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs to operating departments using the step-down method. Operating data for these departments for last year are as follows: Service Departments Operating Departments Personnel Maintenance Assembly Machining Departmental costs $144,000 $84,000 $12,000 $34,000 Number of employees 35 30 90 60 Machine-hours 0 0 330 170 Personnel costs are allocated first on the basis of number of employees and Maintenance costs are allocated second on the...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs...
Andy Corp. has two service departments and two operating departments. The company allocates service departmental costs to operating departments using the step-down method. Operating data for these departments for last year are as follows: Service Departments Operating Departments Personnel Maintenance Assembly Machining Departmental costs $144,000 $84,000 $12,000 $34,000 Number of employees 35 30 90 60 Machine-hours 0 0 210 290 Personnel costs are allocated first on the basis of number of employees and Maintenance costs are allocated second on the...
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International....
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows. Administration Accounting Domestic International Employees – 21 46 33 Transactions 35,000 – 18,000 72,000 Department direct costs $ 361,000 $ 142,000 $ 950,000 $ 3,680,000 Required: a. Allocate the cost of the service departments to the operating...
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International....
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows: Administration Accounting Domestic International Employees – 28 36 36 Transactions 38,000 – 20,000 80,000 Department direct costs $ 363,000 $ 141,000 $ 955,000 $ 3,750,000 Allocate the cost of the service departments to the operating departments using...
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International....
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows. Administration Accounting Domestic International Employees — 25 15 60 Transactions 50,000 — 10,000 40,000 Department direct costs $ 58,000 $ 24,500 $ 159,750 $ 597,000 BluStar estimates that the cost structure in its operations is as follows....
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International....
BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows. Administration Accounting    Domestic    International Employees    – 30 40    30 Transactions 36,000    – 19,000 76,000 Dept direct costs $ 359,000 $ 146,000    $ 930,000    $ 3,720,000 Required:c. Allocate the cost of...
University Printers has two service departments (Maintenance and Personnel) and two operating departments (Printing and Developing)....
University Printers has two service departments (Maintenance and Personnel) and two operating departments (Printing and Developing). Management has decided to allocate maintenance costs on the basis of machine-hours in each department and personnel costs on the basis of labor-hours worked by the employees in each. The following data appear in the company records for the current period: Maintenance Personnel Printing Developing Machine-hours — 1,000 1,000 3,000 Labor-hours 500 — 500 2,000 Department direct costs $ 5,000 $ 12,000 $ 15,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT