Question

In: Accounting

Zeta Department Store has developed the following information in order to develop a TDABC model for...

Zeta Department Store has developed the following information in order to develop a TDABC model for its accounts receivable department:

Activity Estimated worker time to perform activity
manual processing of invoice and cash receipt 1.0 hour
electronic processing of invoice and electronic funds transfer 0.1 hour
maintain customer file 0.5 hour

The time to process payments of customer invoices depends on whether the customer pays the bill manually or electronically, as shown above. The time to maintain each customer file is the same for all customers. The annual cost of the accounts receivable department is $500,000, and the associated practical capacity of accounts receivable labor is 10,000 hours. The accounts receivable department has six employees.

(a) What is the capacity cost rate for the accounts receivable department?

(b) Zeta’s division 1 has 1,000 small- to medium-sized customers who annually generate a total of $10 million in sales, resulting in 4,000 invoices. These customers pay all their invoices manually. What is the annual activity-based cost associated with division 1’s customers?

(c) Zeta’s division 2 has 200 large customers who annually generate a total of $10 million in sales, resulting in 400 invoices. These customers pay all of their invoices electronically. What is the annual activity-based cost associated with division 2’s customers?

(d) Suppose half of Zeta’s division 1 customers change their method of payment to electronic next year. How many hours of accounts receivable labor will it require for 1,000 customers, 2,000 manual invoices, and 2,000 electronic invoices? How much will division 1 be charged for the accounts receivable function? Will Zeta’s costs decrease because of the shift to 50% electronic invoicing in division 1?

Solutions

Expert Solution

Solution :

(a)

Calculate the capacity cost rate.

annual cost is $500,000 and the accounts receivable is 10,000 hours.

Hence the capacity cost rate.

……(1)

(b)

The activity based cost measures the relationship of the demand for the activity and other related cost. It is essential for decision making purpose.

As given the manual processing of invoice and cash receipt is 10hours,

manual processing of invoice and cash receipt is1.0 hour,

electronic processing of invoice and electronic funds transfer is 0.1 hour,

maintaining customer file is 0.5 hour,

small to medium sized customers is 1,000,

Invoice is 4,000.

calculation of activity based cost.

Calculation of Activity Based cost with division 1:

(c)

As given that the number of large customers is 200 and invoice is 400

Calculation of activity based cost with division 2:

(d)

As given that accounts receivable labor required is 1000 customers,

Manual invoices is 2,000,

Electronic invoice = 2,000

Now calculate customer change in division 1.

Calculation Division 1 customer change .

……(2)

The calculated value for capacity cost rate is $50 hours(refer equation (1)).

The calculated value for division 1 customer change is 2,700 hours (refer equation (2)).

Now calculate activity based cost.

The new Activity Based Cost is

The cost of Z company will not decrease because of the shift to 50% of electronic invoicing in division1. When the total resource costs decrease, Z’s costs would also decrease.


Related Solutions

Lombard, Inc. has two investment centers and has developed the following information: Department A Department B...
Lombard, Inc. has two investment centers and has developed the following information: Department A Department B Departmental controllable margin $120,000 ? Average operating assets ? $400,000 Sales 800,000 250,000 ROI 10% 12% Answer the following questions about Department A and Department B. 1. What was the amount of Department A's average operating assets? Average Operating Assets $ ? 2. What was the amount of Department B's controllable margin? Controllable Margin $ ? 3. If Department B is able to reduce...
An accountant for a large department store has the business objective of developing a model to...
An accountant for a large department store has the business objective of developing a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are shown below. (Hint: First determine which are the independent and dependent variables.) Use Excel: Invoices Time 103 1.5 173 2.0 149 2.1 193 2.5 169 2.5 29 0.5 188 2.3 19 0.3 201...
Reebles Food Store developed the following information in recording its bank statement for the month of...
Reebles Food Store developed the following information in recording its bank statement for the month of March. Balance per books March 31 $3,622 Balance per bank statement March 31 $11,400 ——————————————————————————————————————————— (1) Checks written in March but still outstanding $8,000. (2) Checks written in February but still outstanding $3,200. (3) Deposits of March 30 and 31 not yet recorded by bank $7,200. (4) NSF check of customer returned by bank $700. (5) Check No. 210 for $591 was correctly issued...
Superman Store has two support departments, Information Systems and Personnel. The Information Systems Department costs are...
Superman Store has two support departments, Information Systems and Personnel. The Information Systems Department costs are allocated on the basis of hours used.  The Personnel Department costs are allocated based on the number of employees.  Data on information systems hours used and number of employees are as follows:             Information Allocation Bases:                                  Systems            Personnel            Fruit               Nut Total cost                                             $120,000          $30,000           $60,000           $90,000 Information systems hours used                600                   600                   720                480 Number of employees                               10                     20                     40                 120 a.  Write the equations needed to allocate support department costs using the reciprocal method. b.  Solve for the total cost to be allocated under...
It is required to develop the normalization from the Relational Model for the clothing store: Modarte...
It is required to develop the normalization from the Relational Model for the clothing store: Modarte S.A. de C.V. -Step 1: Entity-Relationship Model The clothing store Modarte S.A. de C.V. It has various products for women, men, boys and girls, which requires generating an Entity-Relationship Model for inventory control and sales management. It is required to develop 3 tables: products, employees and customers. In the Products table the following fields must be considered: product code, product name, type, size, purchase...
Use the following information to develop a spreadsheet model that will calculate the free cash flows...
Use the following information to develop a spreadsheet model that will calculate the free cash flows and the value of the equity for the company. Cost of capital 12% Most recent year’s sales $1000 Nonoperating assets $100 Interest-bearing debt $250 Operating profit margin 12% Working capital/sales 35% Fixed assets/sales 20% Noninterest-bearing Current liabilities/sales 10% Tax rate 40% Forecasted sales growth Years 1␣2 12% Years 3␣5 8% 6␣N 4%
PoMA Ltd uses the Economic Order Quantity Model to determine order quantities. The following information is...
PoMA Ltd uses the Economic Order Quantity Model to determine order quantities. The following information is given for the next year: Order costs 20 per order Delivery costs 5 per order Holding costs 10% of purchase price per annum Annual demand 19,000 units Purchase price 40 per unit No safety stocks are held. a. What is the EOQ? b. What are the total annual costs of stock if the company uses EOQ to determine quantity ordered every time (i.e. the...
[The following information applies to the questions displayed below.] Raleigh Department Store uses the conventional retail...
[The following information applies to the questions displayed below.] Raleigh Department Store uses the conventional retail method for the year ended December 31, 2019. Available information follows: The inventory at January 1, 2019, had a retail value of $45,000 and a cost of $27,500 based on the conventional retail method. Transactions during 2019 were as follows: Cost Retail Gross purchases $ 282,000 $ 490,000 Purchase returns 6,500 10,000 Purchase discounts 5,000 Sales 492,000 Sales returns 5,000 Employee discounts 3,000 Freight-in...
Smith’s Department Store needs to decide which advertising budgeting method to use. The following information is...
Smith’s Department Store needs to decide which advertising budgeting method to use. The following information is needed to calculate Smith’s advertising budget using all three methods. Affordable Budget Method Last year’s sales were $9,815,000 and are projected to increase by 4.5% for next year. Last year’s expenses were 41% of last year’s sales and are projected to decrease by 1.5% for next year. Last year the business earned a profit of $4,587,600. Profit is expected to increase by 2% over...
Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning...
Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets    Liabilities and Stockholders' Equity Cash $ 4,000    Accounts payable $31,000 Accounts receivable 31,000    Dividends payable 15,000 Inventory 36,000    Rent payable 3,000 Prepaid Insurance 3,000    Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000    Total liabilities and equity $99,000 Actual and forecasted sales for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT