Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 7, Problem 9R
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning.
On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing $580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT.
Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
DeForest Company had the following transactions for the month. Sales for the month are $85 per unit.
In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using periodic inventory updating.
PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$" (i.e. $12,345.67).
Weighted average cost per unit = per unit.
Cost Allocation Method
Cost of Goods Available
Cost of Goods Sold
Ending Inventory
Sales
Gross Margin
First-in, First-out (FIFO)
Last-in, First-out (LIFO)
Weighted Average (AVG)
At the end of January, Higgins Data Systems had an inventory of 750 units, which cost $13 per unit to produce. During February the
company produced 1,600 units at a cost of $16 per unit. If Higgins sold 2,000 units in February, what was its cost of goods sold?
a. Assume average cost inventory accounting. (Do not round intermediate calculations. Round your answer to nearest whole dollar.)
Cost of goods sold
$30800
b. Assume FIFO inventory accounting.
Cost of goods sold $1
At the end of January, Mineral Labs had an inventory of 905 units, which cost $13 per unit to produce. During February the company produced 1,550 units at a cost of $17 per unit.
a. If the firm sold 2,150 units in February, what was the cost of goods sold? (Assume LIFO inventory accounting.)
b. If the firm sold 2,150 units in February, what was the cost of goods sold? (Assume FIFO inventory accounting.)
Chapter 7 Solutions
Excel Applications for Accounting Principles
Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Prob. 3RCh. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - What changes would have taken place if Dels...Ch. 7 - Suppose Dels purchase prices had remained...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Reset the November 20 purchase to 150 units,...Ch. 7 - Click the Chart sheet tab. On the screen is a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardPietro expects to produce 50,000 units and sell 49,300 units. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Required: 1. Prepare a statement of cost of goods sold in good form. 2. What if the beginning inventory of finished goods decreased by 5,000? What would be the effect on the cost of goods sold?arrow_forwardAt the end of January, Mineral Labs had an inventory of 855 units, which cost $8 per unit to produce. During February the company produced 1,300 units at a cost of $12 per unit. a. If the firm sold 1,650 units in February, what was the cost of goods sold? (Assume LIFO inventory accounting.) Cost of goods sold b. If the firm sold 1,650 units in February, what was the cost of goods sold? (Assume FIFO inventory accounting.) Cost of goods soldarrow_forward
- Assume that in September, Joplin Designs customers actually return$150,000 of inventory. Using the same cost of goods sold percentage, the companywould make the following entries to record 1) the refunds and 2) cost of items returned.arrow_forwardThe Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations: January 20 April 21 July 25 $12 = $13 = 410 units 130 units 230 units 80 units $14 = September 19 $15 During the year, The Shirt Shop sold 680 T-shirts for $20 each. Required a. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions. Required A Purchased Purchased Purchased Purchased Complete this question by entering your answers in the tabs below. Ending inventory Required B Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. Note: Round intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount. FIFO @ @ @…arrow_forward[The following information applies to the questions displayed below.] Home Hardware reported beginning inventory of 30 shovels, for a total cost of $90. The company had the following transactions during the month: January 2 Sold 7 shovels on account at a selling price of $10 per unit. January 16 Sold 12 shovels on account at a selling price of $10 per unit. January 18 Bought 4 shovels on account at a cost of $3 per unit. January 19 Sold 12 shovels on account at a selling price of $10 per unit. January 24 Bought 12 shovels on account at a cost of $3 per unit. January 31 Counted inventory and determined that 13 units were on hand. 3-a. What is the dollar amount of shrinkage that you were able to determine in periodic inventory system? 3-b. What is the dollar amount of shrinkage that you were able to determine in perpetual inventory system? Do not give answer in imagearrow_forward
- Use the following information for Problems 32 and 33.Tristan, Inc., uses the LIFO cost-flow assumption to value inventory. It began the current year with 2,000 units of inventory carried at LIFO cost of $20 per unit. During the first quarter, it purchased 8,000 units at an average cost of $40 per unit and sold 9,500 units at $60 per unit.Assume the company expects to replace the units of beginning inventory sold in April at a cost of $45 per unit and expects inventory at year-end to be between 2,100 and 2,500 units. What amount of cost of goods sold should be recorded for the quarter ended March 31?a. $335,000b. $350,000c. $380,000d. $387,500arrow_forward1. Determine the cost of the December 31 finished-goods inventory. 2. Compute Mason’s net income for the current year ended December 31. 3. If next year’s production decreases to 23,000 units and general cost behavior patterns do not change, what is the likely effect on a. The direct-labor cost of $36 per unit? No change Increase Decrease b. The fixed manufacturing overhead cost of $600,000? No change Increase Decrease c. The fixed selling and administrative cost of $860,000? No change Increase Decrease d. The average unit cost of production? No change Increase Decreasearrow_forwardAt the end of January, Higgins Data Systems had an inventory of 710 units, which cost $15 per unit to produce. During February the company produced 1,070 units at a cost of $18 per unit. If the firm sold 1,210 units in February, what was its cost of goods sold? (Assume LIFO inventory accounting.)arrow_forward
- The following information has been made available of Carson Sdn Bhd for the year 2021 are as follows. 1) The units to be sold are: Month Units January February March 2,200 2,200 3,400 April Мay 3,800 5,000 June 4,600 4,000 July 2) There will be no work in progress at the end of any month. 3) Finished goods equal to half of the sales for the next month will be in inventory at the end of every month (including December 2020). 4) Budgeted production and production costs for the period ending July 2021 are as follows: Production units Direct Material Direct Wages | Total factory overheads based on units produced 44,000 RM 10.00 per unit RM 4.00 per unit RM 88,000 Prepare a production budget for the first half of the year.arrow_forwardThe problem is stated in the picture. Here is the question: 1. Assume instead, the Company uses the Moving Average method in the measurement of its inventories, how much would be the weighted average cost per unit of the sales made at May 20? (Round off the final answers to two decimal places)arrow_forwardNovak Marine Products began the year with 8 units of marine floats at a cost of $11 each. During the year, it made the following purchases: May 5, 34 units at $16; July 16, 17 units at $21; and December 7, 22 units at $25. Assume there are 29 units on hand at the end of the period. Novak uses the periodic system. (a) Determine the cost of goods sold under FIFO. Cost of good sold $ eTextbook and Media Save for Later Attempts: 0 of 3 used (b) The parts of this question must be completed in order. This part will be available when you complete the part above. (c1) The parts of this question must be completed in order. This part will be available when you complete the part above. (c2) The parts of this question must be completed in order. This part will be available when you complete the part above. Submit Answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
INVENTORY & COST OF GOODS SOLD; Author: Accounting Stuff;https://www.youtube.com/watch?v=OB6RDzqvNbk;License: Standard Youtube License