ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
AI-Driven Excel Assignment: Inventory
2
Freshman Accounting | Use this workbook with Excel and an approved AI assistant
3
4
PurposeApply inventory cost-flow assumptions under periodic and perpetual inventory systems, calculate cost of goods sold (COGS) and ending inventory, and use AI critically.
5
Business scenarioCampus Gear sells one type of reusable water bottle. The company uses a perpetual inventory record for day-to-day tracking but also prepares periodic inventory calculations for comparison.
6
Important assumptions
Ignore sales tax, freight, purchase returns, discounts, and shrinkage. All sales are for cash. Assume no inventory shortages. Round unit costs and dollar amounts to 2 decimal places.
7
Required cost-flow methods
FIFO and weighted-average cost. Under periodic inventory, calculate one weighted-average unit cost for the period. Under perpetual inventory, use a moving-average unit cost recalculated after each purchase.
8
How to use AIUse an AI assistant to explain the accounting logic, propose Excel formulas, debug errors, and check your interpretation. Do not simply paste an AI answer. You must verify formulas and explain at least two checks.
9
Academic integritySubmit your AI prompt log and identify any AI-generated formula or explanation you changed. You are responsible for the accuracy of the workbook.
10
Workbook mapTransactions contains the source data. Periodic and Perpetual are calculation workspaces. Summary compares results. AI Log records your AI use.
11
SubmissionSubmit this completed workbook plus a short written response (approximately 300–400 words) answering the questions in the assignment brief.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100