Hi, I have an accounting case study group project..please answer question 6 and 7 in bold as my other colleague will work on the other case(Also, avoid using internet resource as the prof. is using turnitin to screen for plagiarism). I am attaching case study and excel.

1. Why was Dakotas existing pricing system inadequate for its current operating environment?
2. 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.
3. Using your answer to Question 2, calculate the profitability of Customer A and Customer B.
4. What explains any difference in profitability between the two customers?
5. What are the limitations, if any, to the estimates of the profitability of the two customers?
6. Is there any additional information you would like to have to explain the relative profitability of the two customers?
7. Assume that Dakota applies the analysis done in Question 3 to its entire customer base. How could such information help the Dakota managers increase company profits?
8. Suppose that a major customer switched from placing all its orders manually to placing all its orders over the internet site. How should this affect the activity cost driver rates calculated in Question 2? How would the switch affect Dakotas profitability?

Thx, much appreciated

PRB432