Part A: Expected revenue for March - August
March | 8000 |
April | 4800 |
May | 24000 |
June | 6400 |
July | 8000 |
August | 3200 |
Total Revenue $ | 54400 |
Working:
March | =5*1600 |
April | =3*1600 |
May | =15*1600 |
June | =4*1600 |
July | =5*1600 |
August | =2*1600 |
Receipts Budget
March | April | May | June | July | August | Total Receipts for Period | |
March sales | 2400 | 2400 | |||||
April sales | 2400 | 1440 | 3840 | ||||
May sales | 4800 | 12000 | 7200 | 24000 | |||
June sales | 1280 | 3200 | 1920 | 6400 | |||
July sales | 1600 | 4000 | 2400 | 8000 | |||
August sales | 640 | 1600 | 960 | 3200 | |||
Total | 9600 | 14720 | 12000 | 6560 | 4000 | 960 | 47840 |
Working:
March | April | May | June | July | August | |
March sales | =8000*0.3 | |||||
April sales | =4800*0.5 | =4800*0.3 | ||||
May sales | =24000*0.2 | =24000*0.5 | =24000*0.3 | |||
June sales | =6400*0.2 | =6400*0.5 | =6400*0.3 | |||
July sales | =8000*0.2 | =8000*0.5 | =8000*0.3 | |||
August sales | =3200*0.2 | =3200*0.5 | =3200*0.3 |
Preston's Parties specilized in custom birthday parties for children for an average price of $1600. He...
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 -...
Learning Objective: Estimate Receipts Preston's Parties specilized in custom birthday parties for children for an average price of $1,600. 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 NAG August Part A calculate expected revenue for March - August March April May June...
The Happy Wedding Company specializes in custom wedding attire. The average price of each of the bride’s wedding ensembles is $3,200. For each wedding, The Happy Wedding Company receives a 20 percent deposit two months before the wedding, 50 percent the month before, and the remainder of the day the goods are delivered. Based on information at hand, The Happy Wedding Company expects to prepare outfits for the following number of wedding during the coming months: outfit numbers January 5...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May $41,000 June 50,000 July 32,000 August $47,000 58,000 62,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare...
Laura's Decor Stores made the following sales projection for the next six months. All sales are credit sales. march 38,000 April 44,000 may 33,000 june 42,000 july 50,000 august 52,000 sales in january and february were $41,000 and $40,000 respectively experience has shown that total sales, 10% are uncollectible, 35% are collected in the month of sale, 45 percent are collected in the following month and 10 percent are collected two months after sale. a) prepare a monthly cash receipts...
Scare-2-B-U (S2BU) specializes in costumes for all occasions. The average price of each of its costumes is $240. For each occasion, S2BU receives a 20 percent deposit two months before the occasion, 50 percent the month before, and the remainder on the day the costume is delivered. Based on Information at hand, managers at S2BU expect to make costumes for the following number of occasions during the coming months April May June July August September 165 Required: a. What are...
Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 32,000 June $ 36,000 April 38,000 July 44,000 May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....
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...
Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales March $46,000 June $50,000 April 52,000 July 58,000 May 41,000 August 60,000 Sales in January and February were $49,000 and $48,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 25 percent are collected in the month of sale, 35 percent are collected in the following month, and 30 percent are collected two months after sale. a. Prepare a...