Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Recall that at the beginning of the semester, the email dated May 24, 2023 contained the requirement to track all disbursements to be summarized, totaled

Recall that at the beginning of the semester, the email dated May 24, 2023 contained the requirement to track all disbursements to be summarized, totaled and analyzed to provide data on spending patterns and potential changes in spending patterns. Based upon this tracking of disbursements, summarize by category [streaming subscriptions, dining out, cell phone, rent, car payment, gasoline, etc], and compute a total amount of disbursements for each category. You do not have to submit your private financial information in dollar amounts but submit a listing of your categories and convert the dollar amounts to percentages and submit that as part of your document. As illustrated below, conversion of dollar amounts to percentages is: take the dollar total of a category and divide by the total of all category disbursements. After computing these category totals, write a summary of what you learned about your specific spending patterns/behavior. Finally, if you made or plan to make changes to your spending pattern/behavior, include the changes made or the changes you plan to make. If no changes are planned, so state. Submit via D2L Assignments. To emphasize, this assignment has three requirements: 1) The chart as illustrated below 2) Analysis of what you learned about your spending pattern/behavior and 3) what, if any, changes in spending you intend to make. Example of converting $ to % (You may submit the first and last columns; use as many lines as necessary to accommodate your categories) In Word, use the insert chart function to set up chart. Spending Category Dollar Amount Percentage of Total Disbursements Rent $800 68% (800 1,180) Groceries 200 17% (200 1,180) Gasoline 180 15% (180 1,180) Grand Total 1,180 100%

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Advanced Quality Auditing

Authors: Lance B. Coleman

1st Edition

087389913X, 978-0873899130

More Books

Students also viewed these Accounting questions