Answer to Question #33319 in Math for Tunisha

Question

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.

Answer 1

Unfortunately, your question requires a lot of work and cannot be done for free.
Submit it with all requirements as an assignment to our control panel and we'll assist you.