Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In cell E12, enter a formula to calculate the % of Budget by dividing the Actual expense by the Budget expense to indicate the percent

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

assess the infl uence of national culture on the workplace

Answered: 1 week ago