80.2K

Verified Solution

Link Copied!

urement #1 Sales Budget Total Quarter1 Quarter 2 Quarter Quarter 4 4 Unit sales X Selling Price Total Sales Revenue urement #2 Type of Sale Total Quarter1 Quarter 2 Quarter 3 Quarter4 10 11 Cash sales Credit Sales 12 Total Sales Revenue 13 urement #3 15 Cash Collections from Sales to be used in the Cash Budget 16 Total Quarter1 Quarter 2 Quarter Quarter 4 17 Cash Collections from 18 Cash Sales Cash Collections from st Qtr Credit Sales Cash Collections from 20 2nd Qtr Credit Sales 21 3rd Qtr Credit Sales 22 4th Qtr Credit Sales Cash Collections from Cash Collections from Total Cash Collections Sales 23 2 2, Requirement #4 Inventory Purchases Budget Total Sales Revenue XCG5 % 30 CGS 31 Plus: Desired ending 74,000.00$ 74,000.00 32 inventory Less: Beginning 33 inventory TOTAL Quantity of Inventory to purchase 35 Requirement #5 Cash Payments for Inventory Purchases to be used in the Cash Budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 38 Total Cash Payments 39 for DM Purchases 40 4, Requirement #6 Quarter Total S8A exp. Budget 4, Requirement #7 Quarter1 Quarter Quarter 3 Quarter4 49 Total S8A exp. 50 Deprec. (non-cash 52 in Cash 54 | Requirement #8 Cash Budget 56 Quarter4 s7 Beg. Cash Plus: Collections from ss Sales Less: Inventory s9 Payments Less: Payments for 0 IS8A Expenses Ending Cash 61

Answer & Explanation Solved by verified expert

See Answer