Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

UFO / FIFO / Average Cost under Periodic and Pepetual Inventory Systems Spelling Company had the following transactions in connection with their inventory account during

UFO/FIFO/Average Cost under Periodic and Pepetual Inventory Systems
Spelling Company had the following transactions in connection with their inventory account during the month of August:
\table[[,PURCHASES,,,SALES,],[,Units,Unit Cost,,Units,Unit Price],[1-Aug,625s,8.15,4Aug,235s,1260],[3-Aug,670,8.25,10-Aug,635,12.60],[7-Aug,1215,8.45,12-Aug,810,13.00],[11-Aug,580,8.50,17-Aug,630,13.10],[16-Aug,540,8.55,20-Aug,715,13.40],[23-Aug,610,8.60,25-Aug,570,13.50],[4240,,,3595,]]
Instructions:
Calculate the total number of ending imventory units. (This number will be used for all methods and assumptions)
a. Assuming that the company keeps perpetual records in units only; compute the inventory at August 31, using (1) LIFO; (2) FFO and (3) average cost. (the periodic method)
b. Assuming that perpetual records are kept in dollars, compute the inventory at August 31. using (1) LIFO: (2) FIFO and (3) average cost (ine perpetual method)
c. Calculate the cost of goods sold Spelling Compary should record for the month of August assuming the periodic inventory method (fon)(1) LIFO; (2) FIFO and (3) average cost.
d. Calculate the cost of goods sold Speling Company should record for the month of August assuming the perpetual inventory method for (1) LIFO: (2) FIFO and (3) average cost.
Calculate the Gross Profit for LIFO and FIFO under the periodic method.
You are to create worksheets within this document that calculate the requested information provide for above. I must see your work in order to give full credit.
This is your opportunity to flex your Excel muscie and utlize this powerful software to help prepare calculations which are cumbersome and time consuming to do manually. I want to see good organization of data, good usage of Excel functions, and a logical flow of data for each solution area. Label your work appropriately.
If I believe you have shared or copied your data/worksheets, I will prowide a zero for the assignment. Do your own work please!
Provide the Answers on the SOLUTIONS tab in the workbook (use cell references). But make sure this document also provides the backup information/calculation for each solution.
Do not hard enter any number that is a calculation...use formulas and references throughout.
-Present solutions rounded to two decimals.
\table[[CHECK FIGURES:,,],[LiFO Perpetual Ending Inventory,$,5.274.75],[LIFO Periodic Cost of Goods Sold,$,30.422.25],[Average Cost Perpetual Ending Inventory,$,5.490.91]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren

3rd Edition

0131800345, 978-0131800342

More Books

Students also viewed these Accounting questions

Question

Develop a program for effectively managing diversity. page 317

Answered: 1 week ago