Question: In cell E12, enter a formula to calculate the % of Budget by dividing the Actual expense by the Budget expense to indicate the percent
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
