Need to know the colored formulas and blank spaces

125% Collaborate Format Organize View Zoom Add Category Insert Table Chart Text Shape Media Comment MASTER 44 Answer Section: 45 Sales Budget 46 47 June July August 48 49 Units FORMULA1 1,400 1,500 50 Dollars FORMULA2 137,200 147,000 51 52 Unit Purchases Budget 53 54 June July August 55 56 Desired ending inventory FORMULA3 900 720 57 Current month's unit sales FORMULA4 1,400 1,500 58 59 Total units needed FORMULA5 2,300 2,220 60 Beginning inventory FORMULA6 FORMULA3 900 61 62 Purchases (units) FORMULA 1,320 63 64 Purchases (dollars) FORMULA8 $72,600 65 66 67 Cash Budget 68 69 June July August 70 71 Cash balance, beginning $8,000 72 Cash receipts: 73 ctions from customers: 74 From April sales 29,400 75 From May sales 58,800 19,600 76 From June sales 31,360 94,080 31,360 77 From July sales 27,440 82,320 78 From August sales 29,400 79 80 Total cash available $127,560 81 Cash disburser 82 Merchandise $74,800 FORMULA8 D 83 Variable expenses 41,160 84 Fixed expenses 10,000 85 Interest paid 0 86 87 Total disbursements 88 89 Cash balance before financing 90 Less: Desired ending balance 91 92 Excess (deficit) of cash over needs 93 94 Financing125% Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize View Zoom MASTER 95 Borrowing 96 Repayment 97 98 Total effects of financing 99 100 Cash balance, ending 101 102 103 Forecasted Income Statement 104 For Quarter Ended August 31, 19X5 105 106 Sales FORMULA16 107 Cost of goods sold FORMULA17 108 109 Gross profit FORMULA18 110 111 Expenses: 112 Variable expenses FORMULA19 Fixed expenses FORMULA20 114 Depreciation expense FORMULA21 115 Interest expense FORMULA22 116 117 Total expenses $0 118 119 Net income A 120 121 122 Forecasted Balance Sheet 123 August 31, 19X5 124 125 Assets: 126 Cash FORMULA23 127 Accounts receivable FORMULA24 128 Merchandise inventory FORMULA25 129 Fixed assets (net) FORMULA26 130 131 Total assets $0 132 133 Liabilities & equity: 134 Accounts payable FORMULA27 135 Loans payable A 136 Owner's equity FORMULA28 137 138 Total liabilities & equity 139 140