Excel 2 Excel 2 Attached Files: Excel 2 (excel file) (19.808 KB) Product Costing and Decision Analysis for a Service Company Piedmont Airlines provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month. $2,120,000 $788,500 Fuel Ground personnel Crew salaries Depreciation Total Cost $850,000 $430,000 $4,188,500 Piedmont management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: Activity Base Airline Cost Fuel, crew and depreciation Number of miles flown costs Ground personnel Number of arrivals and departures at an airport The size of the company's ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation. Terminal City Charlotte Pittsburgh Detroit San Francisco Total Ground Personnel Cost $256,000 $97,500 $129,000 $306,000 $788,500 Number of Arrivals/Departures 320 130 150 340 940 Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Flight # Travel Miles Flown Number of Passengers Ticket Price per Passenger 101 2000 80 $695.00 102 Charlotte to San Francisco Detroit to San Francisco Charlotte to Pittsburgh 800 50 $441.50 103 400 20 $382.00 INSTRUCTIONS: 1. Determine the fuel, crew and depreciation cost per mile. 2. Determine the cost per arrival or departure by terminal city. 3. Use the information in Steps 1 and 2 to construct a profitability report for these three flights. Each flight has a single arrival and departure to its origin and destination city pairs. Once you have completed the Input worksheet, save the file as Excel2-lastname (using your last name). Then upload it using the link in the assignment title