Jersey Subs, Inc. wants to find an equation to estimate monthly utility costs. Jersey Subs has...
Question:
Jersey Subs, Inc. wants to find an equation to estimate monthly utility costs. Jersey Subs has been in business for one year and has collected the following cost data for utilities:
| Month | Electricity Bill | Kilowatt Hours Used | Telephone | Minutes Used | Water Bill | Water Used |
| January | 375 | 1,250 | $92.50 | 1,200 | $75.00 | 32,560 |
| February | 438 | 1,458 | $91.70 | 1,156 | $75.00 | 28.554 |
| March | 572 | 1,906 | $95.32 | 1,353 | $75.00 | 33,508 |
| April | 422 | 1,406 | $90.09 | 1,069 | $75.00 | 31,926 |
| May | 613 | 2,042 | $98.53 | 1,527 | $75.00 | 32,569 |
| June | 650 | 2,167 | $99.34 | 1,517 | $75.00 | 27,211 |
| July | 544 | 1,813 | $93.91 | 1,276 | $75.00 | 34,829 |
| August | 622 | 2,073 | $96.72 | 1,429 | $75.00 | 33,265 |
| September | 656 | 2,188 | $96.12 | 1,396 | $75.00 | 35,735 |
| October | 641 | 2,135 | $94.31 | 1,298 | $75.00 | 34,062 |
| November | 619 | 2,063 | $91.49 | 1,145 | $75.00 | 30,472 |
| December | 659 | 2,198 | $97.53 | 1,473 | $75.00 | 36,332 |
b. Using the high-low method, determine the cost unction for each cost.
c. Combine the preceding information to get a monthly utility cost function for Jersey.
High Low Method:
The High Low method is a methodology used to separate the fixed and variable components of a mixed cost resulting in an equation to predict costs at different levels of usage or volume. It is very useful for projecting costs for overhead items such as electricity, telephone, water, and others. These types of costs have a variable component that changes with the level of usage but also have a part that remains fixed.
Answer and Explanation: 1
Become a Study.com member to unlock this answer! Create your account
View this answerb) Computation of cost function of each cost
| Description | Electricity | Telephone |
| Highest Cost (a) | $659 | $99.34 |
| Corresponding Usage (b) | 2,198 | 1... |
See full answer below.
Ask a question
Our experts can answer your tough homework and study questions.
Ask a question Ask a questionSearch Answers
Learn more about this topic:
Get access to this video and our entire Q&A library
High-Low Method Accounting: Formula & Examples
from
Chapter 22 / Lesson 29
51K
Understand the high-low method in accounting. Learn the formulas for the high-low method. Learn how to compute variable cost per unit, fixed cost, and cost model.
Related to this Question
- Jersey Subs, Inc. wants to find an equation to estimate monthly utility costs. Jersey Subs has been in business for one year and has collected the following cost data for utilities: Which of the preceding costs is variable? Fixed? Mixed? Explain?
- 1. Jersey Subs, Inc. wants to find an equation to estimate monthly utility costs. Jersey Subs has been in business for one year and has collected the following cost data for utilities: a. Which of th
- Jersey Subs, Inc. wants to find an equation to estimate monthly utility costs. Jersey Subs has been in business for one year and has collected the following cost data for utilities: Mouth Electricity Bill Kilowatt Hours Used Telephone Bill Minutes Us
- The Pearly Onion Company incurred the following monthly utility costs last year: REQUIRED: 1. Use the high-low method to estimate the company's utilities cost behavior and state the cost formula. 2.
- Classify the following cost as either a variable cost or a fixed cost: Utilities amounting to $100 per month.
- Assume that MTA Sandwiches sells sandwiches for $3.55 each. The cost of each sandwich follows: Materials $1.10 Labor 0.40 Variable overhead 0.20 Fixed overhead ($23,500 per month, 18,800 units per month) 1.25 Total cost per sandwich $2.95 One of MTA's reg
- Assume that MTA Sandwiches sells sandwiches for $3.25 each. The cost of each sandwich follows: Materials $1.10 Labor 0.30 Variable overhead 0.30 Fixed overhead ($24,840 per month, 21,600 units per month) 1.15 Total cost per sandwich $2.85 One of MTA's re
- Assume that MTA Sandwiches sells sandwiches for $3.55 each. The cost of each sandwich follows: Materials $1.10 Labor 0.40 Variable overhead 0.20 Fixed overhead ($23,500 per month, 18,800 units per month) 1.25 Total cost per sandwich $2.95 One of MTA's re
- Mitchum Fleet, Inc. has incurred the following maintenance costs on its fleet of taxicabs during the past 6 months. Use the high/low cost estimation method to determine the expected cost if 12,000 mil
- Given the following cost and activity observations for Bounty Company's utilities: Cost Machine hours March $3,106 15,176 April $2,668 9,558 May $2,892 11,947 June $3,538 17,899 Use the high-low method to calculate Bounty's variable utilities cost per m
- The following data pertain to activity and utility costs for two recent years: | | Year 2| Year 1 |Activity Level in Units| 10,000| 6,000 |Utilities Cost| $12,000| $9,000 Using the high-low method, what is the cost formula for utilities?
- The monthly cost of renting manufacturing equipment is: a. Part of conversion cost and a period cost. b. Part of prime cost and an inventoriable cost. c. Part of prime cost and a period cost. d. Part of conversion cost and an inventoriable cost.
- The following budgeted and actual volume and cost data are for March of this year: | |Budget |Actual |Volume |40,000 |36,000 |Budgeted manufacturing costs: | | |Variable costs per unit: | | |Direct materials| $30.00| |Direct labor| 15.0
- The local franchise of Vogorio Sandwich Company assigns you the task of estimating total maintenance cost on its delivery vehicles. This cost is a mixed cost. You are given the following data from past months: Month Units Costs January 4,400 $7,000 Februa
- The following four months of data were collected on utility cost and the number of labor hours in a factory. Month Utility cost Labor hours January $22,100 3,975 February $24,600 5,430 March $23,500 4,400 April $20,140 3,200 What would be the estimate of
- Given the following cost and activity observations for Wondrous Company's utilities, use the high-low method to calculate Wondrous' variable utilities costs per machine hour. a. $10.00 b. $0.67 c. $0.63 d. $0.10
- Monthly utilities costs are reported as expenses along with the monthly revenues. Which accounting concept does this represent? a. cost concept b. accounting period concept c. adequate disclosure concept d. matching concept e. none of the above
- Identifying the parts of the cost formula, calculating monthly, quarterly, and yearly costs using a cost formula based on monthly data, Gordon Company's controller, Eric Junior, estimated the following formula, based on monthly data, for overhead cost: O
- Given the following cost and activity observations for Wondrous Company's utilities, use the high-low method to calculate Wondrous' variable utilities costs per machine hour. Cost Machine Hours March $3,084 14,766 April $2,663 9,823 May $2,839 12,402 Jun
- Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. A. $2,669 B. $3,032 C. $1,554 D. $1,471
- The following data pertain to activity and utilities costs for two recent years: | | Year 2| Year 1 |Activity Level in Units| 12,000| 8,000 |Utilities Cost| $15,000| $12,000 Using the high-low method, what is the variable cost per unit for utilities?
- Use the following data for the 4th quarter of 2009: Month Activity Volume (#Units) Total Costs Oct 90 $5,025 Nov 65 $5,175 Dec100 $6,400 Required: a) Estimate fixed costs and unit variable costs using the high-low method. (hint: should you use the observa
- a. Using High-Low method, estimate the cost formula for X-ray costs. b. Estimate the cost of X-rays for October using both regression and high-low methods, assuming a least-square regression analysis estimated the total fixed costs to be $5,920 per month
- Crandell Co. forecasts monthly production of 20,000 units at a cost of $20 each. The cost breakdown is as follows: Labor: 2 hours per unit at $4 per hour Material: 3 pounds per unit at $2 per pound Fixed overhead: $2 per direct labor hour Variable overhea
- The cost of setups would be considered a: A. Unit Level Cost B. Product Level Cost C. Batch Level Cost D. Facility Level Cost
- City Ambulance Service estimates the monthly cost of responding to emergency calls to be $15,000, plus $200 per call. a. In a month in which the company responds to 150 emergency calls, determine the estimated total cost of responding to emergency calls.
- Exercise 7-24 Predetermined Overhead Rates (LO 7-3) Tappan, Inc., manufactures one product and accounts for costs using a job cost system. You have obtained the following information from the corpora
- The Shapely Company uses the high-low method to determine its cost equation. The following information was gathered for the past year: If Shapely expects to use 12,000 machine hours next month, what are the estimated direct labor costs? A) $687,500 B)
- The Deenut Company estimates the following overhead costs for the coming year: Equipment depreciation $400,000 Equipment maintenance $50,000 Supervisory salaries $ 20,000 Factory rent and utilities $ 16,000 Total $486,000 Deenut budget forecasts for
- How should the following cost be recorded? Annual service fee paid to the franchiser's headquarters for administrative services rendered to the franchisee. a. Charged to the Patent account and amortized b. Charged to the Franchise account and amortized c.
- The calculation for annual depreciation using the units-of-output method is: a. (Initial cost / Estimated output) x Actual yearly output b. (Depreciable cost / Yearly output) x Estimated output c. Depreciable cost / Yearly output d. (Depreciable cost / Es
- Month Sales Orders Order- Processing Costs 1 3,000 $ 49,620 2 1,500 30,225 3 4,400 72,420 4 2,800 49,140 5 2,300 41,865 6 1,200 25,860 7 2,000 37,500 How to calculate the cost estimating equation for monthly production costs?
- The Shapely Company uses the high-low method to determine its cost equation. The following information was gathered for 2008: [TABLE] If Shapely expects to use 10,000 machine hours next month, what are the estimated direct labor costs? - $160,000 - $180,0
- Pete's PCs, Inc. budgeted manufacturing overhead costs for the year are: Type of Cost Cost Pools Electric Power $2,500,000 Inspection $1,500,000 Budgeted overhead costs $4,000,000 Under a traditional
- The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Determine the variable cost components using the high-low method.
- Classify the following cost as either a variable cost or a fixed cost: Phone/internet expenses amounting to $150 per month.
- To estimate the monthly maintenance cost for the maintenance department in a hospital, the following monthly costs are available: Monthly Expense Costs Supervisor Salary Expense $3,000 Depreciation Expense-Maintenance Equipment $5,000 Repairs Expense-Main
- Given the following cost and activity observations for George Company's utilities, use the high-low method to calculate George's variable utilities costs per machine hour.
- erfect Stampers has collected new data over the last three months to perform an analysis of their budgeting and cost computations: |Average production labor cost per month| $7,500 |Average raw mater
- The following data pertains to activity and utility cost for two recent periods Utility cost is a mixed cost with both fixed and variable components. Using the high-low method the cost formula for ut
- A cost that is incurred to support a number of costing objects but cannot be traced to them individually is a ______. Choose from the following words: | Absorbed | Actual | Budgeted | Common cost | Controllable cost | Cost | Full | Market price | Nego
- Using the high-low method, what is the variable cost per unit given the following information over a 6 month period: The month of March had 10,000 units produced with a total cost of $25,600. The mont
- If the total maintenance cost of the lowest month is $1,500 and the variable cost per unit is $1.25 with 300 units produced, what is the fixed portion of the mixed cost using the high-low method? a. $1,125 b. $1,500 c. $1,625
- Using the Fundamentals of Product and Service Costing, explain how a basic product costing system is used to calculate product or service costs.
- Cove's Cakes is a local bakery. Price and cost information follows: Price per cake $14.61 Variable cost per cake Ingredients 2.16 Direct labor 1.19 Overhead (box, etc.) 0.24 Fixed cost per month $4,077.40 1. Determine Cove's break-even point in units and
- An inspection service received their monthly operating costs for the past year. Costs ranged from $4,000. for 1,000 inspected units to $36,000. for 600 inspections. 1. Calculate the variable cost per
- The following overhead data are for a department of a large company. |Actual costs |Static Incurred |Budget |Activity level (in units) |360| 340 |Variable costs: | | |Indirect materials |$4,182 |$4,148 |Electricity |$2,536 | $2,414 |Fixed costs: | |
- The controller of Dousmann Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Determine the variable cost components using the high-low method.
- Circuit Boards R Us (CBRU) uses regression analysis to estimate the monthly cost of producing circuit boards. A regression analysis using number of circuit boards produced as the cost driver has the following output: Y = $ 70,000 + $ 2* number of circuit
- Determine the variable cost per gross-ton mile and the total fixed cost. Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity bas
- Two methods of carrying away surface runoff water from a new subdivision are being evaluated. Method A: Dig a ditch. The initial cost is $60,000. A cost of $25, 000 for re-digging and shaping would be
- Botana Company constructed the following formula for monthly utility costs. Total utility cost = $1,200 + ($8.10 * labor hours) Assume that 775 labor hours are budgeted for the month of April. Calculate the total variable utility cost for the month of
- Determine the per-unit cost for each dog. Fill in the blanks to get the per-unit cost and fixed cost of each service. Most costs are provided for you. Only fill in the missing costs. Based on 5 groo
- X Company's accountant analyzed the following overhead costs in March to develop a cost function that could be used to predict overhead costs in future months. Supplies $22,100 Utilities 15,000 Maint
- Profitability Analysis Assume a local Cost Cutters provides cuts, perms, and hairstyling services. Annual fixed costs are $105,000, and variable costs are 40 percent of sales revenue. Last year's revenues totaled $205,000. (a) Determine its break-even poi
- The utility bill for a law firm consists of both fixed and variable costs. Refer to the 4-month data below and apply the high-low method to answer the question. | | Minutes| Total Bill |January| 460| $3,000 |February| 200| $2,675 |March| 160| $2,625 |Apri
- Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Cost Machine Hours January $81,820 9,600 February 144,460 18,300 March 103,080 12,500 April 120,230
- A job order cost system uses a predetermined overhead rate based on estimated activity and estimated manufacturing overhead cost. At the end of the year, underapplied overhead might be explained by which of the following situations? A) Actual activity: Gr
- Calculate the expected costs when production is 5,200 units. PCB Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of 3,120 units. The utilities and maintenance cos
- The following information is available for a company's utility cost for operating its machines over the last four months. Using the high-low method, the estimated total fixed cost for utilities is: - $1,500 - $3,600 - $6,000 - $3,300 - $2,100
- Conoco Company has an actual factory overhead cost of Depreciation Expenselong dash-Equipment of $5,000. Jobminus-order costing is used. The journal entry to record this actual cost would include _____.
- Assume the local cable company has the following information available about fleet miles and operating costs for its service department: Using the high-low method, develop a cost-estimating equation for total annual operating cost
- A facility has produced 56 units. From the initial run it is estimated that the cost of the first product was $100 with a learning rate of 93%. It now intends to run a larger lot of 250 units. Estimate the average cost per unit for the second lot. What wi
- The utility bill for a law firm consists of both fixed and variable costs. Refer to the 4-month data below and apply the high-low method to answer the question. | | Minutes | Total Bill | January | 460 | $3,000 | February | 200 | $2,675 | March | 160 |
- Using the high low method, compute Soho Corporations's monthly variable cost per telephone hour and total fixed cost. |MONTH|TELEPHONE HOURS USED|TELEPHONE COSTS |April|95|$4350 |May|90|$4230 |June
- Classify the following cost as either a variable cost or a fixed cost: Labor cost of $400 per month.
- The following cost data relate to the office overhead costs of the Pembina Company during the just-completed year: Overhead costs incurred: Office rent $21,000 Office supplies $4,000 Utilities, office $13,200 Salary, office manager $55,000 Salary, recepti
- Using account analysis, what type of cost is an electric bill that charges a flat monthly fee plus a charge for each kilowatt ours of electricity used? a. Step b. Mixed c. Variable d. Fixed
- Estimate the total fixed cost of operating the testing faculty. Estimate the expected cost for a month if 125,000 tests are performed. Separating Mixed Cost Using the High-Low Method The following inf
- At the beginning of the year, Vuncor, Inc., determined that estimated overhead costs would be $600,000, while actual overhead cost for the year totaled $650,000. Furthermore, it was determined that th
- A partial list of the costs for the Wisconsin and Minnesota Railroad, a short hauler of freight, follows. Classify each cost as either indirect or direct. For purposes of classifying each cost, use the train as the cost object. a. Cost to lease (rent) rai
- For the most recent year, Atlantic Company's operating income computed using the absorption costing method was $7,400, and its operating income computed using the variable costing method was $10,100. The company's unit product cost was $17 under variable
- The general formula to allocate cost is: a. estimated overhead cost divide by cost pool b. cost pool divided by estimated overhead pool c. cost to be allocated divided by total occurrences of the allocation base d. cost base divide by estimated overhead
- The controller of Hall Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. |Month |Total Maintenance Costs |Total Machine Hours |
- At the beginning of the year, Vuncor, Inc., determined that estimated overhead costs would be $600,000, while the actual overhead cost for the year totaled $650,000. Furthermore, it was determined that the estimated allocation basis would be 60,000 direct
- The controller of Dousmann Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Determine the variable cost components using the hig
- Using the tables above: a) Estimate how much of the $246,000 of overhead cost in July was in maintenance costs. b) Using the high-low method, estimate a cost formula for maintenance.
- Computing the expected total cost per unit: variable cost per unit is budgeted to be $6 and fixed cost per unit is budgeted to be $3 in a period when units are produced. If production is actually 4,500 units.
- Given the following cost and activity observations for George Company's utilities, use the high-low method to calculate George's variable utilities costs per machine hour. | |Cost| Machine Hours |Ma
- Assume that Plant ABC works 32,500 direct labor-hours during a month. Compute the expected overhead cost for the month. Plant ABC manufactures electrical components & has experienced difficulties with fluctuating monthly overhead costs. Determine the cost
- RTC Supply Co. produces cleaning equipment for professional cleaners. At the start of the year, RTC estimated variable overhead costs to be $13 per unit and total fixed overhead costs at $300,000 based on a volume of 60,000 units. The detail for the overh
- The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Determine the fixed component using the high-low method.
- Refer to the above data. The cost formula for Ratnere's monthly overhead cost can be expressed as _____.
- Using the High Low Method Using the high low method, Compute Soho Corporation's monthly variable cost per telephone hour and total fixed costs.
- Nathan and Kylie MOrse have invested $500,000 in N&K's Place. Their projected costs and activities are as follows: Variable costs 60% Monthly fixed costs $30,000 Monthly covers sold 10,000 Average tax rate 20% 1. What must the average food service check
- Use the following data for the 4th quarter of 2009: |month|activity volume (#units)|total costs |Oct|80|$5,250 |Nov|65|$5,400 |Dec|100|$6,800 Required: a) Estimate fixed costs and unit variable
- The Mixing Department manager of Malone Company can control all overhead costs except rent, property taxes, and salaries. Budgeted monthly overhead costs for the Mixing Department, in alphabetical ord
- The following overhead data are for a department of a large company. | |Actual Costs Incurred |Static Budget |Activity level (in units) |500 |450 |Variable costs: | | |Indirect materials |$5,950 |$5,382 |Electricity| $1,112 |$1,008 |F
- Consider order costs are $20 and holding costs $2 per unit. The firm uses 200,000 units in a year. 1. What is the EOQ? 2. Given the EOQ you calculated, how many orders should be placed and what is t
- The controller of Hall Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours Janua
- ABC Company uses the high-low method to analyze cost behavior and has determined that machine hours best predict the company's total utilities cost. Determine the cost function (formula) for total uti
- Madtack Company uses a job-order costing system and started the month of March with three jobs in process. The cost of beginning work in process plus the costs added during March are shown below: Calculate Madtack's cost of goods sold after the overhead v
- Bostock's Building Blocks uses number of minutes in its firing oven to allocate overhead costs to products. In a typical month, 5,000 firing minutes are expected, and average monthly overhead costs ar
- Calculate the expected cost for Utilities when production is 5,000 units.
- The first step of the 5-step process costing procedure is: A. summarize total costs to account for B. compute the cost per equivalent unit C. summarize the flow of physical units D. compute output in terms of equivalent units
- Classify the following cost incurred by an apparel company as either a product cost or a period cost: Utility costs for office building.
- A cost that can be identified by the equation Y = a + b X is known as a: A. variable/fixed cost. B. mixed cost. C. discretionary cost. D. sunk cost.
- Based on the scenario below, compute the under- or overapplied overhead for the St. Falls plant for the year using the allocation rates, one rate for plantwide overhead and two separate department overhead rates, all based on machine-hours. (Round your in
- After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March: Cost Formula Actual Cost in March Utilities $16,700 plus $0.15 per mac
- Hokie's plumbing. Calculate number of house calls to break even: House call rates is $100 Gas and variable costs is $60 Salaries for each of two is $100,000
Explore our homework questions and answers library
Browse
by subject