Hi, can you solve the following questions for budget next year, looking at previous year budget, for the following questions, thanks

Budget for previous year

Jul - Sep Oct- Dec Jan -Mar Apr - Jun Total

Wholesale coffee sales: 57,200 64,910 65,450 72,640 260,200

Cost of sales: 47,800 49,450 46,110 51,730 195,090

Rent: 12,445 12,724 12,615 12,882 50,666

Depreciation 6,000 6,000 6,000 6,000 24,000

Agents Commission 2,685 2,975 3,220 3,875 12,755

Interest: 4,400 4,305 4,105 4,005 16,815

Wholesale coffee sales -It is expected that the company will experience steady growth of 2% per quarter across the next 12 months; Collections are expected as 80% in the current quarter, 18% in the following quarter and 2% of bad debts (to be written off at the end of the financial year).

Cost of Sales - Cost of sales are expected to be 26% of sales. This should be applied to each quarter. Payments will be made 90% in the quarter incurred and 10% during the subsequent quarter

Rent will increase at the start of the Financial year to $3,500 per month plus 1.75% of turnover, payable as incurred;

Depreciation - will remain constant for the first quarter; Thereafter is will increase by $2,000 which will reflect a cash outlay of $40,000 for new store fittings.

Agent's commission will apply to 30% of wholesale coffee revenue and incurred and paid at a rate of 15%

Interest will be charged at 2% per quarter; repayments will cover the interest plus an additional $10,000 off the principal per quarter (the current balance is $210,000)