Gallatin Carpet Cleaning has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $$12\mathrm{.}10$ per hundred square feet. However, there is some question about whether the company is making a profit on jobs requiring considerable travel time. The owner's daughter suggested answering this question by designing an activity$-$based costing system using the information shown below:

The total cost of operating the company for the year is $$360,000$ which includes the following costs:

She distributed these operating costs across her four activities as follows:

Job support consists of receiving calls from potential customers at tha home office, scheduling jobs, billing, resolving issues, and so on$.$

Required:

Prepare the first$-$stage allocation of costs to the activity cost pools:

Compute the activity rates for the activity cost pools.

The company recently completed a $200-$square$-$foot carpet$-$cleaning job at the Flling $N$ Ranch$-$a $60-$mile round$-$trip from the company's home office Compute the cost of this job using the activity$-$based costing system.

The revenue from the Flying $N$ Ranch was square feet $$12\mathrm{.}10$ per hundred square feet$).$ Calculate the customer margin earned on this job.

Answer is complete but not entirely correct:

Complete this question by entering your answers in the tabs below.

Required $1$

Reguired $2$

Required $3$

Required $4$

Prepare the first$-$stage allocation of costs to the activity cost pools.

$\backslash$table$[[,,\backslash$table$[[$Cleaning$],[$Carpets$]],,\backslash$table$[[$Travel to$],[$Jobs$]],,\backslash$table$[[$Job$],[$upport$]],$Other,Total$],[$Wages$,$$$,116,000,$$$,14,500$$$,$$$,98,14,500,],[$Cleaning supplies,,$20,000,,,,02,08,20\mathrm{.}008],[$Cleaning equipment depreciation,,$11,700$@$,,Q,,08,6,3008,18,000],[$Vehicle expenses,,$00,,25,920Pm,,00,6,080,32,000],[$Office expenses,,$09,,0,,41\mathrm{.}6008,22400x,64,000],[$President$\text{'}$s compensation,,$0\%,,08,,20\mathrm{.}2500,60,750,81,000],[$Total cost$,$$$,147\mathrm{.}700,$$$,40\mathrm{.}420,$$$,61,850,110,030,360,000]]$