excel

QUESTION 1 Below is the achieved sales revenue for the month of February 2018. Prepare a report if the for the following sales summaries by the end of February 2018 Scenario 1 - If the sales revenue is projected to be increased up to $300,000.00, sales return to be decreased up to 10000 and cost of goods sold to be reduced up to 45000 . Expenses will remain the same Scenario 2 - If the sales revenue is projected to be reduced up to $180,000.00, sales return to be increased up to $25,000 and cost of goods sold to be increase up to $60000. Expenses will increase up to $1500. Revenue 250000 (Less) Sales return 12000 (Less) COGS 50000 Gross Profit 188,000 (Less) Total Expenses 10000 Net Profit 17800