Required: b) Also, what is the optimum base stock level? 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: b) Also, what is the optimum base stock level? 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:

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter9: Metric-analysis Of Financial Statements

Section: Chapter Questions

Problem 9.12E: Inventory analysis Costco Wholesale Corporation (COST) and Wal-Mart Stores Inc. (WMT) compete...

See similar textbooks

Similar questions

Q1. As of December 321, 2021, Earth Mother’s Corporation physical inventory was $275,000, and its book inventory was $290,000. The effect of the inventory shrinkage on the accounts is: A. To increase Cost of Goods Sold and Inventory by $15,000 B. To increase Cost of Goods Sold and decrease Inventory by $15,000 C.To decrease Cost of Good Sold and increase Inventory by $15,000 D. To decrease Cost of Goods Sold and Inventory by $15,000
Inventory Management Williams & Sons last year reported sales of $9 million, cost of goods sold (COGS) of $6 million, and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 6 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Enter your answer in dollars. For example, an answer of $1.23 million should be entered as 1,230,000,000. Round your answer to the nearest dollar.
Ma3. Monte Vista uses the perpetual inventory system. At the beginning of the quarter, Monte Vista has $48,000 in inventory. During the quarter the company purchases $10,600 of new inventory from a vendor, returned $1,000 of inventory to the vendor, and took advantage of discounts from the vendor of $380. At the end of the quarter the balance in inventory is $35,500. What is the cost of goods sold?
1. Swing Ltd uses FIFO for its inventory, which is valued at $21,000. It is considering a change to moving weighted average, which would change the valuation of inventory to $22,500. Which of the following would be decreased by the change? a. Cost of goods sold b. Sales c. Liabilities d. Withdrawals 2. Which of the following is NOT an accounting method that could be chosen by a company to increase reported profits in a particular year? a. Understating allowance for doubtful debts b. Classifying longer-term receivables as current assets c. Changing estimates of the useful life of plant and equipment d. Changing inventory valuation method 3. Which of the following statements about the use of the FIFO assumption is NOT true? a. The FIFO assumption assigns the more recent purchase costs to the balance sheet inventory asset account. b. The FIFO assumption is not affected by the inventory control method. c. In periods of rising prices it produces a higher profit than…
Polaris Industries Inc. is the biggest snowmobile manufacturer in the world. It reported the following amounts in its financial statements (in millions):2012 2011 2010 2009Net Sales Revenue $3,200 $2,660 $1,990 $1,570Cost of Goods Sold 2,280 1,900 1,460 1,170Average Inventory 320 270 210 200Required:1. Calculate to one decimal place the inventory turnover ratio and average days to sell inventoryfor 2012, 2011, and 2010.2. Comment on any trends, and compare the effectiveness of inventory managers at Polaris toinventory managers at its main competitor, Arctic Cat, where inventory turned over 5.4 timesin 2012 (67.6 days to sell). Both companies use the same inventory costing method (FIFO)
8.The ABC Boutique had the following information at June 30, 20X1: Inventory increased by P10,000 Purchase returns, P5,000 Freight in, P3,000 Sales, P300,000 Sales discount, P25,000 If the gross profit is 20% of net sales. How much is the gross purchases for June? 202,000 212,000 222,000 232,000
Q5 Libscomb Technologies' annual sales are $6,879,896 and all sales are made on credit, it purchases $3,179,857 of materials each year (and this is its cost of goods sold). Libscomb also has $565,311 of inventory, $545,421 of accounts receivable, and $422,365 of accounts payable. Assume a 365 day year. What is Libscomb’s Operating Cycle (in days)?
Inventory analysis Costco Wholesale Corporation (COST) and Wal-Mart Stores Inc. (WMT) compete against each other in general merchandise retailing, gas stations, pharmacies, and optical centers. Below is selected financial information for both companies from a recent year's financial statements (in millions): a. Determine for bom companies (1) the inventory turnover and (2) the days' sales in inventory. Round to one decimal place. b. Compare and interpret the inventory metrics computed in (a).
The business had 200 units in inventory at 1st February 2018 valued at RO 20. On 10th February Purchase made 400 units at RO 30 each. On 28th February Sales made 500 units at RO 40 each. What will be the cost of goods sold value at the end of February 2018 assuming that the business uses LIFO method? a. OMR 16,000 b. OMR 14,000 c. OMR 2,000 d. OMR 9,000
Suppose this information is available for PepsiCo, Inc. for 2020, 2021, and 2022. (in millions) 2020 2021 2022 Beginning inventory $2,100 $2,400 $2,500 Ending inventory 2,400 2,500 2,700 Cost of goods sold 19,350 20,825 20,280 Sales revenue 41,000 42,500 42,430 (a) Calculate the inventory turnover for 2020, 2021, and 2022. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2020 2021 2022 Inventory turnover enter an inventory turnoverenter an inventory turnover timesenter an inventory turnoverenter an inventory turnover timesenter an inventory turnoverenter an inventory turnover times
E8.7 (LO 3), AP Da Mug, a coffee-mug producer, generally conducts over half of its business in the last month of the calendar year due to holiday sales. By the end of December, its fiscal year-end, Da Mug had accumulated Cost of Goods Sold in the amount of $245,000. Da Mug’s business model is to maintain minimal WIP Inventory and FG Inventory, so these two accounts had balances of just $10,000 and $15,000, respectively, on December 31. Da Mug does hold a fair amount of RM Inventory, however, so it will be able to quickly fulfill its orders. As a result, its December 31 RM Inventory (all direct materials) is $80,000. Da Mug utilizes a normal costing system, in its effort to have timely applied MOH information for each custom job, and its budgeted MOH rate is $2.25/direct labor hour. Budgeted MOH at the beginning of the year was $150,000; actual MOH costs incurred by the end of the year were $140,000. Actual direct labor hours used were 61,000. Required 1. Was Da Mug’s MOH cost for…
PT. Mangane Kopi Nusantara (PT. MKN) produces green coffee bean. The company has found it increasingly difficult to keep accurate inventory and cash flows. Data:- Sales over last 30 days = $5,560,000,-- Accounts receivable at the end of the month = $587,250,-- Inventory value at the end of the month = $776,000,-- Cost of sales = 60 percent of total sales- Accounts payable at the end of the month = $456,000,- Calculate current cash-to-cash cycle for PT. MKN.