College Painters was founded by Cody and John, two seniors in high school, to he
ID: 2561078 • Letter: C
Question
College Painters was founded by Cody and John, two seniors in high school, to help pay their way through college. Fully bonded and insured, College Painters specializes in faux finishes, such as marbleizing, sponging, ragging and washing. While Cody and John used to do all the work themselves, now ten years later, they have crews performing the work. They visit worksites every day to be sure that jobs meet their quality standards and well as meeting prospective customers and preparing bids.
Cody and John budget for 25,000 square feet (sf) of business a month. The average job is 500 sf., and for such a job, Cody and John expect to incur the following costs:
Materials (paint)
1.6 gallons @ $25.00 per gallon
Materials (supplies)
$10.00
Labor (includes surface prep and applying the paint and faux finish)
16 hours @ $15.00 per hour
To arrive at a selling price, Cody and John mark up the budgeted paint cost by 50% and the budgeted labor cost by 100% and the budgeted cost of supplies. Thus the starting point for constructing a bid is:
$550 = (1.5 x 1.6 x $25) + (2.00 x 16 x $15) + 10
Of course, Cody and John adjust the starting price to reflect prevailing market conditions. For example, they charge more for a rush job or provide a discount if a customer is unhappy with the result. Finally, Cody and John budget $2,000 per month for fixed costs such as office rent, phones, advertising, and the company car.
For this past month (October), College Painters earned $25,333 in revenues for several different jobs totaling 24,000 sf. College Painters used 72 gallons and 765 hours of labor during the month. The 765 hours of labor cost $11,475, which includes the 32 hours it took to clean up the mess in a customer’s home because a painter accidentally tripped over a full can of paint.
According to their paint supply store, they spent $2,160 on paint and $480 on supplies during the month. The bill for paint for October was higher than normal because Cody and John decided to try a newer, more expensive paint in the hope that it would lead to improved paint and labor efficiencies. They did not think this would affect the amount of supplies used). Finally, they spent $2,250 on fixed costs during October.
Question: Prepare a budget reconciliation report for October. Your report should include all the variances that make up the total profit variance. For this part, do not consider the costs of the accident separately.
Materials (paint)
1.6 gallons @ $25.00 per gallon
Materials (supplies)
$10.00
Labor (includes surface prep and applying the paint and faux finish)
16 hours @ $15.00 per hour
Explanation / Answer
Budget Actual Variance SFT 25,000 24,000 Average Job SFT 500 500 No of Jobs 50 48 (2.00) Cost per Job No of Gallons / Hours Rate per Gallon / Hour Cost per Job Total Cost No of Gallons / Hours Rate per Gallon / Hour Cost No of Gallons / Hours Per job Cost per Job Cost per Job Variance Total Variance Qty Variance Price Variance Materials (paint) 1.60 $25.00 $40.00 $2,000.00 $72.00 $30.00 $2,160.00 1.50 45.00 5.00 $160.00 ($80.00) $240.00 Materials (supplies) $10.00 $10.00 $500.00 $480.00 ($20.00) ($20.00) $0.00 Labour 16.00 $15.00 $240.00 $12,000.00 $765.00 $15.00 $11,475.00 15.94 239.06 (0.94) ($525.00) ($480.00) ($45.00) Cost per Job $27.60 $14,500.00 $14,115.00 ($385.00) ($580.00) $195.00 Revenue per job $550.00 $527.77 ($22.23) Total Revenue $27,500.00 $25,333.00 ($2,167.00) ($1,100.00) ($1,067.00) Profit $13,000.00 $11,218.00 ($1,782.00) ($520.00) ($1,262.00) Fixed Costs $2,000.00 $2,250.00 $250.00 Profit $11,000.00 $8,968.00 ($2,032.00)