Budgeted Sales

$\backslash$table$[[$March$,$April,May,June,July$],[,,,,],[$Schedule of Expected Cash Collections$],[,$April,May,June,Quarter$],[$Cash Sales,$$59,500,,,],[$Credit Sales,$21,000,,,],[$Total Collections,$$80,500,,,],[$Merchandise Purchases Budget$],[,$April,May,June,Quarter$],[$Budgeted Cost of Goods Sold,$$51,000,,,],[$add: Desired Ending Inventory,$38,640,,,],[$Total Needs,$89,640,,,],[$less: Beginning Inventory,$40,000,,,],[$Required Purchases,,,,$]]$

Schedule of Expected Cash Disbursements $-$ Merchandise Purchaes

$\backslash$table$[[,$April,May,June,Quarter$],[$March Purchases,$$21,930,,,],[$April Purchases,$24,820,,,],[$May Purchases,,,,$],[$June Purchases,,,,$],[$Total Disbursements,$$46,750,,,]]$

Schedule of Expected Cash Disbursements $-$ Selling & Administrative

$\backslash$table$[[$Commissions$,$April,May,June,Quarter$],[$Rent$,58,500,,,],[$Other Expenses,$3,000,,,],[$Total Disbursements,$4,250,,,]]$

$\backslash$table$[[,$Cash Budget$],[$April$,$May,June,Quarter$],[$Cash Balance Beginning,$$30,000,,,],[$Add: Cash Collections,$80,500,,,],[$Total Cash Available,$110,500,,,],[$Less Cash Dishursements,,,,$],[$For Inventory,$46,750,,,],[$For Expenses,$15,750,,,],[$For Equipment,$40,000,,,],[$Total Cash Disbursements,$102,500,,,],[$Excess $($deficiency$)$ of Cash,$8,000,,,],[$Borrowing$,,,,],[$Repayments$,,,,],[$Interest Paid,,,,$],[$Ending Cash Balance,,,,$]]$

Key Information and Instructions

The following data relates to the operations of XYZ Company, a consumer goods company. This data is as of March $31.$

$\backslash$table$[[$Cash$,$$$30,000$