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
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
You have been hired by Johnson and Johnson Corp. this year. Your supervisor approaches you and need you recommendation on the inventory valuation assumption you will recommend for the company to use instead to using Specific Identification method.
Instruction:
Identify each of the cost flow assumptions that company can use.
Explain the advantages and disadvantages of using each of them.
Each one will you recommend and Why?
What are the characteristics of a Just-in-time inventory system?
Explain some advantages and risks of Just-in-time inventory system.
As you watch the simulation, please keep in mind that this is a scenario where the system flow rate is R = 9 passengers per minute and the flow time is T = 6 seconds.
Question 1: Use Little’s Law to compute the average inventory in this system, measured in “passengers.
Question 2: On the basis of this information, would you expect the average inventory to increase or decrease from your answer to question 1? Why? Explain briefly in words.
Question 3: Now use Little’s Law to compute the correct inventory when R = 10 passengers per minute. State the new inventory, I. Were you correct in question 2?
Tracing the Inventory Count. You have been assigned to trace the results of the observation of Brightware China’s physical inventory count to its pricing and compilation. You note the following conditions.1. The last inventory tag documented by Mark Hulse, the auditor who observed the inventory, was 1732, but you notice a number of items with count ticket numbers higher than 1732. You contact the client’s controller, Marcia Vines, who tells you the client found a storage room full of a new product that Brightware had just produced and added it to the inventory.
2. The count tickets recorded by Hulse agree to the inventory list, but some of the other count tickets you select are substantially different from it. Vines tells you these are input errors and she will have them corrected.
3. Hulse described several boxes of goods as being dusty and even broken. They are included in the inventory at cost. Vines’s explanation is that china never “goes bad” and the goods themselves were not…
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
- Please refer to the picture below for information. Kindly show the complete solution using MS Excel or Table. Thank you so much. Question: Using Periodic system and FIFO method, and Perpetual system and FIFO Method what is the amount of inventory as of December 31, respectively.? Choices For Periodic system/FIFO Method: a. P59,000 b. P57,000 c. P61,600 d. P60,210 Choices for Perpetual System/FIFO Method: a. P59,000b. P57,000c. P61,600d. P60,210arrow_forwardThe ABC approach to inventory management is based on the concept that: Multiple Choice inventory should arrive at the time it is needed in the manufacturing process. the inventory period should be constant for all inventory items. basic inventory items that are essential to production and also inexpensive should be ordered in small quantities only. a small percentage of inventory items represents a large percentage of inventory cost. one-third of a year's inventory needs should be on hand, another third should be on order, and the last third should be unordered.arrow_forwardPlease refer to the picture below for the information. Kindly use a TABLE in showing the complete solution. Thank you so much. Question: Using weighted average costing method, what is the amount of inventory as of December 31? and Using moving average costing method, what is the amount of inventory as of December 31, respectively? Choices for weighted average costing method: a. P59,000 b. P57,000 c. P61,600 d. P60,210 Choices for moving average costing method: a. P59,010 b. P60,210 c. P60,900 d. P57,000arrow_forward
- 6. Lily, a new auditor in an electronics manufacturing company, is reviewing the appropriateness of the minimum quantity level of inventory established by a department. Which of the following would Lily be least likely to consider? Group of answer choices Area/size of the warehouse where the inventories are stored. Stockout costs, including lost customers. The potential for obsolescence of inventory items. Seasonal variations in forecasting inventory demand.arrow_forwardThe following describes the expenditure cycle manual procedures for a hypothetical company.The inventory control clerk examines the inventory records for items that must be replenished andprepares a two-part purchase requisition. Copy 1 ofthe requisition is sent to the purchasing department,and Copy 2 is filed.Upon receipt of the requisition, the purchasingclerk selects a supplier from the valid vendor file (reference file) and prepares a three-part purchase order.Copy 1 is sent to the supplier, Copy 2 is sent to theAP department where it is filed temporarily, andCopy 3 is filed in the purchasing department.A few days after the supplier ships the order, thegoods arrive at the receiving department. They areinspected, and the receiving clerk prepares a threepart receiving report describing the number andquality of the items received. Copy 1 of the receivingreport accompanies the goods to the stores, wherethey are secured. Copy 2 is sent to inventory control,where the clerk posts it to…arrow_forwardInventory Valuation under Variable Costing Refer to the data for Pelham Company on the previous page. Required: 1. How many units are in ending inventory? 2. Using variable costing, calculate the per-unit product cost. 3. What is the value of ending inventory under variable costing? Use the following information for Brief Exercises 3-30 and 3-31: During the most recent year, Pelham Company had the following data associated with the product it makes:arrow_forward
- You have decided to open up a small convenience store in your hometown. As part of the initial set-up process, you need to determine whether to use a perpetual inventory system or a periodic inventory system. Write an evaluation paper comparing the perpetual and periodic inventory systems. Describe the benefits and challenges of each system as it relates to your industry and to your business size. Compare at least one example transaction using the perpetual and periodic inventory systems (a purchase transaction, for example). Research and describe the impact each system has on your financial statements. Decide which system would be the best fit for your business, and support your decision with research.arrow_forwardA JIT inventory management system maintains which of the following? a. Goods should be pushed through the system on a fixed schedule based on anticipated demand. b. Goods should be pulled through the system by present demand. c. Total inventory costs are minimized by balancing setup and carrying costs. d. Inventories are needed to avoid stock-out costs.arrow_forwardWhich of the following is an advantage of the periodic inventory system? A. frequent physical inventory counts B. cost prohibitive C. time consuming D. real-time information for managersarrow_forward
- Prepare journal entries to record the following transactions, assuming periodic inventory updating and first-in, first-out (FIFO) cost allocation.arrow_forwardData on the physical inventory of Ashwood Products Company as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item, proceed as follows: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the Lower of C or M column. The first item on the inventory sheet has been completed as an example.arrow_forwardData on the physical inventory of Katus Products Co. as of December 31 follow: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are summarized as follows: Instructions Determine the inventory at cost as well as at the lower of cost or market, using the first-in, first-out method. Record the appropriate unit costs on the inventory sheet and complete the pricing of the inventory. When there are two different unit costs applicable to an item: 1. Draw a line through the quantity and insert the quantity and unit cost of the last purchase. 2. On the following line, insert the quantity and unit cost of the next-to-the-last purchase. 3. Total the cost and market columns and insert the lower of the two totals in the LCM column. The first item on the inventory sheet has been completed as an example.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 LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegePrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
INVENTORY & COST OF GOODS SOLD; Author: Accounting Stuff;https://www.youtube.com/watch?v=OB6RDzqvNbk;License: Standard Youtube License