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 Sold 318,500 163,500 263,500 203,500 288,500 188,500 361,500 268,500 76,300 148,500 92,500 98,500 Total Cost $ 156,000 99,750 204,100 98, 500 200,000 110,500 288,956 150,250 66,500 129,125 92,500 83,150 Month 1 2 3 10 11 12 Predict future total costs when sales volume is (a) 377,000 units and (b) 417,000 units.

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 Sold 318,500 163,500 263,500 203,500 288,500 188,500 361,500 268,500 76,300 148,500 92,500 98,500 Total Cost $ 156,000 99,750 204,100 98, 500 200,000 110,500 288,956 150,250 66,500 129,125 92,500 83,150 Month 1 2 3 10 11 12 Predict future total costs when sales volume is (a) 377,000 units and (b) 417,000 units.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 3DQ: Suppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What...

See similar textbooks

Similar questions

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…
[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 Total Cost 1 324,500 $ 162,000 7 355,500 $ 245,564 2 169,500 105,750 8 274,500 156,250 3 269,500 210,100 9 75,100 60,500 4 209,500 104,500 10 154,500 135,125 5 294,500 206,000 11 6 194,500 116,500 12 98,500 104,500 98,500 77,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 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 High-Low method - Calculation of fixed costs Total cost at the low point Variable costs at the low point: Volume at the…
Required information Skip to question [The following information applies to the questions displayed below.] Alden Co.’s monthly unit sales and total cost data for its operating activities of the past year follow. Management wants to use these data to predict future fixed and variable costs. Month Units Sold Total Cost Month Units Sold Total Cost 1 315,500 $ 153,000 7 364,500 $ 311,084 2 160,500 96,750 8 265,500 147,250 3 260,500 201,100 9 76,900 69,500 4 200,500 95,500 10 145,500 126,125 5 285,500 197,000 11 89,500 89,500 6 185,500 107,500 12 95,500 86,150 1. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.) SEE PICTURE
[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. 2234 in Month 1 Units Sold 315,000 Total Cost $ 152,500 160,000 96,250 260,000 200,600 200,000 95,000 5 285,000 196,500 6 185,000 107,000 7 365,000 314,800 8 265,000 146,750 9 77,000 70,000 10 145,000 125,625 11 89,000 89,000 12 95,000 86,650 2. Predict future total costs when sales volume is (a) 370,000 units and (b) 410,000 units. 370,000 units 410,000 units Total cost
A company has following details for this yearDetails Total sales($) Total cost($) Details Total sales($) Total cost($)Year ended 31/12/2018 35,78,998 25,89,709Year ended 31/12/2019 48,90,742 31,67,984 Calculate P/V ratio, Fixed cost, break even sales, Margin of safety 2018/2019, Variable cost 2018/2019and percent of fixed cost 2018/2019
Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 Jan. 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43, 200 4,800 $ 3,600 $ $ $ 684.65 Average 400 Average cost per hour a (intercept) b (coefficient) 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range of
Alden Company's monthly data for the past year follow. Management wants to use these data to predict future variable and fixed costs. Month 1 2 Saw! 3 4 5 6 7 8 9 10 11 12 Units Sold 315,000 160,000 260,000 200,000 Total cost 285,000 185,000 365,000 265,000 77,000 145,000 89,000 95,000 Total Cost: $152,500. 96,250 200,600 95,000 196,500 107,000 314,800 146,750 70,000 125,625 89,000 86,650 2. Predict future total costs when sales volume is (a) 370,000 units and (b) 410,000 units. 370,000 units 410,000 units
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.
Suppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
9.-Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to determine Smithson's fixed costs per month. Round your final answer to the nearest dollar. Do not round interim calculations. Cost Machine Hours January $26,500 10,100 February 35,400 17,800 March 28,300 11,500 April 31,500 15,200
Required information [The following information applies to the questions displayed below.] Hudson Co. reports the contribution margin income statement for 2019. HUDSON CO. Contribution Margin Income Statement For Year Ended December 31, 2019 Sales (10,600 units at $300 each) Variable costs (10,600 units at $240 each) Contribution margin $3,180,000 2,544,000 636,000 480,000 Fixed costs Pretax income 156,000 The marketing manager believes that increasing advertising costs by $110,000 in 2020 will increase the company's sales volume to 12,000 units. Prepare a forecasted contribution margin income statement for 2020 assuming the company incurs the additional advertising costs. HUDSON CO. Forecasted Contribution Margin Income Statement For Year Ended December 31, 2020 Sales Variable costs Contribution margin Fixed costs Income (pretax)/Loss Should the company incur the additional advertising costs?