[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 variableand fixed costs.Month Units Sold123456320,000160,000280,000200,000300,000200,000Total Cost$ 160,000100,000220,000100,000230,000120,000Total cost at the high pointVariable costs at the high point:Volume at the high point:Variable cost per unitTotal variable costs at the high pointTotal fixed costsTotal cost at the low pointVariable costs at the low point:Volume at the low point:Variable cost per unitTotal variable costs at the low pointTotal fixed costsMonth789101112Units Sold340,000280,00080,000160,000100,000110,0001. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediatecalculations.)Total Cost$ 220,000160,00064,000140,000100,00080,000High-Low method - Calculation of variable cost per unitHigh-Low method - Calculation of fixed costs

Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs. Month Units Sold 1 HNmin 10. 2 3 4 5 6 320,000 160,000 280,000 200,000 300,000 200,000 Total Cost Month $ 160,000 7 100,000 220,000 100,000 230,000 120,000 168 9 10 11 12 Units Sold 340,000 280,000 80,000 160,000 100,000 110,000 Total Cost $ 220,000 160,000 64,000 140,000 100,000 80,000 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.)

Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs. Month Units Sold 1 HNmin 10. 2 3 4 5 6 320,000 160,000 280,000 200,000 300,000 200,000 Total Cost Month $ 160,000 7 100,000 220,000 100,000 230,000 120,000 168 9 10 11 12 Units Sold 340,000 280,000 80,000 160,000 100,000 110,000 Total Cost $ 220,000 160,000 64,000 140,000 100,000 80,000 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.)

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 9EB: The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method,...

See similar textbooks

Similar questions

The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method, express the companys overtime wages as an equation where x represents number of invoices processed. Assume BC has monthly fixed costs of $3,800. Predict the overtime wages if 9,000 invoices are processed. Predict the overtime wages if 6,500 invoices are processed. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.
es ! Required information [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 Units Sold Total Cost Month Units Sold 1 321,000 $ 158,500 7 359,000 Total Cost $ 270,736 2 166,000 102,250 8 271,000 152,750 3 266,000 206,600 9 75,800 64,000 4 206,000 101,000 10 151,000 131,625 5 291,000 6 191,000 202,500 113,000 11 95,000 95,000 12 101,000 80,650 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.) Total cost at the high point Variable costs at the high point: Volume at the high point: Variable cost per unit Total variable costs at the high point Total fixed costs Total cost at the low point Variable costs at the low point: Volume at the low point: Variable cost per unit Total variable costs at the low point Total fixed costs High-Low…
! Required information [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. Units Month Units Sold Total Cost Month Units Sold 1 7 2 8 9 10 11 12 Total 3 4 5 6 319,000 164,000 264,000 204,000 289,000 189,000 $ $156,500 100,250 204,600 (a) 99,000 200,500 111,000 2. Predict future total costs when sales volume is (a) 378,000 units and (b) 418,000 units. Predictions 378,000 0 $ (b) 418,000 361,000 269,000 0 76,200 149,000 93,000 99,000 Total Cost $285,296 150,750 66,000 129,625 93,000 82,650
1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. Alden Company’s monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs. Month Units Sold Total Cost 1 319,000 $ 156,500 2 164,000 100,250 3 264,000 204,600 4 204,000 99,000 5 289,000 200,500 6 189,000 111,000 7 361,000 285,296 8 269,000 150,750 9 76,200 66,000 10 149,000 129,625 11 93,000 93,000 12 99,000 82,650
Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs. Month Units Sold 1 2 3 4 5 6 320,000 160,000 280,000 200,000 300,000 200,000 Total Cost Month $ 160,000 7 8 9 100,000 220,000 100,000 230,000 120,000 10 11 12 Change in cost Change in volume Total cost at the high point Variable costs at the high point: Volume at the high point: Variable cost per unit Total variable costs at the high point Total fixed costs Units Sold 340,000 280,000 80,000 160,000 100,000 110,000 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.) Total cost at the low point Variable costs at the low point: Volume at the low point: Variable cost per unit Total variable costs at the low point Total fixed costs Total Cost $ 220,000 160,000 64,000 140,000 100,000 80,000 High-Low method - Calculation of variable cost per unit Cost at high point…
Units [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. Total Month Units Sold 320,000 160,000 280,000 200,000 300,000 200,000 LN3456 1 2 Total Cost $ 160,000 100,000 220,000 100,000 230,000 120,000 (a) 2. Predict future total costs when sales volume is (a) 220,000 units and (b) 240,000 units. Predictions 220,000 Month 7 8 9 10 11 12 (b) Units Sold 340,000 280,000 80,000 240,000 160,000 100,000 110,000 Total Cost $ 220,000 160,000 64,000 140,000 100,000 80,000
Assume XYZ Company intends to produce 20000 units next month. Calculate total production costs for the next month if fixed cost is 18000 OMR Total Variable cost 100000 OMR and the Units produced is 10000 Units in the current month. Select one: O a. 200000 OMR O b. 210000 OMR O c. 250000 OMR O d. 218000 OMR
Sohar Company’s financial information is given in the table below. Year Sales (OMR) Fixed Costs Variable Costs 2019 405000 90000 225000 2020 450000 120000 240000 Calculate: P/V ratio, E.P. Sales required to earn a profit of OMR 40000. Margin of safety at a profit of OMR 50000 Profit when sales are OMR. 200000.
Brislin Products has a new product going on the market next year. The following data are projections for production and sales: \table[[Variable costs,$250,000
[The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below: Selling price Variable expenses Contribution margin Fixed expenses are $85,000 per month and the company is selling 2,700 units per month. Req 2A Per Unit 125 80 $45 2-a. Refer to the original data. How much will net operating income increase (decrease) per month if the company uses higher-quality components that increase the variable expense by $5 per unit and increase unit sales by 20%. 2-b. Should the higher-quality components be used? Req 2B Complete this question by entering your answers in the tabs below. Percent of Sales Net operating income 100% 64 36% by Refer to the original data. How much will net operating income increase (decrease) per month if the company uses higher- quality components that increase the variable expense by $5 per unit and increase unit sales by 20%. Req 2A Req 2B >
Required information [The following information applies to the questions displayed below.] Data for Hermann Corporation are shown below: Selling price Variable expenses Contribution margin Fixed expenses are $74,000 per month and the company is selling 4,400 units per month. Req 2A Per Unit $ 70 49 $ 21 2-a. Refer to the original data. How much will net operating income increase (decrease) per month if the co pany uses higher-quality components that increase the variable expense by $4 per unit and increase unit sales by 25%. 2-b. Should the higher-quality components be used? Req 2B Percent of Sales Complete this question by entering your answers in the tabs below. 100% 70 30% increases by Refer to the original data. How much will net operating income increase (decrease) per month if the company uses higher- quality components that increase the variable expense by $4 per unit and increase unit sales by 25%. Net operating income
ABM Enterprise reported business transactions for a certain month in 2020: Unit Price, P55.75; Variable Cost Per Unit, P25.50, and Total Fixed Cost, P45,375.00. a. Compute for the number of units to be sold in order to break-even. b. How is the amount of sales to break-even?