Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1: The True Morels Morchella (the true morels), found in the temperate Northern Hemisphere, are one of the most expensive fungi in the world

image text in transcribed
Problem 1: The True Morels Morchella (the true morels), found in the temperate Northern Hemisphere, are one of the most expensive fungi in the world ht s:..='..-'e11.wiki edia.org.-"'wiki..='l\\-*Iorchella . Morchella are rich in proteins, vitaminS, fats, carbohydrates, amino acids, and minerals. Their unique avour is highly admired by gourmet cooks worldwide. However, Morchella are difcult to cultivate at large scale, and the Morchella industry relies on the harvest of wild mushrooms. Every spring, your friend Joey in Michigan goes out foraging for Morchella in the mornings when there is no rain. The probability of precipitation is about 26% in any given day. Fresh Morchella sell quickly in the local farmer's market. The Morchella season lasts for about 90 days and Joey is asking your help to plan the costs to forage, store and transport the highly prized musln'ooms. When there is no rain, J oey' s daily harvest can be modeled by a Triangular distribution, with the minimum value of 8 pounds, the maximum value of 26 pounds, and the peak value of 20 pounds. When it is raining, Joey does not go out foraging for Morchella, brrt his next no-rain day's harvest (regardless of the number of days of continuous raining) would increase by about 50% (that is, a Triangular distribution, with the minimum value of 12 pounds, the maximum value of 39 pounds, and the peak value of 30 pounds). Joey sells the fresh Morchella in the afternoons at a local farmer's market for about $3 Sfporurd. The daily demand can be modeled with a normal distribution with mean of 19 pounds and standard deviation of 5 pounds. Any unsold Morchella have either to be dried in a special dryer in the evening, or to be stored in a very special container to avoid spoilage. The special dryer can be rent for $20 per day. The cost to dry the Morchella is $15 per batch, where each batch consists of at most 1 pound of fresh Morchella. The dried Morchella weigh about 1/10 of the fresh ones. At the end of the 90 days Joey will sell all the dried Morchella overseas for $240 per pound. Alternatively, Joey can rent a special container to store the unsold Morchella at the exact right conditions and temperature. Morchella preserved in the special container have the same qrrality and freshness as the newly harvested ones for many days. This allows Joey to sell any leftover Morchella the next day. A small container can hold up to 5 pounds of Morchella and costs $12 per day, and a large container can hold up to 20 pounds of Morchella and costs $20 a day. The electricity cost of storing the Morchella in the special container is about $4 per pound of Morchella per day. Any Morchella not stored in the special container nor dried deteriorate quickly and Joey will just cook them for dinner. Joey is considering the following strategies: Rent the small container for 90 days Rent the large container for 90 days 1 2. 3. Rent both 4 Rent the drier for 90 days to dry any excess Morchella each day Which strategy should Joey adopt? Use @Risk simulation to build a single model and answer the above question. Use a sample size of 1000 for each scenario

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Creating Value With Data Analytics In Marketing Mastering Data Science

Authors: Peter C Verhoef, Edwin Kooge

2nd Edition

1000465462, 9781000465464

More Books

Students also viewed these General Management questions

Question

What elements of multimedia-based instruction facilitate learning?

Answered: 1 week ago