Question

Jolly Cleaners offers residential and commercial cleaning services. Clients pay a fixed monthly fee for the service, but can cancel the service at the end of any month. In addition to the employees who do the actual cleaning, the firm includes two managers who handle the administrative tasks (human resources, accounting, and so on) and one dispatcher, who assigns the cleaning employees to jobs on a daily basis.

On average, residential clients pay $260 per month for cleaning services and the commercial clients pay $1,500 per month. A typical residential client requires 10 hours a month for cleaning and a typical commercial client requires 50 hours a month. In March, Jolly Cleaners had 40 commercial clients and 120 residential clients. Cleaners are paid $10 per hour and are only paid for the hours actually worked. Supplies and other variable costs are estimated to cost $6 per hour of cleaning.

Other monthly costs (all fixed) are $37,000 SG&A, including managerial and dispatcher salaries, and $2,700 in other expenses.

Jolly Cleaners has earned positive reviews on social media in the area and the managers expect to grow. For April, they forecast a 5 percent increase in residential clients and a 10 percent increase in commercial clients.

Required:

Prepare a budgeted income statement for Jolly Cleaners for April. (Round intermediate calculations to nearest whole number.)

Answer 1

ANSWER

Budgeted residential clients for April = Residential clients in March * ( 1 + % increase ) = 120 * ( 1 + 5% )	126
Budgeted commercial clients for April = Commercial clients in March * ( 1 + % increase ) = 40 * ( 1 + 10% )	44

	Residential	Commercial	Total
Budgeted clients for April	126	44
(*) Hours a month for cleaning	10	50
Total monthly hours budgeted for April	1,260	2,200	3,460

JOLLY CLEANERS
Budgeted income statement
For the month of April
Revenues:
Commercial ( 1,500 * 44 )	66,000
Residential ( 260 * 126)	32,760
Total revenue	98,760
Expenses :
Cleaner compensation ( 3,460* 10 )	34,600
Supplies ( 3,460* 6 )	20,760
SG&A	37,000
Other expenses	2,700
Total expenses	95,060
Income	3,700