Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting,...

50.1K

Verified Solution

Question

Accounting

Data Performance, a computer software consulting company, hasthree major functional areas: computer programming, informationsystems consulting, and software training. Carol Bingham, a pricinganalyst, has been asked to develop total costs for the functionalareas. These costs will be used as a guide in pricing a newcontract. In computing these costs, Carol is considering threedifferent methods of the departmental allocation approach toallocate overhead costs: the direct method, the step method, andthe reciprocal method. She assembled the following data from thetwo service departments, information systems and facilities:

Service DepartmentsProduction Departments
Information SystemsFacilitiesComputer ProgrammingInformation Systems ConsultingSoftware TrainingTotal
Budgeted overhead (base)$79,000$31,000$169,000$195,000$126,000$600,000
Information Systems (computer hours)2,0001,0002,0005,00010,000
Facilities (square feet)2306906906902,300

Part 1

Required:

1. Using computer usage time as the allocation base for theinformation systems department and square feet of floor space asthe application base for the facilities department, apply overheadfrom these service departments to the production departments, usingthese three methods:

a. Direct method.

b. Step method (both for the information systems departmentgoing first and for the facilities department going first).

c. Reciprocal method.

Answer & Explanation Solved by verified expert
4.0 Ratings (788 Votes)
Allocation of overheads a Direct method Service Departments Production Departments Information system Facilities Computer Programming Information Systems Consulting Software Training Total Budgeted Overheads 79000 31000 169000 195000 126000 600000 Information system overhead allocation 79000 9875 19750 49375 0 Facilities overhead allocation 31000 10333 10333 10333 0 189208 225083 185708 600000 Production Departments Computer Programming Information Systems Consulting Software Training Total Computer usage time 1000 2000 5000 8000 Percentage of usage 1250 2500 6250 Square feet 690 690 690 2070 Percentage    See Answer
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