Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Greehey Enterprises markets the CDs for the performing artist Cara Lotta. At the beginning of March, Greehey had beginning inventory of 1 , 8 0
Greehey Enterprises markets the CDs for the performing artist Cara Lotta. At the beginning of March,
Greehey had beginning inventory of Lotta CDs with a unit cost of $
During March, Greehey made the following purchases of Lotta CDs Hard copy due on at the start
of class. After printing project with numbers, click CTRL ~ and print a hard copy of formulas revealed. Staple.
Date: Quantity: Cost: Date: Quantity: Cost:
Mar $ Mar $
Mar $ Mar $
During March, units were sold. Greehey uses a perpetual inventory system.
Prepare answers on an Excel spreadsheet using the following templates. Label with letter in parenthesis.
Instructions:
a Determine the cost of goods available for sale.
COST OF GOODS AVAILABLE FOR SALE
Date Explanation Units Unit Cost Total Cost
Mar Text Number Value Formula
Mar Text Number Value Formula
Mar Text Number Value Formula
Mar Text Number Value Formula
Mar Text Number Value Formula
Total Formula Formula
b Determine the ending inventory under FIFO. c Determine the COGS under FIFO.
FIFO
Ending Inventory Cost of Goods Sold
Date Units Unit Cost Total Cost Title Amount
Mar Quantity Amount Formula Title Amount
Mar Quantity Amount Formula Title Formula
Formula Formula
d Prove the accuracy of the cost of goods sold under FIFO.
Proof of Cost of Goods Sold
Date Units Unit Cost Total Cost
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Formula Formula
e Determine the ending inventory under LIFO. f Determine the COGS under
LIFO.
LIFO
Ending Inventory Cost of Goods Sold
Date Units Unit Cost Total Cost Title Amount
Mar Quantity Amount Formula Title Amount
Mar Quantity Amount Formula Title Formula
Formula Formula
g Prove the accuracy of the cost of goods sold under LIFO.
Date Units Unit Cost Total Cost
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Mar Quantity Amount Formula
Formula Formula
h Determine the ending inventory under weighted average.
Ending Inventory Cost of Goods Sold
Cost of goods available for sale
Avg. cost per unit Less: Ending inventory
decimal places Cost of goods sold
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Answer Here is the Excel spreadsheet with the solutions for the given problem a Determine the cost of goods available for sale COST OF GOODS AVAILABLE ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
663e67e152048_956864.pdf
180 KBs PDF File
663e67e152048_956864.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started