Preparing a sales budget Cambridge Company, which expects to start operations on

ID: 2588289 • Letter: P

Question

Preparing a sales budget

Cambridge Company, which expects to start operations on January 1, 2018, will sell tablets and accesories in shopping malls. Cambridge has budgeted sales as indicated in the following table. The company expects a 10 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. SALES JANUARY FEBRUARY MARCH Cash Sales Sales on Account Total Budgeted Sales $60,000 90,000 $150,000 Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Cambridge will report on its first quarter pro forma income statement.

Explanation / Answer

Cambridge Company

Sales Budget:

SAles

January

February

March

Total

Cash Sales

$60,000

$66,000

$72,600

$198,600

Credit Sales

$90,000

$99,000

$108,900

$297,900

Total Budgeted sales

$150,000

$165,000

$181,500

$496,500

Given that sales increase by 10% every month. Hence, sales of February is 150,000 +10% 150,000 = $165,000

Sales of March = $165,000 + 10% of 165,000 = $181,500.

Ratio of cash sales to credit sales, Alpha units = $60,000/$150,000 = 40%

Cash sales = 40%:; credit sales = 90,000/150,000 = 60%

The company expects that the amount of sales revenue in the first quarter of income statement = $496,500