Question

Bay State Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of these two service departments’ output for the year is as follows:


The budgeted costs in the two service departments for the year are as follows:
Library......................................................................................... $900,000
Computing Services..................................................................... 360,000

Required:
1. Use the direct method to allocate the budgeted costs of the Library and Computing Services Department to the college’s Liberal Arts and Sciences departments.
2. Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: the budgeted costs of the Library and Computing Services are $890,000 and $340,000,respectively.


$1.99
Sales0
Views116
Comments0
  • CreatedApril 22, 2014
  • Files Included
Post your question
5000