A detailed explanation of the following pictures

125% it! A View Zoom Add Category Pivot Table Insert Table Chart Text Shape Media Comment Collaborate Format Organize + Decision Summary Categories Sort Filter O B C D E Categories A - Decision Summary PG mega airline - Quarter 9 Group rows into categories to organize and summarize the table. I D W Fare Quarter 9 Next Quarter Fare per Mile 38 Cents 38 Cents Add a Category... Fare Structure Normal Normal Free soft drinks, snacks, and small Free soft drinks, snacks, and small snack meal for certain flights. Cost: snack meal for certain flights. Cost: Cabin/Food Service $2.20 per passenger $2.20 per passenger Service Fees Checked Baggage, Seat Selection Checked Baggage, Seat Selection Marketing Quarter 9 Next Quarter Promotion Budget $3,500 $3,500 Advertising Budget $3,500 $3,500 In-Flight Magazine Yes Yes Cargo Marketing Budget $10,000 $10,000 Current Sales Force Size Salespersons Hired 0 Estimated Sales Force Cost $84,000 $84,000 18 Social Performance Budget $3,500 $3,500 Social Responsibility Area Educational causes Educational causes 20 21 Reports Quarter 9 Next Quarter 22 Operating Statistics Not purchased Not purchased 23 Human Resources Not purchased Not purchased 24 Fare Purchased Not purchased 25 Sales Not purchased Not purchased 26 Marketing Not purchased Not purchased 27 28 Fleet Quarter 9 Next Quarter Level 3: more frequent cleaning and Level 3: more frequent cleaning and 29 full preventive maintenance. Cost: full preventive maintenance. Cost: Maintenance $5,000 per aircraft per quarter. $5,000 per aircraft per quarter. All fuel purchased on the spot market All fuel purchased on the spot market 30 Fuel Contract this quarter this quarter 31 Acquisitions Region 2 Lease #5 Normal TP-450 No acquisitions have been made. 32 Disposals No aircraft disposals. No aircraft 33 34 Scheduling 35 Rout Aircraft Flights Seats Fare Sale 36 2A - 600 Miles 2 TP-300 (Normal) 2 60 Regular Fare 2 TP-300 (Normal 37 2B - 400 Miles 1 TP-450 (Normal) 105 Regular Fare N W 38 2C - 340 Miles 2 TP-300 (Normal) 60 Regular Fare Text PG mega airline - Quarter 9125% A Format Organize View Zoom Add Category Pivot Table Insert Table Chart Text Shape Media Comment Collaborate + Filter Decision Summary Categories Sort O B C D E 11 Categories 34 Scheduling 35 Route Aircraft Flights Seats Fare Sale 36 2A - 600 Miles 2 TP-300 (Normal) 2 60 Regular Fare Group rows into categories to organize 2 TP-300 (Normal and summarize the table. 37 2B - 400 Miles 1 TP-450 (Normal) 105 Regular Fare 2C - 340 Miles 2 TP-300 (Normal) Add a Category... N NW 60 Regular Fare 38 39 2D - 360 Miles 2 TP-300 (Normal) 60 Regular Fare 1 TP-300 (Normal 40 2E1 - 400 Miles 1 TP-450 (Normal) 2 75 Regular Fare 1 TP-300 (Normal) 41 2E2 - 400 Miles 1 TP-450 (Normal) 75 Regular Fare 2F - 420 Miles 3 TP-300 (Normal) HWN 90 1-Month Sale 42 13 2R - 600 Miles 1 TP-300 (Normal 30 2-Month Sale 1 TP-300 (Normal) 44 2BF - 720 Miles 1 TP-450 (Normal) 2 75 1-Month Sale 45 46 Human Resources Quarter 9 Next Quarter 47 Quality & Training Budget $16,740 $19,740 3.74% above prevailing wage + stock- 3.94% above prevailing wage + stock- 48 Compensation Policy bonus for all employees. bonus for all employees. 49 50 Financing Quarter 9 Next Quarter 51 Purchase 3-month CD $200,000 $200,000 52 Short-Term Loan $0 $0 53 Long-Term Loan so so 54 Stock Sold so Dividend Paid 50 SO 55 56 Stock Dividend No No 57 58 Special Decision Quarter 9 Next Quarter 59 Incident Purchasing Policies Advertising Campaign Exemplary service pays: Keep your 60 Choice current supplier, Vest. None Selected Text PG mega airline - Quarter 9