Dakota case:busa 5061 | Business & Finance homework help

BUSA 5061 Class or Cohort  _________________________ Dakota Office Products Case Analylsis         Grading Rubric Student _________________________________                     TOPIC OR ISSUE Possible Points   Points Earned Comments           Cover Page 5           5: Complete, attractive title page             3-4: Brief, less attractive             1-2: Very brief, not attractive             0: Missing cover page                   Format and Style 5            5: No errors, clear              4: Few errors, uses subheadings              3: No subheadings, unclear format             1-2: Poor style or format                   Introduction 10            9-10: Clear, well-written, answers “what or why”              7-8: Too long, too short, not clear              5-6: Weak introduction              0: Missing introduction                   Case Analysis 30          29-30: Complete, well-supported, organized            27-28: Moderate discussion of issues and alternatives            25-26: Inadequate discussion            15-24: Highly inadequate discussion, no alternatives                   Summary 10          9-10: Clear, well-written, relates to intro            5-8: Too long, too short, not clear               0: Omitted summary                   Use of Activity-Based Costing 10           10: Superior application of ABC               9: Good application of ABC             7-8: Moderate use of ABC or other managerial accounting concepts             5-6: Inadequate use of managerial accounting concepts                   Grammar and Computations 15          15: No errors            14: 1-2 errors            13: 3-4 errors            12: 5-6 errors            11: Overall inadequate writing skill or computational skill            10-5: Very poor writing skill or computational skill                   Quality of Analysis or Thought 15          15: Superior analysis of managerial accounting issues and alternatives          14: Good analysis of managerial accounting issues and alternatives            12-13: Moderate analysis of managerial accounting issues            10-11: Inadequate analysis of managerial accounting issues             5-9: Highly deficient analysis of managerial accounting issues                     100      

TOTAL POINTS

 

 

 

DAKOTA OFFICE PRODUCTS

Write in the names of your

Activity

cost drivers (below)

Total

Base

Cost

hint:  see computations

Cost

Units

# Units

Per Unit

Driver #1

xxxx

# cartons

xxxx

#VALUE!

Driver #2

xxxx

# cartons

xxxx

#VALUE!

Driver #3

xxxx

# deliveries

xxxx

#VALUE!

Driver #4

xxxx

# orders

xxxx

#VALUE!

Driver #5

xxxx

# lines

xxxx

#VALUE!

Driver #6

xxxx

# orders

xxxx

#VALUE!

a) computations

Total

Warehouse

Desktop

Cost

Processing

Delivery

Warehouse Personnel

xxxx

#VALUE!

#VALUE!

Processing cartons – 90%

Desktop Delivery – 10%

Warehouse Rent/Deprec

xxxx

xxxx

Delivery Truck Expenses

xxxx

xxxx

Total

#VALUE!

#VALUE!

b) computations

Manual

Manual

Process

Order

Order

EDI

Total

Processing

Entry

Orders

Order Entry Expenses

20%

75%

5%

xxxx

#VALUE!

#VALUE!

#VALUE!

DAKOTA OFFICE PRODUCTS

Customer Profitability

Customer A

Customer B

Sales

103,000

104,000

Cost of items purchased

85,000

85,000

Gross Margin

18,000

19,000

Number of cartons ordered

52

200

10,400

200

10,400

Number of cartons shipped

6

200

1,200

150

900

Number of desktop deliveries

220

0

25

5,500

Number of orders, manual

10

6

60

100

1,000

Number of line items, manual

4

60

240

180

720

Number of EDI orders

5

6

30

0

Average Accounts Receivable

@10% int

9,000

900

30,000

3,000

Toal service costs

12,830

21,520

Customer Contirbution (Loss)

5,170

(2,520)

DAKOTA OFFICE PRODUCTS         Customer Profitability                                                                                         Customer A   Customer B               Sales           103,000       104,000               Cost of items purchased           85,000       85,000               Gross Margin           18,000       19,000                                                   Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Number of …….   ??   ??   #VALUE!   ??   #VALUE!               Average Accounts Receivable   @10% int   ??   #VALUE!   ??   #VALUE!               Toal service costs           #VALUE!       #VALUE!                                                   Customer Contirbution (Loss)       #VALUE!       #VALUE!                           #VALUE!       #VALUE!