Question

In: Accounting

Alden Co.’s monthly unit sales and total cost data for its operating activities of the past...

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.)

Predict future total costs when sales volume is (a) 371,000 units and (b) 411,000 units.

Solutions

Expert Solution

If you have any query ask in comment section. If you like the answer plz rate. Thanks


Related Solutions

Required information [The following information applies to the questions displayed below.] Alden Co.’s monthly unit sales...
Required information [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 316,000 $ 153,500 7 364,000 $ 307,376 2 161,000 97,250 8 266,000 147,750 3 261,000 201,600 9 76,800 69,000 4 201,000 96,000 10 146,000 126,625 5...
Felix & Co. reports the following information about its unit sales and cost of sales. Period...
Felix & Co. reports the following information about its unit sales and cost of sales. Period Units Sold Cost of Sales Period Units Sold Cost of Sales 1 0 $ 2,640 6 2,140 $ 6,492 2 540 3,612 7 2,540 7,212 3 940 4,332 8 2,940 7,932 4 1,340 5,052 9 3,340 8,652 5 1,740 5,772 10 3,740 9,372 Hint: (Draw an estimated line of cost behavior using a scatter diagram offline.) Complete the below table to calculate the fixed...
Finn Company has the following operating data for the past year: Sales $616,000 Variable Cost $150,000...
Finn Company has the following operating data for the past year: Sales $616,000 Variable Cost $150,000 Fixed Cost $100,000 Minimum required rate of return 27% Balance Sheet Data for beginning and end of year: Assets Beginning Ending Cash $5,000 $5,000 Accounts Receivable $35,000 $40,000 Inventory $90,000 $95,000 Net PP&E $100,000 $115,000 Land (held for future use) $40,000 $40,000 Investments in affiliates $5,000 $0 Total Assets $275,000 $295,000 Liabilities & SH Equity Short Term Debt $22,000 $27,000 Long Term Debt $116,000...
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning...
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning inventory 18 $6 $108 Purchase on Apr 25 35 7 245 Purchase on Nov 16 13 10 130 Sales 45 ? ? MakrelMakrel ​Sales' LIFO cost of ending inventory would be A.$186. B.$129. C.$154. D.$450.
The Selling Division’s unit sales price is $37 and its unit variable cost is $15. Its...
The Selling Division’s unit sales price is $37 and its unit variable cost is $15. Its capacity is 11000 units. Fixed costs per unit are $8. Current outside sales are 9000 units. What is the Selling Division’s opportunity cost per unit from selling 3000 units to the Purchasing Division? -$0 -$37 -$22 -$14 The Can Division of Marigold Corp. manufactures and sells tin cans externally for $1.00 per can. Its unit variable costs and unit fixed costs are $0.24 and...
Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit...
Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit Packaging Costs $15 per unit Electricity $4 per unit Waste and Other Costs $6 per unit Salary and Wages Costs $560,000 per month Fringe Benefits 50% of salaries Rent Costs $750,000 per month Insurance Costs $50,000 per month Depreciation Costs $370,000 per month Actual Data January February Production (Units) 245000 187000 Revenue $ 19,345,000.00 $ 14,888,000.00 Raw Materials $    6,545,000.00 $    4,996,000.00 Package Materials...
The following monthly data in contribution format are available for the MN Co. and its only...
The following monthly data in contribution format are available for the MN Co. and its only product: Total Per Unit Sales……………………………………………………………. $83,700 $279 Variable expenses………………………………………. 32,700 109 Contribution margin…………………………………… 51,000 $170 Fixed expenses……………………………………………. 40,000 Net operating income…………………………………. $11,000               The Company is currently selling 300 units of product per month. Required: (each point is separate) Management is contemplating the use of plastic gearing rather than metal gearing in its product. This change would reduce variable expenses by $18 per unit....
Sales Price per Unit $16.37 Total Fixed Costs $142,408.00 Total Unit Sales 19364 Total Profit $22,952.80...
Sales Price per Unit $16.37 Total Fixed Costs $142,408.00 Total Unit Sales 19364 Total Profit $22,952.80 Variable Rate ? 2. Sales Price per Unit $16.50 Profit $33,381.80 Number of Customers 18,440 Total Fixed Costs $136,137.00 Contribution Rate ? 3. Variable Cost per Unit $5.85 Sales Price per Unit $17.40 Fixed Costs $164,065.60 Break Even Point in Dollars ? 4. Contribution Rate 60% Sales Price per Unit $18.20 Fixed Costs $219,423.16 Break-Even Point in Number of Customers ? 5. Sales Price...
Wilke Realty separates its activities into two operating divisions: Rentals and Sales. In March, the firm...
Wilke Realty separates its activities into two operating divisions: Rentals and Sales. In March, the firm spent $52,000 for general company promotions (as opposed to advertisements for specific properties). John, the corporate controller, has decided to allocate general promotion costs to the two operating divisions. He is considering whether to base his allocations on the (1) expected increase in divisional revenue from the promotions or (2) expected increase in divisional profit from the promotions (before allocated promotion costs). General promotions...
Westside produces pillows with monthly unit sales and costs given as:  Unit Sales: 4000 units...
Westside produces pillows with monthly unit sales and costs given as:  Unit Sales: 4000 units  Price: $10.00 per unit  Variable costs: $5.50 per unit  Fixed costs: $15,000 1. Westside is considering a 5% price cut without additional fixed cost. By what % would sales need to increase to keep profit constant for the 5% price cut? 2. Replacing goose feathers with synthetic filler will decrease the unit variable cost by $0.22. By what % would sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT