Question

1. Petite Martinique Ltd. Had sales of 49,769 in March and 59,902 in April. Forecast sales...

1. Petite Martinique Ltd. Had sales of 49,769 in March and 59,902 in April. Forecast sales for May, June and July are 69,969, 84,513 and 99,931, respectively. The firm has a cash balance of $2,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June and July. 1) The firm makes 17% of sales for cash, 57% are collected in the next month, and the remaining 26% are collected in the second month following sale. 2) The firm receives other income of $2,000 per month 3) The firm’s actual or expected purchases, all made for cash, are 51,610, 69,949 and 89,662 for the months of May through July, respectively. 4) Rent is $2,700 per month 5) Wages and salaries are 8% of the previous month’s sales 6) Cash dividends of $3,200 will be paid in June. 7) Payment of principal and interest of $3,500 is due in June 8) A cash purchase of equipment costing $5,900 is scheduled in July. 9) Taxes of $6,400 are due in June.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cash budget-Basic. Grenoble Enterprises had sales of $50,000 in March and $60,400 in April. Forecast sales...
Cash budget-Basic. Grenoble Enterprises had sales of $50,000 in March and $60,400 in April. Forecast sales for​ May, June, and July are $69,900​, $79,600​, and ​$100,300, 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 18% of sales for​ cash, 62% are collected in...
Grenoble Enterprises had sales of $ 49 comma 700 in March and $ 60 comma 100...
Grenoble Enterprises had sales of $ 49 comma 700 in March and $ 60 comma 100 in April. Forecast sales for May, June, and July are $ 69 comma 700 , $ 80 comma 500 , and $ 99 comma 600 , respectively. The firm has a cash balance of $ 5 comma 100 on May 1 and wishes to maintain a minimum cash balance of $ 5 comma 100. Given the following data, prepare and interpret a cash budget...
Young is a retailer of assorted baby products. The sales forecast for the coming months is:...
Young is a retailer of assorted baby products. The sales forecast for the coming months is: Revenues April $ 181,000 May $ 209,000 June $ 217,000 July $ 249,000 August $ 233,000 Young’s cost of sales averages 80% of revenues. The inventory policy is to carry 20% of next month’s sales needs. April 1 inventory will be as expected under the policy. Young pays for purchases 70% in the month of purchase and 30% the following month. Accounts payable on...
At the end of April the manager of Gaylord's Boutique is concerned about the store's cash...
At the end of April the manager of Gaylord's Boutique is concerned about the store's cash position. Their accountant has informed her that they have fallen below the target cash balance. This represents a potential problem since while, historically, May is a good month for the business - June and July are the slowest months of the year.    Assume all of Gaylord's sales are made on account with 50% of the Sales collected in the same month as the...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for...
Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $210,000 June 250,000 July 360,000 All sales are on account. 50 percent of sales are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September,...
Osage, Inc., has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May 5,930 units June 6,240 units Forecast: July 5,910 units August 6,890 units September 5,630 units October 5,210 units Required: a. The firm’s policy is to have finished goods inventory on hand at the end of the month that is equal to 70% of the next month’s sales. It is currently estimated that there will be 4,137 units on...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750 February 2,050 June 2,900 March 2,000 July 2,600 April 2,500 Volt Battery always keeps an ending inventory equal to 120% of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 2,640 units, which is consistent with this policy. Materials cost $11 per unit and are paid for in the month after purchase. Labor cost is $4 per unit and...
Bluebird Ltd has provided the following forecasted items for the months of July through to September...
Bluebird Ltd has provided the following forecasted items for the months of July through to September 2020. July August September $ $ $ Sales 13,000 14,000 15,000 Purchases 9,400 8,000 10,000 Operating expenses 3,600 6,400 5,000 Other Information: • 35% of Sales are cash sales, the remaining 65% of credit sales which are collected as follows: o 30% in the month of the sale o 40% in the month after the sale o 28% in the 2nd month after the...
10. Print Item Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet...
10. Print Item Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $340,000 June 490,000 July 700,000 All sales are on account. Of sales on account, 57% are expected to be collected in the month of the sale, 38% in the month following the sale, and the remainder in the second month following the...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 640 720 670 760 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 128 units. Prepare a production budget for the months of April, May, and June. RUIZ CO. Production Budget For April, May, and June April May June Next month's budgeted sales...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT