Horngren's Accounting, Student Value Edition (11th Edition)
11th Edition
ISBN: 9780133851182
Author: MILLER-NOBLES, Tracie L.; Mattison, Brenda L.; Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 21, Problem S21.3SE
Using the high-low method
Mel owns a machine shop. In reviewing the shop’s utility bills for the past 12 months, he found that the highest bill of $2,600 occurred in August when the machines worked 1,400 machine hours. The lowest utility bill of $2,300 occurred in December when the machines worked 900 machine hours.
Requirements
- Calculate the variable rate per machine hour and the total fixed utility cost.
- Show the equation for determining the total utility cost for the machine shop
- If Mel anticipates using 1,000 machine hours in January, predict the shop’s total utility bill using the equation from Requirement 2.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Louis Petit, a manager of Doggone Gorgeous, Inc., was reviewing the water bills of a dog daycare and spa. He determined that its highest and lowest bills of $3,800and $2,000 were incurred in the months of May and November, respectively. If 600 dogs were washed in May and 100 dogs were washed in November, what was the fixed cost associated with the company's water bill? (Round any intermediate calculations to the nearest cent and your final answer to the nearest dollar.)
A.$ 2 comma 000
$2,000
B.$ 1 comma 800
$1,800
C.$ 1 comma 640
$1,640
D.$ 3 comma 800
Joey Bag-o-donuts owns an ice cream shop. Looking at last year's utility bills, the highest utility bill was $4000 for 2000 machine hours. The lowest utility bill was $2500 for 1200 machine hours.
Calculate the variable rate per machine hour and the total fixed utility cost.
Show the equation for determining total utility costs.
If Joey plans on using 1500 machine hours, what will the total utility bill be using the equation in part 2.
Kofi Abebrese runs a small industrial company that specialized in the production of high standardwindows for housing estates. A worker is paid GH¢0.9 per hour and can produce two window swith an hour. Each window uses a frame costing GH¢1 and incur a variable overheads of GH¢0.7.Each window sells for GH¢3. Currently, due to the economic condition, work is rather slack and three employees are occupied in carrying out extensive repairs to Kofi Abebrese's own house.Kofi owns a warehouse next to the factory, which had been used as a factory store, in the past. Itis now let out on a renewable annual lease of GH¢600.A new building company, Allied Consult, which specializes in the production of prefabricatedhouses has asked Kofi if he would be interested in accepting a contract for GH¢30,000 which willbe for a year initially, to produce molded internal building sections. Kofi estimates that, thecontract will take 13,200 hours of works, or the work of five men for a year, and that…
Chapter 21 Solutions
Horngren's Accounting, Student Value Edition (11th Edition)
Ch. 21 - For Frank’s Funky Sounds, straight-line...Ch. 21 - Prob. 2QCCh. 21 - Prob. 3QCCh. 21 - Prob. 4QCCh. 21 - Prob. 5QCCh. 21 - On a CVP graph, the total cost line intersects the...Ch. 21 - If a company increases its sales price per unit...Ch. 21 - Prob. 8QCCh. 21 - Prob. 9QCCh. 21 - Prob. 10QC
Ch. 21 - Donovan Company incurred the following costs while...Ch. 21 - Prob. 12AQCCh. 21 - Prob. 1RQCh. 21 - Prob. 2RQCh. 21 - What is a mixed cost? Give an example.Ch. 21 - What is the purpose of using the high-low method?Ch. 21 - Describe the three steps of the high-low method.Ch. 21 - What is the relevant range?Ch. 21 - A chain of convenience stores has one manager per...Ch. 21 - A chain of convenience stores has one manager per...Ch. 21 - Prob. 9RQCh. 21 - Prob. 10RQCh. 21 - Prob. 11RQCh. 21 - What is cost-volume-profit analysis?Ch. 21 - Prob. 13RQCh. 21 - Prob. 14RQCh. 21 - Prob. 15RQCh. 21 - Of the three approaches to calculate sales...Ch. 21 - Prob. 17RQCh. 21 - Prob. 18RQCh. 21 - On the CVP graph, where is the breakeven point...Ch. 21 - What is sensitivity analysis? How do managers use...Ch. 21 - Prob. 21RQCh. 21 - Prob. 22RQCh. 21 - What is a company's cost structure? How can cost...Ch. 21 - What is operating leverage? What does it mean if a...Ch. 21 - Prob. 25RQCh. 21 - What is absorption costing?Ch. 21 - What is variable costing?Ch. 21 - How are absorption costing and variable costing...Ch. 21 - When units produced equal units sold, how does...Ch. 21 - Prob. 30ARQCh. 21 - Prob. 31ARQCh. 21 - Prob. 32ARQCh. 21 - Prob. 33ARQCh. 21 - Identifying variable, fixed, and mixed costs...Ch. 21 - Prob. S21.2SECh. 21 - Using the high-low method Mel owns a machine shop....Ch. 21 - Prob. S21.4SECh. 21 - Prob. S21.5SECh. 21 - Prob. S21.6SECh. 21 - Prob. S21.7SECh. 21 - Prob. S21.8SECh. 21 - Prob. S21.9SECh. 21 - Prob. S21.10SECh. 21 - Prob. S21.11SECh. 21 - Prob. S21.12SECh. 21 - Computing margin of safety Refer to the original...Ch. 21 - Prob. S21.14SECh. 21 - Prob. S21.15SECh. 21 - Prob. S21.16SECh. 21 - S21A-18 Classifying costs
Learning Objective 6...Ch. 21 - Prob. S21A.18SECh. 21 - Use the following information for Short Exercises...Ch. 21 - Prob. S21A.20SECh. 21 - Use the following information for Short Exercises...Ch. 21 - Computing absorption cost per unit Abrey, Inc. has...Ch. 21 - Prob. S21A.23SECh. 21 - Prob. S21A.24SECh. 21 - Prob. E21.25ECh. 21 - Prob. E21.26ECh. 21 - Prob. E21.27ECh. 21 -
E21-28 Determining total variable cost
For each...Ch. 21 - Prob. E21.29ECh. 21 - Prob. E21.30ECh. 21 - Prob. E21.31ECh. 21 - Prob. E21.32ECh. 21 - Prob. E21.33ECh. 21 - Prob. E21.34ECh. 21 - Prob. E21.35ECh. 21 - Prob. E21.36ECh. 21 - Prob. E21.37ECh. 21 - E21-38 Computing margin of safety
Ricky’s Repair...Ch. 21 - Prob. E21.39ECh. 21 - Prob. E21.40ECh. 21 - Prob. E21.41ECh. 21 - Prob. E21.42ECh. 21 - Prob. E21.43ECh. 21 - Prob. E21.44ECh. 21 - Prob. E21.45ECh. 21 - Prob. E21A.46ECh. 21 - Prob. E21A.47ECh. 21 - Prob. E21A.48ECh. 21 - Calculating cost-volume-profit elements The...Ch. 21 - Prob. P21.50APGACh. 21 - Prob. P21.51APGACh. 21 - Prob. P21.52APGACh. 21 - Prob. P21.53APGACh. 21 - Prob. P21.54APGACh. 21 - Prob. P21.55APGACh. 21 - Prob. P21.56BPGBCh. 21 - Prob. P21.57BPGBCh. 21 - Prob. P21.58BPGBCh. 21 - Computing breakeven sales and sales needed to earn...Ch. 21 - Prob. P21.60BPGBCh. 21 - Prob. P21.61BPGBCh. 21 - Prob. P21.62BPGBCh. 21 - Prob. P21.63CPCh. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - Prob. 3CPCh. 21 - Prob. 4CPCh. 21 - The Savannah Shirt Company makes two types of...Ch. 21 - Prob. 6CPCh. 21 - Prob. 21.1DCCh. 21 - Prob. 21.1EI
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Hicks Contracting collects and analyzes cost data in order to track the cost of installing decks on new home construction jobs. The following are some of the costs that they incur. Classify these costs as fixed or variable costs and as product or period costs. Lumber used to construct decks ($12.00 per square foot) Carpenter labor used to construct decks ($10 per hour) Construction supervisor salary ($45,000 per year) Depreciation on tools and equipment ($6,000 per year) Selling and administrative expenses ($35,000 per year) Rent on corporate office space ($34,000 per year) Nails, glue, and other materials required to construct deck (varies per job)arrow_forwardJean and Tom Perritz own and manage Happy Home Helpers, Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Next year, HHH expects to purchase 25,600 of direct materials. Projected beginning and ending inventories for direct materials are as follows: There is no work-in-process inventory; in other words, a cleaning is started and completed on the same day. Required: 1. Prepare a statement of services produced in good form. 2. What if HHH planned to purchase 30,000 of direct materials? Assume there would be no change in beginning and ending inventories of materials. Explain which line items on the statement of services produced would be affected and how (increase or decrease).arrow_forwardJean and Tom Perritz own and manage Happy Home Helpers, Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Next year, HHH expects to purchase 25,600 of direct materials. Projected beginning and ending inventories for direct materials are as follows: There is no work-in-process inventory and no finished goods inventory; in other words, a cleaning is started and completed on the same day. HHH expects to sell 15,000 cleanings at a price of 45 each next year. Total selling expense is projected at 22,000, and total administrative expense is projected at 53,000. Required: 1. Prepare an income statement in good form. 2. What if Jean and Tom increased the price to 50 per cleaning and no other information was affected? Explain which line items in the income statement would be affected and how.arrow_forward
- Identifying Fixed, Variable, Mixed, and Step Costs Consider each of the following independent situations: a. A computer service agreement in which a company pays 150 per month and 15 per hour of technical time b. Fuel cost of the companys fleet of motor vehicles c. The cost of beer for a bar d. The cost of computer printers and copiers at your college e. Rent for a dental office f. The salary of a receptionist in a law firm g. The wages of counter help in a fast-food restaurant h. The salaries of dental hygienists in a three-dentist office. One hygienist can take care of 120 cleanings per month. i. Electricity cost which includes a 15 per month billing charge and an additional amount depending on the number of kilowatt-hours used Required: 1. For each situation, describe the cost as one of the following: fixed cost, variable cost, mixed cost, or step cost. (Hint: First, consider what the driver or output measure is. If additional assumptions are necessary to support your cost type decision, be sure to write them down.) Example: Raw materials used in productionVariable cost 2. CONCEPTUAL CONNECTION Change your assumption(s) for each situation so that the cost type changes to a different cost type. List the new cost type and the changed assumption(s) that gave rise to it. Example: Raw materials used in production. Changed assumptionthe materials are difficult to obtain, and a years worth must be contracted for in advance. Now, this is a fixed cost. (This is the case with diamond sales by DeBeers Inc. to its sightholders. See the following website for information: www.keyguide.net/sightholders/.)arrow_forwardJean and Tom Perritz own and manage Happy Home Helpers. Inc. (HHH), a house-cleaning service. Each cleaning (cleaning one house one time) takes a team of three house cleaners about 1.5 hours. On average, HHH completes about 15,000 cleanings per year. The following total costs are associated with the total cleanings: Next year, HHH expects to purchase 25,600 of direct materials. Projected beginning and ending inventories for direct materials are as follows: There is no work-in-process inventory and no finished goods inventory; in other words, a cleaning is started and completed on the same day. Required: 1. Prepare a statement of cost of services sold in good form. 2. How does this cost of services sold statement differ from the cost of goods sold statement for a manufacturing firm?arrow_forwardVentana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forward
- Dr. Detail is a mobile car wash. The price for a standard wash is $35 and takes half an hour. Each worker is paid $20/hr, uses $5 of materials and $0.50 per mile to use their own vehicle to travel from job to job. The average job is 5 miles. Ernest Kuhns son got sick in the car, and Ernest Kuhn has asked Dr. Detail to detail his car instead of doing a simple wash and vacuum. A. Determine the differential income if $100 was charged to detail the car. Each car detail will take 2 hours. The materials used by the worker is three times that of a standard car wash. B. If the price is raised to $150, what is the differential income change? C. Keeping the price at $150, if the worker rate per hour would increase to $20/hr how would the differential income change? Prepare an Excel spreadsheet. D. What other issues would you need to consider?arrow_forwardAble Transport operates a tour bus that they lease with terms that involve a fixed fee each month plus a charge for each mile driven. Able Transport drove the tour bus 4,000 miles and paid a total of $1,250 in March. In April, they paid $970 for 3.000 miles. What is the variable cost per mile if Able Transport uses the high-low method to analyze costs?arrow_forwardMyrna White is a mobile housekeeper. The price for a standard house cleaning is $150 and takes 5 hours. Each worker is paid $25/hour, uses $15 of materials and $0.50 per mile to use their own vehicle to travel from job to job. The average job is 5 miles. Arniz Meyroyan has a family reunion at her house and needs her house freshened up. She offers $75 for this emergency tidy-up service. This service includes vacuuming and cleaning floors, dusting, and cleaning the bathrooms. Only $5 of materials would be used. A. Prepare an Excel spread sheet to determine the differential income if the emergency tidy-up service is priced at $75. The tidy-up service will take 2 hours. B. If a $25 surcharge was included to make the price of $100 how would the differential income change? C. If the hourly worker rate increased to $30/hour, how would net income change? D. What other issue would you need to consider?arrow_forward
- Curley Maple has produced handcrafted tables for wholesale in his woodworking shop for the past year. He worked 6 days a week, 10 hour per day for 49 weeks of the year, leaving 3 weeks for holidays, vacation, and sick days. Curley has used up his savings over the past year, and now he needs to begin to draw an income from the business. Worried he is not pricing his tables correctly, curley decided to analyze the detailed records of his time and expenses that he has kept for the past year. Complete the chart:arrow_forwardOlga was planning to set up a business where she would purchase paintings for $1,050 per unit and sell them for $1,800 per unit. She wanted to conduct a break-even analysis and identified the following costs for running her business: $4,470.00 per month for store leasing, $54 per month website hosting fee, $5,150 per month for staff salary, $2,040 per month for advertising costs, and $25 per unit for labour charges to pack the paintings. a. How many paintings would she have to sell per month to break-even? Round up to the next whole number b. If she wants to make a profit of $24,000 in a month, how many paintings would she have to sell? Round up to the next whole numberarrow_forwardAl Bawadir manufacturing LLC, who is a leading bottle manufacturing company in Muscat. Mr.Saud, who has recently joined as a production supervisor would like to calculate the total cost of producing 1000 bottles in a month. Records show that material cost of producing one bottle is RO 1.5 while labor cost per chair is RO 1 and other manufacturing cost is also RO 2.5 per unit. The company pays RO 1500 per month as a rent and Mr. Saud found that there are no other expenses Discuss what would be total cost if Al Bawadir produces 1500 bottles in a month. Why Rent should be considered in the total cost. Discuss with reasonsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
What is Business Analysis?; Author: WolvesAndFinance;https://www.youtube.com/watch?v=gG2WpW3sr6k;License: Standard Youtube License