Draw an influence chart to help develop a spreadsheet model


In order to plan for an upcoming fish drought, the government of a South Pacific island is trying to build a model to determine the amount of profit that can be made from fishing. The island has a population of 40,000. Each resident eats an average of 0.5 lbs of fish/day. Any excess fish that is brought in can be sold to exporters for $8/lb. Fish costs $1/lb to bring on-land. Currently, there is a monthly supply of 1M lbs of fish. However, the islanders prefer to not fish more than 80% of the available stock. Because the upcoming drought, supply is expected to decrease by 5%/month over the next year.

Draw an influence chart to help develop a spreadsheet model for the profit over the next year.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Draw an influence chart to help develop a spreadsheet model
Reference No:- TGS02921644

Expected delivery within 24 Hours