a step by step process in excel with all the formulas would be great

b) Dub's Records Stuff estimates its sales for the upcoming period and prepared the following budget: Units 25,000 Sales $20 Less variable costs: variable costs: Manufacturing costs Selling and administrative costs Contribution margin Less fixed costs: Manufacturing costs $14,000 $12,000 Selling and administrative costs Net income TBD Assuming the manager produced 190K in sales, 110K of total variable costs and 14K for total fixed costs for 15,000 units. Of these variable costs, 40K related to selling and administrative costs. Comment if these are favourable or unfavourable. Make sure to use full dollar impacts so it is clear to management the magnitude of any variances. Comment on if the manager has had a successful year. 1) The flex budget method (Give full values vs. per unit) 2) The static budget method (Give full budget vs. per unit)