Sonya works as a sales representative for a computer manufacturer. Using the information below as a guide, prepare a spreadsheet calculating the amount she must report as income, her deduction for adjusted gross income, and her deduction from adjusted gross income. The spreadsheet should be flexible enough that it can calculate the information regardless of whether the company maintains an accountable or non-accountable plan and the amount of reimbursement or expense. Assume that during the year, she receives $18,000 in reimbursements for the following employment-related expenses:

Travel ..... $10,000

Meals ...... 3,600

Lodging ..... 4,500

Entertainment ... 1,900