I have calculated the KPI analysis (The last picture). But I don't know how to manage the demand forecastof the demand part .

The instruction is

?the List each show separately esp. if different show times are expected to have different micros attending

?Can group certain days together only if you believe they will have similar demand patterns.

?Forecasted number of customers (your assumption) need to be realistic

?Yield = all seats (266) sold at highest $ on your price list; therefore, offering deep price cuts is not desirable

KPI Analysis Product Day Occ Current Tkt Current total RevPAS Perished Opportunity (loss version $ revenue Yield % Yield price revenue $) % Seats Spoilage Spillage Monday R 30 80 10.00 $800 $3 $1860 SO $2660 30% Tuesday R 30 80 10.00 $800 $3 $1860 SO $2660 30% Wednesday R 30 80 10.00 $800 $3 $1860 So $2660 30% Thursday R 30 80 10.00 $800 $3 $1860 SO $2660 30% Friday R 30 80 10.00 $800 $3 $1860 SO $2660 30% Saturday R 100 266 10.00 $2660 $10 SO $1330 $2660 100% Sunday R 100 266 10.00 $2660 $10 SO $1330 $2660 100% AVE. AVE. AVE. TOTAL AVE TOTAL TOTAL TOTAL AVG. 50 932 10 $9320 $5 $9300 $2660 $18620 350%Cinema capacity 266 seats Ticket Price $10 Product Version 1 Regular Show/day at 7pm Occupancy Weekday 30% Weekend Sold out early with 50% consumer surplus (spillage); overcrowded Ticket Forecasted Forecasted tt! Forecasted Forecasted 266 Seats product version Forecasted yield % price occ. by micro revenue RevPas / show yield 5 seats S R- showtime Friday 12:00pm - 09:50pm Seniors S Students Adults S Total # Total % Total S R- showtime Saturday 10:00am - 09:50 pm S Seniors S Students S Adults Total # Total % Total $ STicket 266 Seats Forecasted product version Forecasted ttl Forecasted Forecasted price occ. by micro revenue RevPas / show yield Forecasted yield % S seats 9% S % R- Sunday showtime 10:00 am - 06 :50pm Seniors S # Students S # # Adults S Total # Total % Total S %Micro Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total $ Undifferentiated Total Revenue $800 $800 $800 $800 $800 $2660 $2660 $9320 Total $1062 $1062 $1062 $1062 $1062 0 0 $5310 Loss Revenue Yield $2660 $2660 $2660 $2660 $2660 $2660 $2660 $18620 Yield % 30% 30% 30% 30% 30% 100% 100% 50%