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
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
- Chassen Company, a cracker and cookie manufacturer, has the following unit costs for the month of June: A total of 100,000 units were manufactured during June, of which 10,000 remain in ending inventory. Chassen uses the first-in, first-out (FIFO) inventory method, and the 10,000 units are the only finished goods inventory at June 30. Under the absorption costing concept, the value of Chassens June 30 finished goods inventory would be: a. 50,000. b. 70,000. c. 85,000. d. 145,000.arrow_forwardFor each of the following independent situations, calculate the missing values: 1. The Belen plant purchased 78,300 of direct materials during June. Beginning direct materials inventory was 2,500, and direct materials used in production were 73,500. What is ending direct materials inventory? 2. Forster Company produced 14,000 units at an average cost of 5.90 each. The beginning inventory of finished goods was 3,422. (The average unit cost was 5.90.) Forster sold 14,120 units. How many units remain in ending finished goods inventory? 3. Beginning work in process (WIP) was 116,000, and ending WIP was 117,300. If total manufacturing costs were 349,000, what was the cost of goods manufactured? 4. If the conversion cost is 84 per unit, the prime cost is 55, and the manufacturing cost per unit is 105, what is the direct materials cost per unit? 5. Total manufacturing costs for August were 412,000. Prime cost was 64,000, and beginning WIP was 76,000. The cost of goods manufactured was 434,000. Calculate the cost of overhead for August and the cost of ending WIP.arrow_forwardPattison Products, Inc., began operations in October and manufactured 40,000 units during the month with the following unit costs: Fixed overhead per unit = 280,000/40,000 units produced = 7. Total fixed factory overhead is 280,000 per month. During October, 38,400 units were sold at a price of 24, and fixed marketing and administrative expenses were 130,500. Required: 1. Calculate the cost of each unit using absorption costing. 2. How many units remain in ending inventory? What is the cost of ending inventory using absorption costing? 3. Prepare an absorption-costing income statement for Pattison Products, Inc., for the month of October. 4. What if November production was 40,000 units, costs were stable, and sales were 41,000 units? What is the cost of ending inventory? What is operating income for November?arrow_forward
- Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?arrow_forwardBleistine Company had the following transactions for the month. Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $50 each. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardUsing 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_forward
- Pietro 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_forwardRenfro, Inc. was franchised on January 1, 2016. At the end of its third year of operations, December 31, 2018, management requested a study to determine what effect different materials inventory costing methods would have had on its reported net income over the three-year period. The materials inventory account, using LIFO, FIFO, and weighted average, would have had the following ending balances: a. Assuming the same number of units in ending inventory at the end of each year, were material costs rising or falling from 2016 to 2018? b. Which costing method would show the highest net income for 2017? c. Which method would show the lowest net income for 2018? d. Which method would show the highest net income for the three years combined?arrow_forwardWhen prices are falling (deflation), which costing method would produce the highest gross margin for the following? Choose first-in, first-out (FIFO); last-in, first-out (LIFO); or weighted average, assuming that B62 Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming B62 sold just one unit of these goods for $400. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forward
- Akira Company had the following transactions for the month. Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $25 each. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardWhen prices are rising (inflation), which costing method would produce the highest value for gross margin? Choose between first-in, first-out (FIFO); last-in, first-out (LIFO); and weighted average (AVG). Evansville Company had the following transactions for the month. Calculate the gross margin for each of the following cost allocation methods, assuming A62 sold just one unit of these goods for $10,000. Provide your calculations. A. first-in, first-out (FIFO) B. last-in, first-out (LIFO) C. weighted average (AVG)arrow_forwardGolden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.arrow_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
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
INVENTORY & COST OF GOODS SOLD; Author: Accounting Stuff;https://www.youtube.com/watch?v=OB6RDzqvNbk;License: Standard Youtube License