Please help!! If the answer is correct and you show the formulas in excel so I can learn then I will be sure to give a thumbs up. Showing the formulas in excel is very important - as important as getting the right answer. Thanks so much in advance!

i guess you dont have to do it in excel, it just makes it easier to understand since youre able to show formulas that way

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 $34,000,000 (annually), spends 68% of its revenues on purchases, and has a net profit margin of 1.75%. 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.) Number 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.) % 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. (how many) times bigger than the required percentage decrease in purchasing expenses. (Display your The sales increase targeted percentage is answer as a whole number.) Number 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 $34,000,000 (annually), spends 68% of its revenues on purchases, and has a net profit margin of 1.75%. 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.) Number 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.) % 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. (how many) times bigger than the required percentage decrease in purchasing expenses. (Display your The sales increase targeted percentage is answer as a whole number.) Number