Question
Sleepy Night Inc is a Bedding retailer. The following relates to their projected sales for the next quarter April May June Cash Sales 30000 35000
Sleepy Night Inc is a Bedding retailer.
The following relates to their projected sales for the next quarter
April | May | June | |
Cash Sales | 30000 | 35000 | 65000 |
Credit Sales | 42000 | 39000 | 45000 |
Purchases | 55000 | 50000 | 45000 |
Cost of Sales | 35000 | 40000 | 50000 |
Rent | 15000 | 15000 | 15000 |
Wages & Salaries | 12000 | 12000 | 12000 |
Depreciation | 5000 | 5000 | 5000 |
Utilities | 2500 | 2500 | 2500 |
Sleepy Night’s Credit sales were $30000 in February and $36000 in March. Based on historical experience, Sleepy Night usually receives 50% of their credit sales in the month of purchase, 30% in the month following the purchase and 20% in the second month after purchase. All purchases are on credit and paid for in the month of purchase. In June, the company plans to buy a new computer system for their office for $8000. They will also sell their existing computer for $1000 that month. At the beginning of the quarter, there was an unpaid utilities bill for $300 which will need to be paid in April. At the end of March, Sleepy Night had $20000 in the bank.
Required:
- 1.Prepare the schedule of receipts for Sleepy Night
- 2.Prepare the Cash Budget for Sleepy Night
Step by Step Solution
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Schedule of Receipts For April Cash Sales 30000 Credit Sales from February 50 15000 50 of 30000 Cred...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