Question

In: Accounting

Xerbert Co Budgeted and Actual Income Statements For the year Ending December 31 (000s omitted) Budgeted...

Xerbert Co

Budgeted and Actual Income Statements

For the year Ending December 31

(000s omitted)

Budgeted

Actual

Xenox

Xeon

Total

Xenox

Xeon

Total

Units sales

150

100

250

130

130

260

Net Peso sales

P900

P1,000

P1,900

P780

P1,235

P2,015

Variable expenses

450

750

1,200

390

975

1,365

P450

P   250

P   700

P390

P    260

P 650

Fixed expenses

P   200

P   190

   Manufacturing

153

140

   Marketing

95

90

       Total fixed experience

P   448

P 420

Income before taxes

P   252

P   230

1. The percentage difference between the actual and budgeted breakeven point in units was that actual was

  1. 5.00 % above budget.
  2. 6.67 % below budget.
  3. 6.67 % above budget.
  4. 5.00 % below budget.                                                                                        

2. The budgeted total volume of 250,000 units was based upon Xerbert’s achieving a market share of 10%. Actual industry volume was 2,580,000 units. Xerbert increased volume owing to improved market share is

  1. 100%
  2. 80%
  3. 20%
  4. 4%                                                                                          

3. The variance of actual contribution margin from budgeted contribution margin attributed to sales price is

  1. P155,000unfavorable.
  2. P155,000favorable.
  3. P65,000favorable.
  4. P65,000unfavorable.                                                                                         

4. The variance of actual contribution margin from budgeted contribution margin attributed to unit variable cost changes is

  1. P165,000unfavorable.
  2. P137,000favorable.
  3. P165,000unfavorable.
  4. Zero because actual unit variable costs were the same as budgeted unit variable costs.

Solutions

Expert Solution

Q1

1. The percentage difference between the actual and budgeted breakeven point in units was that actual was

Option A : 5.00 % above budget.

Particulars Budget Actual
a Units 250 260
b Contribution 700 650
c Contribution per unit (b/a) 2.8 2.5
d Fixed Cost 448 420
e Breakeven In Units (d/c) 160 168
f Difference in break even point (Budgeted - Acutal) 8
g Difference in break even point in % (8/160) 5%

The budgeted total volume of 250,000 units was based upon Xerbert’s achieving a market share of 10%. Actual industry volume was 2,580,000 units. Xerbert increased volume owing to improved market share is

Option C -20%

Particulars Amount
a Actual Industry Volume 2580000
b Sale as per Industry Volume for Xerbert (10% of A) 258000
c Budgeted Total Volume 250000
d Actual Sale 260000
e Company Incresed Market Share (d-b) 2000
f Difference inActual Sale Vol and Budgeted (d-c) 10000
g Incresed % in Volume owing to Masket Share (e/f) 20%

3. The variance of actual contribution margin from budgeted contribution margin attributed to sales price is

Option D P65,000unfavorable.    

Particluars Xenon Xeon
a Budgeted Sales Price per unit 6 10
b Actual Sale Units 130 130
c Actual Sale Units * Budgeted Sales Price (a*b) 780 1300
d Total for Xenon Xeon (780+1300) 2080
e Actual Sales 2015
f Variance Unfavourable (d-e) 65

4. The variance of actual contribution margin from budgeted contribution margin attributed to unit variable cost changes is

Option D : Zero because actual unit variable costs were the same as budgeted unit variable costs.

Particluars Xenon Xeon
a Budgeted Total variable Cost 450 750
b Budgeted Vol 150 100
c Budgeted cost per unit (a/b) 3 7.5
d Actual Volume 130 130
e Acutal Variable Cost 390 975
f Acutal Variable Cost per unit (d/e) 3 7.5
Variance 0 0

Related Solutions

For the year ending December 31, Beard Clinical Supplies Co. mistakenly omitted adjusting entries for (1)...
For the year ending December 31, Beard Clinical Supplies Co. mistakenly omitted adjusting entries for (1) $7,090 of unearned revenue that was earned, (2) earned revenue that was not billed of $8,970, and (3) accrued wages of $7,220. Indicate the combined effect of the errors on (a) revenues, (b) expenses, and (c) net income. Choose understated or overstated and fill in the blank. a. Revenues were (understated/overstated) by $______ b. Expenses were (understated/overstated) by $______ c. Net income was (understated/overstated)...
Sand Technologies: Income Statements for Year Ending December 31            (in thousands)          ...
Sand Technologies: Income Statements for Year Ending December 31            (in thousands)           2019   2018   Sales               $945,000   $880,000   Expenses excluding depreciation and amortization   822,150   730,400   EBITDA               $122,850   $149,600   Depreciation and amortization       32,400   31,500   EBIT               $90,450   $118,100   Interest Expense           10,470   8,600   EBT               $79,980   $109,500   Taxes (40%)               31,992   43,800   Net income           $47,988   $65,700                         ...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)   2018   2017 Sales $7,800.0   $6,000.0 Operating costs excluding depreciation 5,850.0   5,100.0 Depreciation and amortization 216.0   180.0     Earnings before interest and taxes $1,734.0   $720.0 Less Interest 168.0   129.0     Pre-tax income $1,566.0   $591.0 Taxes (40%) 626.4   236.4 Net income available to common stockholders $939.6   $354.6 Common dividends $846.0   $284.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)   2018   2017 Assets Cash $90.0   $72.0 Short-term investments 39.0   30.0...
Rhodes Corporation’s financial statements are shown below. Rhodes Corporation: Income Statements for Year Ending December 31...
Rhodes Corporation’s financial statements are shown below. Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2020 2019 Sales $ 12,000 $ 11,000 Operating costs excluding depreciation 10,570 9,716 Depreciation and amortization 390 360     Earnings before interest and taxes $ 1,040 $ 924 Less interest 240 200     Pre-tax income $ 800 $ 724 Taxes (25%) 200 181 Net income available to common stockholders $ 600 $ 543 Common dividends $ 201 $ 200 Rhodes Corporation: Balance Sheets...
Following are two income statements for Alexis Co. for the year ended December 31. The left...
Following are two income statements for Alexis Co. for the year ended December 31. The left number column is prepared before any adjusting entries are recorded, and the right column includes the effects of adjusting entries. The company records cash receipts and payments related to unearned and prepaid items in balance sheet accounts. The middle column shows a blank space for each income statement effect of the eight adjusting entries a through g (the balance sheet part of the entries...
Following are two income statements for Alexis Co. for the year ended December 31. The left...
Following are two income statements for Alexis Co. for the year ended December 31. The left column is prepared before any adjusting entries are recorded, and the right column includes the effects of adjusting entries. The company records cash receipts and payments related to unearned and prepaid items in balance sheet accounts. ALEXIS CO. Income Statements For Year Ended December 31 Unadjusted Adjusted   Revenues      Fees earned $ 24,000 $ 30,000      Commissions earned 42,500 42,500      Total revenues 66,500 72,500   Expenses      Depreciation...
Following are two income statements for Alexis Co. for the year ended December 31. The left...
Following are two income statements for Alexis Co. for the year ended December 31. The left number column is prepared before any adjusting entries are recorded, and the right column includes the effects of adjusting entries. The company records cash receipts and payments related to unearned and prepaid items in balance sheet accounts. The middle column shows a blank space for each income statement effect of the eight adjusting entries a through g (the balance sheet part of the entries...
Following are two income statements for Alexis Co. for the year ended December 31. The left...
Following are two income statements for Alexis Co. for the year ended December 31. The left number column is prepared before any adjusting entries are recorded, and the right column includes the effects of adjusting entries. The company records cash receipts and payments related to unearned and prepaid items in balance sheet accounts. The middle column shows a blank space for each income statement effect of the eight adjusting entries a through g (the balance sheet part of the entries...
Following are the data for Larson Co. for the year ending December 31 Year 2, and...
Following are the data for Larson Co. for the year ending December 31 Year 2, and the preceding year ended December 31 Year 1 and the indirect method of reporting cash flows from operating activities. In addition to the balance sheet data, assume that: Equipment costing $125,000 was purchased for cash. Equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000. The stock was issued for cash. The only entries in the retained earnings account were net income...
Lan & Chen Technologies: Income Statements for Year Ending December 31 (Thousands of Dollars) 2010 2009...
Lan & Chen Technologies: Income Statements for Year Ending December 31 (Thousands of Dollars) 2010 2009 Sales $945,000 $900,000 Expenses excluding depreciation and amortization 812,700 774,000 EBITDA $132,300 $126,000 Depreciation and amortization 33,100 31,500 EBIT $99,200 $94,500 Interest Expense 10,470 8,600 EBT $88,730 $85,900 Taxes (40%) 35,492 34,360 Net income $53,238 $51,540 Common dividends $43,300 $41,230 Addition to retained earnings $9,938 $10,310 Lan & Chen Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2010 2009 Cash and cash equivalents...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT