A specialty retailer has four different styles of umbrellas to stock and wants to maximize profits. It is

assumed that every one stocked will be sold. The variables measure the number of women's, golf,

men's, and folding umbrellas, respectively. The constraints measure storage space in units, special

display racks, demand, and a marketing restriction, respectively.

MAX $,4W+6G+5M+3\mathrm{.}5F$

SUBJECT TO

$2W+3G+3M+F,120$ Space

$1\mathrm{.}5W+2G,54$ Racks

$2G+M+F,72$ Demand

$G+M,12$ Marketing Restriction

Use the Excel output below to answer the questions that follow.

Excel Sensitivity Report:

Variable Cells

Final Reduced Objective Allowable Allowable