Use these tables/charts to show your work on the problems indicated. Beginning Balance Cash Collected Cash Payments Surplus/(Shortage) Borrow/(Repay) Ending Balance 3) 5) Octobe Novembe Decembe 40,000 50,000 Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) 60,000 6,000 66,000 9,000 57,000 7) April May June Cash Sales Sales on Account current Sales on Accountimo prior Sales on Account 2mo prior Total Cash Collections 10) Units 21,000 20,000 200,000 Sales S Less variable costs: $ Manufacturing costs Selling and administrative costs Contribution margin $ 70,000 40,000 90,000 $ Less fixed costs: $ Manufacturing costs Selling and administrative costs 22,000 17,000 S Net income $ 51,000 12 & 13) Master SP X SV Flexible SP X AV Actual AP X AV X 15) Year Cashflow PV Factor Present Value NP V 17) Use: PV Factor X Cash Inflow - Cash Outflow 20) Year Cashflow PV Factor Present Value Use these tables/charts to show your work on the problems indicated. Beginning Balance Cash Collected Cash Payments Surplus/(Shortage) Borrow/(Repay) Ending Balance 3) 5) Octobe Novembe Decembe 40,000 50,000 Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) 60,000 6,000 66,000 9,000 57,000 7) April May June Cash Sales Sales on Account current Sales on Accountimo prior Sales on Account 2mo prior Total Cash Collections 10) Units 21,000 20,000 200,000 Sales S Less variable costs: $ Manufacturing costs Selling and administrative costs Contribution margin $ 70,000 40,000 90,000 $ Less fixed costs: $ Manufacturing costs Selling and administrative costs 22,000 17,000 S Net income $ 51,000 12 & 13) Master SP X SV Flexible SP X AV Actual AP X AV X 15) Year Cashflow PV Factor Present Value NP V 17) Use: PV Factor X Cash Inflow - Cash Outflow 20) Year Cashflow PV Factor Present Value