Statistics Solutions

(Steps Shown) [20 pts] The local Office of Tourism sells souvenir calendars. The head of the office, Lucy, needs to order these calendars in advance of the

Question: [20 pts] The local Office of Tourism sells souvenir calendars. The head of the office, Lucy, needs to order these calendars in advance of the main tourist season. Based on past seasons, Lucy has determined the probability of selling different quantities of the calendars for a particular tourist season.

Demand for Calendars Probability of Demand
75,000 0.15
80,000 0.20
85,000 0.25
90,000 0.30
95,000 0.10

The Office of Tourism sells the calendars for $12.95 each. The calendars cost Lucy $5 each. The salvage value is estimated to be $0.50 per unsold calendar. Determine how many calendars Lucy should order to maximize expected profits.

  1. Solve using EXCEL. Use formulas to compute the profit for the various combinations of purchase quantity and demand.
  2. Also, remember to provide a written response to the question posed in the problem.

Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in