Need help figuring out Total cash disbursements and below, But I need to know how to arrive at the answer, I need a formula.

Budget Project Spring 2019 (3) A Home sro Insert - Page Layout Formulas Data Review View Share Arial 14 ab Wrap Text Accounting AA = = = A E AutoSum Fill Sort & X Clear Filter Paste BIU E 3 Merge & Center $ % 0 -26 Conditional Format Formatting as Table Cell Styles Insert Delete Format Find & Select B150 x fc # D F 937,629 $ 1,145,991 848,331 $ 2,083,620 1,885,180 803,682 7,058,442 7,058,442 $ 1,303,682 $ 1,036,849 $ 803,682 $ 1,840,531$ Hint $ 1,919,907 $ 1,994,322 $ 132 collected from 2nd quarter 133 collected from 3rd quarter 134 collected from 4th quarter 135 Total cash receipts 136 137 Cash disbursements due to 138 Purhcase of materials in the following quarter: 139 4th quarter prior year 140 1st quarter 141 2nd quarter 142 3rd quarter 143 4th quarter 144 Total disbursements for purchases 36,180 55,459 $ $ S 83,188 59,741 $ $ / $ 89,612 54,593 $ $ 144,204 $ 91,639 $ 142,929 $ 36,180 138,647 149,353 136,482 51,751 512,413 512,413 4,144,950 932,660 980,000 170,000 145 81,889 $ 51,751 $ 133,640 $ Hint $ 983,340 $ 226,112 $ 245,000 $ 40,000 $ 999,945 $ 228,326 $ 245,000 $ 10,000 1,132,560 $ 246,008 $ 245,000 $ 1,029,105 $ 232,214 $ 245,000 $ 120,000 $ 146 Payment for direct labor 147 Cash payment for overhead 148 Cash disbursement for S&A expense 149 Capital Acquisitions 150 Total Cash Disbursements 151 Excess of receipts over disbursements 152 Plus beginning cash balance 153 Ending Cash Balance 154 20,000 Hint $ 338,419 155 156 Budegeted Balance Sheet For the year ending December 31, 2018 from cash budget = uncollected sales of 4th quarter from DM purchase budget 157 Current Assets 158 Cash 159 Accounts Receivable 160 Raw Material Inventory Finished Goods Inventorty 161 162 Property, Plant and Equipment (net) 163 Total assets Instructions Part 1 Enter = desired ending inventory from production budget x Cost per unit $ 620,000 2.094.526 Diagnostic Page + @ J - 0 + 110%