In the worksheet titled greeting card, there are some cost and revenue numbers for a company that sells greeting cards Information about the costs revenues of the company will be entered in cells B1 B7 That information is Order Quantity the number of cards purchased by the company Unit Cost the cos...

In order to get the required profitloss automatically by changing the values in cell B1B7 the profit ...

In the worksheet titled greeting card, there are some cost and revenue numbers for a company that

Fantastic news! We've Found the answer you've been seeking!

Question:

In the worksheet titled greeting card, there are some cost and revenue numbers for a company that sells greeting cards. Information about the costs/revenues of the company will be entered in cells B1:B7. That information is:

Order Quantity – the number of cards purchased by the company.

Unit Cost – the cost to the company for each card.

Retail Sales Price – the revenue for each full-price card sold.

The Salvage 1 Sales Price – The revenue of each extra card (up to the limit) sold at a discount.

The Salvage 2 Sales Price – The revenue of each extra card over the limit.

Limit of Salvage 1 – The number of extra cards that can be sold at the Salvage 1 price.

Demand – The number of cards that will be able to be sold at full retail price.

You need to calculate the profit/loss for any combination of (non-negative) numbers that I put in columns B1:B7. So your equations will need to be flexible, to account for all possibilities. You should break it up into several different steps and then get the final profit/loss in the last step. As a hint, I’ve put descriptions of the steps I broke it down into in cells G1:G6. I colored the text white, so that you can’t automatically see it. If you need to look at the hints, just highlight the cells and change the text color to black. But please spend some time trying to figure this out without looking at the hints. As an additional hint, the answer for the given numbers can be found in cell G7.