3. Karen wants to compare using the cost plus method to the percentage markup method. If she sells 2 small rice pads, 4 medium rice pads, 2 large rice pads, and 20 boxes of $3.50 tea in a month, how much profit does she accumulate? What markup percentage based on cost would she have to use to make the same amount of profit on this month’s sales?
Amount Sold
Variables Used Small RFP Selling Price= $7.00 2
Medium RFP Selling Price= $10.00 4
Large RFP Selling Price= $15.00 2
BT Selling Price $3.50 20
Small RFP Cost= $5.00
Medium RFP Cost= $8.00
Large RFP Cost= $12.00
BT Cost
Excel Formulas Total Profit
Total Cost
Markup % based on cost=
In the yellow cells, create the Microsoft® Excel® formulas that will give you the total profit, total cost, and required markup percentage based on cost. Use cell references in the formula—do NOT use numbers.