Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am struggling with this cash budget, can someone please help me. I think I have gotten most of it done correctly just don't know
I am struggling with this cash budget, can someone please help me. I think I have gotten most of it done correctly just don't know what I am missing.
Citizens Produce Co-op Cash Budget For the Quarter Ended September 3 credit sales to retailers cash sales to customers collection records collect Total sales May June July August September purchases July August September pays for all purchases with cash monthly costs for quarter heat, lights, and power bank fees rent supplies depreciation of equip equip repairs misc expenses other projected costs salaries and wages July August September sales revenue May June July August September credit sales revenue 80% 80% 20% 50% $60,000 70000 75000 80000 90000 45000 51000 60000 1000 400 2000 1120 1705 1285 500 18700 19500 20600 $60,000 70000 75000 80000 90000 may june july aug sept 48000 56000 60000 64000 72000 cash sales 30% july aug sept 16800 18000 19200 cash sales 20% may june july aug sept 12000 14000 15000 16000 18000 2 months prior credit sales 20% 9600 11200 12000 total collection from customer 71400 77200 85200 July August September Total opening balance as on July 1 2000 3395 3790 Collection from customer 71400 77200 85200 233800 Cash Payments Purchases 45000 51000 60000 156000 Heat light and power 1000 1000 1000 3000 Bank fees 400 400 400 1200 rent 2000 2000 2000 6000 supplies 1120 1120 1120 3360 equip repairs 1285 1285 1285 3855 misc expenses 500 500 500 1500 depreciation of equip 1705 1705 1705 5115 Total Cash Receipts 73400 80595 88990 233800 cash balance at june 30 2000 effective July 1 new policy maintain monthly cash balance can borrow from bank in multiples of 3000 100 ***** note from Instructor This should include totals for July, August, September and the Quarter Page 923 would be a good guide Total Cash payments for all three months = $233,715 Total month ending cash balance = $3,085 Be sure to answer the question in part 2 Part 2 question Should Citizens Produce anticpate taking out a loan during the quarter? If so, how much should it borrow, and when? Citizens Produce Co-op Cash Budget e Quarter Ended September 30 during first month anticipated 30% in month after sale 20% in second month after sale ***** This should include totals for July, August, September and the Quarter Page 923 would be a good guide Total Cash payments for all three months = $233,715 Total month ending cash balance = $3,085 Be sure to answer the question in part 2 d the Quarter Citizens Produce Co-op Cash Budget For the Quarter Ended September 30 Cash Receipts Cash Sales May Credit Sales June Credit Sales July Credit Sales August Credit Sales September Credit Sales Total Collections Cash Payments Produce Purchases Utilities Bank Fees Rent Supplies Equipment Repairs Misc. Expenses Salary and Wages Total Cash Payments Cash Increase Beginning Cash Balance Ending Cash Balance July August September Total 15000 16000 18000 49000 9600 9600 16800 11200 28000 30000 18000 12000 60000 32000 19200 51200 36000 36000 71400 77200 85200 233800 45000 1000 400 2000 1120 1285 500 18700 70005 51000 1000 400 2000 1120 1285 500 19500 76805 60000 1000 400 2000 1120 1285 500 20600 86905 156000 3000 1200 6000 3360 3855 1500 58800 233715 1395 2000 3395 395 3395 3790 -1705 3790 5495 85 9185 3085
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