ACCT 402 - Inventory System Question Bank
Question 1
Problem: Liberty University’s bookstore is preparing for the upcoming semester.
The manager needs to determine the quantity of textbooks to order for a new
course. They expect to sell 250 books during the semester and want to main-
tain a safety stock of 30 books to avoid stockouts. The lead time for textbook
delivery from the supplier is 2 weeks. Calculate the order size for the textbooks
given the sales forecast and the safety stock requirement.
Solution:
Step 1: Understand the variables given in the problem. - Expected sales =
250 books - Safety stock = 30 books
Step 2: Determine the order size. The basic formula to calculate the order
size when you take into account safety stock is:
Order Size = Expected Sales + Safety Stock
Step 3: Plug in the values and calculate.
Order Size = 250 + 30 = 280 books
Thus, the manager should order 280 textbooks for the semester.
Step 4: Consider lead time (if required in further decisions). Lead time is
2 weeks, so orders should be placed at least 2 weeks before the start of the
semester to ensure the books are available on time.
Step 5: Conclusion. To ensure they meet demand and maintain the required
safety stock, the bookstore manager should order 280 textbooks for the upcom-
ing course. Ensure the order is placed far enough in advance to account for
the 2-week delivery lead time. Question 1: Basic Concepts of Inventory
Management
Problem: Liberty University’s bookstore is preparing for the up-
coming semester. The manager needs to determine the quantity of
textbooks to order for a new course. They expect to sell 250 books
during the semester and want to maintain a safety stock of 30 books
to avoid stockouts. The lead time for textbook delivery from the
supplier is 2 weeks. Calculate the order size for the textbooks given
the sales forecast and the safety stock requirement.
Solution:
1
Step 1: Understand the variables given in the problem. - Expected
sales = 250 books - Safety stock = 30 books
Step 2: Determine the order size. The basic formula to calculate
the order size when you take into account safety stock is:
Order Size =Expected Sales +Safety Stock
Step 3: Plug in the values and calculate.
Order Size = 250 + 30 = 280 books
Thus, the manager should order 280 textbooks for the semester.
Step 4: Consider lead time (if required in further decisions). Lead
time is 2 weeks, so orders should be placed at least 2 weeks before
the start of the semester to ensure the books are available on time.
Step 5: Conclusion. To ensure they meet demand and maintain
the required safety stock, the bookstore manager should order 280
textbooks for the upcoming course. Ensure the order is placed far
enough in advance to account for the 2-week delivery lead time.
Question 2
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
2
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 2: Inventory Cost Calculation for Liberty University Book-
store
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
3
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 3
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
4
Conclusion:
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 3: Calculate Ending Inventory and Cost of Goods Sold
(COGS)
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
Conclusion:
5
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 4
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method. Question 4: Calculating Ending Inventory and
Cost of Goods Sold (COGS) Using FIFO Method
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
6
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method.
Question 5
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
7
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.Question
5: Calculating Ending Inventory and Cost of Goods Sold
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
8
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.
9
Step 1: Understand the variables given in the problem. - Expected
sales = 250 books - Safety stock = 30 books
Step 2: Determine the order size. The basic formula to calculate
the order size when you take into account safety stock is:
Order Size =Expected Sales +Safety Stock
Step 3: Plug in the values and calculate.
Order Size = 250 + 30 = 280 books
Thus, the manager should order 280 textbooks for the semester.
Step 4: Consider lead time (if required in further decisions). Lead
time is 2 weeks, so orders should be placed at least 2 weeks before
the start of the semester to ensure the books are available on time.
Step 5: Conclusion. To ensure they meet demand and maintain
the required safety stock, the bookstore manager should order 280
textbooks for the upcoming course. Ensure the order is placed far
enough in advance to account for the 2-week delivery lead time.
Question 2
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
2
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 2: Inventory Cost Calculation for Liberty University Book-
store
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
3
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 3
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
4
Conclusion:
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 3: Calculate Ending Inventory and Cost of Goods Sold
(COGS)
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
Conclusion:
5
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 4
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method. Question 4: Calculating Ending Inventory and
Cost of Goods Sold (COGS) Using FIFO Method
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
6
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method.
Question 5
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
7
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.Question
5: Calculating Ending Inventory and Cost of Goods Sold
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
8
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.
9
Step 1: Understand the variables given in the problem. - Expected
sales = 250 books - Safety stock = 30 books
Step 2: Determine the order size. The basic formula to calculate
the order size when you take into account safety stock is:
Order Size =Expected Sales +Safety Stock
Step 3: Plug in the values and calculate.
Order Size = 250 + 30 = 280 books
Thus, the manager should order 280 textbooks for the semester.
Step 4: Consider lead time (if required in further decisions). Lead
time is 2 weeks, so orders should be placed at least 2 weeks before
the start of the semester to ensure the books are available on time.
Step 5: Conclusion. To ensure they meet demand and maintain
the required safety stock, the bookstore manager should order 280
textbooks for the upcoming course. Ensure the order is placed far
enough in advance to account for the 2-week delivery lead time.
Question 2
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
2
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 2: Inventory Cost Calculation for Liberty University Book-
store
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
3
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 3
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
4
Conclusion:
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 3: Calculate Ending Inventory and Cost of Goods Sold
(COGS)
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
Conclusion:
5
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 4
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method. Question 4: Calculating Ending Inventory and
Cost of Goods Sold (COGS) Using FIFO Method
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
6
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method.
Question 5
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
7
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.Question
5: Calculating Ending Inventory and Cost of Goods Sold
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
8
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.
9
Step 1: Understand the variables given in the problem. - Expected
sales = 250 books - Safety stock = 30 books
Step 2: Determine the order size. The basic formula to calculate
the order size when you take into account safety stock is:
Order Size =Expected Sales +Safety Stock
Step 3: Plug in the values and calculate.
Order Size = 250 + 30 = 280 books
Thus, the manager should order 280 textbooks for the semester.
Step 4: Consider lead time (if required in further decisions). Lead
time is 2 weeks, so orders should be placed at least 2 weeks before
the start of the semester to ensure the books are available on time.
Step 5: Conclusion. To ensure they meet demand and maintain
the required safety stock, the bookstore manager should order 280
textbooks for the upcoming course. Ensure the order is placed far
enough in advance to account for the 2-week delivery lead time.
Question 2
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
2
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 2: Inventory Cost Calculation for Liberty University Book-
store
Background: Liberty University Bookstore received a shipment of
books and calculators at the start of the semester. The delivery and
pricing were as follows:
- 100 textbooks at 40eachweredeliveredonJanuary5th.−150textbooksat45
each were delivered on January 15th. - 200 calculators at 18eachweredeliveredonJanuary10th.−
250calculatorsat20 each were delivered on January 20th.
On January 30th, Liberty University sold 120 textbooks and 190
calculators. Calculate the total cost of goods sold (COGS) and ending
inventory using the FIFO (First-In-First-Out) and LIFO (Last-In-
First-Out) methods.
Instructions: - Use the FIFO method for the first calculation. -
Use the LIFO method for the second calculation.
Solution:
Step 1: Lay out the Inventory Received Textbooks: - FIFO Order:
100 @ 40,150@45 - LIFO Order: 150 @ 45,100@40
Calculators: - FIFO Order: 200 @ 18,250@20 - LIFO Order: 250
@20,200@18
Step 2: Calculate COGS and Ending Inventory Using FIFO COGS
Calculation (FIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 200 @
18 =3,600 - Total COGS: 4,000+900 + 3,600 =8,500
Ending Inventory (FIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(200leftover+250−190sold)remaining−
F rom10@18 = 180 −F rom250@20 = 5,000 −T otalEndingInventory :5,850
+180+5,000 = 11,030
Step 3: Calculate COGS and Ending Inventory Using LIFO COGS
Calculation (LIFO): - Textbooks Sold: 120 units - From 100 @ 40 =4,000
- From 20 @ 45 =900 - Calculators Sold: 190 units - From 150 @
20 =3,000 - From 40 @ 18 =720 - Total COGS: 4,000+900 + 3,000+720
=8,620
3
Ending Inventory (LIFO): - Textbooks Left: 130 (150 - 20 sold) @
45−130@45 = 5,850−CalculatorsLeft : 260(250leftover+200−190sold)remaining−
F rom200@18 = 3,600 −F rom10@20 = 200 −T otalEndingInventory :5,850
+3,600+200 = 9,650
Summary: The total COGS using FIFO is 8,500, andusingLIF Ois8,620.
The ending inventory using FIFO is 11,030, whileusingLIF Ois9,650.
Question 3
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
4
Conclusion:
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 3: Calculate Ending Inventory and Cost of Goods Sold
(COGS)
Scenario: Liberty University’s bookstore had an inventory of 150
textbooks at the beginning of September. During September, they
purchased 300 more textbooks. A total of 325 textbooks were sold
throughout the month. The cost of each textbook is 50.
Task: Calculate the ending inventory and the cost of goods sold
(COGS) for the month of September using the FIFO (First-In-First-
Out) inventory method.
Step-by-Step Solution:
Step 1: Calculate the number of textbooks sold from each batch.
- Since sales happened in September, we use the FIFO method. -
Number of textbooks in the beginning inventory (from August): 150
textbooks - Additional textbooks purchased: 300 textbooks - Total
available for sale in September: 150 (beginning) + 300 (purchased)
= 450 textbooks - Total number of textbooks sold in September: 325
textbooks
Under FIFO, we first sell the older inventory (beginning inven-
tory): - From the 150 beginning inventory, all 150 textbooks are
sold. - From the new batch of 300 textbooks, we need an additional
175 textbooks to meet the sales (325 total sold - 150 from beginning
inventory = 175 from new batch).
Step 2: Calculate Ending Inventory using FIFO
- Textbooks remaining from the newly purchased batch:
300(newbatch)−175(soldfromnewbatch) = 125textbooks
- Ending inventory = 125 textbooks
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO
- Cost of textbooks sold from the beginning inventory:
150 textbooks ×$50/textbook = $7,500
- Cost of textbooks sold from the new batch:
175 textbooks ×$50/book = $8,750
- Total COGS:
$7,500 + $8,750 = $16,250
Conclusion:
5
- The ending inventory of Liberty University’s bookstore at the
end of September, calculated using FIFO, is 125 textbooks. - The
cost of goods sold for September is 16,250.
This detailed analysis should help Liberty University manage their
bookstore’s finances effectively and plan for future inventory needs.
Question 4
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method. Question 4: Calculating Ending Inventory and
Cost of Goods Sold (COGS) Using FIFO Method
Scenario: Liberty University’s bookstore started the month with
150 textbooks in stock, priced at 30each.Duringthemonth, thebookstoremadethefollowingpurchases :
6
- 100 textbooks at 32eachonApril10.−200textbooksat35 each on April
20.
During April, the bookstore sold 300 textbooks. Using the FIFO
(First In, First Out) inventory costing method, calculate the ending
inventory and the cost of goods sold (COGS).
Step-by-Step Solution:
Step 1: Determine the number of textbooks sold and the remaining
inventory.
- Total textbooks sold: 300 textbooks - Total beginning inventory
+ purchases: 150 + 100 + 200 = 450 textbooks - Textbooks remaining
= Total beginning inventory + purchases - sold = 450 - 300 = 150
textbooks
Step 2: Apply the FIFO method to calculate COGS.
FIFO means the first items purchased are the first ones sold.
- The initial 150 textbooks at 30aresoldfirst.−T hen, 100textbooksfromtheApril10purchaseat32
are sold. - From the April 20 purchase, 50 textbooks are sold (300
total sold - 150 - 100 = 50 remaining to reach 300 sold)
Calculate the COGS:
-150 textbooks×$30 = $4500 -100 textbooks×$32 = $3200 -50 textbooks×
$35 = $1750
Total COGS = $4500 + $3200 + $1750 = $9450
Step 3: Calculate Ending Inventory using FIFO.
The remaining 150 textbooks consist of:
- The remaining 150 textbooks from the April 20 purchase at
35each(since50werealreadysoldfromthisbatch).
Calculate Ending Inventory:
-150 textbooks ×$35 = $5250
Step 4: Summarize the results.
- Ending Inventory Value =
$
5250 - Cost of Goods Sold =
$
9450
These calculations provide Liberty University’s bookstore with the
values needed for financial reporting and inventory management using
the FIFO method.
Question 5
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
7
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.Question
5: Calculating Ending Inventory and Cost of Goods Sold
Liberty University’s bookstore had a beginning inventory of 50
textbooks at 20each.Duringthemonth, Libertypurchased100moretextbooksat22
each. By the end of the month, the bookstore had sold 120 textbooks.
Calculate the ending inventory and the cost of goods sold using the
FIFO (First-In, First-Out) inventory method.
—
Step-by-Step Solution:
Step 1: Identify the information given: - Beginning inventory: 50
textbooks at 20each −P urchases : 100textbooksat22 each - Textbooks
sold: 120 textbooks
Step 2: Calculate the total number of textbooks available before
sales: Total Textbooks Available = Beginning Inventory + Purchased
Total Textbooks Available = 50 + 100 = 150
8
Step 3: Calculate Cost of Goods Sold (COGS) using FIFO method.
- FIFO means the first items purchased are the first items sold. - Cal-
culate the total sold from the beginning inventory and purchased in-
ventory: - From beginning inventory: 50 textbooks at 20each50×20 =
1,000 - From the purchased inventory (out of 100, 70 are sold because
120 total were sold and 50 were from beginning inventory): 70×22 =
1,540
Combine the cost of goods from beginning and purchased inven-
tory to get COGS:
COGS =
1,000 + 1,540 =2,540
Step 4: Calculate the Ending Inventory using FIFO method. -
Remaining inventory comes from textbooks purchased: - Purchased
inventory remaining: 100 −70 = 30 textbooks - Calculate the value of
ending inventory:
Ending Inventory = 30×
22 = 660
Step 5: Summarize the results.
Ending Inventory: 660
Cost of Goods Sold: 2,540
Using the FIFO method, after selling 120 textbooks, Liberty Uni-
versity’s bookstore is left with an ending inventory valued at 660andhasincurredacostof goodssoldamountingto2,540.
9
