Sales for Blue Bill Corporation are projected as follows for the months of June through November:...

Transcribed Image Text:

Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 redt sales account for 70% of monthy sales and are collected one month after the sale. Other receipts for October are $5000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fored disbursements other disbursements Total cash disbursements Net change during the month Reginning cash inding cash Required cash Excess cash to invest Cash borrowed Blue Bill Corporation Cash Budget June $200,000 July $200,000 60,000 60,000 August September October $200,000 $300,000 $500,000 150,000 60,000 90,000 November $200,000 These amounts were given 60,000 The cash sales are 30% of monthly sales because they tell us that credit sales are 70% of monthly sales 100000%) Leave the collections amount blank for June Collections are credit sales. They tell us that Credit Sales(Collections) are 70% of monthly sales starting in July. For Collections you do not start collecting until after the first month so the first $140,000 would not be until They tell us Other Receipts for October are $50,000 No other receipts for the other menth DO NOT ADD SALES Only add the totals of cash sales, collections, and other receipts. They tell us Variable disbursements are 60% of sales nach month They tell us Foxed disbursements are $10,000 each month They paid s00,000 in taxes for August and $400,000 delit cepayment in November Add all of the disbursements For these answers you would take the Total Cash Receipts amount from above and subtract the Total Cash Disbursements Beginning cash in June is $50,000. Then use the Inding Cash amount as the Beginning Cash Amount for the next month Net change during the month amoont phes Beginning Cash They tell us Desired Cash is $10,000 so use this as the Required Cash amount for each month Ending Cash minus Required Cash negativer 842 plus 43 for June only Sales for Blue Bill Corporation are projected as follows for the months of June through November: June July August September October November $200,000 200,000 200,000 300,000 500,000 200,000 redt sales account for 70% of monthy sales and are collected one month after the sale. Other receipts for October are $5000. Variable disbursements are 60% of sales each month. Fixed disbursements are $10,000 each month. $80,000 should be included in August for taxes. The company is obligated to make a $400,000 debt repayment in November. Beginning cash in June is $50,000. Desired ending cash each month is $10,000. Complete the monthly cash budget for Blue Bill Corporation for June through November. Sales Cash sales Collections Other Receipts Total cash receipts Variable disbursements Fored disbursements other disbursements Total cash disbursements Net change during the month Reginning cash inding cash Required cash Excess cash to invest Cash borrowed Blue Bill Corporation Cash Budget June $200,000 July $200,000 60,000 60,000 August September October $200,000 $300,000 $500,000 150,000 60,000 90,000 November $200,000 These amounts were given 60,000 The cash sales are 30% of monthly sales because they tell us that credit sales are 70% of monthly sales 100000%) Leave the collections amount blank for June Collections are credit sales. They tell us that Credit Sales(Collections) are 70% of monthly sales starting in July. For Collections you do not start collecting until after the first month so the first $140,000 would not be until They tell us Other Receipts for October are $50,000 No other receipts for the other menth DO NOT ADD SALES Only add the totals of cash sales, collections, and other receipts. They tell us Variable disbursements are 60% of sales nach month They tell us Foxed disbursements are $10,000 each month They paid s00,000 in taxes for August and $400,000 delit cepayment in November Add all of the disbursements For these answers you would take the Total Cash Receipts amount from above and subtract the Total Cash Disbursements Beginning cash in June is $50,000. Then use the Inding Cash amount as the Beginning Cash Amount for the next month Net change during the month amoont phes Beginning Cash They tell us Desired Cash is $10,000 so use this as the Required Cash amount for each month Ending Cash minus Required Cash negativer 842 plus 43 for June only