In-Lab Worksheet 3

In-Lab Worksheet 3 - BUSI 410 Lab Session #3 As we...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSI 410 Lab Session #3 As we discussed in class, analyzing a business problem using simulation requires three steps: Develop a spreadsheet which does the calculations needed. Let Crystal Ball simulate many trials using the spreadsheet. If there are decision variables in your model, use Crystal Ball’s Decision Table tool to determine the “best” values for your decision variables. This lab practice exercise uses the Assembly Line (B) case to lead you through this process. It is a somewhat simplified example of how companies use simulation to manage inventories. Assembly Line (B) Read this case on pp. 55-56 of your course pack – ignore p. 57. Download (do NOT simply open!) the Excel template for this problem from Blackboard – Assignments | Lab Practice Assignments | Assembly B Template. Then start your copy of Crystal Ball and open this file. The model template has been set up with all the labels (in column A) you will need to do your analysis, the input/starting values, the probability distribution of demand (B32:C46), and columns B through CW which contain the 100 week numbers and will contain the formulas you will need to do your analysis. Note that the first week’s Monday Morning Inventory value and the Week 1 and Week 2 Shipments values, as given in the case, have also been inserted. Start building your model by entering the Week 1 demand distribution in cell B16. Click on cell B16, then select Crystal Ball’s Custom Distribution option. (Click on “Define Assumption” and select Custom.) Click on the “More” button (to the right of the Name: window) until you see the Load Data . . . button. Click on that, then in the dialog box that opens, click on the button at the right end of the “Location of data:” window. The Cell Reference dialog box will open. Highlight the probability distribution of demand (both the demand values column and the probabilities column, but no labels, cells B34:C46). Important: Press the F4 key until the B34:C46 cell addresses in the “Cell Reference” dialog box are completely absolute ($B$34:$C$46), then click OK. Make sure the “Keep linked to spreadsheet” box is checked, then click OK two more times to complete the specification. Now enter the appropriate Excel formulas in cells B15, B17 through B23, C13, C18 and D14:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/06/2010 for the course BUSI 410 taught by Professor Massa during the Fall '09 term at UNC.

Page1 / 4

In-Lab Worksheet 3 - BUSI 410 Lab Session #3 As we...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online