Data table

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & A & B & C & D & E $\backslash \backslash$

$\backslash$hline $1$ & & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$SUPPORT DEPARTMENTS$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$OPERATING DEPARTMENTS$\}\backslash \backslash$

$\backslash$hline $2$ & & Human Resources & Information Systems & Corporate Sales & $\backslash$begin$\{$tabular$\}\{$l$\}$

Consumer $\backslash \backslash$

Sales

$\backslash$end$\{$tabular$\}\backslash \backslash$

$\backslash$hline $3$ & Budgeted costs incurred before any interdepartment cost allocations & $\backslash$$ $20,000$ & $\backslash$$ $220,000$ & $\backslash$$ $980,000$ & $\backslash$$ $515,000\backslash \backslash$

$\backslash$hline $4$ & Support work supplied by human resources department & & & & $\backslash \backslash$

$\backslash$hline $5$ & Budgeted number of employees & $0$ & $30$ & $49$ & $21\backslash \backslash$

$\backslash$hline $6$ & Support work supplied by information systems department & & & & $\backslash \backslash$

$\backslash$hline $7$ & Budgeted processing time $($in minutes$)$ & $400$ & $0$ & $2,500$ & $2,100\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ Tech Books, an online book retailer, has two operating departments$-$corporate sales and consumer sales$-$and two support departments$-$human resources and information systems. Each sales department conducts merchandising and marketing operations independently. Tech Books uses number of employees to allocate human resources costs and processing time to allocate information systems costs. The following data are available for September $2020$:

$($Click the icon to view the data.$)$

Read the equirements.

Requirement $1.$ Allocate the support departments' costs to the operating departments using the direct method. $($Do not round intermediary calculations. Only round the amount you input in the input field to the nearest dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a $"0"$ for any zero balances.

Abbreviations used: HR $=$ Human resources; Info. $=$ Information.$)$ Requirements

$1.$ Allocate the support departments' costs to the operating departments using the direct method.

$2.$ Rank the support departments based on the percentage of their services provided to other support departments. Use this ranking to allocate the support departments' costs to the operating departments based on the step$-$down method.

$3.$ How could you have ranked the support departments differently? Data table

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & A & B & C & D & E $\backslash \backslash$

$\backslash$hline $1$ & & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$SUPPORT DEPARTMENTS$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$OPERATING DEPARTMENTS$\}\backslash \backslash$

$\backslash$hline $2$ & & Human Resources & Information Systems & Corporate Sales & Consumer Sales $\backslash \backslash$

$\backslash$hline $3$ & Budgeted costs incurred before any interdepartment cost allocations & $\backslash$$ $20,000$ & $\backslash$$ $220,000$ & $\backslash$$ $980,000$ & $\backslash$$ $515,000\backslash \backslash$

$\backslash$hline $4$ & Support work supplied by human resources department & & & & $\backslash \backslash$

$\backslash$hline $5$ & Budgeted number of employees & P & $30$ & $49$ & $21\backslash \backslash$

$\backslash$hline $6$ & Support work supplied by information systems department & & & & $\backslash \backslash$

$\backslash$hline $7$ & Budgeted processing time $($in minutes$)$ & $400$ & $0$ & $2,500$ & $2,100\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$