Clark and Shiffer LLP perform activities related to e-commerce consulting and information systems in Vancouver, British...

Free

70.2K

Verified Solution

Question

Accounting

Clark and Shiffer LLP perform activities related to e-commerceconsulting and information systems in Vancouver, British Columbia.The firm, which bills $162 per hour for services performed, is in avery tight local labor market and is having difficulty findingquality help for its overworked professional staff. The cost perhour for professional staff time is $72. Selected informationfollows. • Billable hours to clients for the year totaled 8,200,consisting of: information systems services, 4,920; e-commerceconsulting, 3,280. • Administrative cost of $414,760 was (andcontinues to be) allocated to both services based on billablehours. These costs consist of staff support, $221,520; in-housecomputing, $156,000; and miscellaneous office charges, $37,240. Arecent analysis of staff support costs found a correlation with thenumber of clients served. In-house computing and miscellaneousoffice charges varied directly with the number of computer hourslogged and number of client transactions, respectively. Atabulation revealed the following data:

E-Commerce ConsultingInformation
Systems
Services
Total
  Number of clients70250320   
  Number of computer hours2,3203,6705,990   
  Number of client transactions8307001,530   

Assume that the firm uses traditional costing procedures,allocating total costs on the basis of billable hours. Determinethe profitability of the firm’s e-commerce and information systemsactivities, expressing your answer both in dollars and as apercentage of activity revenue. (Do not round intermediatecalculations. Round "Profitability" to 2 decimalplaces.)

      

Using activity-based costing, determine the profitability of thefirm’s e-commerce and information systems activities, expressingyour answer both in dollars and as a percentage of activityrevenue. (Round intermediate calculations and final answersto 2 decimal places.)

      


Answer & Explanation Solved by verified expert
4.3 Ratings (814 Votes)

Traditional costing:

Department Total Billings Net Income Profitability
E-commerce consulting 531360 129296 24.33 %
Information systems 797040 193944 24.33 %

Working:

E-commerce consulting Information systems
Total billings 531360 797040
(3280 x $162) (4920 x $162)
Cost for professional staff time 236160 354240
(3280 x $72) (4920 x $72)
Administrative cost 165904 248856
($414760 x 3280/8200) ($414760 x 4920/8200)
Total costs 402064 603096
Net Income 129296 193944

Activity-Based Costing:

Department Total Billings Net Income Profitability
E-commerce consulting 531360 166120 31.26 %
Information systems 797040 157120 19.71 %

Working:

Activity Cost Pool Cost $ Cost Driver Activity Rate $ E-commerce consulting Information systems
Cost Driver Allocated Cost $ Cost Driver Allocated Cost $
Staff support 221520 320 692.25 70 48457.50 250 173062.50
In-house computing 156000 5990 26.04 2320 60420.70 3670 95579.30
Miscellaneous office charges 37240 1530 24.34 830 20202.09 700 17037.91
Total cost $ 414760 129080.29 285679.71
E-commerce consulting Information systems
Total billings 531360 797040
(3280 x $162) (4920 x $162)
Cost for professional staff time 236160 354240
(3280 x $72) (4920 x $72)
Administrative cost 129080 285680
Total costs 365240 639920
Net Income 166120 157120

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students