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:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Required:
b)
Also, what is the optimum base stock level?
Transcribed Image Text: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:
Transcribed Image Text: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:
Expert Solution
Step 1

Safety Stock 

Safety stock is a surplus of inventory kept on hand by the business to reduce the likelihood that it will run out of a particular item. Safety stock reduces the danger of losing clients or having to cease production even though it comes at an additional cost.

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education