Using the high low method
Variable cost rate = difference in total cost / difference in units
= ($74575-41545) / (40040-18020)
= $1.50
Fixed portion = total - variable
= $41545 - (18020*$1.50)
= $14515
Hence intercept = $14515
Slope = $1.50
Assuming total cost = Y and units = X
Equation will be
Y = $1.50X + $14515
Feel free to ask any queries..
Also plz upvote it means a lot .. thank you
July August September October November December Units Produced 18,020 32032 36,036 22022 40.040 Total Cost $41.545...
July August September October November December Units Produced 18,020 32,032 36,036 22,022 40,040 38,038 Total Cost $41.545 48,048 55,055 42,358 74.575 62,062 Compute the variable-and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation Intercepts Slope 5 The cost equation is: $ per unit produced = Total cost
July August September October November December Units Produced 18.020 32.032 36,036 22.022 40,040 38,038 Total Cost $41,545 48,048 55,055 42,358 74,575 62,062 Compute the variable and fixed-cost elements using the regression analysis. Present your solution in the form of a cost equation Intercept $ Slope 1.2492 The cost equation is: $ 1.2492 per unit produced - Total cost
Blossom Corp. has collected the following data concerning its
maintenance costs for the past 6 months.
Units Produced
Total Cost
July
18,020
$41,545
August
32,032
48,048
September
36,036
55,055
October
22,022
42,358
November
40,040
74,575
December
38,038
62,062
Compute the variable cost per unit using the high-low method.
(Round answer to 2 decimal places, e.g.
2.25.)
Variable cost per unit
$
Compute the fixed cost elements using the high-low
method.
Fixed costs
$
July August September October November December Units Produced 18,000 32,000 32,000 36,000 20,000 40,000 38,000 Total Cost $41,500 58,400 6 6,800 40,700 87,700 83,500 x your answer is incorrect. Try again. Compute the variable cost per unit using the high-low method. (Round variable cost per mile to 2 decimal places e.g. 1.25.) Variable cost per unit J 2.14 x Your answer is incorrect. Try again. Compute the fixed cost elements using the high-low method. Fixed costs Fixed costs 2,100 2,100...
Find Variable Cost per unit & Fixed Cost
Units Total Cost Produced July $45,784 20,970 August September 37,280 55,920 41,940 64,075 October 25,630 47,330 November 46,600 86,792 December 44,270 72.230
**This assignment MUST be completed in Excel using formulas and uploaded into Canvas for grading** BE5.13 Data for Stiever Corporation's maintenance costs is shown below: Total Cost Units Produced 18,000 32,000 36,000 July August September October November December $32,000 48,000 55,000 38,000 66,100 62,000 22,000 40,000 38,000 Compute the variable and fixed cost elements using regression analysis. Present your solution in the form of a cost equation. You must use the Intercept and Slope functions in Excel.
month total distribution cost level of activity (unit produced) july 230.000 3500 august 250.000 3750 september 260.000 3800 october 220.000 3400 november 340.000 5800 december 330.000 5500 January 200.000 2900 February 210.000 3300 March 240.000 3600 April 380.000 5900 may 350.000 5600 june 290.000 5000 a) Determine the variable cost per unit and the fixed cost using the high-low method. b) What is the equation of the total mixed cost function? c) Prepare the scatter diagram, clearly showing any outliers....
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,100 August 105,100 Forecast: September 114,200 October 94,500 November 121,900 December 107,000 Based on past experience, it is estimated that 24% of a month’s sales are collected in the month of sale, 46% are collected in the month following the sale, and 5% are collected in the second month following the sale. Required: Calculate the estimated cash...