Estimated sales: Month 1: $230000 Month 2: $255000 Month 3: $289000 Cost

Estimated sales:

Month 1: $230000 Month 2: $255000 Month 3: $289000

Cost of goods sold is to be budgeted at 45% of the sales figures.

Salary and standards commission are expected to be $75000 per month.

When sales exceed $250000 in any one month the sales team is entitled to an additional 5% commission on the excess sales over this figure. Other expenses are
estimated to be $25000 per month.

60% of the total sales are cash sales settled on purchase. Of the credit sales 75% (i.e. 30% of the month%u2019s sales) will be settled in the month following
the sale. Others (i.e. 10% of the month%u2019s sales will settle in the month after.

The outstanding customer balances that will be collected are as follows:

Month 1: $60000 Month 2: $20000

The organization gets a month%u2019s credit on its purchases. That is the accounts for the purchase made in one month are settled in the following month. All
salaries and the normal commissions are paid in the month in which they are incurred. The additional commission is paid in the month after the month in which
it was earned. Other expenses are paid in the month in which they are incurred.

The purchase value of stock for the last month was $101000 which is to be paid in month 1.

The bank balance at the beginning of the first month is estimated to be $29500.

1) 1) Show the profit and loss calculations for the next three months of operations

2) 2) Show the cash flow projection calculations for the next three months

3) 3) Show amended figures if sales increased by 10% in each month and the cost of goods fell from 45% to 40%