Rogell Academic Services (RAS) provides tutoring and test preparation services for children and young adults. Employees include a director and six facilitators. The director manages all marketing and administrative activities, sometimes with the help of one of the other employees. RAS offers four basic services and accounts for each one separately. The services are Group Tutoring (Group), Personalized Tutoring (Pers), Test Prep (Test), and Coding (Code). The facilitators record the time spent on each service in the RAS computer system. Time spent in training, planning, or when demand is temporarily low is recorded as Not Billed (NB).
Selected operating data for October follow:
NB Group Pers Test Code
Sales revenue $9,100 $8,300 $7,200 $8,100
Direct labor (in hours) 50 45 120 160 170
Direct overhead traceable to departments
Equipment $1,600 $650 $840 $2,000
Supplies 360 280 470 690
Miscellaneous 220 160 490 760
Other Data
The six facilitators all make $18 per hour. A bonus of $5 per hour is paid for facilitating the coding service.
The director earns $4,500 per month.
Overhead that cannot be directly traced to a service, which amounted to $3,420 in October, is allocated among the four services plus the Not Billed "service" based on the number of direct labor-hours used.
Marketing costs (in addition to the director's salary) in October amounted to $870.
Other administrative costs (in addition to the director's salary) in October were $560.
Revenue transactions are cash; all other transactions are on account.
Required:
Management wants to know whether each service is contributing to the company's profit. Prepare an income statement for October that shows the revenue and cost for each service.
Note: Do not round intermediate calculations. Loss amounts should be indicated with a minus sign.