Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The distribution center team reported that 90% of the workers processed cartons in and out of the facility. The remaining 10% of workers were assigned

The distribution center team reported that 90% of the workers processed cartons in and out of the facility. The remaining 10% of workers were assigned to the desktop delivery service. All of the other warehouse expenses (rent, building and equipment depreciation, utilities, insurance, and property taxes) were associated with the receipt, storage, and handling of cartons. The delivery trucks were used only for desktop delivery orders. These estimates were reviewed by supervisors and felt to be representative of operations not just in the current year, but in the past year (2000) as well. The data entry team, from monitoring computer records, learned that operators worked 10,000 hours during year 2000. Further analysis of the records revealed the following distribution of time for each of the activities performed by data entry operators. (Questions are at the bottom, thank you)

Activity

Data Entry Operators Time

Set up a manual customer order

2,000 hours

Enter individual order lines in an order

7,500 hours

Validate an EDI/internet order

500 hours

Total

10,000 hours

Exhibit 1 Dakota Office Products: Income Statement CY2000

Particulars

Amount $

Markups %

Sales

42,500,000

121.4

Cost of Items Purchased

35,000,000

100.0

Gross Margin

7,500,000

21.4

Warehouse Personnel Expense

2,4000,000

6.9

Warehouse Expenses (excluding personnel)

2,000,000

5.7

Freight

450,000

1.3

Delivery Truck Expenses

200,000

0.6

Order Entry Expenses

800,000

2.3

General and Selling Expenses

2,000,000

5.7

Interest Expense

120,000

0.3

Net Income Before Taxes

(470,000)

-1.3

Exhibit 2 Customer Profitability Report (Current Method)

Customer A

Customer B

Particulars

Amount $

Markups %

Amount $

Markups %

Sales

103,000

121.2

104,00

122.4

Cost of Items Purchased

85,000

100.0

85,000

100.0

Gross Margin

18,000

21.2

19,000

22.4

Warehousing, Distribution and Order Entry

12,750

15.0

12,750

15.0

Contribution to General and Selling Expenses, and Profit

5,250

6.2

6,250

7.4

Exhibit 3 Services Provided in Year 2000 to Customers A and B

Particulars

Customer A

Customer B

# of Cartons Ordered

200

200

# of Cartons Shipped Commercial Freight

200

150

# of Desktop Deliveries

None

25

# of Orders, Manual

6

100

# of Line Items, Manual

60

180

# of EDI Orders

6

None

Average Accounts Receivable

$9,000

$30,000

A. Develop an activity-based cost system for Dakota Office Products (DOP) based on Year 2000 data. Calculate the activity cost-driver rate for each DOP activity in 2000.

B. Using your answer to Question A, calculate the profitability of Customer A and Customer B.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And GRC Automation In SAP

Authors: Maxim Chuprunov

2013 Edition

3642434525, 978-3642434525

More Books

Students also viewed these Accounting questions

Question

What are some of the major areas of public accounting services?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago

Question

What is the orientation toward time?

Answered: 1 week ago