You have the following income statement for a restaurant for the month of June. Sales Revenue 136550 Cost of Sales 31% of Sales Wages Expense 20.5% of Sales Operating Expenses $41,000 Rent Expense $17,500 Depreciation Expense $10,500 Operating Income $ Additional Information Actual sales revenue in May was $108,000 Actual purchases (cost of sales) in May was $69,000 Sales revenue is 25% cash Credit card sales revenue is 75% of total sales, of which 98% is collected in the month of sales, 2% is collected in the following month 40% of inventory purchases are paid in the month of purchase, the remaining 60% is paid in the following month Wages and operating expenses included in the income statement are paid in cash in June Cash balance at the end of May was 0217 Required: Calculate the actual cash balance at the end of June by preparing a cash budget
You have the following income statement for a restaurant for the month of June. Sales Revenue 136550 Cost of Sales 31% of Sales Wages Expense 20.5% of Sales Operating Expenses $41,000 Rent Expense $17,500
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![EBK CONTEMPORARY FINANCIAL MANAGEMENT](https://www.bartleby.com/isbn_cover_images/9781337514835/9781337514835_smallCoverImage.jpg)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![Intermediate Financial Management (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781337395083/9781337395083_smallCoverImage.gif)