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.

Transcribed Image Text:

Provider of Service User of Service Library Computing Services 20% Library. Computing Services Liberal Arts Sciences. . 60% : 40% 30% 50%