ManuelV_EE6

Windows Adding Solver File Options Add-Ins Excel Add-Ins >> Go Solver >> OK Adding Developer File Options Customize Ribbon Main tab (on right) Check Developer item

Macs

Product Revenue Share Revenue/Car Cars Sold Camry $1,500,000 16.2% 1200 1250 Corolla $3,000,000 32.4% 1000 3000 Prius $1,950,000 21.1% 1500 1300 Tacoma $2,806,000 30.3% 2300 1220 Total $9,256,000 6770 Average Revenue / Car $1,367.21 Product Revenue Share Revenue/Car Cars Sold Camry $1,927,017 19.9% 1200 1605.84743 Corolla $3,000,000 31.0% 1000 3000 Prius $1,950,000 20.1% 1500 1300 Tacoma $2,806,000 29.0% 2300 1220 Total $9,683,017 7125.84743 Average Revenue / Car $1,358.86 Product Revenue Share Revenue/Car Cars Sold Camry $1,500,000 16.2% 1200 1250 Corolla $3,000,000 32.4% 1000 3000 Prius $1,950,000 21.1% 1500 1300 Tacoma $2,806,000 30.3% 2300 1220 Total $9,256,000 6770 Average Revenue / Car $1,367.21 Product Revenue Share Revenue/Car Cars Sold Camry $1,500,000 10.0% 1200 1250 Corolla $3,000,000 20.0% 1000 3000 Prius $1,950,000 13.0% 1500 1300 Tacoma $8,550,000 57.0% 2300 3717.3913 Total $15,000,000 9267.3913 Average Revenue / Car $1,618.58

1606 6770 3718

Concert budget Venue: # seats 5000 Expenses per seat Talent cost (fixed) xxxxx $25,000 Venue rental, $1.75 per seat $1.75 8,750 Amplification, $1 per seat $1.00 5,000 Lighting, $0.80 per seat $0.80 4,000 Ticketing, $0.70 per seat $0.70 3,500 Security, $0.50 per seat $0.50 2,500 Insurance, $0.40 per seat $0.40 2,000 Total costs 50,750 Revenues per seat Ticke Price / Total Ticket sales $75.00 375,000 Merchandising, $5 per seat $5.00 25,000 Food & beverage, $15 per seat $15.00 75,000 Total revenue 475,000 Profit or loss $ 424,250