US Qui Question 1- Inventory Management (LO3) Simeon runs a business that imports tables from China for sale in the UK. The supplier sells these to Simeon in batches of 1,000 units. Historically sales demand has been stable and relatively even throughout the year, at a rate of 2,500 units per month (2018 to 2020). In the period January to June 2021 however this increased to 3,000 per month, and they have run out of stock every month as a result. They have estimated that each stock out has cost them £1,000 each in lost business. Simeon has had this problem before in 2018 (6 stock outs) and 2019 (3 stock outs) but in 2020 he had fixed the problem and achieved no stock out events. Each batch, including shipping and taxes costs £2,500. The cost of placing and processing each order, regardless of quantity, is £100. Records show the following average stock holdings and associated costs: 2018 500 units £1,200 2019 750 units £1,700 2020 1,250 units £2,700 Required: Required: c) For each of the two areas above, explain the results and advise Simeon on the potential impacts of unexpected delays in the supply chain.

US Qui Question 1- Inventory Management (LO3) Simeon runs a business that imports tables from China for sale in the UK. The supplier sells these to Simeon in batches of 1,000 units. Historically sales demand has been stable and relatively even throughout the year, at a rate of 2,500 units per month (2018 to 2020). In the period January to June 2021 however this increased to 3,000 per month, and they have run out of stock every month as a result. They have estimated that each stock out has cost them £1,000 each in lost business. Simeon has had this problem before in 2018 (6 stock outs) and 2019 (3 stock outs) but in 2020 he had fixed the problem and achieved no stock out events. Each batch, including shipping and taxes costs £2,500. The cost of placing and processing each order, regardless of quantity, is £100. Records show the following average stock holdings and associated costs: 2018 500 units £1,200 2019 750 units £1,700 2020 1,250 units £2,700 Required: Required: c) For each of the two areas above, explain the results and advise Simeon on the potential impacts of unexpected delays in the supply chain.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Inventory Turnover & GMROI 1) The dress department had the following performance last year. Net sales were $150,000. Average inventory was $28,000 at retail. Cumulative markup was 48%. Gross margin was 42%. A. What is the GMROI? B. Interpret the GMROI figure in words: C. What is the TO? D. Interpret the TO figure in words:
I need help with this question problem
Accounting Sheridan Company sells coffee beans, which are sensitive to price fluctuations. The following inventory information is available for this product at December 31, 2022. Coffee Bean Units Unit Cost Net Realizable Value Coffee $5.30 $5.27 12,000 bags arabica Coffee 4,900 bags 3.30 3.40 robusta Calculate Sheridan's inventory by applying the lower-of-cost-or-net realizable value basis.
Give me correct answer
What is the average inventory turnover for the firm?
Typed asap plzzzx
Problem 1 IBC's annual profits of P23,500 was going down the drain while DCC's has an annual profit of P349,600 and was rising sharply. IBC's average inventory was P995,000 whereas, DCC's was P49,500. Inventory costs are estimated to be around 2% per month. If IBC had DCC's level of inventory, its annual profits would have been Profit Average Inventory Inventory Costs IBC 23500 995000 2% DCC 349600 49500 2% per month
Inventory Analysis QT, Inc. and Elppa Computers, Inc. compete with each other in the personal computer market. QT assembles computers to customer orders, building and delivering a computer within four days of a customer entering an order online. Elppa, on the other hand, builds computers for inventory prior to receiving an order. These computers are sold from inventory once an order is received. Selected financial information for both companies from recent financial statements follows (in millions): QT Elppa Sales $52,560 $65,800 Cost of goods sold 43,800 62,050 Inventory, beginning of period 1,856 7,339 Inventory, end of period 2,056 8,539 a. Determine for both companies (1) the inventory turnover and (2) the number of days' sales in inventory. Round your calculations and answers to one decimal place. Assume 365 days a year. QT Elppa 1. Inventory turnover 2. Number of days' sales in inventory days days
A. White Castle Company makes miniature circuit boards that are components of wireless phones and personal organizers. The company has experienced strong growth, and you are especially interested in how well White Castle is managing its inventory balances. You have collected the following information for the current year. • Inventory at the beginning of year S 1,026,000 • Inventory at the end of year, before any adjustments 1,007,000 • Total cost of goods sold, before any adjustments 11,776,000 The company values inventory at lower-of-cost (using LIFO cost fl ow assumption)-or-market; use the cost-of-goods- sold method Required: for part A. i. Compute White Castle's inventory turnover before any adjustment. Recompute the inventory turnover after adjusting White Castle's inventory information for the following items. a. During the year, White Castle recorded sales and costs of goods sold on $22,000 of units shipped to various wholesalers on consignment. At year-end, none of these units…
Pool Corporation Inc. reported in its recent annual report that the industry experienced some price deflation one year followed by more normalized price inflation of approximately 2 percent overall despite price deflation for certain chemical products. This suggests that in some years Pool's overall inventory costs rise, and in some years they fall. Furthermore, in many years, the costs of some inventory items rise while others fall. Assume that Pool has only two product items in its inventory this year. Purchase and sale information are presented below. Pool uses a perpetual inventory system. Transaction Beginning inventory Purchases, February 7 Sales, February 28 Purchases, March 16 Sales, April 28 Item A Item B FIFO Inventory Item A Unit Cost Cost of Sales Units 40 80 50 100 110 $6 8 Weighted-Average 99 Inventory Item B Unit Cost Required: 1. Compute the cost of sales for each of the two items separately using the FIFO and weighted average cost inventory costing methods. (Do not…
15. Farrell's Window Supply has seen an increase in sales, but the company is concerned with its inventory management. Has the increase in sales caused the company's ability to manage inventory effectively to decrease? Support your answer by finding the changes in inventory turnover and number of days' sales in inventory. Round ratios to one decimal place. Inventory: Beginning of year End of year Purchases of inventory 20Y6 2015 $350,900 $352,300 325,400 350,900 330,600 325,200 shulpsins, of woted notandin YOS has 2Y02 dina
3