In cell E12 enter a formula to calculate the of Budget by d

Travel Expense Report 2 Standard Inputs 3 Daily Meal Allowance 4 Airport Parking Daily Rate 5 Mileage Rate to/from Airport 6 Roundtrip Miles to Airport 65.00 $9.00 0.60 20.00 Traveler Inputs Depart Date Return Date # of Nights Hotel Rate/Night Hotel Tax Rate 6/5/18 149.00 18.00% 9 Detailed Expenses 10 Budget Item 11 Travel to/from Destination 12 Mileage to/from Airport 13 Airport Parking 14 Airfare 15 Destination Expenses 16 Shuttle to/from Hotel 17 Hotel Accommodations 18 Meals 19 Incidentals 20 Totals 21 Budget Actual Over or Under %Of Budget 12 1240.75 45 475 -4.25 59.2 534.2 75 710 320 45 1660.28 1736.95 50 703.28 325 50 25 6.72 76.67 23 24

Solution

Formula to enter in cell E 12: Step:1 Enter the following formula as \"=C12/B12\" Step:2 hold control button and press 1 Step:3 Select \"Number\" tab Step:4 Select \"Percentage\" From category Step:5 Then click \"OK\" Detailed expense Budget item Budget Actual Over or Under % of budget Travel to/from Destination Mileage to/from Airport 12 12 0 100.00% Airport barking 45 40.75 -4.25 90.56% Airfare 475 534.2 59.2 112.46% Destination Expenses Shuttle to/from hotel 50 75 25 150.00% Hotel accomodations 703.28 710 6.72 100.96% Meals 325 320 -5 98.46% Incidentals 50 45 -5 90.00% Totals 1660.28 1736.95 76.67