You have been recrulted by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relles for Its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Glven the restriction on avallable funds (most of the avallable capital has been used for new-product development and to recrult a management team), the control of costs, including marketing costs, Is thought by the management team to be essential for the short-term vlability of the company. You have held a number of Intenslve discussions with Susanna and John Thompson, director of marketing for the firm. They have asked you to prepare an estimated budget for marketing expenses for a month of operations. You are provided with the following data, which represent average actual monthly costs over the past three months: Cost Amount Sales commissions $128,000 45, 250 43,700 22,400 12,500 73,100 Sales staff salaries Telephone and mailing Rental-office building Gas (utilities) Delivery charges Depreciation-office 9,500 furniture Marketing consultants 26,300 Your discussions with John and Susanna indicate the following assumptions and anticipated changes regarding monthly marketing expenses for the coming year: Sales volume, because of aggressive marketing, should Increase by 12%. To meet competitive pressures, sales prices are expected to decrease by 6%. Sales commissions are based on a percentage of sales revenue. Sales staff salaries, because of a new hire, will increase by 12%, regardless of sales volume. Because of recent industrywide factors, rates for telephone and maling costs, as well as delivery charges, are expected to Increase by 9%. However, both of these categories of costs are variable with sales volume. Rent on the office bullding is based on a 2-year lease, with 19 months remaining on the original lease. Gas utility costs are largely Independent of changes in sales volume. However, because of industrywide disruptions In supply, these costs are expected to Increase by 17%, regardless of changes in sales volume. Depreciation on the office furniture used by members of the sales staff should increase because of new equipment that will be acqulired. The planned cost for this equlpment is $28,800, which will be depreciated using the stralght- line (SL) method, with no salvage value, over a 4-year useful life. Because of competitive pressure, the company plans to Increase the cost of marketing consultants by $4,500 per month. Required: 1 Based on the preceding Information, what is the percentage change, by line Item and in total, for Items in your budget? 2. The management team is worrled about the short-term financial position of the new company. Given the strain on avallable cash, the president has expressed a desire to keep marketing expenses over the next few months to a maximum of $363,000. Discussions with the marketing department Indicate that telephone and malling costs are the only category, In the short run, that can reasonably bear the planned-for reduction In marketing costs. The budget you have prepared includes an assumed 9% Increase in telephone and malling costs. What must this percentage change (positive or negative) be in order to achieve targeted monthly marketing costs? (Hint: The Goal Seek function in Excel can be used to calculate the percentage changes, which can be found under Data, then What-If Analysis.)