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
Enumerate the data and their type that you can identify or infer from the following application areas.
1. Inventory System of XYZ Wholesale Corporation. The company keeps track of pertinent information regarding all the items in stock through its computerized inventory system. This system enables the company to determine in a few keystrokes and at any time the quantity or stock level or every item. It allows XYZ to set the reorder level and reorder quantity each time such that when the stock level falls below the critical level, the item is automatically reordered from its supplier. The preparation of the purchase order is also automated because the supplier and its address, the reorder quantity, the unit cost, and the description of the item are all available on the computer. When an item in stock is replenished (supplied) or diminished(sold), its inventory and its potential profit margin because the unit selling price aside from the unit acquisition cost of each item is also stored…
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_forwardAccountants at UltraTech obtain their values for inventory and total assets, calculate the balance sheet percentage by dividing inventory by total assets for each year and summarize the observations for the relative size of inventory to total assets for each year and percentage change from year-to-year. This would allow them to effectively assess: a. Inventory control compared to competitorsb. If there is an effective return on assetsc. If inventory is being properly managedd. How they are managing liabilitiesarrow_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_forwardAnother way to look at the concept of inventory turnover is by measuring sales per square foot. Taking the average inventory at retail and dividing it by the number of square feet devoted to a particular product will give you average sales per square foot. When you multiply this figure by the inventory turnover rate, you get the annual sales per square foot.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