Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Monte carlo inventory simulation excel

22/04/2021 Client: muhammad11 Deadline: 2 Day

Sewing Worth, Inc. (SWI) would like to develop an inventory policy that will minimize the total cost associated with the company’s inventory of sewing machines. The type of inventory policy they prefer involves a fixed Reorder Point and Order Quantity. The reorder point is the level of inventory at which an order is sent to the supplier. The order quantity is the amount ordered each time. These are decisions, but once selected, they will remain constant for the entire year (are not changed on a week-by-week basis). The current inventory policy is a Reorder Point of 1 unit, and an Order Quantity of 5 units. At this time, the company has a beginning inventory of 5 units. SWI faces an uncertain demand for these sewing machines each week, as shown in the following table:
Demand Per Week 0 1 2 3 4 5
Probability 20% 55% 10% 5% 5% 5%
Some relevant cost data is known. It costs $1 per week to hold each sewing machine in inventory and it costs $100 to place an order, regardless of the order size. When an order is placed it takes two weeks (assume the order is placed on the last day of the week if inventory is at or below the reorder point, and the order is received on the first day of the second week thereafter; thus there is a week that is skipped between order placement and receipt). The current estimated cost of a lost sale is $50. Build a simulation model for this problem. This will need to be a week-by-week model that utilizes beginning inventory and demand to determine sales, ending inventory, costs, and if an order is required to be placed (again, you should have all of these calculations for each week). Calculate the annual Total Cost (sum of ordering, lost sales, and holding costs) and annual Fill Rate (percentage of demand that is met with sales) to determine the impact of the inventory policy. Note: you will need to use some Excel functions to create this model.
Run the simulation model using the current decision values.
Copy and paste the charts, with statistics, for each Forecast to a new spreadsheet in your workbook (label the sheet ‘2a Charts’).
Using the model developed in Part a, SWI would like to determine if a better inventory policy can be found by using a Decision Table (you do not need to create a second version of the model to perform this task). They would like to look at changing the two Decision as follows: Order Quantity has a range from 1-20 (discrete), and Reorder Point has a range from 1-10 (discrete). Create a Decision Table for the Total Cost Forecast developed in Part a. Use both Decisions to create the table; test 20 values for Order Quantity and test 10 values for Reorder Point. Copy and paste the table over to a new sheet within your HW2 workbook and label the sheet ‘2b’. Answer the following question about the report:
What is the optimal combination of Order Quantity and Reorder Point that will minimize the Mean Total Cost? Highlight the optimal value in the table with a yellow cell color.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Tutor
Coursework Assignment Help
Peter O.
Write My Coursework
Pro Writer
Assignment Helper
Writer Writer Name Offer Chat
Top Academic Tutor

ONLINE

Top Academic Tutor

Give me a chance, i will do this with my best efforts

$22 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$31 Chat With Writer
Peter O.

ONLINE

Peter O.

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$40 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$26 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I have read your project details. I can do this within your deadline.

$31 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I will cover all the points which you have mentioned in your project details.

$41 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Increases air turbulence in the nasal cavity - English 1111 past papers - Describe the role of three external services during an emergency - Payment express response codes - Art discussion 2 - Strategic positioning attempts to achieve sustainable competitive advantage by - 12 bar blues composition project - Georgia parole grid sheet 2018 - Cook chill food service - Titanic case study ethics - Drake precision dental lab - Module 2 - Hair salon design layout - Carestart malaria kit insert - An n channel e mosfet conducts when it has - Phil week 2 - Discussion 7 - Swanson and associates presently leases a copy machine - Learn to jingle dance - Centurion d5 status light red - Learning english madhyamik english bliss lesson 6 sea fever - Mary wollstonecraft questions and answers - An autographed baseball rolls off - Super's life career rainbow - Part 1 and Part 2 - Southport state high school uniform - Performance appraisal system case study - Ambrose avenue group practice - Dunkin donuts organizational design - Open ended probability questions - Examples of intrapersonal conflict in nursing - Anthropology Discussion post - Car wash profit margin - Hr case study scenarios worksheet answers - Human brain clay model - Nur340vulnerable populationchoice - Assignment - Beare and ley website - Obo cable tray catalogue - Owen cunningham architect castleblayney - Most powerful type of computer - Bonaire ducted heating warranty - The Use of Enterprise Resource Planning (ERP) in a Manufacturing Company - Incidents in the life of a slave girl aunt martha - Cloud computing - CBT Therapy - Physics data sheet 2020 - Sheet resistance calculation example - Bayonne packaging case study solution - Sample performance improvement plan for attendance - Hog bristle half colour schemes - What is a voluntary statement to police - Business management capstone written project - The procedure for evaluating the pluses and minuses of a diversified company's strategy includes - She even cooks me pancakes - Caerphilly county borough schools - I need 1000 words essay in business through research internet - 5 2 way double pilot valve function - The outsiders characters physical descriptions - Eucon international university - Pdf xchange keyboard shortcuts - What is a gas thermometer used for - 5 c challenge problem accounting answers - Move their IT to the cloud - Mary poppins script free - Argumentative essay on cell phones in school - Brothers steps for forensic analysis - Budget Cycle - Defects in metal forming process pdf - Constructing a phylogenetic tree worksheet answer key - NEED IN 10 HOURS or LESS POWERPOINT - A baseball player reaches base 35 of the time - Marketing Analysis - History paper - Political factors affecting business - Case Study tomorrow at midnight - Facebook whatsapp acquisition case study - How to present appetizers attractively - Hillsboro health department - Aimé césaire une tempête pdf - Tx school for the blind - UNIT IV DQ MBA 6601 - Factoring polynomials word problems worksheet - Topics in Theory - Latex equation cheat sheet - Love Problem Solution In Canada +917657874622 - What are the eh bee family's real names - Using Access Control Lists to Modify File System Permissions on Windows Systems - Vehicle management system project in java - PCA Legal regulations compliance and investigation. - Common root words and word origins - How many electrons does rubidium have in its outer shell - Industry life cycle template - Http www edchange org multicultural speeches malcolm_x_ballot html - Lab 7: ecological interactions - Cap chap 3 - Supportive Psychotherapy Versus Interpersonal Psychotherapy - Ethical legal and professional issues in counseling 6th edition - Stat 200 assignment 1 descriptive statistics data analysis plan - Bsg comprehensive exam answers chegg