Problem 18-1A (Algo) Measuring costs using high-low method LO P1 The following information applies to the questions displayed below) Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable 12 and fixed costs Month its sola 1 316,500 2 161,500 3 261.500 4 201,500 5 286,500 6 106,500 Total cost $ 154,000 97.750 202, 100 96,500 198,000 108,500 Month 7 8 9 10 11 12 Units sold 363,500 264,500 76,700 146,500 90,500 96,500 Total cost $ 303,676 148, 250 68,500 127, 125 90, 500 B5, 150 Problem 18-1A (Algo) Part 1 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method (Do not round Intermediate calculations.) High-Low method. Calculation of variable cost per unit High-Low method - Calculation of fixed costs Tot constat the high point Variable costs in the high point Volume at the high point Variable cost per unit Total variable costs at the high port Total fue costa TN Con the low point Vrable costs the low point Volume we the low point Variable cost perut Total we costs of the low point Tow foxed Cool of 2 Required Information Problem 18-1A (Algo) Measuring costs using high-low method LO P1 The following information applies to the questions displayed below) Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs Month its sold Total cost Month Units sold Total cost 316,500 $ 154,000 7 363,500 $ 303,676 161,500 97,750 8 266,500 149, 250 261,500 202, 100 76,700 68,500 201,500 96,500 146,500 127, 125 286,500 190,00 90, 500 90,500 186,500 100, 500 12 96,500 85,150 1 2 3 4 9 10 11 Problem 18-1A (Algo) Part 2 2. Predict future total costs when sales volume is (e) 373,000 units and (b) 413,000 units. Predictions () (1) 373,000 413,000 Units Total