Forecast sales for May, June, and July are $69,600, $79,700, and $100,300, respectively. The firm has a cash balance of $5,500 on May 1 and wishes to maintain a minimum cash balance of $5,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, 64% are collected in the next month, and the remaining 20% are collected in the second month following sale. (2) The firm receives other income of $1,800 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,900, $70,300, and $79,700 for the months of May through July, respectively. (4) Rent is $2,600 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $3,100 will be paid 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.) 4 April Sales Cash sales Lag 1 month Lag 2 months Other income GEEEM Total cash receipts $ March 49,500 $ 7,920 59,600 $ 9,536 $ S S S May 69,600
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 3 steps