Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started