Question: Using the excerpt from the case study below discussing cost allocations and the exhibits provided in the case study, please determine if my cost allocation worksheet is completed correctly, and revise it if necessary. This would be very helpful. Also, did I calculate the cost per unit of output correct? If you can't view the numbers in the attached image because they are too small, please download the image to a computer by right clicking, "save image as$".$ COST ALLOCATION EXCERPT:

The challenge facing HSS was how to allocate costs to the three lines of service so that each could be competitively priced.

The company did not have a standard costing system. Direct materials and licences were charged to the service area that incurred the costs. The actual direct materials costs in $2016$ had been allocated as $$23,000$ for software development, $$35,000$ for professional services, and $$4,500$ for special projects. Direct labour hours for the software developers and client service representatives were tracked using time tracking software and assioned directly to the business lines $($see Exhibit $2).$

Under HSS$\text{'}$s old costing setup, indirect labour costs were not allocated to the business lines. But to be profitable and to properly price the company's software licences, the company needed to allocate indirect costs to the appropriate business lines. HSS considered three possible cost drivers for its indirect costs: the number of staff performing each task, the indirect labour hours, and the space occupied by each service area. The use of each of these potential cost drivers is outlined in Exhibit $2$

Service overhead included salary for the supervisor of the software development, all outsourced development costs, and depreciation for the equipment $($see Exhibit $1).$ The supervisor of the development staff worked a standard eight$-$hour day and received $15$ days $(120$ hours$)$ of vacation and $12$ days $(96$ hours of statutory holidays. The maximum number of hours that the supervisor worked was $1,864$ in a given year $($see Exhibit $3).$

Administration overhead included salaries for the three semior executives in the company, generic software licences, marketing and travel, office expenses, and utilities $($see Exhibit $1).$ The senior executives had fixed salaries, and each worked the same number of hours $(1,864)$ per year $($see Exhibit $3).$ The office footprint for the executives totalled $40$ square metres.

The company also had some key performance data from $2015$: the projected number of licences for the year, the number of new clients and special projects, and the number of labour hours available for the supervisor of software development and for the corporate administrative $($executive$)$ personnel $($see

Exhibit $3).$ The number of available labour hours was net of vacation days and statutory holidays.