591 wk3 asg1

Week3WorkbookTemplate.xlsx

Home >Business & Finance homework help >Accounting homework help >591 wk3 asg1

Export Summary

This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
Numbers Sheet Name	Numbers Table Name	Excel Worksheet Name
Instructions
	Table 1	Instructions
E5.2
	Table 1	E5.2
E5.6
	Table 1	E5.6
P5.5A
	Table 1	P5.5A
P6.2A
	Table 1	P6.2A
P6.3A
	Table 1	P6.3A

Instructions

BUS591 Workbook Template

Tips for using the weekly workbook templates:

1) Locate the assigned exercises or problems at the end of the chapter reading in your textbook.

2) Download and save the workbook to your computer in a location where you will be able to easily find it and retrieve it.

3) The workbook has a separate tab designated for each exercise and problem. Be sure to complete all tabs each week.

4) Each tab is pre-designed to fit the assigned problem. This should save you some time in formatting and allow you to focus on mastering the learning objectives required to successfully complete each problem.

5) Remember that you can use the formula functions within Excel to simplify your computations and reduce opportunities for typographical errors.

6) After you have completed the assignment, save the document, and upload for grading.

*Note: Not all lines on the template will be used for every problem. The template is simply a guide to save you time in formatting. Feel free to modify, add lines, or delete lines as you feel appropriate for each problem.

&"Helvetica Neue,Regular"&12&K000000&P

E5.2

					Exercise 5.2
	Date	Account Titles	Debit	Credit
1	(a)
2	(1) Apr 5
3
4
5	(2) 6
6
7
8	(3) 7
9
10
11	(4) 8
12
13
14	(5) 15
15
16
17
18
19	(b)
20	May 4
21
22
23
24
25

&"Helvetica Neue,Regular"&12&K000000&P

E5.6

		Exercise 5.6
		Doqe Company
	DOQE COMPANY
	Income Statement (Partial)
	For the Year Ended October 31, 2017
1		1
2		2
3		3
4		4
5		5
6		6

&"Helvetica Neue,Regular"&12&K000000&P

P5.5A

		Problem 5.5A
		Simon Company
	SIMON COMPANY
	Income Statement
	For the Year Ended December 31, 2022
1		1
2		2
3		3
4		4
5		5
6		6
7		7
8		8
9		9
10		10
11		11
12		12
13		13
14		14
15		15
16		16
17		17
18		18
19		19
20		20
21		21
22		22
23		23
24		24
25		25
26		26
27		27
28		28
29		29
30		30

&"Helvetica Neue,Regular"&12&K000000&P

P6.2A

						Problem 6.2A
						Mullins Distribution
	(a)
	COST OF GOODS AVAILABLE FOR SALE
	Date	Explanation	Units	Unit Cost	Total Cost
1	March 1					1
2	5					2
3	13					3
4	21					4
5	26					5
6						6
7						7
8	(b)	FIFO				8
9	(1)	Ending Inventory				9
10	Date		Units	Unit Cost	Total Cost	10
11						11
12						12
13						13
14						14
15						15
16	(2)	Cost of Goods Sold				16
17						17
18						18
19						19
20						20
21						21
22		Proof of Cost of Goods Sold				22
23	Date		Units	Unit Cost	Total Cost	23
24						24
25						25
26						26
27						27
28						28
29						29
30						30
31						31
32						32
33						33
34						34
35						35
36						36
37						37
38						38
39						39
40						40
	(b) (Continued)
	LIFO
	(1)	Ending Inventory
	Date		Units	Unit Cost	Total Cost
1						1
2						2
3						3
4						4
5						5
6	(2)	Cost of Goods Sold				6
7						7
8						8
9						9
10						10
11						11
12	Proof of Cost of Goods Sold					12
13	Date		Units	Unit Cost	Total Cost	13
14						14
15						15
16						16
17						17
18						18
19						19
20						20
21	Average Cost					21
22	(1)	Ending Inventory				22
23	Average Cost Per Unit		Units	Unit Cost	Total Cost	23
24						24
25						25
26	(2)	Cost of Goods Sold				26
27						27
28						28
29						29
30						30
31						31
32	(c)					32
33	(1)					33
34						34
35						35
36	(2)					36
37						37
38						38
39						39
40						40

&"Helvetica Neue,Regular"&12&K000000&P

P6.3A

						Problem 6.3A
						Vista Company Inc.
	(a)
	COST OF GOODS AVAILABLE FOR SALE
	Date	Explanation	Units	Unit Cost	Total Cost
1	1/1					1
2	2/20					2
3	5/5					3
4	8/12					4
5	12/8					5
6						6
7						7
8	(b)	FIFO				8
9	(1)	Ending Inventory				9
10	Date		Units	Unit Cost	Total Cost	10
11						11
12						12
13						13
14						14
15						15
16	(2)	Cost of Goods Sold				16
17						17
18						18
19						19
20						20
21						21
22		Proof of Cost of Goods Sold				22
23	Date		Units	Unit Cost	Total Cost	23
24						24
25						25
26						26
27						27
28						28
29						29
30						30
31						31
32						32
33						33
34						34
35						35
36						36
37						37
38						38
39						39
40						40
	(b) (Continued)
	LIFO
	(1)	Ending Inventory
	Date		Units	Unit Cost	Total Cost
1						1
2						2
3						3
4						4
5						5
6	(2)	Cost of Goods Sold				6
7						7
8						8
9						9
10						10
11						11
12	Proof of Cost of Goods Sold					12
13	Date		Units	Unit Cost	Total Cost	13
14						14
15						15
16						16
17						17
18						18
19						19
20						20
21	Average Cost					21
22	(1)	Ending Inventory				22
23	Average Cost Per Unit		Units	Unit Cost	Total Cost	23
24						24
25						25
26	(2)	Cost of Goods Sold				26
27						27
28						28
29						29
30						30
31						31
32	Proof of Cost of Goods Sold					32
33						33
34						34
35	(c)					35
36						36
37						37
38						38
39						39
40						40

&"Helvetica Neue,Regular"&12&K000000&P