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

Ikea transformational leadership - Cyber Security - Shipley glen pleasure grounds - Three necessary ingredients for thunderstorm formation - Rb25 maf wiring diagram - Career spectrum scavenger hunt - Principles of marketing. (Business Buying Behavior) - Characteristics of the four market structures - Python program for rail fence technique - Nsw department of education adobe - Leadership and governance definition - Humanity - Assessment 3: Digital Forensic Report This document supplies detailed information on assessment tasks for this unit. - Final Paper - Need help on accounting homework - Ops 571 statistical process control methods - Mary kay cosmetics case study - Do crocodiles have opposable thumbs - Psychology - Volvo penta 4.3 gxi fuel consumption - Https www netacad com create account - Icf guidelines speech therapy - 7/265 ocean drive port macquarie - History Essay Writing - Macrobertson girls high school history - Creo parametric 2.0 manual pdf - Environmental Health - Quadrat method for estimating population size - What is step voltage - Assignment - Rounding to significant figures - Century national bank case study answers - Team vs individual work - Post adjusting entries to the t accounts problem 4 8a - Stickleback evolution lab answers - Diet and wellness plus diet analysis program - Synchronous motor and generator - Espn swot analysis - An object's inertia is its tendency to maintain a constant: - CRIJ 2313 - If a cosmetics company is selling an eye shadow priced at $11.99 rather than $12, it is using: - Life history interview essay - Animal farm chapter 9 summary - In flowchart parallelogram is used to show - Bone timber supplies adelaide - Topic 6 DQ 1 - First act lola ce140 - Burton's royal edinburgh luxury shortbread - Age of reason literature authors - Property valuation report pdf - Read and answer 3 questions - Taussig technologies corporation has been - Request additional tax deductions at source - 4 questions to three readings: briefly respond to each of these questions in three or four sentences. - Girl FRiend ((LOVE)) vashikaran +91-7023339183 specialist molviji - Beta management company case excel - Data archiving in sap bw - Negotiation story - Herbie archie weller full story - How to write a history essay - Epidermal layer containing the oldest cells - The best leadership style for unfavorable conditions is - Psychology - Final Project - Temperature coefficient of platinum resistance thermometer experiment - Edexcel gcse mathematics linear 1ma0 - Gx gallup com gue gx - Columbia university graduate school of journalism notable alumni - Rotter incomplete sentence blank child - Systems thinking in nursing - Elijah of buxton timeline - Lse past exam papers - In the last line of "god's grandeur," we see an unusual and complicated use of - Pracconnassignoperations - The divine command theory implies that - Generation like reflection - Two sinusoidal waves with the same amplitude - HR Discussion post - Gas laws virtual lab answer key - Sat vocabulary lesson and practice lesson 4 pdf - Ruler drop test disadvantages - Mila Jefferies - Module 03: Performance Management Paper Submit Assignment - Air hose festoon system - History of geography ppt - P6#2 - How to make a bindi dot - Pdp samples for teachers - Advantages of core cutter method - Fun facts about epithelial tissue - Lab safety escape room - Grace to you sermon - Leasing Decisions - Compare and contrast macbeth - Give me liberty an american history 5th edition pdf - Critical study of literature year 11 - Paulo Case Scenario: Independent Living Mini Unit - Ethical issues in coaching - 560 paper - I need guest post on your site