ject 1 i 20 Use the data to answer the following. 21 22 1. Compute equivalent units. 23 24 25 Saved He Mixing Department Equivalent Units of Production Materials Conversion 26 Units transferred to the next department 27 Ending work in process: 28 Materials 29 Conversion eBook 30 Equivalent units of production 31 Print 32 2. Compute cost per equivalent unit. References 33 Mixing Department 34 Cost per Equivalent Unit 35 Materials Conversion 36 Cost of beginning work in process Sheet1 ... Mc READY Attempt(s) Graw Hill Type here to search F2 F3 F4 3 #m 2 K F5 F6 54 $ 5 dos % 圓 + + 100% Hint Prev 1 of 1 Next O F7 F8 & 蚵 DELL F9 0 6 7 8 * 00 W E R T Y U כ F10 F11 F12 ( 9 O S D F G H J K L X C V B N M P 81°F Windy ^ COUNT THE HAPPIE PrtScr Insert Delete Alt Ctri + ? " Backspa 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 ان

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

please provide excel formulas.....

ject 1 i
20 Use the data to answer the following.
21
22 1. Compute equivalent units.
23
24
25
Saved
He
Mixing Department
Equivalent Units of Production
Materials
Conversion
26 Units transferred to the next department
27 Ending work in process:
28 Materials
29
Conversion
eBook
30 Equivalent units of production
31
Print
32 2. Compute cost per equivalent unit.
References
33
Mixing Department
34
Cost per Equivalent Unit
35
Materials
Conversion
36 Cost of beginning work in process
Sheet1
...
Mc
READY
Attempt(s)
Graw
Hill
Type here to search
F2
F3
F4
3
#m
2
K
F5
F6
54
$
5
dos
%
圓
+
+
100%
Hint
Prev
1 of 1
Next
O
F7
F8
&
蚵
DELL
F9
0
6
7
8
* 00
W
E
R
T
Y
U
כ
F10
F11
F12
(
9
O
S
D
F
G
H
J
K
L
X
C
V
B
N
M
P
81°F Windy ^
COUNT THE HAPPIE
PrtScr
Insert
Delete
Alt
Ctri
+
?
"
Backspa
Transcribed Image Text:ject 1 i 20 Use the data to answer the following. 21 22 1. Compute equivalent units. 23 24 25 Saved He Mixing Department Equivalent Units of Production Materials Conversion 26 Units transferred to the next department 27 Ending work in process: 28 Materials 29 Conversion eBook 30 Equivalent units of production 31 Print 32 2. Compute cost per equivalent unit. References 33 Mixing Department 34 Cost per Equivalent Unit 35 Materials Conversion 36 Cost of beginning work in process Sheet1 ... Mc READY Attempt(s) Graw Hill Type here to search F2 F3 F4 3 #m 2 K F5 F6 54 $ 5 dos % 圓 + + 100% Hint Prev 1 of 1 Next O F7 F8 & 蚵 DELL F9 0 6 7 8 * 00 W E R T Y U כ F10 F11 F12 ( 9 O S D F G H J K L X C V B N M P 81°F Windy ^ COUNT THE HAPPIE PrtScr Insert Delete Alt Ctri + ? " Backspa
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 ان
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
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