Sales Budget Form

a.2ne1UglyDoll Company is preparing a budget for the year

2014 with sales data from the sales & marketing department

for the last 4 consecutive years are as follows:

14,500, 20,000, 22,500, 23,000.

b. The sales plan was carried out in two regions, namely Batam (70%)

and Singapore (30%) with a percentage of sales of

20% for Quarter I and Quarter IV, 30% for Quarter II and

Quarter III.

c. Estimated Selling Price in Batam in the first semester of $ 5 per

unit while in Singapore it is $ 10 per unit. For

second semester, selling prices both in Batam and Singapore

increased each by 10% of the selling price of Semester I.

d. The following are management policies regarding sales:

The cash sales pattern is 70% with a cash discount of 5% and

the rest is credit

Allowance for uncollectible accounts is 2%

Receivables collection pattern is 60% received in the sales quarter and

the remainder is paid in the following quarter.

Requested:

1.Calculate the estimated sales (units) of the finished product for 2014

2. Prepare a sales budget for 2014 by region and

time of sale

3. Prepare a sales budget for 2014 based on time and type

sales

4. Compile the cash receipts from the 2014 cash sales

5. Compile the cash receipts from the 2014 receivables collection