Project 1 i A1 X A Saved fx Hayword, Inc. uses weighted-average costing and has two departments - mixing B C D E 1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: ts 5 Units in process 300 6 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% eBook 8 Cost in the beginning inventory: 9 Print Materials cost $10,500 10 Conversion cost $6,750 References 11 Units started into production during the period 6,200 12 Costs added to production during the period: 13 Materials cost $330,912 14 Conversion cost $406,408 15 Work in process, July 31: 16 Units in process 450 17 Percent completed with respect to materials 40% 18 Percent completed with respect to conversion 30% 19 Mc Graw Hill 20 Use the data to answer the following. 21 Type here to search F2 F3 F4 $ 94 #3 W E R D F F5 F6 F7 Prev 1 of 1 Next F8 蚵 85 % & 6 7 29 T Y U כ DELL 81°F Windy COUNT THE HAPE F9 F10 F11 F12 PrtScr Insert Delete * 00 8 9 G H J K C V B N Σ L P - Backs ان roject 1 i 40 Cost per equivalent unit Saved Total 41 42 3. Assign costs. 43 44 Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out 45 Materials Conversion 46 Ending work in process inventory: 47 Equivalent units of production S 48 Cost per equivalent unit 49 Cost of ending work in process inventory eBook 50 51 Units completed and transferred out: Print 52 References 53 Units transferred to the next department Cost per equivalent unit 54 Cost of units transferred out 55 Mc 56 4. Prepare reconciliation. READY Attempt(s) Graw Hill Type here to search Sheet1 *** F2 F3 F4 F5 K # 2 3 $ 4 % 85 F6 F7 6 W E R T Y + 100% Hint Prev 1 of 1 Next 81°F Windy DELL F8 F9 F10 & 7 8 * 00 כ ( 9 F11 く COUNT THE HAPE F12 PrtScr T Insert Delete + - Backs O P B 1 S D F G H J K L X C V B N Σ L نانا

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

please excel formulas..

Project 1 i
A1
X
A
Saved
fx Hayword, Inc. uses weighted-average costing and has two departments - mixing
B
C
D
E
1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging.
2 The following information relates to work in the mixing department for the month of July:
3
4 Work in process, July 1:
ts
5
Units in process
300
6
Percent completed with respect to materials
60%
7
Percent completed with respect to conversion
40%
eBook
8
Cost in the beginning inventory:
9
Print
Materials cost
$10,500
10
Conversion cost
$6,750
References
11 Units started into production during the period
6,200
12 Costs added to production during the period:
13
Materials cost
$330,912
14
Conversion cost
$406,408
15 Work in process, July 31:
16
Units in process
450
17
Percent completed with respect to materials
40%
18
Percent completed with respect to conversion
30%
19
Mc
Graw
Hill
20 Use the data to answer the following.
21
Type here to search
F2
F3
F4
$
94
#3
W
E
R
D
F
F5
F6
F7
Prev
1 of 1
Next
F8
蚵
85
%
&
6
7
29
T
Y
U
כ
DELL
81°F Windy
COUNT THE HAPE
F9
F10
F11
F12
PrtScr
Insert
Delete
* 00
8
9
G
H
J
K
C
V
B
N
Σ
L
P
-
Backs
ان
Transcribed Image Text:Project 1 i A1 X A Saved fx Hayword, Inc. uses weighted-average costing and has two departments - mixing B C D E 1 Hayword, Inc. uses weighted-average costing and has two departments - mixing and packaging. 2 The following information relates to work in the mixing department for the month of July: 3 4 Work in process, July 1: ts 5 Units in process 300 6 Percent completed with respect to materials 60% 7 Percent completed with respect to conversion 40% eBook 8 Cost in the beginning inventory: 9 Print Materials cost $10,500 10 Conversion cost $6,750 References 11 Units started into production during the period 6,200 12 Costs added to production during the period: 13 Materials cost $330,912 14 Conversion cost $406,408 15 Work in process, July 31: 16 Units in process 450 17 Percent completed with respect to materials 40% 18 Percent completed with respect to conversion 30% 19 Mc Graw Hill 20 Use the data to answer the following. 21 Type here to search F2 F3 F4 $ 94 #3 W E R D F F5 F6 F7 Prev 1 of 1 Next F8 蚵 85 % & 6 7 29 T Y U כ DELL 81°F Windy COUNT THE HAPE F9 F10 F11 F12 PrtScr Insert Delete * 00 8 9 G H J K C V B N Σ L P - Backs ان
roject 1 i
40 Cost per equivalent unit
Saved
Total
41
42 3. Assign costs.
43
44
Mixing Department
Costs of Ending Work in Process Inventory and the Units Transferred Out
45
Materials
Conversion
46 Ending work in process inventory:
47 Equivalent units of production
S
48
Cost per equivalent unit
49
Cost of ending work in process inventory
eBook
50
51 Units completed and transferred out:
Print
52
References
53
Units transferred to the next department
Cost per equivalent unit
54
Cost of units transferred out
55
Mc
56 4. Prepare reconciliation.
READY
Attempt(s)
Graw
Hill
Type here to search
Sheet1
***
F2
F3
F4
F5
K
#
2
3
$ 4
%
85
F6
F7
6
W
E
R
T
Y
+ 100%
Hint
Prev
1 of 1
Next
81°F Windy
DELL
F8
F9
F10
&
7
8
* 00
כ
(
9
F11
く
COUNT THE HAPE
F12
PrtScr
T
Insert
Delete
+
-
Backs
O
P
B
1
S
D
F
G
H
J
K
L
X
C
V
B
N
Σ
L
نانا
Transcribed Image Text:roject 1 i 40 Cost per equivalent unit Saved Total 41 42 3. Assign costs. 43 44 Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out 45 Materials Conversion 46 Ending work in process inventory: 47 Equivalent units of production S 48 Cost per equivalent unit 49 Cost of ending work in process inventory eBook 50 51 Units completed and transferred out: Print 52 References 53 Units transferred to the next department Cost per equivalent unit 54 Cost of units transferred out 55 Mc 56 4. Prepare reconciliation. READY Attempt(s) Graw Hill Type here to search Sheet1 *** F2 F3 F4 F5 K # 2 3 $ 4 % 85 F6 F7 6 W E R T Y + 100% Hint Prev 1 of 1 Next 81°F Windy DELL F8 F9 F10 & 7 8 * 00 כ ( 9 F11 く COUNT THE HAPE F12 PrtScr T Insert Delete + - Backs O P B 1 S D F G H J K L X C V B N Σ L نانا
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education