Please provide formula, and process, in excel.

QUESTION 1

Frolic Corporation has budgeted sales and production over the next quarter as follow:

	July	August	September
Sales in Units	50,000	62,000	??????
Production in units	71,200	62,300	66,650

The company has 6,000 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month.

October sales are expected to be 81,500 units.

Required:

Prepare the Budgeted sales for September in units.