5-2 Final Project Milestone 4: Optimization & Decision Making Organic Red White # of Bottles Revenue 0 $30.00 0 $20.00 0 $20.00 $0.00 Production cost $6.30 $2.40 $3.40 $0.00 Profit Constraints Grapes $23.70 $17.60 $16.60 $0.00 2.50 2.50 2.50 0.00 <= 100,000 0.00 <= 6,000 0.00 <= 16,000 0.00 <= 16,000 Max Bottles Organic Max Bottles Red Max Bottles White 1 1 1 LHS Sign RHS Ceilings: Type Organic Wine Red Wine White Wine Total lbs of grapes per bottle total lbs of grapes avail. Price for Organic Wine ($) $30.00 Bottles 6,000 16% 16,000 42% 16,000 42% 38,000 2.5 100,000 Price for Red Wine ($) $20.00 Price for White Wine ($) $20.00 C. Create a decision tree or table for management to support your recommendation that takes into account your D. When presenting your answers to the questions above, did you: i. Present the information accurately and logically? ii. Choose tables and graphics that will best communicate the information to the relevant stakeholders? iii. Properly color, label, and proportion the graphics? takes into account your estimation of the probabilities and likely outcomes for alternative states of nature. e relevant stakeholders? Sales $11,221 $8,758 $7,642 $6,326 $6,312 $3,986 $4,369 $9,990 $3,020 $11,146 $7,498 $7,498 $9,432 $6,685 $6,061 $3,877 $9,121 $8,681 $6,981 $6,262 $7,390 $4,670 $9,248 $7,451 $5,686 $10,399 $11,310 $10,497 $3,390 $8,535 $3,287 $5,761 $8,559 $9,010 $7,472 $4,827 $10,898 $4,168 $8,305 $9,837 $3,913 $9,887 $5,546 $5,605 City Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego Date Jun May Mar Feb May May Feb May Jan Jun Apr Apr May Apr Jan Jan Mar Jun Jun Mar May Jun Apr Feb Jan Mar Feb May Feb Jun Jan Jun May Feb Feb Jun Apr Mar Feb May Jan Jan Feb Jun Sales Rep Joe Jane Bill Joe Joe Jane Jane Joe Jane Joe Joe Jane Bill Joe Jane Jane Jane Jane Jane Bill Jane Joe Joe Bill Joe Joe Joe Bill Bill Jane Jane Bill Jane Jane Bill Jane Jane Joe Jane Bill Joe Joe Bill Jane Type Wine Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Type Organic Red White totals Sales $166,174 $299,361 $301,704 $767,239 % 22% 39% 39% $9,525 $11,649 $8,703 $5,582 $8,581 $11,552 $11,482 $7,515 $8,722 $9,112 $8,197 $9,779 $10,157 $5,286 $6,437 $9,332 $3,407 $5,936 $7,913 $8,507 $6,077 $4,908 $7,373 $6,388 $10,694 $8,516 $11,498 $9,133 $5,437 $11,667 $5,217 $4,641 $10,440 $11,953 $11,959 $9,549 $9,014 $7,177 $8,950 $7,914 $4,716 $8,573 $10,424 $4,652 $4,031 San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Diego San Francisco San Francisco San Francisco San Francisco San Francisco Jun Mar Apr Apr Jan Apr Jun Apr Jan May Jan Jun May Jan Jun Apr Jan Feb Jun Mar Apr Feb Feb Apr Jan May Jan Mar Feb Apr Apr Jun Jan May Jan Mar Feb Apr May Feb Feb Mar Apr Jan Feb Jane Jane Jane Joe Joe Jane Jane Bill Joe Bill Joe Bill Joe Joe Bill Bill Bill Bill Jane Joe Bill Jane Joe Bill Joe Bill Bill Joe Joe Bill Bill Bill Jane Joe Jane Jane Bill Bill Jane Joe Joe Bill Bill Jane Bill Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red Red White White White White White White White White White White White White White White White White White White White White White White White White White White White White $4,031 $4,788 $4,276 $8,587 $5,607 $11,029 $5,294 $7,879 $7,763 $10,919 $8,274 San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco San Francisco Feb May Apr Jan Jun Jan Jan Mar Jun Feb Mar Jane Jane Joe Bill Joe Bill Jane Jane Jane Joe Bill White White White White White White White White White White White