70.2K

Verified Solution

Link Copied!

I only need the chart of g.Cash budget

there are some data I have done above

Total-Qtr 44,750 910,250 1,655,000 a. Sales Budget 6 Cash sales November 247,500 302,500 550,000 December 273,350 332,750 605,000 Sales on account 275,000 Total budgeted sales Total-Qtr 44,750 577,500 b. Schedule of Cash Receipts Current cash sales Plus collections from A/R Total collections November 247,500 275,000 522,500 December 8 272,250 225,000 574,750 (Hint-these do na Total-Qtr 1,324,000 373,200 Inventory Purchases Budget Budgeted cost of goods sold Plus desired ending inventory Inventory needed Less beginning inventory Required purchases (on account) c. November December 10 145,200 96,000 132,000 453,200 145,200 434,800 532,000 1,420,000 check math vertically too d. Schedule of Cash Payments Budget for Inventory Purchases Total-Qtr November 181,280 319,200 500,480 December Payment of current month's AVP Payment for prior month's AVP Total budgeted payments 212,800 173,920 591,120 212,800 445,840 Total-Qtr 44,750 910,250 1,655,000 a. Sales Budget 6 Cash sales November 247,500 302,500 550,000 December 273,350 332,750 605,000 Sales on account 275,000 Total budgeted sales Total-Qtr 44,750 577,500 b. Schedule of Cash Receipts Current cash sales Plus collections from A/R Total collections November 247,500 275,000 522,500 December 8 272,250 225,000 574,750 (Hint-these do na Total-Qtr 1,324,000 373,200 Inventory Purchases Budget Budgeted cost of goods sold Plus desired ending inventory Inventory needed Less beginning inventory Required purchases (on account) c. November December 10 145,200 96,000 132,000 453,200 145,200 434,800 532,000 1,420,000 check math vertically too d. Schedule of Cash Payments Budget for Inventory Purchases Total-Qtr November 181,280 319,200 500,480 December Payment of current month's AVP Payment for prior month's AVP Total budgeted payments 212,800 173,920 591,120 212,800 445,840

Answer & Explanation Solved by verified expert

See Answer