Question

In: Accounting

given below is the variable costing income statement for a XY Company:                         Sales, 6,000 units...

given below is the variable costing income statement for a XY Company:

                       

Sales, 6,000 units @ $35                                                         $210,000

Variable costs:

Beginning inventory, 680 units @ $20               $13,600

Variable manufacturing cost of

goods manufactured, 6,600 units @ $20       + $132,000

Ending inventory, 1,280 units @ $20               - $25,600

Variable manufacturing cost of goods              $120,000

Variable selling and administrative exp.           + $24,900

Total variable costs                                                       - $144,900

Contribution margin                                                                 $65,100

Fixed costs:

Fixed factory overhead                                     $19,800

Fixed selling and admin. expenses                 + $15,300

Total fixed costs                                                               - $35,100

Operating income                                                                     $30,000

REQUIRED:                                                                            

   a. Prepare an absorption-costing income statement for the same period.

   b. Reconcile the difference between variable costing and absorption costing operating income.

Note: Please Show all the steps and calculations in solving the problem ( I don't need the problem on excel i need to see all the steps)

Solutions

Expert Solution

Ans.   Income statement as absorption-costing income statement

Sales (6000X35)                          =      210000

Less: Cost of goods sold

Opening stock (680X23)    = 15640           

Add:cost of manufacturing                         

(6600X23) = 151800       

Less:Clo stock(1280X23)   = (29440)   

cost of goods sold                              = 138000

Gross profit (210000-138000)       =    72000

Less: Market and admn exp.

Variable marketable exp. =   24900     

Fixed marketable exp.                         = 15300

Net operating Income                           =    31800

*Calculation of Total goods production during the year

= Sale inventory+closing inventory-opening inventory

=6000+1280-680 = 6600 units or we can directory good manufactured during the year 6600 units

** Calculation of manfacturing expenses per unit = 20+(19800/6600) = 23 per unit

b. Reconcile Statement between variable costing and absorption costing operating income

Operating Income as per Variable costing              =       30000

Add: Fixed cost included in closing stock (1280X3) =      3840

Less: Fixed cost included in opening stock (680X3) =     2040

Operating income as per absorption costing            =     31800


Related Solutions

Below is the variable costing income statement for South Bend Co. Sales, 6,000 units                             &n
Below is the variable costing income statement for South Bend Co. Sales, 6,000 units                                                                        $210,000 Total variable costs:           Beg. inventory,            680 units              $13,600           Variable manufacturing cost of           goods manufactured,       ? units           + 132,000           Ending inventory,     1,280 units           - (25,600)           Variable manufacturing cost of goods $120,000           Variable selling & admin. exp.              + 24,900     ($144,900) Contribution margin                                                                    $65,100 Total fixed costs:           Fixed factory overhead                            $19,800...
Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution...
Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution margin 240,000 Fixed costs 80,000 Net income $160,000 (a) At what sales volume (in sales dollars) does Sherpa break even? (b) At what sales volume (in units) does Sherpa break even? (c) Given the income statement above, compute the margin of safety. (d) What level of sales volume must be attained to reach net income of $200,000? (e) What level of sales volume must...
White Limited’s most recent income statement is shown below: Total Per Unit Sales (6,000 units) $...
White Limited’s most recent income statement is shown below: Total Per Unit Sales (6,000 units) $ 312,000 $ 52.00 Variable expenses 216,000. 36.00 Contribution margin 96,000 $ 16.00 Fixed expenses. 84,000 Operating income $ 12,000 Fixed expenses 84,000 Operating income $ 12,000 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. The sales volume increases by 200 units. 2. The sales volume declines by 200 units. 3. The sales volume...
1. Test Company reported the following income statement for the most recent period. Sales (6,000 units)...
1. Test Company reported the following income statement for the most recent period. Sales (6,000 units) $120,000 Variable expenses      72,000 Contribution margin 48,000 Fixed expenses      30,000 Operating income $18,000 Determine the breakeven point in units. Note: Give your answer using commas. Do not include the word “units.” Example: 12,345 2. Determine the number of units Test Company must sell to earn operating income of $20,000. Note: Give your answer using commas. Do not include the word “units.” 3....
A company’s contribution format income statement for last month is given below: Sales (40,000 units ×...
A company’s contribution format income statement for last month is given below: Sales (40,000 units × $22 per unit) $ 880,000 Variable expenses 616,000 Contribution margin 264,000 Fixed expenses 211,200 Net operating income $ 52,800 The company considers renovating its operations by purchasing a new machine that would reduce variable expenses by $6.60 per unit. However, fixed expenses would increase to a total of $475,200 each month. Using the new machine would not cause a change in monthly sales quantity...
Sprinkles Company: a) Prepare both an Absorption & Variable Costing Income Statement, given the following: (Provide...
Sprinkles Company: a) Prepare both an Absorption & Variable Costing Income Statement, given the following: (Provide computations or excel attachment) Total units= 85,000 kg Consumer Price (including VAT): 148.20, Value Added Tax (25% of consumer price before tax): 29.64, Consumer Price before tax: 118.56, Retailer's Margin (27.5% of price to retailer): 25.57, UNIT PRICE to Retailer: 92.99 Cake Material: 10.67, Cake Labor: 10.25, Toppings Material: 5.55, Toppings Labor: Cabbage: 5.45, Packaging: 10.26, Transportation & Storage: 6.20, Margins & Discounts to...
Morton Company’s contribution format income statement for last month is given below: Sales (15,000 units ×...
Morton Company’s contribution format income statement for last month is given below: Sales (15,000 units × $30 per unit) $ 450,000 Variable expenses 315,000 Contribution margin 135,000 Fixed expenses 90,000 Net operating income $ 45,000 The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits....
Morton Company’s contribution format income statement for last month is given below: Sales (43,000 units ×...
Morton Company’s contribution format income statement for last month is given below: Sales (43,000 units × $23 per unit) $ 989,000 Variable expenses 692,300 Contribution margin 296,700 Fixed expenses 237,360 Net operating income $ 59,340 The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits....
Morton Company’s contribution format income statement for last month is given below: Sales (43,000 units ×...
Morton Company’s contribution format income statement for last month is given below: Sales (43,000 units × $29 per unit) $ 1,247,000 Variable expenses 872,900 Contribution margin 374,100 Fixed expenses 299,280 Net operating income $ 74,820 The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits....
Morton Company’s contribution format income statement for last month is given below: Sales (47,000 units ×...
Morton Company’s contribution format income statement for last month is given below: Sales (47,000 units × $27 per unit) $ 1,269,000 Variable expenses 888,300 Contribution margin 380,700 Fixed expenses 304,560 Net operating income $ 76,140 The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT