Cash budgetlong dashBasic

Grenoble Enterprises had sales of

$ 50 comma 300$50,300

in March and

$ 60 comma 000$60,000

in April. Forecast sales for May, June, and July are

$ 69 comma 800$69,800,

$ 79 comma 800$79,800,

and

$ 99 comma 900$99,900,

respectively. The firm has a cash balance of

$ 4 comma 500$4,500

on May 1 and wishes to maintain a minimum cash balance of

$ 4 comma 500$4,500.

Given the following data, prepare and interpret a cash budget for the months ofMay, June, and July.(1) The firm makes

17 %17%

of sales for cash,

61 %61%

are collected in the next month, and the remaining

22 %22%

are collected in the second month following sale.(2) The firm receives other income of

$ 2 comma 500$2,500

per month.(3) The firm's actual or expected purchases, all made for cash, are

$ 49 comma 700$49,700,

$ 70 comma 300$70,300,

and

$ 79 comma 600$79,600

for the months of May through July, respectively.(4) Rent is

$ 3 comma 200$3,200

per month.(5) Wages and salaries are

8 %8%

of the previous month's sales.(6) Cash dividends of

$ 2 comma 600$2,600

will be paid in June.(7) Payment of principal and interest of

$ 4 comma 200$4,200

is due in June.(8) A cash purchase of equipment costing

$ 5 comma 900$5,900

is scheduled in July.(9) Taxes of

$ 5 comma 800$5,800

are due in June.

Complete the first month of the cash budget for Grenoble Enterprises below:(Round to the nearest dollar. Please input all the values in the table before checking your answers.)

	March		April		May
Sales	$	50,300	$	60,000	$	69,800
Cash sales		8,551		10,200	$
Lag 1 month					$
Lag 2 months					$
Other income					$
Total cash receipts					$