Dakota Case:BUSA 5061

profileAdams Nigel
 (Not rated)
 (Not rated)
Chat
Home>Homework Answsers>Business & Finance homework help
BUSA 5061Class or Cohort  _________________________
Dakota Office Products Case Analylsis    
Grading RubricStudent _________________________________
     
     
TOPIC OR ISSUEPossible Points Points EarnedComments
     
Cover Page5   
    5: Complete, attractive title page    
    3-4: Brief, less attractive    
    1-2: Very brief, not attractive    
    0: Missing cover page    
     
Format and Style5   
     5: No errors, clear    
     4: Few errors, uses subheadings    
     3: No subheadings, unclear format    
    1-2: Poor style or format    
     
Introduction10   
     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 Analysis30   
   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    
     
Summary10   
   9-10: Clear, well-written, relates to intro    
   5-8: Too long, too short, not clear    
      0: Omitted summary    
     
Use of Activity-Based Costing10   
    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 Computations15   
   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 Thought15   
   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!  
  • 11 years ago
Report issue
A+++++++++++ Solution
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    3-8502845_-_solutions_-_copy_of_student_-_profitability_dakota_office_products.xls
  • attachment
    2-8502845_-_solutions_-_copy_of_student_-_cost_drivers_dakota_office_products.xls
  • attachment
    1-8502845_-_solutions_-_copy_of_rubric_for_dakota_case_busa_5061.xls