Homework Help is Here – Start Your Trial Now!
Business
Accounting
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 2019 2020 Required: 500 units £1,200 750 units £1,700 1.250 units £2,700 a) If the increased demand seen so far in 2021 continues, what is the the optimum order size you would recommend to Simeon? b) Also, what is the optimum base stock level? 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.

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 2019 2020 Required: 500 units £1,200 750 units £1,700 1.250 units £2,700 a) If the increased demand seen so far in 2021 continues, what is the the optimum order size you would recommend to Simeon? b) Also, what is the optimum base stock level? 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.

Cornerstones of Cost Management (Cornerstones Series)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter16: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 35P
See similar textbooks
icon
Related questions
Question
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: E EE 2018 500 units £1,200 2019 750 units £1,700 2020 1.250 units £2,700 Required: a) If the increased demand seen so far in 2021 continues, what is the the optimum order size you would recommend to Simeon? b) Also, what is the optimum base stock level? 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.
Transcribed Image Text: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: E EE 2018 500 units £1,200 2019 750 units £1,700 2020 1.250 units £2,700 Required: a) If the increased demand seen so far in 2021 continues, what is the the optimum order size you would recommend to Simeon? b) Also, what is the optimum base stock level? 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.
Expert Solution
steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Revenue Recognition
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SEE MORE TEXTBOOKS