Expected revenue:
Month | Parties | x |
Average Price |
= |
Expected Revenue |
March | 5 | x | $1,600 | = | $8,000 |
April | 3 | x | $1,600 | = | $4,800 |
May | 15 | x | $1,600 | = | $24,000 |
June | 4 | x | $1,600 | = | $6,400 |
July | 5 | x | $1,600 | = | $8,000 |
August | 2 | x | $1,600 | = | $3,200 |
Receipt Budget:
March | April | May | June | July | August | Total receipts for period | |
March Sales | $2,400 | $2,400 | |||||
April Sales | $2,400 | $1,440 | $3,840 | ||||
May Sales | $4,800 | $12,000 | $7,200 | $24,000 | |||
June Sales | $1,280 | $3,200 | $1,920 | $6,400 | |||
July Sales | $1,600 | $4,000 | $2,400 | $8,000 | |||
August Sales | $640 | $1,600 | $960 | $3,200 | |||
Total | $9,600 | $14,720 | $12,000 | $6,560 | $4,000 | $960 | $47,840 |
Calculations:
Revenue | % of collection | March | April | May | June | July | August | |
March Sales | $8,000 | |||||||
Received in March | 30% | $2,400 | ||||||
April Sales | $4,800 | |||||||
Received in March | 50% | $2,400 | ||||||
Received in April | 30% | $1,440 | ||||||
May Sales | $24,000 | |||||||
Received in March | 20% | $4,800 | ||||||
Received in April | 50% | $12,000 | ||||||
Received in May | 30% | $7,200 | ||||||
June Sales | $6,400 | |||||||
Received in April | 20% | $1,280 | ||||||
Received in May | 50% | $3,200 | ||||||
Received in June | 30% | $1,920 | ||||||
July Sales | $8,000 | |||||||
Received in May | 20% | $1,600 | ||||||
Received in June | 50% | $4,000 | ||||||
Received in July | 30% | $2,400 | ||||||
August Sales | $3,200 | |||||||
Received in June | 20% | $640 | ||||||
Received in July | 50% | $1,600 | ||||||
Received in August | 30% | $960 | ||||||
Total | $9,600 | $14,720 | $12,000 | $6,560 | $4,000 | $960 |
Learning Objective: Estimate Receipts Preston's Parties specilized in custom birthday parties for children for an average...
Learning Objective: Estimate Receipts Preston's Parties specilized in custom birthday parties for children for an average price of $1600. He receives a 20% deposit two months in advance, a payment of 50% one month in advance and the remaining 30% on the day of the party. Preston anticipates the following number of parties for each of the next six months: March 5 April 3 May 15 June 4 July 5 August 2 Receipts Budget March April May June July August...
Learning Objective: Estimate Receipts Preston's Parties specilized in custom birthday parties for children for an average price of $1600. He receives a 20% deposit two months in advance, a payment of 50% one month in advance and the remaining 30% on the day of the party. Preston anticipates the following number of parties for each of the next six months: March 5 April 3 May 15 June 4 July 5 August 2 Part A: calculate expected revenue for March -...
Preston's Parties specilized in custom birthday parties for children for an average price of $1600. He receives a 20% deposit two months in advance, a payment of 50% one month in advance and the remaining 30% on the day of the party. Preston anticipates the following number of parties for each of the next six months: March April May June July August ܗ ܚ ; ܠܪ ܗ ܚ Part A: calculate expected revenue for March - August March April May...
Cash receipts A firm has actual sales of $60,000 in April and $57,000 in May. It expects sales of $75,000 in June and $96,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? Complete the cash receipts table below: (Round to the nearest...
Learning Objective: Estimate Purchases and Disbursements Kealy's Vintage Books purchases vintage books a month in advance of planned sales. Vintage books are purchased from wholesalers for $29 each (on average), using financing to pay 40% of the purchase in the month of delivery and the remaining 60% in the month of the sale. Kealy purchased 1,000 books in April and has 800 books in stock at the end of the month. Estimated sales for May are 860 books, June are...
Learning Objective: Estimate Purchases and Disbursements Kealy's Vintage Books purchases vintage books a month in advance of planned sales. Vintage books are purchased from wholesalers for $29 each (on average), using financing to pay 40% of the purchase in the month of delivery and the remaining 60% in the month of the sale. Kealy purchased 1000 books in April and has 800 books in stock at the end of the month. Estimated sales for May are 860 books, June are...
Cash receipts A firm has actual sales of $61,000 in April and $58,000 in May. It expects sales of $72,000 in June and $96,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? Complete the cash receipts table below: (Round to the nearest...
Cash receipts A firm has actual sales of $62,000 in April and $59,000 in May. It expects sales of $70,000 in June and $104,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? June July August April 62,000 $ May 59,000 $ Sales...
Cash receipts A firm has actual sales of $61,000 in April and $62,000 in May. It expects sales of $73,000 in June and $100,000 in July and in August. Assuming that sales are the only source of cash inflows and that half of them are for cash and the remainder are collected evenly over the following 2 months, what are the firm's expected cash receipts for June, July, and August? Complete the cash receipts table below: (Round to the nearest...
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales • 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. • 5 percent uncollectible....