Question

In: Accounting

The computer department (CD) of ABC Corporation is considered a service department, and allocations of the...

The computer department (CD) of ABC Corporation is considered a service department, and allocations of the costs incurred by this department are made to the three divisions within ABC, (X, Y, and Z) benefiting from its use. These three divisions originally requested the idea of centrally provided computer services and estimated the extent of their long term need for computer support so that the needed capacity for this service could be identified. These estimates for long term use and the actual CPU time used during the current month, December, are shown below for each using division:

Division

% of Expected Long-Term

Use of Capacity

Actual CPU Hours Used

In December

X

Y

Z

Total

30 %

60 %

10 %

100%

1,500

7,500

1,000

10,000

CD’s actual costs incurred for the month of December were $500,000; CD’s budgeted monthly costs are determined using the following equation incorporating CPU Hours as the cost driver:

Budgeted Monthly CD Cost = $475,000 + $1.50 per CPU Hour

Use this information to answer the next four questions.

1. Determine the total December computer costs that should be allocated  FROM CD to the using divisions using allocation Method 1 (actual costs w/ actual use):

Group of answer choices

$490,000

$475,000

$500,000

$515,000

2. Determine the total December computer costs that should be allocated  FROM CD to the using divisions using allocation Method 2 (budgeted costs w/ actual use):

Group of answer choices

$515,000

$490,000

$500,000

$475,000

3. Indicate the $ amount of the total allocation that would be allocated TO Division Y only, using Method 2 (budgeted costs w/ actual use).

Group of answer choices

$300,000

$296,250

$294,000

$367,500

4. Indicate the $ amount of the total CD allocation that would be allocated TO Division Y only, using the Dual Rate Method.

Group of answer choices

$367,500

$300,000

$294,000

$296,250

Solutions

Expert Solution

1) The total December computer cost that should be allocated FROM CD to the using divisions using allocation Method 1 ( actual cost w/actual use

                             = $ 500000

2) The total December computer cost that should be allocated FROM CD to the using divisions using allocation method 2 (budgeted cost w/actual use)

Given as per question – Budgeted Monthly CD cost = $ 475000 + $1.5 per CPU Hour.

Actual CPU hours used for December is 10000 Hrs.   hence

The total cost should be allocated is - $475000 + $1.5 x 10000 = $ 490000

3. The $ amount of the total allocation that would be allocated TO Division Y only, using Method 2 (budgeted costs w/ actual use) is

The total cost should be allocated under budgeted cost is –

   $475000 + $1.5 x 10000 = $ 490000

Actual CPU hours used for December is     -   10000 Hrs

Actual CPU hours used for December by Y division   is - 7500 Hrs.

The amount of the total allocation that would be allocated to division Y is

      $490000 x 7500hrs/10000hrs = $ 367500

4. The $ amount of the total CD allocation that would be allocated TO Division Y only, using the Dual Rate Method.

The total cost should be allocated under budgeted cost is –

   $475000 + $1.5 x 10000 = $ 490000

% of expected long term use capacity - 60% hence

   Amount allocated to y    = $294000


Related Solutions

ABC Corporation has three service departments with the following costs and activity base: Service Department Cost...
ABC Corporation has three service departments with the following costs and activity base: Service Department Cost Activity Base for Allocation Graphics Production $200,000 # of copies Accounting $500,000 # of invoices processed Personnel Department $400,000 # of employees ABC has three operating divisions, Micro, Macro and Super. Their revenue, cost and activity information for December 31, 2017 are as follows: Micro Macro Super Direct Revenues $700,000 $850,000 $650,000 Direct Operating Expenses $50,000 $70,000 $100,000 # of copies made 20,000 30,000...
1. Support Department Allocations And Cost Drivers Varney Corporation, a manufacturer of electronics and communications systems,...
1. Support Department Allocations And Cost Drivers Varney Corporation, a manufacturer of electronics and communications systems, allocates Computing and Communications Services Department (CCS) costs to profit centers. The following table lists the types of services and cost drivers for each service. The table also includes the budgeted cost and quantity for each service for August. CCS Services Cost Drivers Budgeted Cost Budgeted Quantity of Services Help desk Number of calls $90,000 3,600 Network center Number of devices 120,000 1,500 Electronic...
ABC Corporation makes skis in two departments: Department A makes      the frame and Department B...
ABC Corporation makes skis in two departments: Department A makes      the frame and Department B adds the bindings and paints the skis. Monthly      capacities are as follows:                                                                         Department A         Department B                  Monthly capacity                         4,000 pairs of skis    5,000 pairs of skis                      The company can sell 5,000 pairs per month. A pair of skis sells for $500 and has a      variable cost of $250.     Required: Assuming that ABC sells every pair it...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $40,248, and the Purchasing Department had expenses of $12,470 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $40,768, and the Purchasing Department had expenses of $19,430 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are...
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $68,768, and the Purchasing Department had expenses of $33,630 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...
ABC Corporation is a service company that measures its output based on the number of customers...
ABC Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes: Fixed amount per month Variable amount per customer Revenue $5,000 Payroll cost $50,000 $1,100 Travel expenses $600 Admin expenses $36,000 $500 Other expenses $10,000 $200 When preparing its planning budget, the company estimated that it would serve 60 customers per month; however, during April the company actually...
43. Division A reported operating income of $975,000 and total support department allocations of $675,000. As...
43. Division A reported operating income of $975,000 and total support department allocations of $675,000. As a result, a.net income was $300,000 b.the gross profit was $300,000 c.consolidated net income was $300,000 d.operating income before support department allocations was $1,650,000 42. Operating income of the Pierce Automobile Division is $2,225,000. If operating income before support department allocations is $3,250,000, a.noncontrollable charges are $1,025,000 b.direct manufacturing charges are $1,025,000 c.operating expenses are $1,025,000 d.total support department allocations are $1,025,000 41. Operating...
ABC Corporation wants to purchase an old office building with an estimated remaining service life of...
ABC Corporation wants to purchase an old office building with an estimated remaining service life of 25 years. Recently, the tenants signed long-term leases, which leads you to believe that the current rental income of $250,000 per year will remain constant for the first 5 years. Then the rental income will increase by 10% for every 5-year interval over the remaining life of the asset. For example, the annual rental income would be $275,000 for years 6 through 10, $302,500...
(Computer memory) (Computer-integrated Manufacturing) A retail store uses a CD ROM with 700 MB capacity to...
(Computer memory) (Computer-integrated Manufacturing) A retail store uses a CD ROM with 700 MB capacity to store its products name, specification and manufacturer information. On the average, including the spaces between words, the products names are 15 letters long. The product specification and manufacturer information require 60 and 30 letters each. An additional 200 letters is required for retailer tracking information. How many CDs are necessary for 1,000,000 products?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT