Question

In: Accounting

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 286,000 197,500 11 90,000 90,000
6 186,000 108,000 12 96,000 85,650

2. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.)

please guy show step by step

Solutions

Expert Solution

Answer:- a)-High-Low Method:-

Variable Cost per Unit

Variable cost per unit (b) is calculated using the following formula:

Variable cost per unit=Y2-Y1/X2-X1

Where,
y2 is the total cost at highest level of activity;
y1 is the total cost at lowest level of activity;
x2 are the number of units/miles/ labor ,machine hours etc. at highest level of activity; and
x1 are the number of units/miles/ labor, machine hours etc. at lowest level of activity

The variable cost per unit is equal to the slope of the cost volume line (i.e. change in total cost ÷ change in number of machine hours).

Total Fixed Cost

Total fixed cost (a) is calculated by subtracting total variable cost from total cost, thus:

Total Fixed Cost = y2 – b*x2 = y1 – b*x1

We have,
at highest activity: x2 = 364000 units; y2 = $307376
at lowest activity: x1 = 76800 units; y1 = $69000

Variable Cost per unit = ($307376− $69000) ÷ (364000 −76800)  

= $238376/287200 units =$.0.83 per unit

Total Fixed Cost = $69000 − ($0.83 × 76800) = $69000 – $63744 =$5256


Related Solutions

Required information Skip to question [The following information applies to the questions displayed below.] Stoll Co.'s...
Required information Skip to question [The following information applies to the questions displayed below.] Stoll Co.'s long-term available-for-sale portfolio at the start of this year consists of the following. Available-for-Sale Securities Cost Fair Value Company A bonds $ 533,600 $ 490,000 Company B notes 159,230 152,000 Company C bonds 662,000 640,190 Stoll enters into the following transactions involving its available-for-sale debt securities this year. Jan. 29 Sold one-half of the Company B notes for $78,640. July 6 Purchased bonds of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $84,000. Raw materials purchases in April are $550,000, and factory payroll cost in April is $384,000. Overhead costs incurred in April are: indirect materials, $55,000; indirect labor, $24,000; factory rent, $31,000; factory utilities, $20,000; and factory equipment depreciation, $56,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $660,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $88,000. Raw materials purchases in April are $560,000, and factory payroll cost in April is $379,000. Overhead costs incurred in April are: indirect materials, $50,000; indirect labor, $23,000; factory rent, $35,000; factory utilities, $22,000; and factory equipment depreciation, $60,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $670,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $80,000. Raw materials purchases in April are $500,000, and factory payroll cost in April is $363,000. Overhead costs incurred in April are: indirect materials, $50,000; indirect labor, $23,000; factory rent, $32,000; factory utilities, $19,000; and factory equipment depreciation, $51,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $635,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $80,000. Raw materials purchases in April are $500,000, and factory payroll cost in April is $363,000. Overhead costs incurred in April are: indirect materials, $50,000; indirect labor, $23,000; factory rent, $32,000; factory utilities, $19,000; and factory equipment depreciation, $51,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $635,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $85,000. Raw materials purchases in April are $510,000, and factory payroll cost in April is $377,000. Overhead costs incurred in April are: indirect materials, $51,000; indirect labor, $22,000; factory rent, $34,000; factory utilities, $23,000; and factory equipment depreciation, $57,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $640,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $85,000. Raw materials purchases in April are $510,000, and factory payroll cost in April is $387,000. Overhead costs incurred in April are: indirect materials, $50,000; indirect labor, $26,000; factory rent, $35,000; factory utilities, $21,000; and factory equipment depreciation, $56,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $650,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $85,000. Raw materials purchases in April are $510,000, and factory payroll cost in April is $387,000. Overhead costs incurred in April are: indirect materials, $50,000; indirect labor, $26,000; factory rent, $35,000; factory utilities, $21,000; and factory equipment depreciation, $56,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $650,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $89,000. Raw materials purchases in April are $520,000, and factory payroll cost in April is $383,000. Overhead costs incurred in April are: indirect materials, $52,000; indirect labor, $27,000; factory rent, $32,000; factory utilities, $22,000; and factory equipment depreciation, $52,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $695,000 cash in April. Costs of...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory...
Required information [The following information applies to the questions displayed below.] Marcelino Co.'s March 31 inventory of raw materials is $85,000. Raw materials purchases in April are $580,000, and factory payroll cost in April is $382,000. Overhead costs incurred in April are: indirect materials, $54,000; indirect labor, $25,000; factory rent, $34,000; factory utilities, $24,000; and factory equipment depreciation, $54,000. The predetermined overhead rate is 50% of direct labor cost. Job 306 is sold for $665,000 cash in April. Costs of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT