Managerial AccountingChapter 9-Budget Excel SpreadsheetBudgeted sales are expected to be:April40,000UnitsMay30,000UnitsJune20,000UnitsJuly35,000UnitsAugust30,000UnitsSelling Price$20Per unitPrepare the Budgets for second quarter!!1)Sales Budget with expected Cash CollectionsAll sales are on account.The company collects 60% in month of sale and 35%in the following month.The remaining 5% is uncollectable.March 31 AR is 40,000 and all is collectableMonth of sale Collections60%Following month collections35%