Question: fs by 17,500 per month. Required: 1. Based on the preceding information, what is the percentage change, by line item and in total, for items



\fs by 17,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 worried about the short-term financial position of the new company. Given the strain on available cash, the president has expressed a desire to keep marketing expenses over the next few months to a maximum of $357,000. Discussions with the marketing department indicate that telephone and mailing 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 8% increase in telephone and mailing 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.) Complete this question by entering your answe s in the tabs below. Required 1 Required 2 The management team is worried about the short-term financial position of the new company. Given the strain on available cash, the president has expressed a desire to keep marketing expenses over the next few months to a maximum of $357,000. Discussions with the marketing department indicate that telephone and mailing 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 8% increase in telephone and mailing 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.) (Negative amounts should be indicated by a minus sign. Round percentage answers to 2 decimal places, i.e. 0.123 should be considered as 12.30%) Show less A Monthly marketing expense budget Change Sales commissions Sales staffs salaries % Telepone and mailing % Rental-sales office building % Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture New furniture Marketing consultants Total budgeted costs %Saved 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 worried about the short-term financial position of the new company. Given the strain on available cash, the president has expressed a desire to keep marketing expenses over the next few months to a maximum of $357,000. Discussions with the marketing department indicate that telephone and mailing 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 8% increase in telephone and mailing 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.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 Based on the preceding information, what is the percentage change, by line item and in total, for items in your budget? ( Round percentage answers to 2 decimal places. i.e. 0.1234 should be considered as 12.34%.) Monthly marketing expense budget Change Sales commissions % Sales staffs salaries Telepone and mailing % Rental-sales office building Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture % New furniture Marketing consultants % Total budgeted costs % Required 2 >
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
