Assignment: Business Process Management
In this homework, you'll work with a simple, discrete simulation model of a fictitious business called "Last-Minute Gifts".
To successfully complete this homework, we strongly advise that you follow the following procedure:
• The homework is based on Microsoft Excel 2003, 2007 or 2010 and so on (your choice) running on Microsoft Windows.
• For these spreadsheets to work an "add-in" called Analysis Toolpak must be installed on Microsoft Excel. All COB computers already have it. If you are using your own computer and do not have the Analysis Toolpak added in, you can add that by going to Excel's Help (F1) and typing "Analysis Toolpak".
• Although this spreadsheet will run on Microsoft's Mac version of Excel, it is a little harder to make it work nicely. Hence, we advise you to run this homework on a Windows machine.
• Carefully read the assignment and make sure that you understand its logic.
• Study the simulation model associated with the problem. Make sure you understand what the spreadsheet shows and how you can use it before (!!) you use it to answer the questions.
• If reading the problem and studying the spreadsheet causes you problems or if you lose track of things, first review your notes from class and see if your classmates can help you. If you remain stuck, see your instructor.
Background
One of the costs of doing business is work-in-progress (WIP) inventory; i.e, work that is in progress but not yet ready to be sold. The value of this 'inventory' is often known as holding cost. The holding cost for a business is the cost for storing and keeping track of the inventory and any finance costs incurred in borrowing the money to pay for the inventory until it can eventually be sold and the expenses recovered.
The holding cost increases as the inventory moves forward through the process chain, with inventory at the next step worth more than at earlier steps. This is because every step adds some more value to the inventory. The total holding cost associated with WIP is, therefore, a function of the holding cost at each step and the time duration for which inventory is held at each step before it is moved to the next step.
To compute the holding cost at each process step, one typically multiplies the WIP quantity at that process step by it's per unit holding cost at that step.
Your simulation model simulates a five-step process employed by the "Last-Minute Gifts" company for preparing gift assortments for delivery to holiday customers. Each gift that customers order goes through these five steps in the following order:
1. Checking the order against available items in stock.
2. Selecting the right box and packing materials.
3. Retrieving the set of items from the warehouse stock.
4. Assembling the gift in the box.
5. Closing the box and completing the documentation for delivery and sending the completed invoice to order processing.
Task
Using Simulation1.xls, we're going to evaluate the effects of changing capacities on holding cost. To do this, you will need to run several simulations: one to estimate the holding cost with the current capacities and several others to estimate the holding cost with other capacity values. You can change the capacities by changing the maximum and/or minimum capacity values in the Decision variables box at the top of the Model sheet.
Answer the following questions by typing them in a word document:
1. Would you expect holding cost to go down with increases in maximum capacity? Explain your answer.
2. Could the actual pattern be different from the expected one? Explain your answer.
3. Run your model to test your hypothesis formulated under question 1. What happens to the holding costs when you increase the maximum capacity for all five process steps from 6 to 7? Do the holding costs follow the expected pattern? If not, why not? In your answer consider both the mean of and variation in holding costs. Also consider the percentage of shipped gifts?
4. Would you expect the capacity increase to have an effect on slack (idle capacity)? Would you include slack effects in your decision to increase or not increase capacity? What, according to your model, will be the effect of the capacity increase on slack?
5. What happens with holding cost and slack when instead of increasing the maximum capacity for all steps from 6 to 7, we increase the minimum capacity for all steps from 1 to 2? Why is the effect on holding cost of changing the minimum capacities by 1 so much bigger than the effect of increasing the maximum capacities by 1?
6. Next, instead of setting the maximum capacity of all steps in the process from 6 to 7, set only the maximum capacities of steps 4 and step 5 to 7 while leaving all others at 6. Also, at the same time, set the minimum capacity back to 1. What do you observe when you run the model?
7. Make a recommendation for the optimum capacity at each step for this business. In your analysis, carefully consider averages, minimum values, maximum values and variation. (Hint: You may want to try some model runs with capacity configurations other than the ones we have recommended above. Keep in mind that a hold at step 5 ($7) is seven times as expensive as a hold at step 1 ($1). Also keep in mind that as you hold fewer gifts, you have to tell fewer customers that their gift orders are not yet ready and that they have to come back the next day - meaning more satisfied customers.)
Along with your answers, also turn in the revised excel workbook that has the following summary sheets with:
1. All minimum capacities at 1 and all maximum capacities at 6.
2. All minimum capacities at 1 and all maximum capacities at 7.
3. All minimum capacities at 2 and all maximum capacities at 6.
4. All minimum capacities at 1, the maximum capacity of only steps 4 and 5 at 7, and the other steps at a maximum capacity of 6.
5. Your preferred capacity settings.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Simulation.rar