Question

Jolly Cleaners offers residential and commercial cleaning Services Clients pay a foed 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 $300 per month for cleaning services and the commercial clients pay $1.400 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 160 residential clients. Cleaners are paid $15 per hour and are only paid for the hours actually worked. Supplies and other variable costs are estimated to cost $5 per hour of cleaning, Other monthly costs (all fixed) are $30,000 SG&A, including managerial and dispatcher salaries, and $2.000 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 10 percent increase in residential clients and a 20 percent increase in commercial clients. Required: Prepare a budgeted income statement for Jolly Cleaners for April

Answer 1

Jolly Cleaners Budgeted Income Statement For the month of April 67,200 52,800 120,000 Revenues: Commercial Residential Total Revenue Expenses: Cleaner Compensation Supplies SG&A Other Expenses Total Expenses Income 62,400 20,800 28,000 2,000 113,200 6,800 Working: Commercial Client = 40 + (20% of 40) = 48 Clients Residential Client = 160 + (10% of 40) = 176 Clients Revenue Commercial = 48 x 1400 =67200 Residential = 176 x 300 = 52800 Hours Required Commercial = 48 x 50 =2400 Residential = 176 x 10 = 1760 Total Hours = 2400 + 1760 = 4160 Cleaner Compensation = 4160 hrs x $15 = 62400 Supplies = 4160 hr x $5 =20800 S&G = 30000 - 2000 = 28000