Select Page

## accounting-Smith Company started the month of March

Chapter Eight Case â 30 points

Smith Company started the month of
March, 2014 with 7,000 units of product X, with a cost of \$13.00 per unit. Merchandise transactions for the month of
March 2014 are as follows:
.0/msohtmlclip1/01/clip_image002.png”>
Based on the information provided, develop
a spreadsheet in Excel that calculates the following results:

1.
FIFO, using the perpetual system
a.
Ending inventory value â 3 pts
b.
Cost of goods sold â 2 pts
c.
Gross profit â 3 pts
2.
LIFO, using the perpetual system
a.
Ending inventory value â 3 pts
b.
Cost of goods sold â 2 pts
c.
Gross profit â 3 pts
3.
Average cost, using the perpetual system
a.
Ending inventory value â 3 pts
b.
Cost of goods sold â 2 pts
c.
Gross profit â 3 pts

Required:
Prepare, using Excel, develop the
solution for the required information.
If you use Excel as a âtypewriterâ you will lose up to 5 points toward
your total for this assignment. This
portion of the assignment is worth 24 points.
You will then complete a Word document discussing the solutions, making
sure to import the appropriate Excel data to support the discussion. This portion of the assignment is worth 6
points. If you simply âpasteâ the Excel
data or paste as an Excel object into the Word document, which is not following
the instructions for the assignment, you will lose up to 5 points toward the
total for this assignment.

Make sure to complete both the
Excel file and the Word document prior to attempting to upload to the
assignment in Blackboard. You must
âbrowseâ and access both files prior to hitting the âsubmitâ button in Blackboard.

paper (the Word document) and you should follow the appropriate details
associated with this assignment as such.
The file name of the Word file and the Excel file will be as
follows: lastname_ACC310-Fa15_Case 4.

```We pride ourselves in writing quality essays

#### Plagiarism Free

We use anti-plagiarism software to ensure you get high-quality, unique papers. Besides, our writers have a zero plagiarism mentality

#### On Time Delivery

Your essay will be delivered strictly within the deadline.  If you have an urgent order, we can do it!

#### Money Back Guarantee

We offer warranty service, including free revisions, and a right to request a refund incase your expectations are not met!

#### THE BEST PAPER WRITER HELPER

• Say “NO” to plagiarism – FREE plagiarism report as an addition to your paper
• The lowest prices that fit excellent quality
• Authorship – you are the one who possesses the paper. We DO NOT re-sale or re-use any of them.

### Our Freebies

• Free Cover Page
• Free Revisions
• Free Reference Page