Principles of Accounting Volume 1
19th Edition
ISBN: 9781947172685
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 10, Problem 6TP
Use a spreadsheet and the following excerpts from Hileah Company’s financial information to build a template that automatically calculates (A) inventory turnover and (B) number of days’ sales in inventory, for the year 2018.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Huluduey Corporation's comparative balance sheet for current assets and liabilities was as follows: Dec. 31, 2012 Dec. 31, 20Y1 $12,700 $12,400 59,500 60,200 28,600 28,300 28,000 26,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Accounts receivable Inventory Accounts payable Dividends payable X Open spreadsheet Adjust net income of $120,100 for changes in operating assets and liabilities to arrive at net cash flows from operating activities. 120,300 X Feedback Check My Work Once you have calculated the changes in the current operating assets and liabilities determine what impact those changes would have on cash. For example if accounts receivable has increased from last year to this year does that mean the company has collected more cash or less cash? If accounts payable has decreased does that mean the company has more cash or less cash?
You are required toa. Calculate the weighted average cost per unit after the purchase of inventory on 5 June 2022. Show your calculation clearly and round youranswer to the nearest Rand.b. Prepare the general journal entries to record the transactions listed above in the general ledger of York Trading for the year ending 30 June
Best Company had the following transactions in March 2020:
Purchased merchandising amounting to P36,000. Terms,
March 2 2/10, n/30 FOB Shipping Point. Paid freight bill
amounting to P4,000.
Returned P3,000 of the merchandise purchase on March
March 5
2 because they were defective
Sold merchandise on account for P10,000, Terms 3/15,
March 8
n/30. The cost of merchandise sold was P6,000
March 10 Paid the purchase made on March 2
Received P2,.000 of merchandise sold on March 8. The
March 12
cost of the merchandise returned was P1.200.
March 22 Received cash from the March 8 sale.
Chapter 10 Solutions
Principles of Accounting Volume 1
Ch. 10 - If a company has four lots of products for sale,...Ch. 10 - If a company has three lots of products for sale,...Ch. 10 - When inventory items are highly specialized, the...Ch. 10 - If goods are shipped FOB destination, which of the...Ch. 10 - On which financial statement would the merchandise...Ch. 10 - When would using the FIFO inventory costing method...Ch. 10 - Which accounting rule serves as the primary basis...Ch. 10 - Which type or types of inventory timing system...Ch. 10 - Which of these statements is false? A. If cost of...Ch. 10 - Which inventory costing method is almost always...
Ch. 10 - Which of the following describes features of a...Ch. 10 - Which of the following financial statements would...Ch. 10 - Which of the following would cause periodic ending...Ch. 10 - Which of the following indicates a positive trend...Ch. 10 - What is meant by the term gross margin?Ch. 10 - Can a business change from one inventory costing...Ch. 10 - Why do consignment arrangements present a...Ch. 10 - Explain the difference between the terms FOB...Ch. 10 - When would a company use the specific...Ch. 10 - Explain why a company might want to utilize the...Ch. 10 - Describe the goal of the lower-of-cost-or-market...Ch. 10 - Describe two separate and distinct ways to...Ch. 10 - Describe costing inventory using first-in,...Ch. 10 - Describe costing inventory using last-in,...Ch. 10 - Describe costing inventory using weighted average....Ch. 10 - How long does it take an inventory error affecting...Ch. 10 - What type of issues would arise that might cause...Ch. 10 - Explain the difference between the flow of cost...Ch. 10 - What insights can be gained from inventory ratio...Ch. 10 - Calculate the goods available for sale for...Ch. 10 - Company accepts goods on consignment from R...Ch. 10 - The following information is taken from a companys...Ch. 10 - Complete the missing piece of information...Ch. 10 - Akira Company had the following transactions for...Ch. 10 - Akira Company had the following transactions for...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Prepare Journal entries to record the following...Ch. 10 - If a group of inventory items costing $15,000 had...Ch. 10 - If Wakowski Companys ending inventory was actually...Ch. 10 - Shetland Company reported net income on the...Ch. 10 - Compute Altoona Companys (a) inventory turnover...Ch. 10 - Complete the missing pieces of McCarthy Companys...Ch. 10 - Calculate the goods available for sale for Soros...Ch. 10 - X Company accepts goods on consignment from C...Ch. 10 - Considering the following information, and...Ch. 10 - Complete the missing piece of information...Ch. 10 - Bleistine Company had the following transactions...Ch. 10 - Bleistine Company had the following transactions...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - If a group of inventory items costing $3,200 had...Ch. 10 - If Barcelona Companys ending inventory was...Ch. 10 - Tanke Company reported net income on the year-end...Ch. 10 - Compute Westtown Companys (A) inventory turnover...Ch. 10 - Complete the missing pieces of Delgado Companys...Ch. 10 - When prices are rising (inflation), which costing...Ch. 10 - Trini Company had the following transactions for...Ch. 10 - Trini Company had the following transactions for...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Use the first-in, first-out (FIFO) cost allocation...Ch. 10 - Use the last-in, first-out (LIFO) cost allocation...Ch. 10 - Use the weighted-average (AVG) cost allocation...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Compare the calculations for gross margin for A76...Ch. 10 - Company Elmira reported the following cost of...Ch. 10 - Assuming a companys year-end inventory were...Ch. 10 - Use the following information relating to Shana...Ch. 10 - Use the following information relating to Clover...Ch. 10 - When prices are falling (deflation), which costing...Ch. 10 - DeForest Company had the following transactions...Ch. 10 - DeForest Company had the following transactions...Ch. 10 - Calculate the cost of goods sold dollar value for...Ch. 10 - Use the first-in, first-out method (FIFO) cost...Ch. 10 - Use the last-in, first-out method (LIFO) cost...Ch. 10 - Use the weighted-average (AVG) cost allocation...Ch. 10 - Prepare journal entries to record the following...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Calculate a) cost of goods sold, b) ending...Ch. 10 - Compare the calculations for gross margin for B76...Ch. 10 - Company Edgar reported the following cost of goods...Ch. 10 - Assuming a companys year-end inventory were...Ch. 10 - Use the following information relating to Singh...Ch. 10 - Use the following information relating to Medinas...Ch. 10 - Assume your company uses the periodic inventory...Ch. 10 - Consider the dilemma you might someday face if you...Ch. 10 - Use a spreadsheet and the following excerpts from...
Additional Business Textbook Solutions
Find more solutions based on key concepts
What role does culture have in how leadership is viewed?
Principles of Management
Ravenna Candles recently purchased candleholders for resale in its shops. Which of the following costs would be...
Financial Accounting (12th Edition) (What's New in Accounting)
Mallorys Video Supply has changed its focus tremendously and as a result has dropped the selling price of DVD p...
Principles of Accounting Volume 2
Prepare a production cost report and journal entries (Learning Objectives 4 5) Vintage Accessories manufacture...
Managerial Accounting (5th Edition)
Discussion Questions 1. What characteristics of the product or manufacturing process would lead a company to us...
Managerial Accounting (4th Edition)
E6-14 Using accounting vocabulary
Learning Objective 1, 2
Match the accounting terms with the corresponding d...
Horngren's Accounting (11th Edition)
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
- Use the following information relating to Shana Company to calculate the inventory turnover ratio and the number of days sales in inventory ratio.arrow_forwardUse the following information relating to Clover Company to calculate the inventory turnover ratio, gross margin, and the number of days sales in inventory ratio, for years 2022 and 2023.arrow_forwardThe following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forward
- The following select account data is taken from the records of Carnival Express for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardUse the following information relating to Singh Company to calculate the inventory turnover ratio and the number of days sales in inventory ratio.arrow_forwardneed to enter the beginning balances in the summary and record the April transactions using a perpetual inventory system. include margin explanations for the changes in revenues and expenses please answer in text with workings and stepsarrow_forward
- How do we update inventory using the year-end physical count and begin the next cycle using the periodic inventory system?arrow_forward1))For the years ended December 31, 2018 of your analysis, assume all sales are on credit and then compute the following: · (a) collection period, · (b) accounts receivable turnover, · (c) inventory turnover, and · (d) days' sales in inventory. · (e) Based on your estimates, comment on the changes in the ratios from 2018 year by drawing conclusion regarding efficiency in managing inventory and in collecting receivables (Note: Comment not more than 10 lines). 2))Provide your recommendations for improving the financial condition of your company. (Note: Comment not more than 10 lines).arrow_forwardexplain the image provided the Accounts receivable turn over, days to collect, Inventory turnover,Days to sell, accounts payable turnover,days to pay and give recommendationarrow_forward
- What would be the Average Inventory?arrow_forwardFind the liquidity ratios (current ratios, acid-test ratio, average collection period, accounts receivable turnover, inventory turnover) from the following financial statement (please open the link) https://alfamart.co.id/storage/report-lists/March2021/FTR7FV0X3t8l9QzYV0tw.pdfarrow_forwardReview the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. Compute the number of days’ sales in receivables ratios for each company for 2018 and 2019. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
The accounting cycle; Author: Alanis Business academy;https://www.youtube.com/watch?v=XTspj8CtzPk;License: Standard YouTube License, CC-BY