Purchase Solution

Expense Report Claims

Not what you're looking for?

Ask Custom Question

1-Retrieve the Expense Report and save it on your computer as Expense Report 1. This partially completed workbook contains the column headings and several expense items.

2-Enter a SUM function in cells C12:N12 which totals the figures in rows 8 through 11. The formula for doing that is "=SUM(C8:C11)" and enter that in C12 and copy it in columns D through N.

3-In cell M4, put the label "Allowance." In cell M5, type ".32", which is the amount paid per mile. In cell M8, put the formula that multiplies the mileage in cell L8 by the mileage allowance. Remember to use an absolute reference for cell M5. Copy the formula to cells M9:M11.

4-In cell N8, sum the range C8:K8 and M8, omitting column L, which is not an expense. Copy the formula to cells N9:N11
Hint: One way is to use the SUM function for the contiguous range and add in the noncontiguous. Another way is to enter the range as two separate arguments.
5-Select the column headings in row 6 and bold them.

6-Create a report title by typing "Expense Report" in cell A2. Select cells A2:N2 and use the Merge and Center button. Change the font size to 14 point.
7-Use the Merge and Center button to place "Transportation" above "Air" and "Ground." Do not forget to format these headings to match the others.
8-Use the Merge and Center button to place "Meals" above "Brkfast", "Lunch" and "Dinner." Do not forget to format these headings to match the others.

9-Select the dates in cells A8:A11 and change the format to day-month.

10-Adjust the column widths.
11-Create a custom footer with "Created by <your name>" at the right side.
12-Change the orientation of the page to landscape and make it Fit on One page

Attachments
Purchase this Solution
Solution Summary

The solution examines expense report claims and how to compute them in Excel.

Solution Preview

Please see attached spreadsheet.

To update the custom footer, you will need to go to the ...

Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Choate and Choate is an advertising agency that employs

    If the new system is established, one must be careful that the new system would not open door for potential fraudulent claims.

  • Accounting Questions

    Office salaries expense b. Interest expense c. Depreciation expense d. Travel expense Answer: C Depreciation expense is a non-cash expense. 18. The going concern assumption underlies the a. cost principle.

  • Income Tax

    The amount charged to warranty expense on its books was $95,000. Assuming a 40% income tax rate, what amount was actually paid this year for warranty claims? Please find my response below. (D) Income Tax Payable is 104,000.

  • Financial Accounting

    I belive their verification process is quite efficient and they have sufficient internal control to prevent improper or fraudulent claims. The expert examines financial accounting for a company's expense.

  • Time Value of Money

    Present Value of expected loss adjustment expense = 240/1.06 = 226.415 2C. Fair Premium = 2,036.792 + 226.415 = 2,263.207 The solution explains the concepts very well using the example in the question.

  • E19-6 Identify Temporary or Permanent Differences

    Expense (deduction) reported first on GAAP statements then to IRS = Deferred tax asset Rationale: Results in future deductions Example: Warranty expenses (expense matched with sale but deducted when actual claims paid for IRS) (a) ___2___ The

  • Wal-Mart: GAAP Balance sheet vs. Economic Balance Sheet

    Determine if information exists in the annual report or elsewhere that can assist in valuing the non-operating net assets, debt, and other capital claims.

  • An Auditor Review for Surgery Insurance Claims

    268707 An Auditor Review for Surgery Insurance Claims An Auditor reviewed 25 oral surgery insurance claims from a particular surgical office determining that the mean out of pocket patient billing above the reimbursed amount was $275.66 with a standard

  • Auditing: 19 comprehensive questions - reports and field work

    D) Interest income and interest expense. 42.

View More Related Solutions