T.6.1 Mariel Cruz1

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 3

TAREA 6.

1 Conjunto B de ejercicios

Mariel Cruz

Administración De Empresas

NUC University Online Division

ACCO 3520 - 3004ONL

Profesor, Manfredo Rodríguez

13 de abril de 2024

1
PR 22- 4B: Cash budget

Monthly Cash Budget


June
Item Amount
Beginning Cash Balance $42,000
Sales (90% collected in June) $144,000
Manufacturing costs $66,000
Selling and admin. expenses $40,000
Depreciation/Other expenses $12,000
Total Cash Inflows $186,000
Total Cash Outflows $118,000
Ending Cash Balance $68,000

Monthly Cash Budget


July
Item Amount
Beginning Cash Balance $68,000
Sales (60% collected in July) $111,000
Sales (40% collected in August) $74,000
Manufacturing costs $82,000
Selling and admin. expenses $51,000
Income tax payment $24,000
Dividend declared $15,000
Total Cash Inflows $185,000
Total Cash Outflows $172,000
Ending Cash Balance $81,000

Monthly Cash Budget


August
Item Amount
Beginning Cash Balance $81,000
Sales $200,000
Manufacturing costs $105,000
Total Cash Inflows $200,000
Total Cash Outflows $105,000
Ending Cash Balance $176,000

2
Recommendations:
Based on the cash budget prepared, the following recommendations should be made to the controller:
June:
Ensure collections are in line with estimates to maintain the desired minimum cash balance.
July:
Monitor the cash inflows closely due to the income tax payment and dividend declaration.
Consider delaying the dividend payment to maintain a healthy cash balance.
August:
Plan for the increase in manufacturing costs and ensure cash flow is managed effectively.
Evaluate the need for additional financing or cost-cutting measures if necessary.

You might also like