Required information {The folio wing information appiies to the questions dispiayed bellow} Williams Company's accounting department has nished preparing the master budget for this year. The chief financial officer {CFO} would like your assistance in creating data visualizations that she can use to better explain the master budget to the company's senior management team. You decide to break down your assignment into two parts. First, you will review the master budget to ensure that you understand all of its schedules and their interrelationships. Second. you will prepare the data visualizations that have been requested by the CFO. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a a brieftutorial on Charts in Excel. 7. The CFO would like you to prepare some data visualizations that depict trends in sales, net income, and cash collections. Accordingly. use Charts to do the following: a. Go to the \"Sales Budget\" tab and create a line chart that provides a monthly sales trend analysis. b. Go to the \"Sales Budget\" tab and create a line chart that includes the monthly sales trend analysis from requirement 7a plus another trend line pertaining to the monthly cash collections from customers. 1:. Go to the \"Budgeted Income Statements\" tab and create a line chart that includes the monthly sales trend analysis from requirement 7a plus another trend line pertaining to monthly net income. d. What insights are revealed by the charts in requirements 7a, 7b, and 7c? 8. The CFO would also like you to prepare some data visualizations that depict monthly trends in the cash balance, current assets, and net income. Accordingly, use Charts to do the following: a. Go to the "Cash Budget\" tab and create a bar chart that includes one bar for each of 12 months. Each month's bar will show the excess {deciency} of cash available over disbursements for that month and [where appropriate] the borrowings for that month. Use different colors to distinguish the excess [deciency] of cash available over disbursements from any borrowings. Also, insert a horizontal line within your chart to depict the company's minimum cash balance of $30,000. b. Go to the \"Budgeted Balance Sheets\" tab and create a bar chart that depicts each month's ending total current assets. Each bar within the chart will sub-divide into three partsthe portion of the overall balance that resides in cash. accounts receivable, and inventory. 1:. Go to the \"Cash Flow vs. Net Income\" tab and create a line chart that includes a total oftwo lines. The rst line will depict monthly trends in operating cash flows (cash collections from customers minus total cash disbursements. including interest payments] and the second line will depict net income. d. What insights are revealed by the charts in requirements 8a, 3b, and 8c