Answer:
1-A. Sales budget
1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Sales units 12,200 13,200 15,200 14,200 54,800
Price per unit $21 $21 $21 $21 $21
Total sales $256,200 $277,200 $319,200 $298,200 $1,150,800
1-B. Cash collections budget
1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Collections from $72,600 $76,860 $83,160 $95,760 $72,600
previous quarter
Collections from $166,530 $180,180 $207,480 $193,830 $1,003,900
current quarter
Total $239,130 $257,040 $290,640 $289,690 $1,076,500
2. Productions budget
1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Sales units 12,200 13,200 15,200 14,200 54,800
Planned ending 2,640 3,040 2,840 2,640 2,640
inventory
Total production 14,840 16,240 18,040 16,840 65,960
required
- Beginning 2,440 2,640 3,040 2,840 2,440
inventory
Units to be 12,400 13,600 15,000 14,000 63,520
produced