Financial Accounting
3rd Edition
ISBN: 9780133791129
Author: Jane L. Reimers
Publisher: Pearson Higher Ed
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 5B, Problem 2SEB
(Estimate inventory. (LO 9). Knick-Knacks wants to estimate its ending inventory balance for its quarterly financial statements for the first quarter of the year. Given the following, what is your best estimate?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
For 2021, Walmart and Target had the following information (all values are in millions of dollars): Assume a 365-day year.
a. What is each company's accounts receivable days?
b. What is each company's inventory turnover?
c. Which company is managing its accounts receivable and inventory more efficiently?
Data table
(Click on the following icon in order to copy its contents into a spreadsheet.)
Walmart
Target
(Income Statement)
Sales
572,762
106,007
Cost of Goods Sold
(Income Statement)
428,997
74,962
Accounts Receivable
(Balance Sheet)
8,279
830
Inventory
(Balance She
56,519
13,902
= X
Suppose a company's cost of goods sold for
years 2 and 3 were $283,310 and $299,390
respectively. Also suppose that inventory had
a balance of $34,740 at the end of year 1,
$35,168 at the end of year 2, and $36,356 at
the end of year 3. If the annual growth in total
revenues is 8.42% for the foreseeable future,
calculate the forecasted inventory balance at
the end of year 5. Assume the same inventory
turnover in all future years as that in year 3
calculated using the average asset balances.
Also assume the same gross margin % in all
future years as that in year 3. Note that year 3
is the latest year with reported results, while
years 4 onwards are all forecasted years.
Consider the following details about a firm from the past year. Assume that this sample time period provides a good estimate for the firm's cycles. What is its Inventory Period?
March 1 - Acquire Inventory
March 20 - Pay $25,000 for Inventory
April 22 - Sell Inventory on Credit
May 23 - Collect $40,000 for Sale on Credit
Chapter 5B Solutions
Financial Accounting
Ch. 5B - Suppose Base Company began May with inventory of...Ch. 5B - Estimate inventory. (LO 9). Fantasy Games, Inc.,...Ch. 5B - (Estimate inventory. (LO 9). Knick-Knacks wants to...Ch. 5B - Estimate inventory. (LO 9). The following...Ch. 5B - Estimate inventory. (LO 9). The records of Florida...Ch. 5B - Estimate inventory. (LO 9). Hines Fruit Corp....Ch. 5B - Estimate inventory. (LO 9). Carries Cotton Candy...
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
- Suppose the company has to revise its estimates because of a downturn in the economy. Unit sales for August, September, and October will be half (50%) of the original estimates. Revise the estimates in cells 1311 through 1313. After this is done, check your forecasted balance sheet. It should still balance! What effect will this new state of affairs have on net income and borrowing? Explain why these items changed.arrow_forwardUnder the periodic inventory system, what account is debited when an estimate is made for sales made this year, but expected to be returned next year? (a) Sales Returns and Allowances (b) Merchandise Inventory (c) Customer Refunds Payable (d) Salesarrow_forwardYou 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 Junearrow_forward
- The Quartz Company has been taking a physical inventory every quarter in order to prepare its quarterly financial statement. The management is interested to know if they have some alternative to find an efficient way of determining the cost of ending inventory for its quarterly reports. You have been given the following information abased on which you are supposed to suggest the management something that will fulfil the requirements. The Quartz Company Partial Income Statement For the year ended Dec 31, 2020 Net Sales $655,000 CGS: Beginning Inventory 80000 Purchases, Net 575000 COGAS…arrow_forwardFrom the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac) 2018 48520 30560 6480 2019 56520 36800 8260arrow_forwardObtain Apple's annual report of Fiscal Year 2021 and answer the questions below. Hint: Go to the company's official website and look for the "Investor Relations" section. Download the 2021 annual report (also called Form 10-K). Do NOT use quarterly reports or reports of other years.arrow_forward
- Use the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Cost of Average Sales Goods Sold Inventory Year 2021 $260,000 $177,500 $25,000 Year 2022 305,000 221,250 30,000 Year 2023 343,000 242,250 35,000 Inventory Gross Days' Sales Turnover Margin in Inventory Year 2022 Year 2023arrow_forwardA) Calculate the following liquidity ratios for 2020. 1. Working capital- 2.Current Ratio- 3. Acid test ratio- 4. Accounts receivable turnover- B) calculate the following liquidity ratios for 2020. 1. Average collection period (in days)- 2. Inventory turnover (in times)- C) calculate the average days to sell inventory for 2020. 1. Average days to sell inventory-arrow_forward1.A.) The following table shows the desired ending inventory levels of Red Rose Product of Rose Turkish Delight Company for the following year. The company's sales department manager expects the first quarter's sales to be 10,000 boxes and a 10% increase in each quarter. 31.12.2021 31.03.2022 30.06.2022 30.09.2022 31.12.2022 Desired Ending Inventory balances of Red 600 700 800 900 1000 Rose Prepare a production budget for Red Rose Product Line for 2022.arrow_forward
- From the following hypothetical data for Riffa Co. in 2018 and 2019 to project revenues, cost of goods sold, and inventory for Year +1. Assume that Riffa's Year +1 revenue growth rate, gross profit margin growth rate, and inventory turnover will be identical to 2019. Project the average inventory balance in Year +1 and use it to compute the implied ending inventory balance. Cost of Goods Sold Gross Profit Ending Inventory Riffa Co. Required: Calculate the followings for Riffa Co. (consider 3 decimal places) 1. Sales Revenue and Growth Rate for Y+ 1 year. 2. Inventory Turnover for 2019. 3. Forecasted Gross Profit for Y+1. 4. Projected Average Inventory Balance in Year +1 5. Projected Ending Inventory for Year + 1. 2018 48520 30560 6480 2019 56520 36800 8260arrow_forwardThe company had the following inventory at end-of-year prices: $1,230,000 in 2016 (base year), $1,345,000 in 2017, and $1,350,000 in 2018. The price index is 1.02 in 2017 and 1.03 in 2018. What is the LIFO effect in 2018? Round to the nearest whole number.arrow_forwardUse the following information relating to Clover Company to calculate (a) the inventory turnover ratio, (b) gross margin, and (c) the number of days' sales in inventory ratio, for years 2022 and 2023. Assume a year has 365 days. Do not round intermediate calculations and round your final answers to 3 decimal places. Year 2021 Year 2022 Year 2023 Year 2022 Year 2023 Sales $260,000 305,000 333,000 Cost of Goods Sold $187,500 241,250 242,250 Inventory Turnover Average Inventory $25,000 30,000 38,000 Gross Margin Days' Sales in Inventoryarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Chapter 6 Merchandise Inventory; Author: Vicki Stewart;https://www.youtube.com/watch?v=DnrcQLD2yKU;License: Standard YouTube License, CC-BY
Accounting for Merchandising Operations Recording Purchases of Merchandise; Author: Socrat Ghadban;https://www.youtube.com/watch?v=iQp5UoYpG20;License: Standard Youtube License