Question: You are to create formulas that return the profit made from selling a greeting card. Current information is given in cells B1:B7 of the file
You are to create formulas that return the profit made from selling a greeting card. Current information is given in cells B1:B7 of the file named Problem37data.xlsx. We ordered cards at a cost of $3.50 per card. Cards sold at full price are sold for $6. Full-price demand is entered in cell B7. The first 40 leftover cards are sold for $2. Remaining leftover cards are sold for $0.50. Write formulas that always return the correct profit for any set of nonnegative inputs.
Step by Step Solution
3.43 Rating (143 Votes )
There are 3 Steps involved in it
To create formulas that return the profit made from selling a greeting card based on the given infor... View full answer
Get step-by-step solutions from verified subject matter experts
