Inventory valuation under absorption costing and variable costing At the end of the first year of operations, 19,400 units remained in the finished goods inventory. The unit manufacturing costs during the year were as follows: Direct materials $21 Direct labor 25 Fixed factory overhead 17 Variable factory overhead 13 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the cost of the finished goods inventory reported on the balance sheet under (a) the absorption costing concept and (b) the variable costing concept. a. Cost of the finished goods inventory under the absorption costing: b. Cost of the finished goods inventory under the variable costing:

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter3: Setting Up A New Company
Section: Chapter Questions
Problem 3.4C
icon
Related questions
Question

At the end of the first year of operations, 19,400 units remained in the finished goods inventory. The unit manufacturing costs during the year were as follows:

Direct materials $21  
Direct labor 25  
Fixed factory overhead 17  
Variable factory overhead 13  

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

 

O Chapter 21 Homework
X : CengageNOWv2 | Online teach x
O Excel Online Student Work
x b Inventory valuation under abso x
+
+ → C O about:blank
Excel
template - Saved
Simplified Ribbon
File
Home
Insert
Formulas
Data
Review
View
Help
Tell me what you want to do
A Editing v
O Comments
Arial
В
A v
Ev ab E Merge v
Currency
.00
.0
...
...
.00
C15
fx
A
E
F
H
I
1
Inventory valuation under absorption costing and variable costing
2
At the end of the first year of operations, the number of units and the unit manufacturing costs were as follows:
3
4
5
DATA
6 Units in the finished goods inventory
19,400
$21
7
Direct materials
8
Direct labor
25
9 Fixed factory overhead
10 Variable factory overhead
17
13
11
Using formulas and cell references, perform the required analysis, and input your answers into the Cost of Finished Goods column. Transfer the numeric
12 results for the green entry cells (C15:C16) into the appropriate fields in CNOWV2 for grading.
13
14
Cost of Finished Goods
Formulas
15 a. Absorption costing
16 b. Variable costing
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
A Data
Calculation Mode: Automatic
Workbook Statistics
Give Feedback to Microsoft
- 100% +E
Transcribed Image Text:O Chapter 21 Homework X : CengageNOWv2 | Online teach x O Excel Online Student Work x b Inventory valuation under abso x + + → C O about:blank Excel template - Saved Simplified Ribbon File Home Insert Formulas Data Review View Help Tell me what you want to do A Editing v O Comments Arial В A v Ev ab E Merge v Currency .00 .0 ... ... .00 C15 fx A E F H I 1 Inventory valuation under absorption costing and variable costing 2 At the end of the first year of operations, the number of units and the unit manufacturing costs were as follows: 3 4 5 DATA 6 Units in the finished goods inventory 19,400 $21 7 Direct materials 8 Direct labor 25 9 Fixed factory overhead 10 Variable factory overhead 17 13 11 Using formulas and cell references, perform the required analysis, and input your answers into the Cost of Finished Goods column. Transfer the numeric 12 results for the green entry cells (C15:C16) into the appropriate fields in CNOWV2 for grading. 13 14 Cost of Finished Goods Formulas 15 a. Absorption costing 16 b. Variable costing 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 A Data Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 100% +E
O Chapter 21 Homework
* CengageNowv2 | Online teach x
b Inventory valuation under abso x
+
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Chapter 21 Homework
Show Me How
O Office 365
еВook
Print Item
1. EX.21.08.ALGO
Inventory valuation under absorption costing and variable costing
At the end of the first year of operations, 19,400 units remained in the finished goods inventory. The unit manufacturing costs during the year were as follows:
2. PR.21.01A.BLANKSHEET.A...
Direct materials
$21
3. EX.21-01.EXCEL.ALGO
Direct labor
25
Fixed factory overhead
17
4. EX.21-02.EXCEL.ALGO
Variable factory overhead
13
5. EX.21-03.EXCEL.ALGO
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.
6. BE.21.01
7. BE.21.01.ALGO
Open spreadsheet
8. BE.21.02
Determine the cost of the finished goods inventory reported on the balance sheet under (a) the absorption costing concept and (b) the variable costing concept.
9. BE.21.03
a. Cost of the finished goods inventory under the absorption costing:
b. Cost of the finished goods inventory under the variable costing:
10. BE.21.04.ALGO
Check My Work
Previous
Next
Progress: 3/10 items
Assignment Score: 1.72%
All work saved.
Email Instructor
Save and Exit
Submit Assignment for Grading
Transcribed Image Text:O Chapter 21 Homework * CengageNowv2 | Online teach x b Inventory valuation under abso x + A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false Chapter 21 Homework Show Me How O Office 365 еВook Print Item 1. EX.21.08.ALGO Inventory valuation under absorption costing and variable costing At the end of the first year of operations, 19,400 units remained in the finished goods inventory. The unit manufacturing costs during the year were as follows: 2. PR.21.01A.BLANKSHEET.A... Direct materials $21 3. EX.21-01.EXCEL.ALGO Direct labor 25 Fixed factory overhead 17 4. EX.21-02.EXCEL.ALGO Variable factory overhead 13 5. EX.21-03.EXCEL.ALGO This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. 6. BE.21.01 7. BE.21.01.ALGO Open spreadsheet 8. BE.21.02 Determine the cost of the finished goods inventory reported on the balance sheet under (a) the absorption costing concept and (b) the variable costing concept. 9. BE.21.03 a. Cost of the finished goods inventory under the absorption costing: b. Cost of the finished goods inventory under the variable costing: 10. BE.21.04.ALGO Check My Work Previous Next Progress: 3/10 items Assignment Score: 1.72% All work saved. Email Instructor Save and Exit Submit Assignment for Grading
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning