ACCT 504 help A Guide to career/uophelp.com ACCT 504 help A Guide to career/uophelp.com - Page 71

Begin by computing the ratios. Start by selecting the formula for the current ratio. Then calculate the current ratios for Company BB, NN, and QQ ------------------------------------------------------------------------------- ACCT 504 Week 6 Case Study 3 - Cash Budgeting LBJ Company For more course tutorials visit www.uophelp.com ACCT504 Case Study 3 on Cash Budgeting The cash budget was covered during Week 4 when we covered TCO D and you read Chapter 7. There is also a practice case study to work on. Your Professor will provide the solution to the practice case study at the end of Week 5. This case study should be uploaded by 11:59PM Mountain time of the Sunday ending Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing. The LBJ Company has budgeted sales revenues as follows: April May June Credit sales $94,000 $89,500 $75,000 Cash sales 48,000 75,000 57,000 Total sales $142,000 $164,500 $132,000 Past experience indicates that 30% of the credit sales will be collected in the month of sale and the remaining 70% will be collected in the following month. Purchases of inventory are all on credit and 40% is paid in the month of purchase and 60% in the month following purchase. Budgeted inventory purchases are $195,000 in April, $135,000 in May, and $63,000 in June.