Maple Ridge Corp has the following sales data forecast for the coming year

Q1 Budgeted sales in units 3,760.00

Q2 Budgeted sales in units 4,700.00

Q3 Budgeted sales in units 5,640.00

Q4 Budgeted sales in units 5,170.00

Selling price/ per unit $9.40

Sales collection in current quarter 65%

Sales collection in next quarter 30%

Uncollectible 5%

Last year outstanding A/R $37,835.00

Last year ending inventory 940.00

desired ending inventory is 7.05% of next quarter budgeted sales in units

desired ending inventory for the forth quarter is 1057.50

Please use the budget format shown in the lecture notes to prepare the Sales and Production Budget

please provide step by step solution

create a budget plan. please provide the step wise calculations

Maple Ridge Corp has the following sales data forecast for the coming year Q1 Budgeted sales in units 3,760.00 Q2 Budgeted sales in units 4,700.00 Q3 Budgeted sales in units 5,640.00 Q4 Budgeted sales in units 5,170.00 Selling price/ per unit $9.40 Sales collection in current quarter 65% Sales collection in next quarter 30% Uncollectible 5\% Last year outstanding A/R $37,835.00 Last year ending inventory 940.00 desired ending inventory is 7.05% of next quarter budgeted sales in units desired ending inventory for the forth quarter is 1057.50 Please use the budget format shown in the lecture notes to prepare the Sales and Produ