please show formulas

Module 7 Excel Spreadsheet Instructions Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set \#1 Inputs: Data Section: Check figure (Total liabilities \& equity): $324,357 Fvral formulae muet ho uead Dlasea ho cura th euhmit wair fila ae an Fvral filo Any submissions in 44 Answer Section: Sales Budget 4546SalesBu 47484950UnitsDollars 50 Dollars 51 52 Unit Purchases Budget 53 54 55 56 Desired ending inventory 57 Current month's unit sales 58 59 Total units needed 60 Beginning inventory 61 62 Purchases (units) 63 64 Purchases (dollars) 65 66 67 Cash Budget 68 69 70 71 Cash balance, beginning 72 Cash receipts: 73 Collections from customers: 74 From April sales 75 From May sales 76 From June sales 77 From July sales 78 From August sales 79 80 Total cash available 81 Cash disbursements: 82 Merchandise 83 Variable expenses 84 Fixed expenses June$8,000July$42,760August$142,720 29,400 58,80019,600 31,36094,08031,360 27,44082,320 29,400 $127,560$183,880$285,800 $74,800010,000FORMULA841,1600$044,10010,000