Gipps Business College (GBC) has two degree programs, undergraduate (UG) and graduate (GRAD) and three service departments, information technology (IT), Event Planning (EP), and Career Services (CS). The CFO of GBC is conducting a profitability analysis of the two programs and wants to include the appropriate costs of the service departments in the costs of the two degree programs. As a part of the analysis, the CFO has collected the following usage patterns of the service departments over the last two years.

*To Be Determined

Requireda. The CFO is unsure what the best way to allocate the cost is and has asked you for the allocations to the UG and GRAD programs using:1. The direct method;2. The step method starting with IT, followed by EP, and then CS;3. The reciprocal method. (You do not need matrix algebra or to read the Appendix to complete this requirement.)b. Write a short memo to the CFO with a recommendation on the method that should be used. Assume that this usage pattern is expected to remain roughly constant over time.c. Allocate the costs using the step method starting with CS, followed by EP and then IT.d. Compare the results in requirement (a)(2) and (c). If the CFO decides to use the step method (perhaps ignoring your recommendation in requirement (b)), what sequence would you recommend the CFO follow in allocating costs: the sequence in requirement (a)(2) or in requirement (c)? Explain.

Transcribed Image Text:

Using Department Supplying Departiment UG GRAD EP IT CS IT -0- 10% 20% 40% 30% EP 25% -0- 25% 50% -0- CS 40% -0- -0- -0- 60% Direct costs $70,000 $90,000 $100,000 TBD* TBD*