Please help, 10 questions. needs full work for all answers!! i really need help and appreciate it, will give thumbs up!

Project One is worth 75 Points. Project one is due by March 13th, Your submission should be well documented (you MUST show your work). Your submission should be completed using Excel. (If this is an issue, you MUST contact me to discuss) Mark from Mark's Mowers wants to make some changes to his business. He has asked each of his department managers (Production, Marketing and Sales ) to submit a plan for growth to you the General Manager. Currently Mark is selling 500 lawn mowers a month at $250 each. His variable cost per lawnmower is $160 each. His fixed cost per month are $ 28,000. For purposes of this project assume that each scenario is within the relevant range (no larger space is needed, no additional people will be needed and no additional fixed cost will be necessary. Question 1. What is the current income / loss that Mark is incurring per month? Question 2. What is Mark's current breakeven in units? Question 3. What is Mark's current breakeven in dollars? The Production Department is considering three different alternatives. A. Switch to better raw materials which would increase Variable cost by 12.5% per unit. They believe this would increase brand awareness and consequently increase unit sales by at least 15% B. Switch to lower quality materials and become a "price conscience" distributer. The amount that the Production department felt best was to decrease Variable cost by 20%. They believe that this would likely reduce unit sales by no more than 15%. C. Finally the Production Department thought a combination of lower quality materials reducing variable costs by 15% combined with a lower retail price of $225 per mower would increase unit sales by at least 25%. Question 4. How much money will Mark make in each of the separate situations? Question 5. Which of the scenarios is best and why? The Marketing Department is considering three different alternatives. A. Do $5,000 in advertising. The Marketing department believe this would increase sales by at least 35 units. B. Do $ 10.000 in advertising. The Marketing department believe this would increase sales by at least 65 units. C. Do $ 6,000 in advertising combined with a "sales" price of $225 (a 10% discount). The believe that this would increase sales by at least 54 units. Question 6. How much money will Mark make in each of the separate situations? Question 7. Which of the scenarios is best and why? The Sales Department is also considering three different alternatives. A. Offer a commission of $ 5 per mower to the sales force. They believe that this will increase sales by at least 24 units. a B. Offer a commission to the sales force of $15 per mower. They believe that this will increase sales by at least 35 units per month. C. Offer a commission of $ 25 per mower and increase the cost of the mower by $10. Even with the higher price, they believe it would increase mower sales by at least 40 mowers per month. Question 8. How much money will Mark make in each of the separate situations? Question 9. Which of the scenarios is best and why? Question 10. As the General manager of Mark's Mowers which of the above scenarios do you this is best going forward and why