would some one show me how I would sumbit this answers in an excel sheet, all the dat is correct. for example i would like to know what would i enter in the formulas if i would like to sum a certain column and that multiply it buy a certain number. I just can write the answers i am requested to put the formula funtions$\backslash$table$[[f_x,x$ Enter text or formula here$],[4,$A$,$B$,$C$,$D$,$E$,$F$,$G$,H,$I,J$],[8,,,,$April,May,June,Quarter,,,,,$],[9,$Requirement $1$a$.$ Sales budget:,,,,,,,,,$],[10,$Budgeted sales in units,$65,{000}^{TT},100,000,50,000,215,000,,,,,],[11,$Selling price per unit,$$10,$$$10,$$$10,$$$10,,,,,],[12,$Total sales,$$650,000,$$$1,000,000,$$$500,000,$$$2,150,000,,,,,],[13,$"Correct!,"Correct!,Correct!,Correct!,,,,,$],[14,$Requirement $1$b$.$ Schedule of expected cash collections:,,,,,$],[15,$February sales,$$26,000,,,$$$26,000,,,,,],[16,$March sales,$280,000,40,000,,320,000,,,,,],[17,$April sales,$130,000,455,000,65,000,650,000,,,,,],[18,$May sales,,$200,000,700,000,900,000,,,,,],[19,$June sales,,,$100,000,100,000,,,,,],[20,$Total cash collections,$$436,000,$$$695,000,$$$865,000,$$$1,996,000,,,,,],[21,$Correct!,"correct!,Correct!,Correct!,,,,,$],[22,$Requirement $1$c$.$ Merchandise purchases budget:,,,,,$],[23,$Budgeted unit sales,$65,000,100,000,50,000,215,000,,,,,],[24,$Add desired ending inventory,$40,000,20,000,12,000,12,000,,,,,],[25,$Total needs,$105,000,120,000,62,000,227,000,,,,,],[26,$Less beginning inventory,$26,000,40,000,20,000,26,000,,,,,],[27,$Required purchases in units,$79,000,80,000,42,000,201,000,,,,,],[28,$Unit cost,$$4,$$$4,$$$4,$$$4,,,,,],[29,$Required dollar purchases,$316,000,$$$320,000,$$$168,000,$$$804,000,,,,,],[30,"$ Correct!," Correct!,"correct!,Correct!,,,,,$],[31,$Requirement $1$d$.$ Budgeted cash disbursements for merchandise purchases:,,,,$],[32,$Accounts payable,$100,000,,,100,000,,,,,],[33,$April purchases,$158,000,158,000,,316,000,,,,,],[34,$May purchases,,$160,000,160,000,320,000,,,,,],[35,\{$

$\backslash$table$[[$June purchases$],[$Total cash dishursements$]]\},,,84,000,84,000,,,,,],[36,$$$258\mathrm{.}000,$$$318\mathrm{.}000,$$$244\mathrm{.}000,$$$820\mathrm{.}000,,,,,],[,$Template,Numbers,$+,,,,,,,,,]]$