Apple mart in Nizwa had faced a serious working capital issues during the last year due to the pandemic. In the year 2021 the business wants to improve its internal performance. Hence, it needs to estimate the amount of money to be invested further to keep up the required level of working capital. The finance department had provided with the following information to the management accounting team to work out the Average inventory processing period. The business has started its operations in the last year with an opening stock of OMR 10,000 and purchased OMR 40,000 worth goods from its supplier. Later, the business has rejected OMR 4,000 worth goods after the quality check conducted by the stores department. The total sales of the company for the year 2020 was OMR 80,000 out of which OMR 30,000 was on cash basis. The finance department has also provided with the following details; Particulars Debtors at the beginning Debtors at the end Creditors at the beginning Creditors at the end Stock at the end Amount in OMR 16,000 14,000 12,000 8,000 16,000 Identify the Average inventory processing period from the following Options? O 188.57 days O 140.57 days O 158.17 days O 140.17 days

Apple mart in Nizwa had faced a serious working capital issues during the last year due to the pandemic. In the year 2021 the business wants to improve its internal performance. Hence, it needs to estimate the amount of money to be invested further to keep up the required level of working capital. The finance department had provided with the following information to the management accounting team to work out the Average inventory processing period. The business has started its operations in the last year with an opening stock of OMR 10,000 and purchased OMR 40,000 worth goods from its supplier. Later, the business has rejected OMR 4,000 worth goods after the quality check conducted by the stores department. The total sales of the company for the year 2020 was OMR 80,000 out of which OMR 30,000 was on cash basis. The finance department has also provided with the following details; Particulars Debtors at the beginning Debtors at the end Creditors at the beginning Creditors at the end Stock at the end Amount in OMR 16,000 14,000 12,000 8,000 16,000 Identify the Average inventory processing period from the following Options? O 188.57 days O 140.57 days O 158.17 days O 140.17 days

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 22M

See similar textbooks

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.
Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year: The selling price of Poleskis single product is 16. In recent years, profits have fallen and Poleskis management is now considering a number of alternatives. Poleski wants to have a net income next year of 250,000, but expects to sell only 120,000 units unless some changes are made. The president of Poleski has asked you to calculate the companys projected net income (assuming 120,000 units are sold) and the sales needed to achieve the companys net income objective for next year. Also, compute Poleskis contribution margin per unit, contribution margin ratio, and break-even point for next year. The worksheet CVP has been provided to assist you. Note that the data from the problem have already been entered into the Data Section of the worksheet.
Apple mart in Nizwa had faced a serious working capital issues during the last year due to the pandemic. In the year 2021 the business wants to improve its internal performance. Hence, it needs to estimate the amount of money to be invested further to keep up the required level of working capital. The finance department had provided with the following information to the management accounting team to work out the Average inventory processing period. The business has started its operations in the last year with an opening stock of OMR 10,000 and purchased OMR 40,000 worth goods from its supplier. Later, the business has rejected OMR 4,000 worth goods after the quality check conducted by the stores department. The total sales of the company for the year 2020 was OMR 80,000 out of which OMR 30,000 was on cash basis. The finance department has also provided with the following details; Identify the Average inventory processing period from the following Options?
Diamond Computers, which is owned and operated by Dale Diamond, manufactures and sells different types of computers. The company has reported profits every year since its inception in 2002 and has applied for a bank loan near the end of 2021 to upgrade manufacturing facilities. These upgrades should significantly boost future productivity and profitability. In preparing the financial statements for the year, the chief accountant, Sandy Walters, mentions to Dale that approximately $80,000 of computer inventory has become obsolete and a write-down of inventory should be recorded in 2021. Dale understands that the write-down would result in a net loss being reported for company operations in 2021. This could jeopardize the company’s application for the bank loan, which would lead to employee layoffs. Dale is a very kind, older gentleman who cares little for his personal wealth but who is deeply devoted to his employees’ well-being. He truly believes the loan is necessary for the company’s…
You are a financial adviser with a client in the wholesale produce business that just completed its first year of operations. Due to weather conditions, the cost of acquiring produce to resell has escalated during the latter part of this period. Your client, Javonte Gish, mentions that because her business sells perishable goods, she has striven to maintain a FIFO flow of goods. Although sales are good, the increasing cost of inventory has put the business in a tight cash position. Gish has expressed concern regarding the ability of the business to meet income tax obligations. Required Prepare a memorandum that identifies, explains, and justifies the inventory method you recommend that Ms. Gish adopt.
A. Management has developed a new inventory management system that it projects will reduce company inventory from $15,000,000 at the beginning of the next operating year to $12,000,000 at the end of the next operating year: will cash be generated by inventory or needed to fund inventory? And, by how much? a. $3,000,000 of cash generated by reducing inventory b. $12,000,000 of cash needed to fund inventory c. $254,000 of cash needed to fund the inventory reduction program d. $3,000,000 needed to fund inventory B. Accounts payable are projected to be $300,000 at the beginning of the next operating year and $500,000 at the end of the next operating year: will cash be generated by accounts payable or needed to fund accounts payable? And, by how much? a. $200,000 of cash generated by the increase in accounts payable (borrowed more money) b. $500,000 of cash needed to fund accounts payable c. $200,000 of cash needed to fund accounts payable d. No cash will be…
Kiley Corporation had the following data for the most recent year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered? (Hint: Calculate the CCC for original and then for revised and take the difference. SHOW ALL WORK)
Kiley Corporation had the following data for the most recent year (in millions). The new CFO believes (1) that an improved inventory management system could lower the average inventory by $4,000, (2) that improvements in the credit department could reduce receivables by $2,000, and (3) that the purchasing department could negotiate better credit terms and thereby increase accounts payable by $2,000. Furthermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made, by how many days would the cash conversion cycle be lowered? Original Revised Annual sales: unchanged $110,000 $110,000 Cost of goods sold: unchanged $80,000 $80,000 Average inventory: lowered by $4,000 $20,000 $16,000 Average receivables: lowered by $2,000 $16,000 $14,000 Average payables: increased by $2,000 $10,000 $12,000 Days in year 365 365
Rock Designs, Inc. is a jewelry store located in Miramar Beach, Florida. After Valentine’s Day, the store often has excess cash to get it through the three-month slow season. The primary stockholder, Hardy Rock, wants to make this seasonal cash work for the business. Requirements Identify which investment class options are available to Rock Designs, Inc. The company identifies that it wants to invest in the technology sector and has narrowed its choices to three companies: Apple Inc., Google Inc., and Microsoft Corporation. Prepare a brief analysis comparing the three companies, and recommend one of the three based on your analysis.
The new owners of Sheraton Natural Foods Inc. have hired you to help them diagnose and cure problems that the company has had in maintaining adequate liquidity. As a first step, you perform a liquidity analysis. You then do an analysis of the company’s short-term activity ratios. Your calculations and appropriate industry norms are listed. Ratio Sheraton Industry Norm Current ratio 4.5 4.0 Quick ratio 2.0 3.1 Inventory turnover 6.0 10.4 Average collection period 73 days 52 days Average payment period 31 days 40 days Requirements: What recommendations relative to the amount and the handling of inventory could you make…
Margie Johnson is a staff accountant at ToolEx Company, a manufacturer of tools and equipment. The company is under pressure from investors to increase earnings, and the president of the company expects the accounting department to "make this happen." Margie's boss, who has been a mentor to her, is concerned that if earnings do not increase, he will be terminated. Shortly after the end of the fiscal year, the company performs a physical count of the inventory. When Margie compares the physical count to the balance in the inventory account, she finds a significant amount of inventory shrinkage. The amount is so large that it will result in a significant drop in earnings this period. Margie's boss asks her not to make an adjusting entry for shrinkage this period. He assures her that he will get "caught up" on shrinkage in the next period, after the pressure is off to reach this period's earning goal. Margies boss asks her to do this as a personal favor for him. What should Margie…
Horizon Corporation manufactures personal computers. The company began operations in 2012 and reported profits for the years 2012 through 2019. Due primarily to increased competition and price slashing in the industry, 2020’s income statement reported a loss of $20 million. Just before the end of the 2021 fiscal year, a memo from the company’s chief financial officer (CFO) to Jim Fielding, the company controller, included the following comments:If we don’t do something about the large amount of unsold computers already manufactured, our auditors will require us to record a write-down. The resulting loss for 2021 will cause a violation of our debt covenants and force the company into bankruptcy. I suggest that you ship half of our inventory to J.B. Sales, Inc., in Oklahoma City. I know the company’s president, and he will accept the inventory and acknowledge the shipment as a purchase. We can record the sale in 2021 which will boost our loss to a profit. Then J.B. Sales will simply…