Data Table - in order to copy the contents of the data table below into a (Click the icon here spreadsheet.) Item Clothes Interest received Dining out Groceries Salary Auto payment Utilities Mortgage Gas Cash inflow Cash outflow $1,500 $440 $520 $820 $4,500 $352 $260 $1,250 $222 Print Done Cash flows it is typical for Jane to plan, monitor, and assess her financial position using cash flows over a given period, typically a month. Jane has a savings account and her bank loans money at 6% per year while it offers short-term investment rates of 5%. Jane's cash flows during August were as follows: a. Determine Jane's total cash inflows and cash outflows. b. Determine the net cash flow for the month of August. C. If there is a shortage, what are a few options open to Jane? d. If there is a surplus, what would be a prudent strategy for her to follow? a. Jane's total cash inflows are $ (Round to the nearest dollar.) Jane's total cash outflows are $ (Round to the nearest dollar.) b. Jane's net cash flow for the month of August is $ shortage.) (Round to the nearest dollar. Remember that a positive number indicates a surplus and a negative number indicates a c. If there is a shortage, what are a few options open to Jane? (Select the best answer below.) ex Jane can open a savings/investing account or increase the balance on an existing account. Alternatively, she could reduce debt by paying more for some obligations like her auto loan, credit cards or mortgage. In order to maintain her monthly surplus she should maintain her current level of expenses. * Jane can borrow money from her bank or withdraw money from an existing savings/investing account. Another alternative is to cut down on any unnecessary expenses. d. If there is a surplus, what would be a prudent strategy for her to follow? (Select the best answer below.) Jane can use her monthly surplus to open a savings/investing account or increase the balance on an existing account. Alternatively, she could reduce debt by paying more for some obligations like her auto loan, credit cards or mortgage. In order to maintain her monthly surplus she should maintain her current level of expenses. O Jane can borrow money from her bank or withdraw money from an existing savings/investing account. Another alternative is to cut down on any unnecessary expenses