Question

Rundle Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Rundle has budgeted sales as indicated in the following table. The company expects a 11 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.
Required Complete the sales budget by filling in the missing amounts.
Determine the amount of sales revenue Rundle will report on its first quarter pro forma income statement.

Answer 1

Answer:

Complete Sales Budget is as described in the attached image:

Total Sales revenue for the quarter =  $568,157.00  

Explanation:

The question is incomplete. Here is the missing table for January

Table for January Figures:

Cash Sales:  $50,000

Sales on Account: $120,000

Total Budgeted Sales: $170,000

Further explanation

We have the budgeted figures for January. While the ratio of Cash Sales to Sales on Account is 30 to 70 respectively. From the question, we have been advised to maintain this ratio.

Therefore to calculate the Sales figure for the following months: February & March. The total budgeted Sales for January will be increased by 11%.

Solving for February Figures

11% of $170,000 will give us a total Sales figure of $188,700. This figure is further split between Cash Sales(30%) = $56,610 and Sales on Account(70%) = $132,090 respectively.

Solving for March Figures

11% of $188,700 will give us a total Sales figure of $209,457. This figure is further split between Cash Sales(30%) = $62,837.10 and Sales on Account(70%) = $146,619.90 respectively.

The total Sales Revenue is the addition of  $170,000+ $188,700+$209,457 =  $568,157