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. Witam Company For The Year pre Jewy M Der Budget Belgroepen ! 2.100 To 20100 009 000 10000 TO Fewy 700 00 3000 1. AVE wy Ane Agar 1,100 1400 2.500 3,000 3.500 20.01 2009 0.005 0 1 290000070720122203 DO 1 200.000 1.100 0001 50 Ortobor ver 1,600 0001 142.000 00 000 066 La M IV 1 Cancer bomo Cashion from RO DOO 1920 ON 9000 Schedule of Eucl Cash Cotections Ane My 72000 1300 100 MADO 25.00 45.000 110 1040 Ap 216.000 1160 Fairy 13,000 22400 O 1820 1 al 720,400 37 400 1.000 S400 Our 100.000 14000 word BOK COPE RW NE MORE WE 122 SAN WitamCom Mere Purch Budget For The Year Le F Arw Ora 48 et contro Nos marchand hory July 14.00 COV 40 1 0956 C June 12.750 32171 +603 Are 545 17 71778 10 19 500 137613 1113 12 1410 24 AT 10 2. 53.213 X220 LO 100239 1122 S OR 151 TO 200 25 111 104 w 3.00 25. 100 HAE: 1 OLE TO130 129 100 VE RAU 22 400 KE A O Fy 43000! MO 4.00 SAM Camp Cenerator purchase Seed Chihuane for More Pro Minh . 704N 110,47 21 74 12413 22 2020 31.00 ON 1 ICF 1 SP 1 12 21 16 BUDGE Det 2000 . . M161 M WIE IR VE AM MS Dicentenang hatory based on asut raya 200 Wir Company Selling and Active Fen Budget For The Year A June 2.000 Ton 2010 3100 1.100 200 000 7 000 Ow 2.100 100 DO ADO 100 3 12.000 Nevero Der 10 1 1 5 1 100 003 1 14 1 1 25 UNESCO 000 TO 90 55.000 2000 16000 20.000 6.000 15 10000 0000 20.000 Tary M AMI wy 100 1,100 TA 091 1001 031 5001 BO 1 1111 15.00 5000 16.00 20.000 20 od 20.000 20.000 4.000 2.000 800 4,000 5.000 5.000 FO 300 1000 4 2.000 2.300 es 200 22 300 2000 $4.000 54100 51200 |huniyai Varer Wrisbeeg wrdd expen Pred sugande esperes Attvertro He sa www a Property 14 Dec Towed sig Trade LOT Cash design sperma 55.000 20.000 5.000 15.000 20.000 6,000 3,000 3000 100 4000 72.000 0000 2009 TO 20,000 000 t 000 6000 5000 000D 000 0002 0009 000 00010 DOS 000 3.000 bo 3.000 1 54000 07 CO 2000 SC 000 DOW 12.00 00012 CH 44000 00 712 4000 01200 020 7200 400 0.800 8000 62.000 30 74.000 DOO DO 70.00 RO 8.000 000 ROA 304 TOM NA 000 1 DO E W CAT Cash Far This Yew M Ar Order M 50331 30 31.000 1 52 1. Title 0.001 HAN FY OD 1 174 14100 OUP 10 OSCH OOC P Dengah RE Gelectron T LI Wherches Morgd Tural them 14200 IND 4.400 4400 TEN DO AI SA 200001 OCT 1 14 29 28820 1.00 1600 M 11 10 2014 INE LIVE I GE App ME CH ORZU 09 MO 1.00 14.500 N111 1.21 104 ID 1441 CONTROL WWW 14 WE NHL CORT 14 2009 2004 Furg wi Mapenent de rest 47 11 146 44 44 INC AND 42 111 14.40 1999 H TE TE NO RE Suche Casa 44 1.00 11 30,00 # MON 3. 10 30 Required: To improve your understanding of all schedules included in the master budget and their interrelationships, answer the following questions: 1. Go to the "Sales Budget" tab: a. How are the sales for July (cell H8) being calculated? b. How are the cash collections for August (cell 115) being calculated? 2. Go to the "Merchandise Purchases Budget" tab: a. How are the required merchandise purchases for April (cell E10) being calculated? b. How are the cash disbursements for merchandise purchases for May (cell F17) being calculated? 3. Go to the "Seling & Admin Budget* tab: a. How are the total selling and administrative expenses for September (cell J16) being calculated? b. How are the cash disbursements for selling and administrative expenses for November (cell L18) being calculated? 4. Go to the "Cash Budget" tab: a. How is the excess (deficiency) of cash available over disbursements for March (cell D14) being calculated? b. How is the ending cash balance for June (cell G20) being calculated
