Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience,

The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience, the demand for bananas is expected to be 100, 150, 200, or 250 pounds with the following probabilities: 100lbs 0.20; 150lbs 0.25, 200lbs 0.35, 250lbs 0.20. The bananas cost the store $.45 per pound and are sold for $.085 per pound. Any unsold bananas at the end of each week are sold to a local zoo for $.30 per pound. Use your knowledge of decision analysis to model and solve this problem in order to recommend how many pounds of bananas the manager should order each week

Please show work and the functions it took in EXCEL to answer the problem.

Step by Step Solution

3.50 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

this problem in Excel we can use the concept of decision analysis and create a decision tree to model the different scenarios and calculate the expect... 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

Business Statistics

Authors: Robert A. Donnelly

2nd Edition

0321925122, 978-0321925121

More Books

Students also viewed these General Management questions

Question

Do I make impulse purchases during my surfing sessions?

Answered: 1 week ago