please give step by step, thanks!

Dixon, vice president of sales, has provided the following information: a. Salaries for his office (including himself at $64,650, a marketing research assistant at $41,350, and an administrative assistant at $24,450 ) are budgeted for $130,450 next year. b. Depreciation on the offices and equipment is $17,250 per year. c. Office supplies and other expenses total $20,050 per year. company should spend 15 percent of first-year Uitima sales for a print and television campaign. e. Commissions on the Sleepeze and Plushette lines are 5 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores. f. Last year, shipping for the Sleepeze and Plushette lines averaged $50 per unit sold. Gene expects the Ultima line to ship for s75 per unit sold since this model features a larger mattress. Suppose that Gene is considering three sales scenarios as follows: Suppose Gene determines that next year's Sales Division activities include the following: Research-researching current and future conditions in the industry Shipping-arranging for shipping of mattresses and handling calls from purchasing agents at retail stores to trace shipments and correct errors Jobbers-coordinating the efforts of the independent jobbers who sell the mattresses Basic ads-placing print and television ads for the Sleepeze and Plushette lines Ultima ads-choosing and working with the advertising agency on the Ultima account Office management-operating the Sales Division office The percentage of time spent by each employee of the Sales Division on each of the above activities is given in the following table: Additional information is as follows: a. Depreciation on the office equipment belongs to the office management activity. management activity. Required: Required: 1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity. If required, round answers to the nearest dollar. Olympus, Inc. Activity-Based Budget For Next Year Research: Shipping: Jobbers: Basic ads: Ultima ads: 2. On the basis of the budget prepared in Requirement 1 , advise Gene regarding actions that might be taken to reduce expenses