Franklin Co Departmental Data for the Company's Recent Reporting Period Follow

Essay

Franklin Co. has three departments: purchasing, human resources, and assembly. In a recent month the three departments incurred two shared indirect expenses. The amounts of the indirect expenses and the bases used to allocate them follow. Use this information to allocate each of the two indirect expenses across the three departments using the tables provided below.
$$\begin{array} { | l | c | c | } \hline \text { Indirect Expense } & \text { Cost } & \text { Allocation Base } \\\hline \text { Supervision } & \$ 85,000 & \text { Number of employees } \\\hline \text { Utilities and Insurance } & \underline { 38,000 } & \text { Square feet occupied } \\\hline \text { Total } & \underline { 123,000 } & \\\hline\end{array}$$ Departmental data for the company's recent reporting period follow.
$\begin{array}{|l|c|c|} \hline \text { Department } & \text { Employees } & \text { Square Feet } \\\hline \text { Purchasing } & 10 & 15,000 \\\hline \text { Human Resources } & 6 & 10,000 \\\hline \text { Assembly } & \underline{20} &\underline{ 25,000 }\\\hline \text { Total } & \underline{36} & \underline{50,000 }\\\hline \text { Supervision } & & \\\hline \text { Purchasing } & & \\\hline \text { Human Resources } & & \\\hline \text { Assembly } & & \\\hline \text { Total } & &\\\hline \end{array}$
$$\begin{array} { | l | l | l | l | } \hline \text { Utilities and Insurance } &\quad\quad\quad &\quad\quad\quad &\quad\quad\quad \\\hline \text { Purchasing } & & & \\\hline \text { Human Resources } & & & \\\hline \text { Assembly } & & & \\\hline \text { Total } & & & \\\hline\end{array}$$