Please help solve for formulas, do not just show amount.
B D MASTER Master Budget 1,400 1,000 1,600 1,400 1,500 1,200 A 1 2 3 4 5 Data Section 6 7 Actual and Budgeted Unit Sales 8 May 9 June 10 July 11 August 12 September 13 October 14 15 Balance Sheet, June 30 16 Cash 17 Accounts receivable 18 Merchandise inventory (640 units) 19 Fixed assets (net) 20 Total assets 21 Accounts payable (merchandise) 23 Owner's equity 24 Total liabilities & equity 25 26 Other Data 27 Average selling price 28 Average purchase cost per unit 29 Desired ending inventory 30 (% of next month's unit sales) 31 Collections from customers: 32 Collected in month of sale 33 Collected in month after sale 34 Collected two months after sale 35 Projected cash payments: 36 Variable expenses 37 Fixed expenses (per month) 38 Depreciation per month 39 $12,480 239,120 70,400 130,000 $452,000 22 $136,400 315,600 $452,000 $196 $110 40% 20% 50% 30% 25% of sales $40,000 $2,000 B D 40 August July FORMULA1 September 0 0 FORMULA2 0 0 July August September FORMULA3 FORMULA FORMULA5 FORMULA6 FORMULAT 0 0 0 0 0 Ooool 0 FORMULAS $0 $0 July $12,480 August $0 September $0 A Answer Section 41 42 Sales Budget 43 Units 44 45 Dollars 46 47 48 Unit Purchases Budget 49 Desired ending inventory 50 Current month's unit sales 51 Total units needed 52 Beginning inventory 53 Purchases (units) 54 55 Purchases (dollars) 56 57 58 Cash Budget 59 Cash balance, beginning 60 Cash receipts: 61 Collections from customers: 62 From May sales 63 From June sales From July sales 65 From August sales 66 From September sales 67 Total cash available 68 Cash disbursements: 69 Merchandise 70 Variable expenses 71 Fixed expenses 72 Interest paid 73 Total disbursements 74 Cash balance before financing 75 Less: Desired ending balance 76 Excess (deficit) of cash over needs 77 Financing 78 Borrowing 79 Repayment 80 Total effects of financing 81 Cash balance, ending 82 FORMULAS FORMULA10 FORMULA12 64 FORMULA11 0 0 0 $0 $0 $0 FORMULA13 FORMULA14 FORMULA15 0 $0 SO 0 $0 $0 0 0 0 $0 $0 0 $0 $0 0 0 0 $0 $0 0 $0 $0 0 $0 $0 $0 0 $0 $0 $0 0 $0 $0 B D MASTER Master Budget 1,400 1,000 1,600 1,400 1,500 1,200 A 1 2 3 4 5 Data Section 6 7 Actual and Budgeted Unit Sales 8 May 9 June 10 July 11 August 12 September 13 October 14 15 Balance Sheet, June 30 16 Cash 17 Accounts receivable 18 Merchandise inventory (640 units) 19 Fixed assets (net) 20 Total assets 21 Accounts payable (merchandise) 23 Owner's equity 24 Total liabilities & equity 25 26 Other Data 27 Average selling price 28 Average purchase cost per unit 29 Desired ending inventory 30 (% of next month's unit sales) 31 Collections from customers: 32 Collected in month of sale 33 Collected in month after sale 34 Collected two months after sale 35 Projected cash payments: 36 Variable expenses 37 Fixed expenses (per month) 38 Depreciation per month 39 $12,480 239,120 70,400 130,000 $452,000 22 $136,400 315,600 $452,000 $196 $110 40% 20% 50% 30% 25% of sales $40,000 $2,000 B D 40 August July FORMULA1 September 0 0 FORMULA2 0 0 July August September FORMULA3 FORMULA FORMULA5 FORMULA6 FORMULAT 0 0 0 0 0 Ooool 0 FORMULAS $0 $0 July $12,480 August $0 September $0 A Answer Section 41 42 Sales Budget 43 Units 44 45 Dollars 46 47 48 Unit Purchases Budget 49 Desired ending inventory 50 Current month's unit sales 51 Total units needed 52 Beginning inventory 53 Purchases (units) 54 55 Purchases (dollars) 56 57 58 Cash Budget 59 Cash balance, beginning 60 Cash receipts: 61 Collections from customers: 62 From May sales 63 From June sales From July sales 65 From August sales 66 From September sales 67 Total cash available 68 Cash disbursements: 69 Merchandise 70 Variable expenses 71 Fixed expenses 72 Interest paid 73 Total disbursements 74 Cash balance before financing 75 Less: Desired ending balance 76 Excess (deficit) of cash over needs 77 Financing 78 Borrowing 79 Repayment 80 Total effects of financing 81 Cash balance, ending 82 FORMULAS FORMULA10 FORMULA12 64 FORMULA11 0 0 0 $0 $0 $0 FORMULA13 FORMULA14 FORMULA15 0 $0 SO 0 $0 $0 0 0 0 $0 $0 0 $0 $0 0 0 0 $0 $0 0 $0 $0 0 $0 $0 $0 0 $0 $0 $0 0 $0 $0
