Question

Spalding Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Spalding expects sales in January year 1 to total $120,000 and to increase 5 percent per month in February and March. All sales are on account. Spalding expects to collect 70 percent of accounts receivable in the month of sale, 20 percent in the month following the sale, and 10 percent in the second month following the sale. Required Prepare a sales budget for the first quarter of year 1.

Answer 1

Answer:

Spalding Pointers Corporation

Sales Budget

For the first quarter of year 1.

Details                                     January             February        March  

Sales revenue ($)                   120,000              126,000       132,300

Explanation:

Before preparing the sales budget, the following are calculated first:

Expected sales in January year 1 = $120,000

Expected sales in February year 1 = Expected sales in January year 1 * (100% + Expected percentage increase) = $120,000 * (100% + 5%) = $126,000

Expected sales in March year 1 = Expected sales in February year 1 * (100% + Expected percentage increase) = $126,000 * (100% + 5%) = $132,300

The sales budge will now look as follows:

Spalding Pointers Corporation

Sales Budget

For the first quarter of year 1.

Details                                     January             February        March  

Sales revenue ($)                   120,000              126,000       132,300