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

 In cell E12, enter a formula to calculate the % of
In cell E12, enter a formula to calculate the % of Budget by dividing the Actual expense by the Budget expense to indicate the percent of the budgeted amount used in that category. Whats the formula that I should put in cell E12?

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f