I need the excel formula used to get the answers to all in yellow. Included is the data as well as the rows and columns for reference. Thank you!

1 Input Data (USD) 3 Budgeted sales 4 April (units] 5 May (units) 6 June (units) 7 July (units) 8 August (units] 9 10 Selling Price unit Expected 2.500 6,000 3,000 2,500 2,000 $ 120.00 Cash collection pattern Month of sale 14 Following month 15 Uncollectible 40% IF Cash payments for materials 18 Month of purchase 13 Following month 60% 5 $7.00 Production requirements 22 Raw material per unit (lb) 23 Raw mat, cost per lb 24 Direct labor hours per unit 25 Direct labor rate per hour 26 Variable MOHD per DL hour 27 Fixed MOHD per month 28 Depreciation in Fixed MOHD $40.00 $57.950 $20.000 30 Selling & administrative costs 31 Variable S& A cost per unit sold 32 Fixed 58 A. cost per month $63.000 33 Depreciation in Fixed S& A cost $10.000 34 35 Other cash outflows 36 Cash dividende paid each month $15.000 37 Equipment purchases May $47820 38 Equipment purchases June 154 600 39 40 Desired ending inventory 41 Finished Goods 42 Raw Materials 408 43 Cash($) $30.000 44 45 Beginning account balances - March 31 46 Cash $1 28 Depreciation in Fixed MOHD $20,000 30 Selling & administrative costs 31 Variable S&A cost per unit sold 32 Fixed S&A cost per month 33 Depreciation in Fixed S&A cost $63,000 $10,000 35 Other cash outflows 36 Cash dividends paid each month 37 Equipment purchases May 38 Equipment purchases June $15.000 $47.820 $154 600 40 Desired ending inventory Finished Goods 42 Raw Materials 43 Cash ($) 20% $30.000 45 Beginning account balances - March 31 46 Cash ($) 37.745 47 Accounts Receivable [$] $ 132,000 48 Finished Goods inventory 30.750 FG inventory (units) 410 50 Raw Materials inventory 32.200 Raw Materials (lbl 4,600 52 Accounts Payable ($) 55 000 54 Land 55 Buildings and equipment 5 Accumulated Depreciation 57 Common stock 58 Retained earnings $520.000 $1,800 000 ($750.000) $500.000 $1.247.695 BO 62 64 E120 > D H 105 106 107 108 109 110 Budgeted sales in units Variable S&A per unit Total Variable S&A Total Fixed S&A Total S&A Expense Less Depreciation Cash Disbursements for S&A E F G Selling and Administrative Expense Budget (USD) April May June 2.500 6,000 3,000 $1.25 $1.25 $1.25 $ 3,125 $ 7,500 $ 3.750 $ $ 63.000 $ 63.000 $ 63.000 $ $ 66,125 $ 70.500 $ 66.750 $ $ 10.000 $ 10.000 S 10.000 $ $ 56,125 $ 60.500 $ 56.750 $ Quarter 11.500 $1.25 14 375 189,000 203,375 30,000 173,375 112. 113 114 115 116 117 Little Annin Flagmakers Cash Budget (USD) April May 37745 $ 132,000 June Quarter $ Cash Balance, Beginning Add: Receipts Cash Collections Total Cash Available 118 119 120 121 122 123 124 125 126 127 128 129 130 131 Less Disbursements: Direct Materials Direct Labor Manufacturing Overhead Selling and Administrative Dividends Equipment Purchases Total Disbursements Excess (deficiency) of cash available: 132 133 134 135 136 137 138 139 140 Financing Borrowing Repayments Interest Total Financing Cash Balance, ending C D H 143 144 145 146 F G Little Annin Flagmakers Budgeted Income Statement (USD) Quarter Ending June 30 147 148 Net Sales Less: Cost of Goods Sold Gross Margin Less S&A Expenses Net Operating Income Less: Interest Expense Net Income 149 150 151 152 153 154 155 156 157 158 159 Computation of Net Sales: Sales: Less uncollectible amounts: Net Sales: 160 Little Annin Flagmakers Budgeted Balance Sheet (USD) 161 162 Ending March 31st Ending June 30th 163 164 165 Current Assets: Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Plant and Equipment: Land Buildings and Equipment Accumulated Depreciation Total Assets: 166 167 168 169 170 171 172 173 174 175 176 177 178 179 Liabilities: Accounts Payable Stockholder's Equity Common Stock Retained Earnings Ta 1 : E120 v XV f E F G H D Sales: Less uncollectible amounts: Net Sales: Little Annin Flagmakers Budgeted Balance Sheet (USD) Ending March 31st 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 Ending June 30th Current Assets Cash Accounts Receivable Raw Materials Inventory Finished Goods Inventory Plant and Equipment Land Buildings and Equipment Accumulated Depreciation Total Assets 172 173 174 175 176 177 178 179 Liabilities: Accounts Payable Stockholder's Equity Common Stock Retained Earnings Total Liabilities and stockholder's equity 180 181 182 183 184