Jack Donaldson Owns and Operates Jack's Abstracting Service Required:
Use the Reciprocal Method to Allocate the Service Department

question 39

Essay

Jack Donaldson owns and operates Jack's Abstracting Service.Jack's two revenue generating operations (Abstracting Services and Closing Services)are supported by two service departments: Clerical and Custodial.Costs in the service departments are allocated in the following order using the designated allocation bases.Clerical: number of transactions processed.Custodial: square footage of space occupied.Average and expected activity levels for next month are as follows: $$\begin{array} { | l r | r | r | } \hline & \begin{array} { r } \text { Number of } \\\text { Transactions }\end{array} & \begin{array} { r } \text { Square } \\\text { Footage }\end{array} & \begin{array} { r } \text { Expected } \\\text { Costs }\end{array} \\\text { Abstract services } & 50 & 1,800 & \\\hline \text { Closing services } & 25 & 2,200 & \\\hline \text { Clerical } & & 1,600 & \$ 40,000 \\\hline \text { Custodial } & 5 & &10,000 \\\hline\end{array}$$
Required:
Use the reciprocal method to allocate the service department costs to the revenue generating departments.Provide the total costs for the revenue departments.

---

Definitions:

Selected Records

Refers to the specific data entries chosen based on certain criteria within a data set or database.

AND Criteria

A logical condition used in database queries and programming that requires all specified conditions to be true for an action to be taken or a record to be selected.

Criteria Row

In database queries, a row where conditions are defined to filter the data returned in the query results.

Query Design

The process of creating a request to access, retrieve, or manipulate data within a database through a graphical or textual interface.