Question

In: Accounting

Machine-Hours Maintenance Cost March 4,440 $50,950 April 4,431 $50,877 May 4,412 $50,696 June 4,460 $51,113 July...

Machine-Hours Maintenance Cost
March 4,440 $50,950
April 4,431 $50,877
May 4,412 $50,696
June 4,460 $51,113
July 4,414 $50,711
August 4,433 $50,900
September 4,443 $50,976
October 4,415 $50,730
November 4,391 $50,530

Management believes that maintenance cost is a mixed cost that depends on machine-hours.

Using the high-low method, calculate

Variable cost per machine-hour?

Fixed cost per month?

What would total costs be for a month with 4,000 machine-hours?

Solutions

Expert Solution

In high low two point method we use the highest and lowest activity level costs to find out the variable cost and fixed cost.

1. Calculation of Variable cost per machine hour

Highest point of activity is in the month of June with 4460 Machine hours and lowest level of activity is in the month of November with 4391 machine hours.

Variable cost per machine hour =(Cost at highest level of activity- cost at lowest level of activity) / (High activity Level - Low Activity Level) =($51113 - $50530) / (4460 - 4391) =$583/69 =$8.45 per machine hour

2.Calculation of monthly Fixed cost

Fixed Cost can be find out by either using the high point or low point and both will give the same answer

Fixed cost = Total cost – (Variable cost per machine hour x Activity level)

Fixed cost Using highest point of activity = $51113– ($8.45 x 4460) = $13426

Fixed cost using lowest point of activity = $50530– ($8.45 x 4391) = $13426(rounded off)

Both are giving the same answer.

Therefore, Fixed cost per month =$13426

3. Calculation of Total cost for a month at 4000 machine hours

Total cost = Fixed cost + Variable cost for = $13426 + ($8.45 x 4000 hour) = $13426+ $33800 = $47226


Related Solutions

For the past 8 months: Machine-Hours Maintenance Cost This is all the given info!! March 4,440...
For the past 8 months: Machine-Hours Maintenance Cost This is all the given info!! March 4,440 $50,950 April 4,431 $50,877 May 4,412 $50,696 June 4,460 $51,113 July 4,414 $50,711 August 4,433 $50,900 September 4,443 $50,976 October 4,415 $50,730 November 4,391 $50,530 Management believes that maintenance cost is a mixed cost that depends on machine-hours Using the high-low method, calculate (a) Variable cost per machine-hour (b) Fixed cost per month (c) What would total costs be for a month with 4,000...
Cost Behavior Assume a local pizzeria reported the following results for June and July April May...
Cost Behavior Assume a local pizzeria reported the following results for June and July April May Unit Sales      2,000      3,000 Cost of Food Sold $   8,000 $ 12,000 Wages and Salaries      3,700      4,000 Rent      2,000      2,000 Depreciation         500         500 Utilities      1,400      1,500 Supplies         200         300 Total $ 15,800 $ 20,300 a. Identify each cost as being fixed, variable or mixed. b. Determine the equation for total operating costs...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000...
Month Sales January $100,000 February $120,000 March $150,000 April $180,000 May $150,000 June $120,000 July $150,000 August $180,000 Actual November and December 2018 sales were $200,000 and $90,000, respectively. Cash sales are 45% of the total and the rest are on credit. About 70% of credit sales are typically collected one month after the sale and 30% the second month. Monthly inventory purchases represent 50% of the following month’s sales. The firm pays 40% of its inventory purchases in cash...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July...
Month Patient Days January 543 February 528 March 531 April 542 May 558 June 545 July 543 August 550 September 546 October 540 November 535 December 529 Predict naïve forecast of patient days for February and June. Predict the patient days for January, using a four-period moving average. Predict the patient days for January, using the six-period moving average. Plot the actual data and the results of the four period and the six-period moving averages. Which is a better predictor?
Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600...
Jan 523.9 Feb 510.23 March 545.65 April 514.23 May 550.71 June 505.34 July 525.34 August 600 Sept. 569.42 October 500.2 Novem. 533.12 December 507.11 What percentage of your bills are within two standard deviations of the mean?
April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000...
April May June July Sales 600,000 900,000 500,000 400,000 Cost of Goods sold 420,000 630,000 350,000 280,000 Gross Margin 180,000 270,000 150,000 120,000 Selling and admin expenses selling expense 79,000 120,000 62,000 51,000 administrative 45,000 52,000 41,000 38,000 total selling and administrative expenses 124,000 172,000 103,000 89,000 net operating income 56,000 98,000 47,000 31,000 a. sales are 20% for cash and 80% on account b. sales on account are collected over a three month period with 10% collected in the...
month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200...
month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200 august 7000 26000 september 8400 29800 october 7800 26500 november 6800 25700 using the gleason products data from above perform a LEAST REGRESSION ANALYSIS on the data ( use excel to perform analysis) a) what is Gleasons total fixed cost? b) what is Gleasons varaiable cost per unit? c) what would total cost be for a month with 7500 units produced? d) what proportion...
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July...
Historical demand for a product is as follows: DEMAND April 61 May 56 June 81 July 61 August 86 September 81 a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) b. Using single exponential smoothing with α = 0.30 and a September forecast = 64, calculate a forecast for October. (Round your answer to 2 decimal places.) c. Using simple linear regression, calculate the trend line for the historical data....
Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000;...
Cave Hardware's forecasted sales for April; May; June; and July are $200,000; $230,000; $190,000; and $240,000; respectively. Sales are 65% cash and 35% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75%of sales and ending inventory is maintained at $60,000 plus 10% of the following month's cost of goods sold. All inventory purchases are paid 22% in the month of purchase and 78%in the following month. What are the cash collections...
Ruiz Co. provides the following sales forecast for the next four months: April May June July...
Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (units) 680 760 710 800 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 136 units. Assume July's budgeted production is 710 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT