Please use excell

SM.62 Suppose a company has $25,000,000in (annual) revenue and spends 71% of its revenues on purchases. By how much can this company increase its bottom line (profits) if it can decrease purchasing costs by 0.90%?(Display your answer as a whole number.)

-------------------------------------------------------------------------------------------------------------------------------

SM.63 A small company has $10,000,000 in (annual) revenue, spends 48% of its revenues on purchases, and has a net profit margin of 8.75%. They would like to increase their profits and they are looking at focusing in one of two directions. First, they think they can save 1.80% on their purchase expenses. Or second, they can focus on increasing sales. By how many dollars would they have to increase sales in order to equal a 1.80% savings to purchasing expenses? (Display your answer as a wholenumber.)

----------------------------------------------------------------------------------------------------------------------------

SM.66A small regionalretailer is looking for ways to increase profits. Given its impressive record of growth, the sales and marketing vice president wants to target a 6% increase in sales to meet the profitability goals. The company currently has revenues of $27,000,000 (annually), spends 52% of its revenues on purchases, and has a net profit margin of 5.25%. 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 6%, by how many dollars would revenue increase? (Display your answer as a wholenumber.) Assumingthat revenues stayed flat (meaning the company did not try to increase sales by the 6 percent target), by what percentage would they have to decrease purchasing expenses to equal the increased profit that would have come from a 6 percent increase to revenues? (answer as a percentage, and display your answer to twodecimal 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. 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.)