What you have to do A. Prepare Cash Budget for Best Value Supermarkets Problem: Gerry Jacobs a financial analyst for Best Value Supermarkets has prepared the following sales and cash disbursement estimates for the period of August through December of the current year. Month Sales August September Php400,000 500,000 500,000 Cash Disbursements Php300,000 500,000 700,000 October November 400,000 600,000 700,000 December 500,000 90% of the sales are for cash, remaining 10% are collected one month later. All disbursements are on a cash sales basis. The firm wishes to maintain a minimum cash balance of Php50,000. The beginning cash balance in September is Php25,000. Prepare a cash budget for the months of October, November and December, noting any needed financing or excess available. - For your guide, follow the format of cash budget below. Best Valu Supermarkets Cash Budget For the months of October, November, and December September October Cash Receipts November Php December Php Sales (cash 90%) Php Php. Sales Collected (1 mo. lag 10%) Total Cash receipts Total cash disbursements Net cash flow Beginning Cash Balance Ending cash balance Minimum cash balance Required financing Excess Cash B. Answer the table below regarding the proper management of cash, receivables and inventories. Definition 1. CASH 2. RECEIVABLES 3. INVENTORIES Proper Management What you have to do A. Prepare Cash Budget for Best Value Supermarkets Problem: Gerry Jacobs a financial analyst for Best Value Supermarkets has prepared the following sales and cash disbursement estimates for the period of August through December of the current year. Month Sales August September Php400,000 500,000 500,000 Cash Disbursements Php300,000 500,000 700,000 October November 400,000 600,000 700,000 December 500,000 90% of the sales are for cash, remaining 10% are collected one month later. All disbursements are on a cash sales basis. The firm wishes to maintain a minimum cash balance of Php50,000. The beginning cash balance in September is Php25,000. Prepare a cash budget for the months of October, November and December, noting any needed financing or excess available. - For your guide, follow the format of cash budget below. Best Valu Supermarkets Cash Budget For the months of October, November, and December September October Cash Receipts November Php December Php Sales (cash 90%) Php Php. Sales Collected (1 mo. lag 10%) Total Cash receipts Total cash disbursements Net cash flow Beginning Cash Balance Ending cash balance Minimum cash balance Required financing Excess Cash B. Answer the table below regarding the proper management of cash, receivables and inventories. Definition 1. CASH 2. RECEIVABLES 3. INVENTORIES Proper Management
