Question

In: Finance

Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May,...

Grenoble Enterprises had sales of $50,200 in March and $60,200 in April. Forecast sales for May, June, and July are $70,100, $79,600, and $99,800, respectively. The firm has a cash balance of $4,500 on May 1 and wishes to maintain a minimum cash balance of $4,500. Given the following data, prepare and interpret a cash budget for the months of May, June and July.

1) The firm makes 16% of sales for cash, 62% are collected in the next month, and the remaining 22% are collected in the second month following sale.

2) The firm receives other income of $1,900 per month.

3) The firms actual or expctd purchses, all made for cash, are $50,200, $70,200, and $79,900 for the months of May through July, respectively.

4) Rent is $2,900 per month.

5) Wages and salaries are 9% of the previous months sales.

6) Cash dividends of $3,500 will be paid in June.

7) Payment of principal and interest of $4,200 is due in June.

8) A cash purchase of equipment costing $5,900 is scheduled in July.

9) Taxes of $5,900 are due in June.

PART A: Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar.)

PART B: Complete the second month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar.)

Solutions

Expert Solution


Related Solutions

Cash budget—Basic   Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...
Cash budget—Basic   Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales for​ May, June, and July are $69,500​, $80,000​, and $99,800​, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July. ​(1) The firm makes 24% of sales for​ cash, 62% are collected in the...
Cash budget—Basic   Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales...
Cash budget—Basic   Grenoble Enterprises had sales of $50,100 in March and $60,100 in April. Forecast sales for​ May, June, and July are $69,500​, $80,000​, and $99,800​, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July. ​(1) The firm makes 24% of sales for​ cash, 62% are collected in the...
Cash budget—Basic   Grenoble Enterprises had sales of $49,600 in March and $60,200in April. Forecast sales for​...
Cash budget—Basic   Grenoble Enterprises had sales of $49,600 in March and $60,200in April. Forecast sales for​ May, June, and July are $69,800​,$80,200​,and $ 99 comma 500$99,500​, 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 of​ May, June, and July. ​(1) The firm makes 22 %22% of sales...
Cash budgetlong dash—Basic   Grenoble Enterprises had sales of $50,100 in March and $59,600 in April. Forecast...
Cash budgetlong dash—Basic   Grenoble Enterprises had sales of $50,100 in March and $59,600 in April. Forecast sales for​ May, June, and July are $69,700​, $80,100​,and $99,500​, respectively. The firm has a cash balance of $5,200 on May 1 and wishes to maintain a minimum cash balance of $5,200. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July. ​(1) The firm makes 20 % of sales for​ cash, 60% are collected in...
Cash budgetlong dash—Basic Grenoble Enterprises had sales of $50,200 in March and $59,600 in April. Forecast...
Cash budgetlong dash—Basic Grenoble Enterprises had sales of $50,200 in March and $59,600 in April. Forecast sales for​ May, June, and July are $70,000​, $80,500​, and $99,500​, respectively. The firm has a cash balance of $4,500 on May 1 and wishes to maintain a minimum cash balance of $4,500. Given the following​ data, prepare and interpret a cash budget for the months of​ May, June, and July.​ (1) The firm makes 22% of sales for​ cash, 65% are collected in...
Cash budgetlong dashBasic Grenoble Enterprises had sales of $ 50 comma 200 in March and $...
Cash budgetlong dashBasic Grenoble Enterprises had sales of $ 50 comma 200 in March and $ 59 comma 800 in April. Forecast sales for May, June, and July are $ 70 comma 300 , $ 79 comma 600 , and $ 100 comma 400 , respectively. The firm has a cash balance of $ 5 comma 300 on May 1 and wishes to maintain a minimum cash balance of $ 5 comma 300. Given the following data, prepare and interpret...
Grenoble Enterprises had sales of $ 50 comma 500$50,500 in March and $ 59 comma 500$59,500...
Grenoble Enterprises had sales of $ 50 comma 500$50,500 in March and $ 59 comma 500$59,500 in April. Forecast sales for​ May, June, and July are $ 69 comma 500$69,500​, $ 79 comma 600$79,600​, and $ 100 comma 100$100,100​, respectively. The firm has a cash balance of $ 4 comma 900$4,900 on May 1 and wishes to maintain a minimum cash balance of $ 4 comma 900$4,900. Given the following​ data, prepare and interpret a cash budget for the months...
Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March...
Joshua Studios expects the following sales in March, April and May: Sales $ Purchases $ March 240,000 180,000 April 250,000 210,000 May 300,000 225,000 The controller has determined that the company collects sales in the following pattern: 30% in the month of sale, 50% in the first month after sale, 10% in the second month after sale, and 10% uncollectable. Based on the agreed terms of trade with suppliers, 40% of purchases are expected to be paid in the month...
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and...
Grover has forecast sales to be $128,000 in February, $137,000 in March, $151,000 in April, and $148,000 in May. The average cost of goods sold is 70% of sales. All sales are on made on credit and sales are collected 60% in the month of sale, and 40% the month following. What are budgeted cash receipts in March? $133,400 $96,900 $137,400 $94,100
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 207 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT