the year 1 , year 2 and year 3 half of year was given for the problem. assignment asks to create the " new budget " with a reason for each category as to why the new budget number was selected. I have created the new budget as seen in pic.my reason for selecting the budget numbers are listed, bottom of page. please check math to ensure my calculations are correct

UEffects Scale 100% . Area Print Print Titles Forward Backward- Pane hemes Page Setup Scale to Fit Sheet Options Arrange Of A C H Year 1 % of % of Sales Year 2 Year 3 % of % of New Actual Sales Sales Actual 1/2 Year Sales Budget 24,150,000 Sales Actual Revenue 22,500,000 20,450,000 12,250,000 Radio Ad Buys Newspaper Ad Buys Mailers and Flyers Conference Pamphlets 731,250 3.30% 664,625 3.30% 805,000 6.57% $796,950 3.30% 450,000 2.00% 306,750 2% 3.76% 460,000 483,000 29% 82,500 0.40% 76,000 0.37% 83,000 0.68% 96,600 0.40 % 72,000 0.30% 64,750 0.30 % 76,400 0.62% 72,450 0.30% Postage 43,260 0.20% 0.20 % 38,706 44,632 0.36% 0.20% 48,300 Travel 23,500 0.10% 0.26 % 19,500 0.10% 32,000 24,150 0.10% Professional License 5,000 0.00% 5,500 0.03 % 5,500 0.04% 7,245 0.03% Office Supplies Software & License 8,500 0.00 % 7,300 0.04% 11,500 0.09% 9,660 0.04% 21,250 0.10% 7,500 0.04% 7,500 0.06% 24,150 0.10% The categories in my budget are a constant, that is they do not change year to year. Regardless of sales revenue, the company still needs a constant budget for software and lice nse, despite sales. The softeare and license budget is 0.1 % of the actual revenue, which is consistent with the previous years percent of sales. The company needs office supplies regardless of sales revenue, since the actual revenue increased for the new budget year, my budget for supplies increased from year 1 The company will always need to maintain a professional license regardless of sales revenue and I have allocated 0.3 % towards that from year 1 due to the increase in actual reve Travel expenses have been consistent year to year. Based on year 1 and 2, I kept the budget for travel expenses the same, at O.1 % Postage budget is a constant despite sales, which I kept the same at .2 % based on prior years budget Background and Questions TIe Income Statement Salaries Other SG&A 4 1159 O Type here to search W 7:24 PM 7/7/2019