Bill, a salesperson at an art gallery, is in charge of the sales of two kinds of paintings - oil and watercolor. The cost of acquiring an oil painting is $50 while the cost of acquiring a watercolor painting is $25. The selling price per oil painting is $1,000, while per watercolor is $550. Bill receives a commission of 5% on the profit. Answer the following questions based on this scenario. For each question start with the original values and then make changes as specified in the question. For the questions below, subtract Bill's commission from the gross profit when calculating net profit for the art gallery.

The cost of oil paintings can change in increments of $10. The commission can change in increments of 5% (e.g., 5%, 10%, 15% etc.).

Which of the following combinations is possible if Bill sells 2 oil and 3 watercolor paintings?

a Commission is $395.00, commission rate is 25%, oil . paintings cost $200

b Commission is $218.25, commission rate is 5%, oil . paintings cost $350

c Commission is $170.25, commission rate is 10%, oil paintings cost $150

d Commission is $512.25, commission rate is 15%, oil . paintings cost $80

1.b

If the cost of acquiring a painting (both oil and watercolor) increased by $10, and Bill earned $582 as his commission this week, what is the next profit of art gallery?

PS - please help in solving this question using excel, and explain solution step by step.