Question

In: Accounting

Given the following information: Prior Year (Budget) Prior Year (Actual) Current Year (Budget) Current Year (Actual)...

Given the following information:

Prior Year (Budget)

Prior Year (Actual)

Current Year (Budget)

Current Year (Actual)

Beginning Inventory (Units)

0

0

?

?

Sales (Units)

600,000

580,000

575,000

570,000

Manufactured (Units)

600,000

590,000

640,000

610,000

Selling Price ($/unit)

9.99

9.90

9.95

10.00

Variable Manufacturing Cost ($/unit)

4.92

4.90

5.00

4.95

Total Fixed Manufacturing Costs ($)

1,584,000

1,561,000

1,625,000

1,599,531

Variable Selling Cost ($/unit)

1.00

1.01

0.99

1.00

Total Fixed SG&A Costs ($)

350,000

353,000

352,850

348,000

Other information:

  • The manufacturer uses FIFO
  • The manufacturer uses Standard Costing

Required:

  1. Prepare an income statement for the Current Year based on Variable Costing.
  1. Prepare an income statement for the Current Year based on Absorption Costing.
  1. Reconcile the difference in Net Income between Variable Costing and Absorption Costing for the current year by comparing this difference in income to the differences in ending inventory for Absorption Costing and Variable Costing.

Solutions

Expert Solution

Given :

Actual unit sold in the prior year = 58000

Actual units manufactured in the prior year = 590000

Therefore, ending inventory during the prior period = 590000-580000 =10000

The ending inventory of the prior period will be the beginning inventory for the current period.

Therefore, beginning inventory for the current period = 10000

                                                                     Current year           current year

                                                                        budget                   actual

     

Beginning Inventory (Units)

?

10000

Sales (Units)

575,000

570,000

Manufactured (Units)

640,000

610,000

Selling Price ($/unit)

9.95

10.00

Variable Manufacturing Cost ($/unit)

5.00

4.95

Total Fixed Manufacturing Costs ($)

1,625,000

1,599,531

Variable Selling Cost ($/unit)

0.99

1.00

Total Fixed SG&A Costs ($)

352,850

348,000

1.) income statement for the Current Year based on Variable Costing:

particulars

amount

amount

Sales

5700000

Less Variable cost of goods sold

Opening inventory (10000x4.9)

49000

(+) VC of goods manufactured

3019500

VC of goods available for sale

3068500

(-)closing inventory (50000x4.95)

247500

Gross contribution margin

2821000

(-) variable selling cost

570000

Contribution margin

2251000

Less: period expenses

Fixed manufacturing expense

1599531

Fixed SG and A cost

348000

1947531

Net operating income

303469

income statement for the Current Year based on Absorption Costing.

particulars

amount

Amount

sales

5700000

Less cost of goods sold:

Opening inventory

75500

+ COGM

4619031

Cost of goods available for sale

4694531

- Closing inventory

378500

4316031

Gross profit

1383969

Less selling expenses

variable

570000

fixed

348000

Net operating income

465969

net income using absorption costing is greater than using variable costing by 162500 (465969-303469).

also, ending inventory using absorption costing is 378500 and using variable costing is 247500. this is because fixed manucaturing expense is added to ending inventory in absorption costing.


Related Solutions

Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory...
Given the following information: Prior Year (Budget and Actual) Current Year (Budget and Actual) Beginning Inventory (Units) 0 ? Sales (Units) 600,000 575,000 Manufactured (Units) 600,000 640,000 Selling Price ($/unit) 9.90 10.00 Variable Manufacturing Cost ($/unit) 4.80 5.00 Total Fixed Manufacturing Costs ($) 1,560,000 1,600,000 Variable Selling Cost ($/unit) 1.00 1.00 Total Fixed SG&A Costs ($) 351,000 358,000 Other information: The manufacturer uses FIFO. All Variable costs are direct costs Required: Prepare an income statement for the Current Year based...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in...
Below is the variance report Prior year Item Budget Actual Variance Variance % Actual Days in time period 31 31 31 Staffed Beds 20 20 20 Patient days 527 498 (29.0) -5.5% 415 Total RN FTEs 45.1 50.1 (5.0) -11.1% 36.7 Revenue: Gross patient revenue $460,450 $441.932 ($18,518) -4.0% $417,883 Personnel Expense: Total salaries and wages $171,920 $192,845 ($20,925) -12.2% $141,552 Benefits $51,576 $52,797 ($1,221) -2.4% $42,466 Total personnel expenses $223,496 $245,642 ($22,146) -9.9% $184,018 Overtime wages % 2.0% 6.1%...
XYZhas the following financial information: Current Year Prior Year # Units in Beginning Inventory ?            ...
XYZhas the following financial information: Current Year Prior Year # Units in Beginning Inventory ?                    0   # Units Sold        570,000         580,000 # Units Manufactured (Actual)        610,000         590,000 # Units Manufactured (Budget)        640,000         600,000 Selling Price (per unit)            10.00               9.90 Variable Manufacturing Costs (per unit)              5.00               4.80 Variable Sales+Admin Costs (per unit)              1.00               1.00 Fixed Manufacturing Costs (Budget and Actual) (total)     1,600,000      1,560,000 Fixed sales+admin costs...
YYZ has the following financial information: Current Year Prior Year # Units in Beginning Inventory ?...
YYZ has the following financial information: Current Year Prior Year # Units in Beginning Inventory ?                    0   # Units Sold        570,000         580,000 # Units Manufactured (Actual)        610,000         590,000 # Units Manufactured (Budget)        640,000         600,000 Selling Price (per unit)            10.00               9.90 Variable Manufacturing Costs (per unit)              5.00               4.80 Variable Sales+Admin Costs (per unit)              1.00               1.00 Fixed Manufacturing Costs (Budget and Actual) (total)     1,600,000      1,560,000 Fixed sales+admin...
I need to create a balance sheet with the following information Account Current Year Prior Year...
I need to create a balance sheet with the following information Account Current Year Prior Year Cash 3,422,928 3,773,862 Balance sheet Accrued compensation and related liabilities 4,248,791 2,656,831 Balance sheet Accounts and notes receivable 52,966,361 48,883,616 Balance sheet Prepaid expenses and other current assets 13,956 33,094 Balance sheet Inventory 1,461,138 1,397,898 Balance sheet Accounts payable 2,080,892 2,657,082 Balance sheet Payable to third­party payors 400,083 321,196 Balance sheet Notes and loans payable 5,142,900 Balance sheet Other deferred credits 40,598 Balance sheet...
. Ledger Properties has the following financial information: Current Year Prior Year Revenues $ 48,915 $...
. Ledger Properties has the following financial information: Current Year Prior Year Revenues $ 48,915 $ 43,610 Administrative expenses 12,106 11,602 Interest expense 816 468 Cost of goods sold 29,715 26,309 Depreciation 1,408 1,387 Net fixed assets 32,711 31,984 Current liabilities 14,652 14,625 Common stock 15,000 14,000 Current assets 16,506 14,687 Long-term debt 12,200 ? Retained earnings 7,365 4,246 Dividends paid 290 275 What is the cash flow of the firm for the current year if the tax rate is...
Given the information below, What is the total variance in the actual and static budget? DeFleur...
Given the information below, What is the total variance in the actual and static budget? DeFleur manufactures bicycles. The bicycles are manufactured in two divisions. In the framing division, the carbon bicycle frames are manufactured. In the assembly division, the components are assembled to the frame and the bike is ready for sale. There is no market for the unassembled frames and all manufactured frames are transferred to the assembly division. For the purposes of performance evaluation, the framing division...
5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915...
5) Ledger Properties has the following financial information:    Current Year Prior Year Revenues $ 48,915 $ 43,610 Administrative expenses 12,106    11,602 Interest expense    816 468 Cost of goods sold    29,715 26,309 Depreciation 1,408    1,387 Net fixed assets    32,711 31,984 Current liabilities    14,652    14,625 Common stock    15,000 14,000 Current assets 16,506    14,687 Long-term debt 12,200 ? Retained earnings 7,365 4,246 Dividends paid    290    275 What is the cash flow...
You are given the following static budget report: Budget            Actual              Variance Unit Sales  &nbsp
You are given the following static budget report: Budget            Actual              Variance Unit Sales                                           10,000               15,000             5,000 F Variable Expenses:     Commissions                                  $30,000 $33,000 $3,000 U     Advertising                                      $1,000 $1,200 $200 U     Travel                                              $10,000 $11,000 $1,000 U     Samples                                          $2,500 $2,300 $200 F Total Variable                                     $43,500 47,500 $4,000 U Fixed Expenses     Rent                                                 $5,000 $5,000 0     Salaries – Sales                               $2,000 $2,000 0     Salaries – Office                              $1,200 $1,200 0     Depreciation                                    $1,500 $1,500 0 Total Fixed                                          $9,700 $9,700             0 Total Expenses $53,200 $57,200 $4,000 U Prepare a flexible budget analysis and explain whether you believe that costs were controlled.  How do the results of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT