Question
In: Accounting
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet so that it looks like this:
|
A B C |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
|
(b) What is the net operating income (loss) in Year 2 under absorption costing?
Solutions
Expert Solution
The net operating income (loss) for Year 2 under absorption costing :-
| Particulars | Amount($) | Amount($) |
| A.Revenue (Units Sold* Selling Price):(2400*$334) | 801600 | |
| Less: Cost of Sales | ||
| Opening Inventory (Units * Full cost) (200*$267) [see note1,2&3] | 53400 | |
| Direct Material (Produced Units * Direct Material cost per unit):(2300*$135) | 310500 | |
| Direct Labor (Produced Units * Direct Lobor cost per unit) : (2300*$54) | 124200 | |
| Variable Manufacturing Overhead (Produced Units * Variable Manufacturing overhead per unit) : (2300*$26) | 59800 | |
| Fixed Manufacturing Overhead (Produced Units * Fixed Manufacturing overhead per unit) : (2300*$52) [ see note 3] | 119600 | |
| less: Closing Inventory (Units * Full cost) (100*$267) [see note1,2&3] | (26700) | |
| B.Cost of Sales | 640800 | |
| C. Gorss Profit (A-B) | 160800 | |
| D.Add/(less): Over/(Under) Absorption [see note 4] | 0 | |
| E.Less: Selling & Adminstrative Expenses | ||
| Variable (Units sold * variable per unit ) (2400*$4) | 9600 | |
| Fixed per year | 58000 | 67600 |
| F. Net Operation Income as per Absorption Costing (C-D-E) | 93200 |
Notes:
1. Calculation of Opening & Closing Inventory for the 2nd Year:
| Particulars | Year 1(units) | Year 2 (units) |
| Opening Inventory |
0 |
200 |
| Add:Produced Units | 2600 | 2300 |
| Less: Sold Units | 2400 | 2400 |
| Closing Inventory | 200 | 100 |
2. Full Cost per unit:
| Particulars | Amount($) per unit |
| Direct Material | 135 |
| Direct labor | 54 |
| Variable Manufacturing Overhead | 26 |
| Fixed Manufacturing Overhead (see note 3) | 52 |
| Full Cost | 267 |
3. Fixed Manufacturing Overhead per unit =Budgeted Fixed overhead/Budgeted Units
=$119600/2300
=$52
(Budgeted data is not given therefore, actual figures are used)
4. Over /(under) Absorption=Absorbed fixed overhead- Actual Fixed overhead
=119600-119600
=0
ekkarill92 answered 1 year agoRelated Solutions
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet
so that it looks like this:
A
B
C
1
2
3
4
5
6
7
Chapter 5: Applying Excel
Data
Unit sales
30,000
units
Selling price per unit
$30
per unit
Variable expenses per unit
$18
per unit
Fixed expenses
$288,000
If your formulas are correct, you should get the correct answers
to the following questions.
(a) What is the break-even in dollar sales?
(b) What...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet
so that it looks like this: If your formulas are correct, you
should get the correct answers to the following questions.
A
B
C
D
1
Chapter 5: Applying Excel
2
3
Data
4
Unit sales
80,000
units
5
Selling price per unit
$20
per unit
6
Variable expenses per unit
$14
per unit
7
Fixed expenses
$384,000
8
(a) What is the break-even in dollar sales?...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet
so that it looks like this:
A
B
C
D
1
Chapter 3: Applying Excel
2
3
Data
4
Unit sales
30,000
units
5
Selling price per unit
$50
per unit
6
Variable expenses per unit
$20
per unit
7
Fixed expenses
$720,000
8
If your formulas are correct, you should get the correct answers
to the following questions.
(a) What is the break-even in dollar sales?...
2. Change all of the numbers in the data area of your worksheet so that it...
2.
Change all of the numbers in the data area of your worksheet so
that it looks like this:
3
Data
4
Selling price per unit
$374
5
Manufacturing costs:
6
Variable per unit produced:
7
Direct materials
$152
8
Direct labor
$58
9
Variable manufacturing overhead
$38
10
Fixed manufacturing overhead per year
$166,400
11
Selling and administrative expenses:
12
Variable per unit sold
$4
13
Fixed per year
$98,000
14
15
Year 1
Year 2
16
Units in...
2. Change all of the numbers in the data area of your worksheet so that it...
2.
Change all of the numbers in the data area of your worksheet so
that it looks like this:
3
Data
4
Selling price per unit
$374
5
Manufacturing costs:
6
Variable per unit
produced:
7
Direct
materials
$152
8
Direct
labor
$58
9
Variable manufacturing overhead
$38
10
Fixed
manufacturing overhead per year
$166,400
11
Selling and administrative
expenses:
12
Variable per unit
sold
$4
13
Fixed per
year
$98,000
14
15
Year 1
Year 2
16
Units in...
2. Change all of the numbers in the data area of your worksheet so that it...
2. Change all of the numbers in the data area of your worksheet
so that it looks like this:
A
B
C
1
2
3
4
5
6
7
Chapter 5: Applying Excel
Data
Unit sales
50,000
units
Selling price per unit
$20
per unit
Variable expenses per unit
$14
per unit
Fixed expenses
$270,000
If your formulas are correct, you should get the correct answers
to the following questions.
(a) What is the break-even in dollar sales?
(b) What...
1. Change all of the numbers in the data area of your worksheet so that it...
1. Change all of the numbers in the data area of your worksheet so
that it looks like this:
Data
Selling price per unit
$292
Manufacturing costs:
Variable per unit produced:
Direct materials
$125
Direct labor
$55
Variable manufacturing overhead
$23
Fixed manufacturing overhead per year
$172,800
Selling and administrative expenses:
Variable per unit sold
$7
Fixed per year
$74,000
Year 1
Year 2
Units in beginning inventory
0
Units produced during the year
3,200
2,700
Units sold during the...
The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following
A
B
C
1
2
3
4
5
6
7
8
9
10
11
12
13
Chapter 7: Applying Excel
Data
Example E
Cost of equipment needed
$360,000
Working capital needed
$30,000
Overhaul of equipment in four years
$25,000
Salvage value of the equipment in five years
$30,000
Annual revenues and costs:
Sales revenues
$430,000
Cost of goods sold
$245,000
Out-of-pocket operating costs...
Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in Exhibit 1–7.
This Excel worksheet form is to be used to recreate Exhibit 1–7. The workbook, and instructions on how to complete the file, can be found in Connect.
Required:
1. Check your worksheet by changing the variable selling cost in the Data area to $900, keeping all of the other data the same as in Exhibit 1–7. If your worksheet is operating properly, the net operating income under the traditional format income statement and under the contribution format income statement should...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period...
Requirement 2:
Revise the data in your worksheet to reflect the results for the
subsequent period as shown below:
A
B
C
D
E
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Chapter 9: Applying Excel
Data
Revenue
$16.50
q
Cost of ingredients
$6.25
q
Wages and salaries
$10,400
Utilities
$800
+
$0.20
q
Rent
$2,200
Miscellaneous
$600
+
$0.80
q
Actual results:
Revenue
$29,730
Cost of ingredients...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Using the following reduction potentials: I2(s) + 2e- <---> 2I-(aq) E0 = 0.535 V I2 (aq)...
- Why are learnability and critical thinking crucial skills for the 21stcentury? And, how can you improve...
- Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff,...
- LUVE produces bracelets. Each band generates $460 in revenue and requires one ounce of gold as...
- (The following data apply to the next three questions.) Assume the following cost and revenue data...
- C# programming Create a classes called AlphabetDice that simulates a multi-sided dices with alphabet characters on...
- What are the trends in Distributed Systems?
ADVERTISEMENT