Question
Sales for Rainy Day Restaurant are as follows: November $150,000, December $125,000, January $100,000, February $120,000, March $150,000, April 125,000. Sales are 30% cash and
Sales for Rainy Day Restaurant are as follows: November $150,000, December $125,000, January $100,000, February $120,000, March $150,000, April 125,000. Sales are 30% cash and 70% credit. The credit sales are collected 20% in the month of the sale, 60% in the month following the sale and the remaining 20% 2 months following the sale. Rainy Day has food costs of 35% and pays for them one month later. Payroll is paid each month and is 40% of sales. Other expenditures are $12,000 a month for rent, insurance in January for $15,000, and other expenses of $15,000 per month. The chef wants to buy some new equipment in February. It will cost $50,000 but they are getting a bank loan for $25,000. This enables him to sell off an old piece of equipment with a book value of $1,000 with a gain of $1,500 also in February. Prepare a cash budget for January through April with a beginning cash balance of $15,000 using the cash receipts and disbursements approach
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started