Concept explainers
Estimating Cost Behavior Using Scattergraph and High-Low Methods
Camp Rainbow offers overnight summer camp programs for children ages 10 to 14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the Camp’s resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children.
The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled.
Following is the cost information for Camp Rainbow s operations last summer
1. For each of the following items. Identify, whether the cost is variable, fixed, mixed, step-variable, or step-fixed. State any assumptions you make.
a. Cost of meals for campers.
b. Cost of camp counselor wanes.
c. Cost of crafting materials.
d.
e. Feed for the camp animals.
f. Electricity for the camp.
g. Camp managers’ salaries.
h. Cost of toys to be assembled by campers.
I. Housekeeping (e.g. cleaning cabins between sessions, laundering bed linens).
2. Prepare a scattergraph of Camp Rainbows operating cost and draw the line you believe best fits the data.
3. Based on this graph, estimate Camp Rainbow s total fixed costs per month.
4. Using the high-low method, calculate Camp Rainbow s total fixed operating costs and variable operating cost per child.
5. Using the high-low method results, calculate the camps expected operating cost if 170 children attend a session.
(a)
Concept introduction:
Variable cost:
Variable costs are the cost that vary with the level of production and are directly related to the production volume. Example: Cloth (i.e., the raw material) used for producing shirt is a variable costs.
Fixed cost:
Fixed cost is the cost which remains fixed over time or production volume and do not vary with the production level. Example include salaries and wages of officers, depreciation etc.
Mixed cost:
Mixed cost is the cost which has some part of cost fixed and some is variable. Example includes some production cost which remains fixed at $800 and also increases by $2 for every unit produced.
Step-variable cost- Step variable costs means the costs which is fixed over a very narrow range of activity and increases in many steps across the relevant range.
Step-fixed cost- Step fixed costs means the costs which is fixed over a very wide range of activity as compared to variable costs.
The nature of given expenses.
Answer to Problem 10E
a. | variable |
b | step-fixed |
c | step-variable |
d | fixed |
e | fixed |
f | step-fixed |
g | fixed |
h | variable |
Explanation of Solution
a. | Cost of meal will vary on the number of participants. |
b | Camp counselor wages vary slightly depending on the number of participants. |
c | Camp counselor wages will vary highly on the number of participants |
d | Depreciation will remain fixed |
e | feed of the camp animals will remain fixed |
f | Electricity expenses remain fixed upto a certain limit |
g | Camp manager's salary will remain fixed |
h | Variable based on the number of participants |
Thus, thenature of expenses has been determined.
(b)
Concept introduction:
Scatter-graph- Scatter-graph is the visual representation of the data on the graph with total costs on the y-axis and level of activity in the x-axis.
High-low method:
High-low method uses the most extreme values to determine the variable and fixed cost based on given trends.
To prepare:
The scatter-graph and estimate the fixed costs.
Answer to Problem 10E
Explanation of Solution
The points have been plotted and a straight line has been drawn near the points.
Thus, the scatter-graph has been prepared
Concept introduction:
Scatter-graph- Scatter-graph is the visual representation of the data on the graph with total costs on the y-axis and level of activity in the x-axis.
High-low method:
High-low method uses the most extreme values to determine the variable and fixed cost based on given trends.
Variable cost:
Variable cost are the cost that vary with the level of production and are directly related to the production volume. Examples include clothes in production of shirts is a variable costs the clothes and other accessories utilized can be directly traced to units of shirts produced.
Fixed cost:
Fixed cost are the cost which remain fixed over time or production volume and do not vary with the production level. Example include salaries and wages of officers, depreciation etc.
Mixed cost:
Mixed cost are the cost which have some part of cost fixed and some is variable. Example include some production cost which remain fixed at $800 and also increases by R$2 for every unit produced.
Step-variable cost- Step variable costs means the costs which is fixed over a very narrow range of activity and increase in many steps across the relevant range.
Step-fixed cost- Step fixed costs means the costs which is fixed over a very wide range of activity as compared to variable costs.
Requirement 3
To provide
The estimated fixed costs
Answer to Problem 10E
The estimated fixed cost is $7,000.
Explanation of Solution
The intercept is at hence the fixed cost is estimated
Thus, the estimated fixed cost has been provided.
(d)
Concept introduction:
Scatter-graph- Scatter-graph is the visual representation of the data on the graph with total costs on the y-axis and level of activity in the x-axis.
High-low method:
High-low method uses the most extreme values to determine the variable and fixed cost based on given trends.
Variable cost:
Variable cost are the cost that vary with the level of production and are directly related to the production volume. Examples include clothes in production of shirts is a variable costs the clothes and other accessories utilized can be directly traced to units of shirts produced.
Fixed cost:
Fixed cost are the cost which remain fixed over time or production volume and do not vary with the production level. Example include salaries and wages of officers, depreciation etc.
Mixed cost:
Mixed cost are the cost which have some part of cost fixed and some is variable. Example include some production cost which remain fixed at $800 and also increases by R$2 for every unit produced.
Step-variable cost- Step variable costs means the costs which is fixed over a very narrow range of activity and increase in many steps across the relevant range.
Step-fixed cost- Step fixed costs means the costs which is fixed over a very wide range of activity as compared to variable costs.
To compute:
The fixed and variable cost using high low method.
Answer to Problem 10E
The fixed operating cost is $2839
The variable operating cost is $57.35/camper
Explanation of Solution
The highest point is 188campers with total cost $13,670
The lowest point is 90 campers with total cost $8050
So, variable cost per camper =
So, fixed cost for 90 camper=8050-(90*57.37) = 8050-5161.22=$2839
Hence, the fixed cost and variable cost has been determined.
(e)
Concept introduction:
Scatter-graph- Scatter-graph is the visual representation of the data on the graph with total costs on the y-axis and level of activity in the x-axis.
High-low method:
High-low method uses the most extreme values to determine the variable and fixed cost based on given trends.
Variable cost:
Variable cost are the cost that vary with the level of production and are directly related to the production volume. Examples include clothes in production of shirts is a variable costs the clothes and other accessories utilized can be directly traced to units of shirts produced.
Fixed cost:
Fixed cost are the cost which remain fixed over time or production volume and do not vary with the production level. Example include salaries and wages of officers, depreciation etc.
Mixed cost:
Mixed cost are the cost which have some part of cost fixed and some is variable. Example include some production cost which remain fixed at $800 and also increases by R$2 for every unit produced.
Step-variable cost- Step variable costs means the costs which is fixed over a very narrow range of activity and increase in many steps across the relevant range.
Step-fixed cost- Step fixed costs means the costs which is fixed over a very wide range of activity as compared to variable costs.
To compute:
The estimated cost at given number of units.
Answer to Problem 10E
The expected operating cost of 170 children using high-low method is $12,587
Explanation of Solution
The cost of 170 campers = 2839+(170*57.35) = $12,588
Hence, the estimated costs has been determined
Want to see more full solutions like this?
Chapter 5 Solutions
MANAGERIAL ACCOUNTING W/CONNECT
- Camp Rainbow offers overnight summer camp programs for children ages 10 to 14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled. Following is the cost information for Camp Rainbow's operations last summer: Week Number of Cost to Run Camp Campers 12345698 184 $ 13,810 142 10,990 92 8,060 106 8,180 158 12,930 148 10,790 7 150 11,750 178 13,130…arrow_forwardRequired information [The following information applies to the questions displayed below.] Camp Rainbow offers overnight summer camp programs for children ages 10 to 14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled. Following is the cost information for Camp Rainbow's operations last summer: Week 1 2 3 4 5 6 7 8 Number of Cost to Run Camp $8,630…arrow_forwardRequired Information [The following information applies to the questions displayed below.] Camp Rainbow offers overnight summer camp programs for children ages 10 to 14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled. Following is the cost Information for Camp Rainbow's operations last summer: Week 41234SG7O 5 6 Intercept X Variable 1 Number of…arrow_forward
- ACE Math Academy provides math help for high school students. The organizations believes a small group learning environment allows students to become more comfortable in asking questions while being able to learn from other students. As a result, each instructor is expected to have a class of six students and each session is two hours long. There are four instructors and they are each being paid $35 per hour. Each session is expected to cost $30 for the student. For the month of June, the company expects 120 sessions. By the end of the month the company noticed everything has met expectations expect the following Instructors were being paid at $40 per hour There were a total of 100 sessions in the month students paid 34 per session A) Calculate the selling price variance for the month. B) Calculate the rate and efficiency variance per hour for direct labor C) Calculate the total direct labor flexible budget variancearrow_forwardMASTERY PROBLEMBarry Bird opened the Barry Bird Basketball Camp for children ages 10through 18. Campers typically register for one week in June or July,arriving on Sunday and returning home the following Saturday. Collegeplayers serve as cabin counselors and assist the local college and high school coaches who run the practice sessions. The registration feeincludes a room, meals at a nearby restaurant, and basketballinstruction. In the off-season, the facilities are used for weekend retreatsand coaching clinics. Bird developed the following chart of accounts forhis service business: The following transactions took place during the month of June:June 1 Bird invested cash in the business, $10,000.1 Purchased basketballs and other athletic equipment, $3,000. 2 Paid Hite Advertising for flyers that had been mailed to prospectivecampers, $5,000.2 Collected registration fees, $15,000.2 Rogers Construction completed work on a new basketball court thatcost $12,000. Arrangements were made to…arrow_forwardCalculating costs using traditional and activity-based systems Bubba and Danny are college friends planning a skiing trip to Killington before the new year. They estimated the following for the trip: Requirements Bubba suggests that the costs be shared equally. Calculate the amount each person would pay. Danny does not like the idea of sharing the costs equally because he plans to stay in the room rather than ski. Danny suggests that each type of cost be allocated to each person based on the above-listed allocation bases. Using the activity allocation for each person, calculate the amount that each person would pay based on his own consumption of the activity.arrow_forward
- Full of Hope Center Operations Recent Operations Presently, the Full of Hope Center facility accommodates a maximum of 20 children at one time, although more children enroll and attend part-time. Sometimes, especially during school vacations, daily attendance is less than 20. Hours are from 7:00 a.m. until 6:00 p.m. each weekday, with lunch and snacks provided for the children. The fee is $500 per week per child, with payment due at the beginning of each week. However, fee payments often trickle in during the week as the services are provided. Each day, three employees operate the Full of Hope Center—the salaried director, one full-time employee, and one part-time emplo But, within a few days, Ruth noticed the cash collected did not match the number of children she observed at the Center during the week. When Ruth asked Miriam if there was additional cash that had been collected, Miriam reached into a desk drawer and handed Ruth currency that totalled $1,000. Miriam explained that…arrow_forwardFull of Hope Center Operations Recent Operations Presently, the Full of Hope Center facility accommodates a maximum of 20 children at one time, although more children enroll and attend part-time. Sometimes, especially during school vacations, daily attendance is less than 20. Hours are from 7:00 a.m. until 6:00 p.m. each weekday, with lunch and snacks provided for the children. The fee is $500 per week per child, with payment due at the beginning of each week. However, fee payments often trickle in during the week as the services are provided. Each day, three employees operate the Full of Hope Center—the salaried director, one full-time employee, and one part-time emplo But, within a few days, Ruth noticed the cash collected did not match the number of children she observed at the Center during the week. When Ruth asked Miriam if there was additional cash that had been collected, Miriam reached into a desk drawer and handed Ruth currency that totalled $1,000. Miriam explained that…arrow_forwardIdentifying variable, fixed, and mixed costs Holly’s Day Care has been in operation for several years. Identify each cost as a variable (V), fixed (F), or mixed (M), relative to the number of students enrolled. Building rent. Toys. Compensation of the office manager, who receives a salary plus a bonus based on the number of students enrolled. Afternoon snacks. Lawn service contract at $200 per month. Holly’s salary. Wages of afterschool employees. Drawing paper for student artwork. Straight-line depreciation on furniture and playground equipment. The fee paid to a security company for monthly service.arrow_forward
- Mastery Problem Barry Bird opened the Barry Bird Basketball Camp for children ages 10 through 18. Campers typically register for one week in June or July, arriving on Sunday and returning home the following Saturday. College players serve as cabin counselors and assist the local college and high school coaches who run the practice sessions. The registration fee includes a room, meals at a nearby restaurant, and basketball instruction. In the off-season, the facilities are used for weekend retreats and coaching clinics. Bird developed the following chart of accounts for his service business: Chart of Accounts Assets 101 Cash 142 Office Supplies 183 Athletic Equipment 184 Basketball Facilities Liabilities 202 Accounts Payable Owner’s Equity 311 Barry Bird, Capital 312 Barry Bird, Drawing Revenues 401 Registration Fees Expenses 511 Wages Expense 512 Advertising Expense 524 Food Expense 525 Phone Expense 533 Utilities Expense…arrow_forwardYour friend, Suzie Chang, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie's product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow. Factory rent Company advertising Wages paid to assembly workers Depreciation for salespersons' vehicles Screws Utilities for factory Assembly supervisor's salary Sandpaper President's salary $ 3,020 1, 010 30, 300 2,070 510 840 3,550 105 5,190 4,080 Plastic tubing Paint Sales commissions Factory insurance Depreciation on cutting machines Wages paid to painters Assume that Suzie Chang has decided to begin production of her outdoor children's toy. 280 1, 390 1,070 2,180 7,800 Required: 1 & 2. Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for direct materials (DM), direct labor (DL), or manufacturing overhead…arrow_forwardYour friend, Suzie Chang, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie's product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow. Factory rent Company advertising Wages paid to assembly workers Depreciation for salespersons' vehicles Screws Utilities for factory Assembly supervisor's salary Sandpaper President's salary Plastic tubing Paint Sales commissions Factory insurance Req 1 and 2 $ 3,050 1,050 30,600 2,200 580 880 1,210 1,060 Depreciation on cutting machines 2,090 Wages paid to painters 8,150 Assume that Suzie Chang has decided to begin production of her outdoor children's toy. Required: 1 & 2. Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for direct materials (DM), direct labor (DL), or manufacturing overhead (MOH) and also…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning