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
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 decimal places. ie should be considered as
The management team is worried about the shortterm 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 $ Discussions with the marketing department indicate that telephone and mailing costs are the only category, in the short run, that can reasonably bear the plannedfor reduction in marketing costs. The budget you have prepared includes an assumed 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 WhatIf Analysis.
Note:Negative changes should be entered as negative values. Round percentage answers to decimal places. ie should be considered as
Please help with the correct answers, plus the formulas used to get each answer in excel. Thanks.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
