Question: Next, you are to perform some simulation analyses. Rather than using random numbers for these...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question: Next, you are to perform some simulation analyses. Rather than using random numbers for these simulations, you will use historical data for the arrival of cranberries and assume that the effective processing capacity does not vary over time. You should perform three separate simulations of the dryer area (show these neatly in three exhibits...design your spreadsheet so that you will be able to display it as a good exhibit with an easily readable font size). If you feel it is advisable to deviate from any of the operating policies indicated in the case (i.e. work schedules etc.), indicate your rationale in the body of your report and conduct the simulations in accordance with your changes. For the first simulation, use the current drying capacity, for the second, add one additional dryer and for the third, add two additional dryers. For each simulation, keep track (in hourly increments) of the arrivals of wet berries measured in bbls, the bbls processed that hour, the bbls that have not yet been dried ("inventory"), and the implied number of trucks waiting to unload if the bins are full. Use the following concepts in performing the simulations: Your arrival data should be created using the log of deliveries for September 25, 1995 given below (which you may assume is a representative day during the peak of the cranberry harvest). Calculate the percent of wet berries to be processed through the dryers as 72% of the total arriving berries. Total berry arrivals (wet and dry) for September 25, 1995 Time bbls arriving 7 am - 8 am 1907 8 am - 9 am 1504 9 am - 10 am 1423 10 am - 11 am 1445 11 am-12 pm 1512 12 pm-1 pm 1366 1 pm-2 pm 1530 2 pm-3 pm 1593 3 pm-4 pm 1478 4 pm - 5 pm 1411 5 pm - 6 pm 1282 6 pm - 7 pm 1055 Question Continued Based on 72% wet / 28% dry and should be a processing area rather than a storage area). | Please ignore Exhibit 1 on page 9 of the case. In lieu of that data, use the data in the table above for your simulation. Based on the data above, which totals 17,506 bbls arriving, please adjust one value in Exhibit 2 on page 10 of the case. The arrivals on September 25, 1995 should read 17,506 instead of 18,257. Once the holding bins are filled, the implied number of trucks waiting should be calculated. For each simulation, calculate the additional number of wet holding bins that would be required to eliminate waiting time for trucks (clearly identify this number in your simulation exhibit). Question: Next, you are to perform some simulation analyses. Rather than using random numbers for these simulations, you will use historical data for the arrival of cranberries and assume that the effective processing capacity does not vary over time. You should perform three separate simulations of the dryer area (show these neatly in three exhibits...design your spreadsheet so that you will be able to display it as a good exhibit with an easily readable font size). If you feel it is advisable to deviate from any of the operating policies indicated in the case (i.e. work schedules etc.), indicate your rationale in the body of your report and conduct the simulations in accordance with your changes. For the first simulation, use the current drying capacity, for the second, add one additional dryer and for the third, add two additional dryers. For each simulation, keep track (in hourly increments) of the arrivals of wet berries measured in bbls, the bbls processed that hour, the bbls that have not yet been dried ("inventory"), and the implied number of trucks waiting to unload if the bins are full. Use the following concepts in performing the simulations: Your arrival data should be created using the log of deliveries for September 25, 1995 given below (which you may assume is a representative day during the peak of the cranberry harvest). Calculate the percent of wet berries to be processed through the dryers as 72% of the total arriving berries. Total berry arrivals (wet and dry) for September 25, 1995 Time bbls arriving 7 am - 8 am 1907 8 am - 9 am 1504 9 am - 10 am 1423 10 am - 11 am 1445 11 am-12 pm 1512 12 pm-1 pm 1366 1 pm-2 pm 1530 2 pm-3 pm 1593 3 pm-4 pm 1478 4 pm - 5 pm 1411 5 pm - 6 pm 1282 6 pm - 7 pm 1055 Question Continued Based on 72% wet / 28% dry and should be a processing area rather than a storage area). | Please ignore Exhibit 1 on page 9 of the case. In lieu of that data, use the data in the table above for your simulation. Based on the data above, which totals 17,506 bbls arriving, please adjust one value in Exhibit 2 on page 10 of the case. The arrivals on September 25, 1995 should read 17,506 instead of 18,257. Once the holding bins are filled, the implied number of trucks waiting should be calculated. For each simulation, calculate the additional number of wet holding bins that would be required to eliminate waiting time for trucks (clearly identify this number in your simulation exhibit).
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
verizon communications Focus on the financial health of the company and the likelihood of achieving future success. Specifically, evaluate the company's capital structure, liquidity, profitability,...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
A cell uses 90 kg of a certain material each day. The material is transported in vats that hold 54 kg each. Cycle time for a kanban is about two hours. The manager has assigned a safety factor of...
-
Morocco Imports provided the following information regarding its inventory for the current year, its second year of operations. Compute Moroccos ending inventory and cost of goods sold under each of...
-
Sunset Boards is a small company that manufactures and sells surfboards in Malibu. Tad Marks, the founder of the company, is in charge of the design and sale of the surfboards, but his background is...
-
The New menu command clears any existing data from memory in preparation for setting up a new system. (True/False)
-
What are the major issues in this case? Assess Wal-Marts corporate social responsibility using the four-part CSR model. Is Wal-Mart socially responsible while it has a devastating impact on small...
-
6. In the reaction Cal2 (s) + Cl (g) ->>> O A. Both products are liquids. O B. Both products are solids. t CaCl2 (s) + 12 (s), what phases are the products in after the reaction? C. Cal, is a solid,...
-
Explain in detail to Juan all of the stages in an effective recruitment and selection (Talent Acquisition) program. In addition to your explanation, provide a list of three specific issues that may...
-
Consider the beam shown below. Using the 2D beam elements discussed in the notes, if two elements are used to model the system, what is the size of the global stiffness matrix after boundary...
-
The newest gadget model of ABC Co. will be released next month and will be sold for P21,000 per unit. Pre-release costs already incurred totaled P1,200,000. Forecasted data over the product life...
-
Use the following information to answer the next two questions Chris has a custom curtain and chair cover shop. The job-costing system was designed using an activity-based approach. There are two...
-
Compare two companies; use the following sample and two companies to compare Comparison Abbot Labs vs. Johnson & Johnson what you have to do: 1. Lines of business 2. Sales 2021 3. Capital structure...
-
A company is planning its capital budget over the next several years. There are ten projects under consideration. A calculation has been made of the expected net present value of each project, along...
-
Read the case study below and answer the questions Consumer Research at Procter & Gamble is considered a science When Procter & Gamble conduct qualitative consumer research to generate new ideas,...
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
Explain the trade-offs that inventory managers face when they reorder products or supplies. How is the reorder point computed?
-
Supply-chain management involves long-term partnerships among channel members that are working together to reduce inefficiencies, costs, and redundancies and develop innovative approaches to satisfy...
-
Assume that you are responsible for the physical distribution of computers at a web-based company. What would you do to ensure product availability, timely delivery, and quality service for your...
Study smarter with the SolutionInn App