pictures are clear

Required information [The following information applies to the questions displayed below) Williams Company's accounting department has finished 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 brief tutorial 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 (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded so incorrect.) 0. Go to the "Sales Budget" tab and create a line chart that provides a monthly sales trend analysis b. Which of the following statements are true based on the line chart that you created in requirement 7a? The company's sales peok during the summer month the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) a. Go to the "Sales Budget" tab and create a line chart that provides a monthly sales trend analysis b. Which of the following statements are true based on the line chart that you created in requirement ? The company's sales peak during the summer months The company's lowest sales occur in February The company's sales are relatively consistent throughout the year, The montity sales continuously drop from August through December c. Go to the "Sales Budget" tab and create a line chart that includes the monthly sales trend analysis from requirement 7a plus another trendline pertaining to the monthly cash collections from customers. d. Which of the following statements are true based on the line chart that you created in requirement 7e2 me company's sales are seasonal, but its cash collections are relatively constant throughout the year, The comory's cash collections to its cales The company's sales logit cash collectons, The company cash collections are sesso, but its goles are relatively constant throughout the year The company's cash collections are seasonal, but its sales are relatively constant throughout the year e. 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. f. Which of the following statements are true based on the line chart that you created in requirement 7e? The sales peak during the winter months and net income peaks during the summer months The salen peak during the summer months and net income peaks during the winter months The sales and net income both peak during the summer months The sales and net income bom peak during the winter month 8. The CFO would blso 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 barchart that includes one bar for each of 12 months. Each month bar will show the excess deficiency of cash available over disbursements for that month and where appropriate the borrowings for that month Use different colors to distinguish the excess deficiency of cash available over disbursement from any borrowings. Also incerto horizontal line within your chart to depict the company minimum cash balance of $30,000 b. Which of the following tatements are true based on the bar chart that you created in requirement 8a? 2. The company's cash collections in February are greater than it coin dicoursements during that som month 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: 2. 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 (deficiency of cash available over disbursements for that month and (where appropriate the borrowings for that month. Use different colors to distinguish the excess (deficiency) 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. Which of the following statements are true based on the bar chart that you created in requirement 8o? The company's cath collections in February are greater than its cash disbursements during that same month. The company's excess deficiency of cash available over disbursements peaks in December The company's excess defidency of cash available over disbursemerits hits te lowest point in March The company needs to borrow money during the year including borrowing in May and June c. Go to the Budgeted Balance Sheets" tab and create a bor chart that depicts each month's ending total current assets Each bar within the chart will sub-divide into three parts-the portion of the overal balance that resides in cosh, accounts receivable, and inventory d. Which of the following statements are true based on the bar chart that you created in requirement 8c c. 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 parts-the portion of the overall balance that resides in cash, accounts receivable, and d. Which of the following statements are true based on the bar chart that you created in requirement 8c? The total current assets are highest in June and July Accounts receivable comprise the largest portion of August's current assets. The cash balance peoks in November, 2. inventory comprises the largest portion of the total current assets in June e. Go to the "Cash Flow vs. Net Income' tab and create a fine chart that includes a total of two lines. The first line will depict monthly trends in operating cosh flows cosy collections from customers minus total cash disbursements, including interest payments) and the second line will depict net income 4. Which of the following statements are true based on the line chart that you created in requirement 8e? 2 The income and operating cash flows ek in August Required information The total current assets are highest in June and July 2 Accounts receivable comprise the largest portion of August's current assets. The cash balance peaks in November 2 Inventory comprises the target portion of the total current assets in June e. Go to the "Cash Flow vs Net Income tab and create a line chart that includes a total of two lines. The first line will depict monthly trends in operating cash flows (cash collections from customers minus total cosh disbursements, including interest payments) and the second line will depict net income . Which of the following statements are true based on the line chart that you created in requirement 8e? The net income and operating cash flows Deak in August The net income and operating cash flows peki September 2 The net income tags operating con The coating cash wing come Balance Sheet Beginning of the Year Assets Current assets: Cash $ 68,000 Accounts receivable 80,000 Merchandise inventory 13,200 Total current assets $ 161,200 Plant and equipment: e Buildings and equipment 900,000 3 Accumulated depreciation (292,000) Plant and equipment, net 608,000 5 Total assets $ 769,200 6 7 Liabilities and Stockholders' Equity 8 Current liabilities: 19 Accounts payable $ 40.000 20 Stockholders' equity 21 Common stock S 253,000 22 Retained earnings 476.200 23 Total stockholders' equity 729.200 24 Total liabilities and stockholders' equity $ 769 200 25 Sales budget For This Year 000 Budgetedunt ses Selling price per una January February March Am May he Ally August September October November 700 1000 1.100 1,400 2.500 3.000 3200 2.100 1,500 1500 5 00.00 $ 90.00 5 00 00 5 90.00 5 90.005 90.00 90.005 9000 $ 90.00 5 90.00 5 000 585.000 63 000 $ 90.000 5 99.000 $126.0005 225 000 $ 270,000 200 000 S 109 000 000 135.000 Ker An Canh coton som pror month's sales Cash Concurentes Toucas colections Schedule of Expected Cash Collections February March April May June August October Now 0 000 64.000 10.400S 72.000 70 2003 100 100 180.000 $216.000 $ 230/400 151.2005 115200 16.200 13600 10 000 19 300 25200 15.000 000 7 000 17000 DO 27.000 06 2005 2005 1.800 591.100 3100.000 5 145 2005 234.000 55A 2005 1 1200 May Sales Coistot goods sold Gross margin Seling and administrative expenses Not operating Income interest expense Net Income January $ B1,000 46,550 36 450 61,200 024.750) February 63.000 5 30.000 28,350 59 300 (31.250) March 90,000 $ 49.500 40,500 02.000 (21.500) 48 20.54 Budgeted Income Statements For This Year (Absorption costing basis) April June wy August September October 99,000 $128 000 $ 225,000 $ 270,000 $280,000 $189.000 144.000 54,450 09 200 123.750 118.500 158 400 103.050 79 200 44.550 8.700 101,250 121.500 129,000 85.050 34,800 62300 65200 74000 78.000 79.000 70.800 05.00 (10,250) (0.600) 22.0 43.500 50 000 14250 (2000) 190 343 44 445 18.440 18.841 43045 49565 19.440 246750) 31.240 Hordalance Sheets Fortschuh The Year FY ar A My Ar Aque October W 3 6403 640 10000 700 Ass Curta ch Account Here we Tour Pand Dn Andrew S10 400 12.5 113 30.000 72.000 151 1156 000 10000 3005 30.0001 100.000 1121 125 112002200321845 1726 230 400 15020 200 10000 28930 19.800 30 13.00 209.24 351 SED 27 26.900 0600 31 2 SOL CS 130.461 000 2000 000 900,000 SO 200.000 (10,000 900.000 0001 DORO 000 000 19.000 2000 00 GOD 900 000 0000 000 000 563.000 0 000 04000 SE000 1012 000 000 1000PX 000KS 44000 CS COS 0 00 VOY 513.000 777 21 CIVI os 11 50,00 4 w 5 34,11 12 4447 48 100 4 1 OSTS 54 LAR 1.5 LIT! 2 000 IE ST 2010 DOSE 23000 ORCE 24 od UAB 293.000 000 RE M CE TO HE LI Cash Flow vs. Net Income Tor Each thanh This Year AR Now 5 Operating show Name Jan February March Al May June S (3.00215 113 965) 519 (14051) 5 (147S 119.9665 247505 012501 121.50 10.406) S 1.415 2015 30 907 30465 51,953 September 5766 105 26.01 04457 Tow 2454 110 5 48 Required information [The following information applies to the questions displayed below) Williams Company's accounting department has finished 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 brief tutorial 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 (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded so incorrect.) 0. Go to the "Sales Budget" tab and create a line chart that provides a monthly sales trend analysis b. Which of the following statements are true based on the line chart that you created in requirement 7a? The company's sales peok during the summer month the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) a. Go to the "Sales Budget" tab and create a line chart that provides a monthly sales trend analysis b. Which of the following statements are true based on the line chart that you created in requirement ? The company's sales peak during the summer months The company's lowest sales occur in February The company's sales are relatively consistent throughout the year, The montity sales continuously drop from August through December c. Go to the "Sales Budget" tab and create a line chart that includes the monthly sales trend analysis from requirement 7a plus another trendline pertaining to the monthly cash collections from customers. d. Which of the following statements are true based on the line chart that you created in requirement 7e2 me company's sales are seasonal, but its cash collections are relatively constant throughout the year, The comory's cash collections to its cales The company's sales logit cash collectons, The company cash collections are sesso, but its goles are relatively constant throughout the year The company's cash collections are seasonal, but its sales are relatively constant throughout the year e. 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. f. Which of the following statements are true based on the line chart that you created in requirement 7e? The sales peak during the winter months and net income peaks during the summer months The salen peak during the summer months and net income peaks during the winter months The sales and net income both peak during the summer months The sales and net income bom peak during the winter month 8. The CFO would blso 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 barchart that includes one bar for each of 12 months. Each month bar will show the excess deficiency of cash available over disbursements for that month and where appropriate the borrowings for that month Use different colors to distinguish the excess deficiency of cash available over disbursement from any borrowings. Also incerto horizontal line within your chart to depict the company minimum cash balance of $30,000 b. Which of the following tatements are true based on the bar chart that you created in requirement 8a? 2. The company's cash collections in February are greater than it coin dicoursements during that som month 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: 2. 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 (deficiency of cash available over disbursements for that month and (where appropriate the borrowings for that month. Use different colors to distinguish the excess (deficiency) 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. Which of the following statements are true based on the bar chart that you created in requirement 8o? The company's cath collections in February are greater than its cash disbursements during that same month. The company's excess deficiency of cash available over disbursements peaks in December The company's excess defidency of cash available over disbursemerits hits te lowest point in March The company needs to borrow money during the year including borrowing in May and June c. Go to the Budgeted Balance Sheets" tab and create a bor chart that depicts each month's ending total current assets Each bar within the chart will sub-divide into three parts-the portion of the overal balance that resides in cosh, accounts receivable, and inventory d. Which of the following statements are true based on the bar chart that you created in requirement 8c c. 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 parts-the portion of the overall balance that resides in cash, accounts receivable, and d. Which of the following statements are true based on the bar chart that you created in requirement 8c? The total current assets are highest in June and July Accounts receivable comprise the largest portion of August's current assets. The cash balance peoks in November, 2. inventory comprises the largest portion of the total current assets in June e. Go to the "Cash Flow vs. Net Income' tab and create a fine chart that includes a total of two lines. The first line will depict monthly trends in operating cosh flows cosy collections from customers minus total cash disbursements, including interest payments) and the second line will depict net income 4. Which of the following statements are true based on the line chart that you created in requirement 8e? 2 The income and operating cash flows ek in August Required information The total current assets are highest in June and July 2 Accounts receivable comprise the largest portion of August's current assets. The cash balance peaks in November 2 Inventory comprises the target portion of the total current assets in June e. Go to the "Cash Flow vs Net Income tab and create a line chart that includes a total of two lines. The first line will depict monthly trends in operating cash flows (cash collections from customers minus total cosh disbursements, including interest payments) and the second line will depict net income . Which of the following statements are true based on the line chart that you created in requirement 8e? The net income and operating cash flows Deak in August The net income and operating cash flows peki September 2 The net income tags operating con The coating cash wing come Balance Sheet Beginning of the Year Assets Current assets: Cash $ 68,000 Accounts receivable 80,000 Merchandise inventory 13,200 Total current assets $ 161,200 Plant and equipment: e Buildings and equipment 900,000 3 Accumulated depreciation (292,000) Plant and equipment, net 608,000 5 Total assets $ 769,200 6 7 Liabilities and Stockholders' Equity 8 Current liabilities: 19 Accounts payable $ 40.000 20 Stockholders' equity 21 Common stock S 253,000 22 Retained earnings 476.200 23 Total stockholders' equity 729.200 24 Total liabilities and stockholders' equity $ 769 200 25 Sales budget For This Year 000 Budgetedunt ses Selling price per una January February March Am May he Ally August September October November 700 1000 1.100 1,400 2.500 3.000 3200 2.100 1,500 1500 5 00.00 $ 90.00 5 00 00 5 90.00 5 90.005 90.00 90.005 9000 $ 90.00 5 90.00 5 000 585.000 63 000 $ 90.000 5 99.000 $126.0005 225 000 $ 270,000 200 000 S 109 000 000 135.000 Ker An Canh coton som pror month's sales Cash Concurentes Toucas colections Schedule of Expected Cash Collections February March April May June August October Now 0 000 64.000 10.400S 72.000 70 2003 100 100 180.000 $216.000 $ 230/400 151.2005 115200 16.200 13600 10 000 19 300 25200 15.000 000 7 000 17000 DO 27.000 06 2005 2005 1.800 591.100 3100.000 5 145 2005 234.000 55A 2005 1 1200 May Sales Coistot goods sold Gross margin Seling and administrative expenses Not operating Income interest expense Net Income January $ B1,000 46,550 36 450 61,200 024.750) February 63.000 5 30.000 28,350 59 300 (31.250) March 90,000 $ 49.500 40,500 02.000 (21.500) 48 20.54 Budgeted Income Statements For This Year (Absorption costing basis) April June wy August September October 99,000 $128 000 $ 225,000 $ 270,000 $280,000 $189.000 144.000 54,450 09 200 123.750 118.500 158 400 103.050 79 200 44.550 8.700 101,250 121.500 129,000 85.050 34,800 62300 65200 74000 78.000 79.000 70.800 05.00 (10,250) (0.600) 22.0 43.500 50 000 14250 (2000) 190 343 44 445 18.440 18.841 43045 49565 19.440 246750) 31.240 Hordalance Sheets Fortschuh The Year FY ar A My Ar Aque October W 3 6403 640 10000 700 Ass Curta ch Account Here we Tour Pand Dn Andrew S10 400 12.5 113 30.000 72.000 151 1156 000 10000 3005 30.0001 100.000 1121 125 112002200321845 1726 230 400 15020 200 10000 28930 19.800 30 13.00 209.24 351 SED 27 26.900 0600 31 2 SOL CS 130.461 000 2000 000 900,000 SO 200.000 (10,000 900.000 0001 DORO 000 000 19.000 2000 00 GOD 900 000 0000 000 000 563.000 0 000 04000 SE000 1012 000 000 1000PX 000KS 44000 CS COS 0 00 VOY 513.000 777 21 CIVI os 11 50,00 4 w 5 34,11 12 4447 48 100 4 1 OSTS 54 LAR 1.5 LIT! 2 000 IE ST 2010 DOSE 23000 ORCE 24 od UAB 293.000 000 RE M CE TO HE LI Cash Flow vs. Net Income Tor Each thanh This Year AR Now 5 Operating show Name Jan February March Al May June S (3.00215 113 965) 519 (14051) 5 (147S 119.9665 247505 012501 121.50 10.406) S 1.415 2015 30 907 30465 51,953 September 5766 105 26.01 04457 Tow 2454 110 5 48