Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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: Sales revenue Direct labor (in hours) Direct overhead traceable to departments Equipment Supplies Miscellaneous Other Data NB 50 Group $9,140 450 $1,620 380 240 Pers $ 8,340 120 $670 300 180 Test $7,240 160 $860 490 510 Marketing costs (in addition to the director's salary) in October amounted to $890. Other administrative costs (in addition to the director's salary) in October were $580. Revenue transactions are cash; all other transactions are on account. Code $8,260 170 $ 2,020 710 780 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,580 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. 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.

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ ROGELLACADEMIC SERVICES } \\ \hline \multicolumn{6}{|c|}{ Income Statement } \\ \hline \multicolumn{6}{|c|}{ For the Month Ended October 31} \\ \hline & Group & Pers & Test & Code & Total \\ \hline \multicolumn{6}{|l|}{ Revenue } \\ \hline \multicolumn{6}{|l|}{ Cost of services: } \\ \hline \multicolumn{6}{|l|}{ Labor } \\ \hline \multicolumn{6}{|l|}{ Direct overhead } \\ \hline \multicolumn{6}{|l|}{ Indirect overhead } \\ \hline \multicolumn{6}{|l|}{ Total costs of services } \\ \hline \multicolumn{6}{|l|}{ Department margin } \\ \hline \multicolumn{6}{|l|}{ Less other costs: } \\ \hline \multicolumn{6}{|l|}{ Unassigned labor costs } \\ \hline \multicolumn{6}{|l|}{ Unassigned overhead indirect costs } \\ \hline \multicolumn{6}{|l|}{ Marketing and administrative costs } \\ \hline Operating profit (loss) & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ ROGELLACADEMIC SERVICES } \\ \hline \multicolumn{6}{|c|}{ Income Statement } \\ \hline \multicolumn{6}{|c|}{ For the Month Ended October 31} \\ \hline & Group & Pers & Test & Code & Total \\ \hline \multicolumn{6}{|l|}{ Revenue } \\ \hline \multicolumn{6}{|l|}{ Cost of services: } \\ \hline \multicolumn{6}{|l|}{ Labor } \\ \hline \multicolumn{6}{|l|}{ Direct overhead } \\ \hline \multicolumn{6}{|l|}{ Indirect overhead } \\ \hline \multicolumn{6}{|l|}{ Total costs of services } \\ \hline \multicolumn{6}{|l|}{ Department margin } \\ \hline \multicolumn{6}{|l|}{ Less other costs: } \\ \hline \multicolumn{6}{|l|}{ Unassigned labor costs } \\ \hline \multicolumn{6}{|l|}{ Unassigned overhead indirect costs } \\ \hline \multicolumn{6}{|l|}{ Marketing and administrative costs } \\ \hline Operating profit (loss) & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Perform A GDPR Compliance Audit

Authors: Kieran McLaughlin

1st Edition

1798935120, 978-1798935125

More Books

Students also viewed these Accounting questions