Ireland Assignments .ieIRELAND.ieASSIGNMENTS
Order Now Log In
  • Home
  • Services
    Writing Services
    • Essay Writing Services
    • Dissertation Writing
    • Thesis Writing Service
    • Literature Review Writing
    • Research Paper For Sale
    • Report Writing Assistance
    • Do My Assignment
    • Write My Essay
    • Buy Assignments Online
    • Irish Homework Help
    AI Support & Referencing
    • Assignment Review Service
    • AI-Free Assignment Help
    • Remove AI From Your Assignment
    • Citation and Referencing Help
    • AI Guidance for Students
    Assignment Type
    • Learner Record Writing
    • Skill Demonstration Assignments
    • Work Experience Diary
    • Reflection Journal
    • Online Exam Help
    • QQI Level 5
    • QQI Level 6
    Course
    • Nursing
    • Childcare
    • Healthcare
    • SNA (Special Needs)
    • Care of Older People
    • Child Development
    • Care Skills
    • Care Support
    • Disability Awareness
    • Infection Prevention
    • Health & Safety at Work
    Online Degree Course
    • Psychology Assignments
    • Early Childhood QQI Assignments
    • Montessori Assignments
    • Palliative Course Assignments
    • Communications FETAC Level 5 Assignments
    • Law Course Assignments
    • Management Assignments
    • Train the Trainer
    • Healthcare Assistance
    • Digital Marketing Assignment
    • QQI Assignments
    Cities
    • Dublin
    • Galway
    • Cork
    • Limerick
    • Waterford
    • Sligo
    • Dundalk
    • Carlow
    • Maynooth
  • Samples
  • Experts
  • Questions
  • Blog
  • Reviews 4.9/5
Order Now Log In
Search from Thousands of
Ireland Assignments Answers
  • 463+ Experts
  • A+ Grade
  • Free Turnitin Report
  1. Home
  2. Questions
  3. Supply Chain Simulation – Demand, Safety Stock & Service Levels

Supply Chain Simulation – Demand, Safety Stock & Service Levels

University Technological University Dublin (TUD)
Subject Logistics and Supply Chain Management

Assignment:

  1. Choose one of the wholesalers
  2. Choose Service level (SL)
  3. Evaluate Safety Stock taking into account the demand uncertainty (estimate demand during lead time)
  4. Provide calculations and explanation
  5. Run a simulation experiment and observe the SL
  6. Explain simulation results

Problem solution

The simulation tool is Excel. You can solve this task in the PC class after the break.

Number of simulated lead time periods – 500
Random demand simulation using
=randbetween(min,max) function

  1. Simulate daily demand d for three particular days
  2. Calculate demand at lead time DL for L=3 as a sum of three independent daily demand values
  3. Repeat the calculations 500 times
  4. Design a histogram of DL
  5. Evaluate the safety stock for 95% SL

Histogram creation from simulated data

Simulation results

Simulation number Demand at Wholesaler
First day Second day Third day Demand at Lead Time (sum of all)
1 19 16 28 63
2 20 23 15 58
3 17 26 23 66
4 20 20 15 55
5 18 24 23 65
6 14 21 17 52
7 22 24 18 64
8 21 24 16 61
9 25 13 13 51
10 14 14 23 51
11 22 14 12 48
min DL = 38, max DL = 82
Average DL = 58.6,
DL standard deviation
σDL = 8.03
Are You Searching Answer of this Question? Request Ireland Writers to Write a plagiarism Free Copy for You.
Get A Free Quote

Histogram creation from simulated data

Data table (may be created using EXCEL array function Frequency or Data Analysis tool Histogram):

Bin Lower bound Upper bound Number of DL observations Histogram of simulated DL
Demand at leadtime
1 36 40 6 0.012
2 40 44 11 0.022
3 44 48 31 0.062
4 48 52 66 0.132
5 52 56 91 0.182
6 56 60 91 0.182
7 60 64 86 0.172
8 64 68 61 0.122
9 68 72 36 0.072
10 72 76 14 0.028
11 76 80 5 0.01
12 80 84 2 0.004

Safety stock as a percentage of lead-time demand

Average DL = 58.6, DL standard deviation = 8.03

Service level agreement is 95% (0.95 probability that the ordered goods are available at stock)

Estimated analysing simulation results Safety stock (SS) 17,
i.e. ~4.2% of DL values are larger than average + SS (or 58.6 + 17).

Calculated assuming that our DL is normally distributed

SS = z·σ = 1.64·8.03 = 13.2 ≈ 13

DIC_XIM

A SUPPLY CHAIN SIMULATOR. Parameters

Factory warehouse Distribution center W1 W2 W3
Warehouse capacity 4000 1000 200 200 200
Initial inventory 2000 200 50 20 20
Transportation time L 8 3 3 3
Backorder No No Yes
Backorder cost 4.5
Fixed order costs Ca (administrative costs) 700 40 40 40
Holding costs (per day) Ch 0 0.75 1 1 1
Holding costs (Overstock) 0 1.5 2 2 2
Average demand D 20 6 5
Costs of goods sold/price 72 115 115 115
Trucks 2 5
Truck capacity 260 100
Truck costs 18 5
Fixed period costs (per day) 70

A Supply Chain Simulator. Dayly Demand

  • Demand per Period (Day)
    W1 Uniform between 12 and 28
    W2 Uniform between 4 and 8
    W3 Uniform between 1 and 9
  • Client 1
  • Client 2
  • Client 3

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get A Free Quote

A Supply Chain Simulator Safety. Stock

  1. Choose one of the wholesalers
  2. Choose Service level (SL)
  3. Evaluate Safety Stock taking into account the demand uncertainty (*estimate demand during lead time)
  4. Provide calculations and explanation
  5. Run a simulation experiment and observe the SL
  6. Explain simulation results
  7. Provide your individual report with conclusions in ORTUS by the next lesson

A SUPPLY CHAIN SIMULATOR. Demand during lead time

Estimate demand during lead time:

  1. Demand during lead time (DL) is a random variable with unknown distribution function;
  2. Lead time is known and is constant;
  3. Reorder period and Lead time are not the same and may be different.
  4. DL distribution function can be estimated theoretically or by Excel simulation; Use the distribution from the previous practical assignment “Safety Stock”
  5. To use the calculations provided in the lecture we need to confirm that DL is a normally distributed random variable;
  6. For safety stock calculation we need the mean value of DL and the demand standard deviation σDL;
  7. After Safety Stock calculation we need to formulate the strategy principles for implementation with the SC simulator to provide the necessary SL.

Average DL = 58.6, DL standard deviation = 8.03

Service level agreement is 95% (0.95 probability that the ordered goods are available at stock)

Estimated analysing simulation results Safety stock (SS)
≈ 17, i.e. ≈ 4.2% of DL values are larger than average
+ SS (or 58.6+17).

Calculated assuming that our DL is normally distributed

SS = z · σ = 1.64 · 8.03 = 13.2 ≈ 13

Standard Normal distribution

Z ∼ N(μ, σ) = N(0,1)

Excel function = NORM.DIST(z value, 0, 1, FALSE)

Stuck in Completing this Assignment and feeling stressed ? Take our Private Writing Services

Get A Free Quote

Shared with
Ireland Assignments Editorial Team

A student shared this brief with our team; personal details have been removed. Our editorial team works on tasks like this and can guide you on how to approach it.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Buy Now
Related Questions
  • LOGT9404 Design and Management of Logistics Systems Main Assignment 2026-27: Efficient vs Effective Digital Supply Chains | TU Dublin
  • TU378 Supply Chain Simulation and Business Process Modelling CA1 2026: African Supply Chain Process Research Paper | TU Dublin
  • VOMP3011 From URS to PQ: P&ID-1 Bioreactor Sketch and Performance Requirements Assignment (TU Dublin)
  • Strategic Operations Management Individual Assignment (25%) 2026: Penang Mutiara, Long Ridge, Dell and Fast Fashion Case Questions (TU Dublin)
  • LOGT9042 Logistics and Supply Chain Management Fundamentals Engagement Activity 2: Case Study Reflection 2026 (TU Dublin)
  • SMCOH3023 Performance Analysis Assessment Brief 2026 | TU Dublin
  • H4011 Research Methods Repeat Continuous Assessment 2026 | TU Dublin
  • Field Survey & Mapping Assignment 2026 | Technological University Dublin
  • Business Research Proposal Assessment 2026 | Technological University Dublin
  • Social Care L7 & L8 Creative Skills 1 Assessment Semester 2 2026 | TU Dublin
  • INTE 2003 Modernism and Modernisms – Interior Design Assignment 2 2026
  • SOCI06039 Professional Social Care Practice 2.2 Assignment Individual Essay 2026 | TU Dublin
  • INNT9001 Innovation Management Assignment Brief 2026 | TU Dublin
  • NRM2 Quantity Surveyor Assignment Task 1 2026 | Technological University Dublin
  • VOMP3001 Fundamentals of Pharmaceutical Manufacturing Technologies Assignment Essay
  • TU721 Aviation Technology Assessment 1 – Commercial Aircraft Maintenance Management
  • REEN 2215 Renewable Energy Technologies Assignment 2025-26 | TU Dublin
  • Marketing 2025 Continuous Assessment Brief Report- Technological University Dublin
  • MANG1708 Introduction to Customer Care Individual Assignment Essay – Technological University Dublin (TU Dublin)
  • BSMT9005 Customs & International Trade Assignment – Technological University Dublin TUD
Get the Answer to This Question

Tell us about your assignment in 3 quick steps and get a free, no-obligation quote.

1 Basics 2 Details 3 Contact
The basics
Over 10,000 words? Choose 10,000+ and type your exact count.
Step 1 of 3 · takes under a minute
About your assignment
What help do you need?
Do you have the brief or marking rubric?
Step 2 of 3 · last step is your contact details
Where should we send your quote?
Attach your brief, rubric or notes (optional, up to 10 files)
PDF, Word, PowerPoint, Excel or images · up to 100MB in total
Uploading…
Free quote No payment to submit 100% confidential

To Get Answer
Please Fill the following Details

If you think the question is incomplete, then you can upload your assignment brief.

Facing Issues with Assignments? Talk to Our Experts Now!Download Our App Now!

Request a Call Back
Irish assignment expert ready to help a student

Have Questions About Our Services?
Download Our App!

Get the App Today!

iphone android
QRcode
Ireland Assignments .ieIRELAND.ieASSIGNMENTS

Ireland Assignments

Ireland Assignment's offers plagiarism free assistance to the students around the globe. We understand the value of top grades to a student. And that is the reason we are here to assist you with ultimate professionalism. By availing our services we assure you better grades. Raise your academic grades with our Ireland assignment help.

Useful Links

Useful Links

Useful Links
  • Home
  • Services
  • Samples
  • Blog
  • User Reviews
  • Questions
  • Experts
  • Submit Questions
Legal & Policies

Legal & Policies

Legal & Policies
  • Privacy Policy
  • Warranty
  • Copyright Notice
  • Terms & Conditions
  • About Us
  • Contact Us
  • How Ordering Works
  • University Assignment Help
  • Final Year Project Help
  • Semester Assignment Help
  • Social Care Project Help
  • Care of the Surgical Patient
Cities

Cities

Cities
  • Dublin
  • Galway
  • Cork
  • Limerick
  • Waterford
  • Sligo
  • Dundalk
  • Carlow
  • Maynooth
GDPR
info@irelandassignments.ie
Secure Payment

77 Camden Street Lower, Dublin, D2 XE80, Ireland

Student Login·Facebook

Disclaimer: Ireland Assignments provides academic assistance to students so that they can complete their university assignments and projects on time. Our business does NOT deal with ghostwriting services as we are aware of this being one of the academic misconducts. But we do help students by connecting them to online subject experts within an affordable price range. Also, if you're looking for high-quality resources such as journals and articles, pdf files, videos, research papers, e-books, and other secondary literature to write your assignment task, then we can certainly help you out. Ireland Assignments is not sponsored or endorsed by (Ireland) Quality and Qualification Ireland or any college or university in Ireland or elsewhere in the world. All trademarks, logos and brand names are the property of their respective owners. All university related assistance services, materials and their names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Ireland Assignments rated 4.9/5 based on 15,000+ student reviews on WhatsApp

Copyright © 2026 Ireland Assignments, All Right Reserved