# For many years the Honey Lake Summer Camp had used the number of campers per week to estimate...

## Question:

For many years the Honey Lake Summer Camp had used the number of campers per week to estimate weekly costs. The summer camp is open for ten weeks during the summer with a different number of campers each week. Costs from last year's summer camp is used to estimate costs for this year for pricing purposes. Camp counselors are plentiful and the job is fun, so they only hire as many as they need each week. The following costs occurred during a slow week last year and the costs of each cost category are expected to be the same this year:

 Weekly Cost Supervisor's salary (hired weekly) $500 Cook's salary (hired weekly)$400 Camp counselor salaries (1 for each occupied cabin, each of which holds 10 campers) (5 counselors x $200/counselor)$1,000 Food (50 campers x $100/camper)$5,000 Supplies (50 campers x $20/camper)$1,000 Utilities (50 campers x $10/camper)$500 Insurance (50 campers x $20/camper)$1,000 Property tax ($10,000/10 weeks)$1,000 Weekly total $10,400 Average cost per camper:$10,400/50 campers $208/camper The Honey Lake Summer Camp expects 65 campers during the second week of July. a. Using the average cost per camper, what is the expected total cost of a 65 camper week? b. What is the expected total cost of that week calculated using ABC? c. The last week of August is always a very slow week, with an average of only 12 campers, paying$400 each. Using ABC, how much is their profit (loss) for that week?

d. Ignoring any marketing issues, how much would they save (lose) compared to staying open by canceling the last week of August?

## Income Statement:

The income statement is prepared after deducting all operating expenses from the revenue for the concerned period. The allocation of operating expenses could be done under activity-based costing method or traditional method.

a. Using the average cost per camper, the expected total cost of a 65 camper week is $13,520 ($208 x 65)

b. The expected total cost of that week calculated using ABC is $13,050. Compute the expected total cost of that week calculated using ABC as follows: - Particulars Amount Weekly Cost Supervisor's salary (hired weekly)$500
Cook's salary (hired weekly) $400 Camp counselor salaries (1 for each occupied cabin, each of which holds 10 campers) (7 counselors x$200/counselor) $1,400 Food (65 campers x$100/camper) $6,500 Supplies (65 campers x$20/camper) $1,300 Utilities (65 campers x$10/camper) $650 Insurance (65 campers x$20/camper) $1,300 Property tax ($10,000/10 weeks) $1,000 Weekly total$13,050

c. During the last week of August using ABC, company would earn $500 as profit. Compute net profit as follows: - Income Statement Particulars Amount Sales Value ($400 x 12) (A) $4,800 Less: Operating Costs Weekly Cost Supervisor's salary (hired weekly)$500
Cook's salary (hired weekly) $400 Camp counselor salaries (1 for each occupied cabin, each of which holds 10 campers) (3 counselors x$200/counselor) $600 Food (12 campers x$100/camper) $1,200 Supplies (12 campers x$20/camper) $240 Utilities (12 campers x$10/camper) $120 Insurance (12 campers x$20/camper) $240 Property tax ($10,000/10 weeks) $1,000 Weekly total (B)$4,300
Net Profit (A-B) $500 d. By canceling the last week of August the company would lose$500 as profit.