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 ان Project 1 28 Materials 29 Conversion 30 Equivalent units of production 31 32 2. Compute cost per equivalent unit. 33 34 35 nts Saved Mixing Department Cost per Equivalent Unit Materials Conversion eBook Print 36 Cost of beginning work in process 37 Cost added during the period 38 Total cost 39 Equivalent units of production 40 Cost per equivalent unit References 41 42 3. Assign costs. 43 44 READY Attempt(s) Mc Graw Hill Type here to search Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Sheet1 F2 F3 F4 F5 F6 K 2 % 8°5 $ 4 #3 96 B ++ 100% Hint Prey 1 of 1 Next F7 F8 W E R T Y S D F G & 29 7 H DELL 81°F Windy COUNT THE HAPP F9 F10 F11 F12 PrtScr Insert Delete 蚵 כ X C V B N * 00 8 9 O J K L Σ P Backsp ـان ?

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 provide 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 ان
Project 1
28 Materials
29 Conversion
30 Equivalent units of production
31
32 2. Compute cost per equivalent unit.
33
34
35
nts
Saved
Mixing Department
Cost per Equivalent Unit
Materials
Conversion
eBook
Print
36 Cost of beginning work in process
37 Cost added during the period
38 Total cost
39 Equivalent units of production
40 Cost per equivalent unit
References
41
42 3. Assign costs.
43
44
READY
Attempt(s)
Mc
Graw
Hill
Type here to search
Mixing Department
Costs of Ending Work in Process Inventory and the Units Transferred Out
Sheet1
F2
F3
F4
F5
F6
K
2
%
8°5
$ 4
#3
96
B
++ 100%
Hint
Prey
1 of 1
Next
F7
F8
W
E
R
T
Y
S
D
F
G
&
29
7
H
DELL
81°F Windy
COUNT THE HAPP
F9
F10
F11
F12
PrtScr
Insert
Delete
蚵
כ
X
C
V
B
N
* 00
8
9
O
J
K
L
Σ
P
Backsp
ـان
?
Transcribed Image Text:Project 1 28 Materials 29 Conversion 30 Equivalent units of production 31 32 2. Compute cost per equivalent unit. 33 34 35 nts Saved Mixing Department Cost per Equivalent Unit Materials Conversion eBook Print 36 Cost of beginning work in process 37 Cost added during the period 38 Total cost 39 Equivalent units of production 40 Cost per equivalent unit References 41 42 3. Assign costs. 43 44 READY Attempt(s) Mc Graw Hill Type here to search Mixing Department Costs of Ending Work in Process Inventory and the Units Transferred Out Sheet1 F2 F3 F4 F5 F6 K 2 % 8°5 $ 4 #3 96 B ++ 100% Hint Prey 1 of 1 Next F7 F8 W E R T Y S D F G & 29 7 H DELL 81°F Windy COUNT THE HAPP F9 F10 F11 F12 PrtScr Insert Delete 蚵 כ X C V B N * 00 8 9 O J K L Σ P Backsp ـان ?
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