HOME

INSERT

PAGELAYOUT

FORMULAS

DATA

REVIEW

VIEW

or Cut

$$ Copy

Format Painter

Clipboard

${}_3$

Calibri

B

B I

$U{?}_{(})$

$11$

Wrap Text

Merge & Center

Font

$\sqrt[\phantom{2}]{x}$

Alignment

$\backslash$table$[[$Managerial Accounting $-$ Course Project,,,,$],[$March$,$April,May,June,July$],[,,,,]]$

Schedule of Expected Cash Collections

$\backslash$table$[[,$April,May June,Quarter$],[$Cash Sales,$36,000,,],[$Credit Sales,$20,000,,],[$Total Collections,$$56,000,,]]$

Merchandise Purchases Budget

$\backslash$table$[[,,$April,May,June,Quarter$],[$Budgeted Cost of Goods Sold,$$,45,000,,,],[$add: Desired Ending Inventory,,$43,200,,,],[$Total Needs,,$88,200,,,],[$less: Beginning Inventory,,$36,000,,,],[$Required Purchases,$$,52,200,,,]]$

Schedule of Expected Cash Disbursements $-$ Merchandise Purchaes

$\backslash$table$[[,,$April,May,June,,uarter$],[$March Purchases,$$,21,750,,,$$$,21,750],[$April Purchases,,$26,100,26,100,,,52,200],[$May Purchases,,,,,,$],[$June Purchases,,,,,,$],[$Total Disbursements,$$,47,850,,,,]]$

Schedule of Expected Cash Disbursements $-$ Selling & Administrative

Commissions

April

$ $7,200$

Rent

Other Expenses

Total Disbursements

May

$2,500$

$3,600$

$$,13,300$

Cash Budget

April

April

May

$$ Cash balance beginning

April $$8,000$

May

June

Quarter

Add: Cash Collections

April $$56,000$

May

June

Quarter

Total Cash Available

April $$64,000$

May

June

Quarter

Less cash disbursements

For inventory $$47,850$

For expenses $$13,300$

For equipment $1,500$

Total Cash disbursements $62,650$

Excess $($deficiency$)$ of cash $1350$

Borrowing

Repayments

Interesr Paid

Ending cash balance