Question: Everything I do shows that it should be 0.33% but it keeps saying that is wrong. Please Help and use excel so I can see

Everything I do shows that it should be 0.33% but

Everything I do shows that it should be 0.33% but

Everything I do shows that it should be 0.33% but it keeps saying that is wrong. Please Help and use excel so I can see your calculations.

SM.66 A small regional retailer is looking for ways to increase profits. Given its impressive record of growth, the sales and marketing vice president wants to target a 8% increase in sales to meet the profitability goals. The company currently has revenues of $35,000,000 (annually), spends 54% of its revenues on purchases, and has a net profit margin of 2.5%. You are a buyer working for this company and you want to show the vice president that it may be easier to reach the profitability goals by lowering purchasing expenses. If the company achieves its revenue growth target of 8%, by how many dollars would revenue increase? (Display your answer as a whole number.) 2800000 Assuming that revenues stayed flat (meaning the company did not try to increase sales by the 8 percent target), by what percentage would they have to decrease purchasing expenses to equal the increased profit that would have come from a 8 percent increase to revenues? (Write your answer as a percentage, and display your answer to two decimal places.) 0.33 % Note: This question is to stretch your mind a bit and to show how much more, on a percentage basis, sales must increase in order to equal the bottom-line benefits of a modest decrease in purchasing expenses. There will not be a question like this on any assessment The sales increase targeted percentage is (how many) times bigger than the required percentage decrease in purchasing expenses. (Display your answer as a whole number.) Number Data Revenue Increase in sales Purchsing expense Net profit percent Net income Purchase expenditures $35,000,000 8.00% 54% 2.25% $787,500 $18,900,000.00 Answers Status quo net profit New total Revenue Next Year's total profit Increase to revenue Increse to profit Purchasing expense Incresed sales dollars from growth target Increased profits from sales growth target Required decrease in pruchasing expenses (w/o sales increase) $787,500.00 $37,800,000.00 $850,500 $2,800,000.00 $63,000 $18,900,000.00 $2,800,000.00 $63,000.0000 0.33%

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 General Management Questions!