Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

eBook Show Me How Periodic Inventory by Three Methods Dymac Appliances inventory

ID: 2545483 • Letter: E

Question

eBook Show Me How Periodic Inventory by Three Methods Dymac Appliances inventory count at December 31 are summarized as follows uses the periodic inventory system. Detalls regarding the Inventory of appliances at Janusry 1, purchases invoices during the next 12 months, and the Inventory, anuary 1 Model A10 815 E60 G83 134 M90 Q70 Required: Inventory Count, December 31 1st 2nd 3rd 4 at $40 4at 43 4 at $46 B at $95 4at 86 3at 92 6t 99 3 at 75 3 at 65 5at 68 9at 70 7 at 230 6at 238 at 248 10 at 247 12 at 85 10 at 87 16 at 94 16 at 9 2 at 124 2at 126 3 at 144 3 at 146 5 at 164 4at 174 4at 179 7at 184 13

Explanation / Answer

Answer

Inventory will be valued at latest invoices price

Quantity

Unit cost ($)

Total cost ($)

A10

4

46

184

A10

1

43

43

B15

6

99

594

B15

1

92

92

E60

5

70

350

G83

9

247

2223

J34

13

95

1235

M90

3

146

438

M90

2

144

288

Q70

7

184

1288

Q70

1

179

179

Total

52

$6914

Inventory will be valued from earliest purchase (or beginning inventory)

Quantity

Unit cost

Total cost

A10

4

40

160

A10

1

43

43

B15

7

95

665

E60

3

75

225

E60

2

65

130

G83

7

230

1610

G83

2

238

476

J34

12

85

1020

J34

1

87

87

M90

2

124

248

M90

2

126

252

M90

1

144

144

Q70

5

164

820

Q70

3

174

522

Total

52

$6402

Working for Average price

Inventory jan 1

1st Invoice Value

2nd Invoice Value

3rd Invoice Value

Total value ($)

Total Units

Average cost ($)

A10

160

172

184

516

12

43

B15

760

344

276

594

1974

21

94

E60

225

195

1020

630

2070

30

69

G83

1610

1428

1240

2470

6748

28

241

J34

1020

870

1504

1520

4914

54

91

M90

248

252

432

438

1370

10

137

Q70

820

696

716

1288

3520

20

176

Answer

Quantity

Unit cost (calculated above)

Total cost $

A10

5

43

215

B15

7

94

658

E60

5

69

345

G83

9

241

2169

J34

13

91

1183

M90

5

137

685

Q70

8

176

1408

Total

52

$6663

Quantity

Unit cost ($)

Total cost ($)

A10

4

46

184

A10

1

43

43

B15

6

99

594

B15

1

92

92

E60

5

70

350

G83

9

247

2223

J34

13

95

1235

M90

3

146

438

M90

2

144

288

Q70

7

184

1288

Q70

1

179

179

Total

52

$6914