Question: 1 . Based on the preceding information, what is the percentage change, by line item and in total, for items in your budget? Note: Round

1. Based on the preceding information, what is the percentage change, by line item and in total, for items in your budget?
Note: Round percentage answers to 2 decimal places. i.e.0.1234 should be considered as 12.34%.
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 $363,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 6% 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.)
Note:Negative changes should be entered as negative values. Round percentage answers to 2 decimal places. i.e.0.123 should be considered as 12.30%
Please help with the correct answers, plus the formulas used to get each answer in excel. Thanks.
1 . Based on the preceding information, what is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!