Question

In: Accounting

A company has the following financial information: year Labour (in hours) machine costs (in $) 2009...

A company has the following financial information:

year

Labour

(in hours)

machine costs

(in $)

2009

         1,200

103,266

2010

         1,225

110,216

2011

         1,100

    97,579

2012

         1,050

    94,581

2013

         1,160

111,762

2014

         1,200

115,786

2015

         1,350

136,476

2016

         1,380

141,852

2017

         1,250

128,679

2018

         1,270

135,334

2019

         1,220

132,222

Required


Using the high-low method, what are the estimated machine costs

  1. if there are 1,100 Labour hours?
  2. if there are zero Labour hours?
  3. What is a significant drawback to using the High-low method to calculate costs at zero labour hours?

Solutions

Expert Solution

a

Month Hours Cost
2009          1,200 $         103,266
2010          1,225 $         110,216
2011          1,100 $           97,579
2012          1,050 $           94,581
2013          1,160 $         111,762
2014          1,200 $         115,786
2015          1,350 $         136,476
2016          1,380 $         141,852
2017          1,250 $         128,679
2018          1,270 $         135,334
2019          1,220 $         132,222
High          1,380 $         141,852
Low          1,050 $           94,581
Variable cost               143.25
= (141852-94581)/(1380-1050)
Fixed cost        (55,826.73)
= 141852-1380 × 143.25
Equation= Cost   =   143.2455 × Hours + -55826.73
Cost at 1100 hours: $   101,743.27
[ 1100 * 143.2455 + -55826.73

b

Month Hours Cost
2009          1,200 $         103,266
2010          1,225 $         110,216
2011          1,100 $           97,579
2012          1,050 $           94,581
2013          1,160 $         111,762
2014          1,200 $         115,786
2015          1,350 $         136,476
2016          1,380 $         141,852
2017          1,250 $         128,679
2018          1,270 $         135,334
2019          1,220 $         132,222
High          1,380 $         141,852
Low          1,050 $           94,581
Variable cost               143.25
= (141852-94581)/(1380-1050)
Fixed cost        (55,826.73)
= 141852-1380 × 143.25
Equation= Cost   =   143.2455 × Hours + -55826.73
Cost at 0 hours: $    (55,826.73)
[ 0 * 143.2455 + -55826.73

c

Cost can not be negative. At 0 hours it is providing negative cost which is a drawback of the method.

please rate.


Related Solutions

Kootenay Welding company is not sure whether or not to use direct labour hours or machine...
Kootenay Welding company is not sure whether or not to use direct labour hours or machine hours to allocate manufacturing overhead. They expect total manufacturing overhead for the year to be $450,000. They expect to have 6,000 direct labour hours and 4,500 machine hours. Kootenay Welding Company is going to bid on a contract that is expected to take 450 direct labour hours and 375 machine hours. Direct Labour costs $45 an hour and materials would total $25,000. Assuming a...
Mosaic Company applies overhead using machine hours and reports the following information. Actual machine hours used...
Mosaic Company applies overhead using machine hours and reports the following information. Actual machine hours used (AH) 4,900 hours Standard machine hours (for actual production) (SH) 5,400 hours Actual variable overhead rate per hour (AVR) $ 4.55 Standard variable overhead rate per hour (SVR) $ 4.40 QS 23-18A Total variable overhead cost variance LO P5 Compute the total variable overhead cost variance and classify it as favorable, unfavorable or no variance. Compute the variable overhead spending variance and the variable...
Deidoro Company has provided the following data for maintenance cost: Prior Year Current Year Machine hours...
Deidoro Company has provided the following data for maintenance cost: Prior Year Current Year Machine hours 22,000 24,500 Maintenance cost $ 31,400 $ 34,900 Maintenance cost is a mixed cost with variable and fixed components. The fixed and variable components of maintenance cost are closest to: Multiple Choice $34,300 per year; $.714 per machine hour $600 per year; $.714 per machine hour $600 per year; $1.400 per machine hour $31,400 per year; $1.400 per machine hour . Derst Inc. sells...
The following information pertains to Glass Works Company for 2014. Budgeted direct-labour cost: --------------------------------75,000 hours at...
The following information pertains to Glass Works Company for 2014. Budgeted direct-labour cost: --------------------------------75,000 hours at $16 per hour Actual direct-labour cost: ------------------------------------80,000 hours at $17.50 per hour. Budgeted Manufacturing Overhead: ---------------------$ 997,500 Actual Manufacturing Overhead: Depreciation ------------------------------------------------- $ 240,000 Property Taxes---------------------------------------------------12,000 Indirect Labour --------------------------------------------------82,000 Supervisory Salaries --------------------------------------------200,000 Utilities------------------------------------------------------------ 59,000 Insurance ----------------------------------------------------------30,000 Rental of Space-------------------------------------------------- 300,000 Indirect Material --------------------------------------------------- 79,000 Required (i) Compute the firm’s predetermined overhead rate, which is based on direct-labour hours. (ii) Calculate the overapplied or underapplied...
Company A shows the following information on its 2009 income statement: sales = $200,000; costs =...
Company A shows the following information on its 2009 income statement: sales = $200,000; costs = $87,000; other expenses = $4,900; depreciation expense = $9,100; interest expense = $14,500; taxes = $29,575; dividends = $10,000. In addition, you're told that the firm issued $7,100 in new equity during 2009 and redeemed $8,700 in outstanding long-term debt. (b) What is the 2009 cash flow to creditors? (c) What is the 2009 cash flow to stockholders? (d) If net fixed assets increased...
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 15,000 $12,075 August 13,500 10,800 September 11,500 9,580 October 15,500 12,080 November 14,800 11,692 December 12,100 9,922 If Fromme expects to incur 14,000 machine hours in January, what will be the estimated total production cost using the high-low method?
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 16,600 $ 12,155 August 15,100 12,400 September 13,100 9,740 October 17,100 12,240 November 16,400 11,772 December 13,700 9,970 If Fromme expects to incur 12,200 machine hours in January, what will be the estimated total production cost using the high-low method? $8,732.63. $9,177.50. $7,625.00. $19,865.00.
(1) Fromme's Frocks has the following machine hours and production costs for the last six months...
(1) Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 17,000 $ 12,175 August 15,500 12,800 September 13,500 9,820 October 17,500 12,280 November 16,800 11,792 December 14,100 9,982 If Fromme expects to incur 12,600 machine hours in January, what will be the estimated total production cost using the high-low method? (A) $20,029.00. (B) $8,841.60. (C) $7,749.00. (D) $9,266.50. (3) Case (A) Case (B) Case (C)...
Consider the following financial information about a new machine at a computer manufacturing company: The machine...
Consider the following financial information about a new machine at a computer manufacturing company: The machine costs $150,000 and will be used for 4 years. The machine will be depreciated using MACRS 5-year class property. At the end of the fourth year, the machine will be sold at 40% of the initial cost. The firm will invest $20,000 in working capital (fully recoverable at the end of the project life). The expected annual savings on labor and materials due to...
The Alphonse Company allocates fixed overhead costs by machine hours and variable overhead costs by direct...
The Alphonse Company allocates fixed overhead costs by machine hours and variable overhead costs by direct labor hours. At the beginning of the year the company expects fixed overhead costs to be $600,000 and variable costs to be $800,000. The expected machine hours are 6,000 and the expected direct labor hours are 80,000. The actual fixed overhead costs are $700,000 and the actual variable overhead costs are $750,000. The actual machine hours during the year are 5,500 and the actual...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT