12 1 Calculating Markup Percent 3 Cost 4 Markup % 5 Retail In the above spreadsh

Question

12 1 Calculating Markup Percent 3 Cost 4 Markup % 5 Retail In the above spreadsheet, enter the formula that will perform the calculation to find the markup percentage. Use the spreadsheet to calcuate the individual markup percentages of the following itsms and record them on the appropriate table below. (Credit will not be given for any item without the correct formula 8 entered in the spreadsheet. You must do this via Excel, not by hand) 1 pt 10 |Unit Cost |Unit Retail | Individual Markup % 12 13 14 15 16 17 18 19 20 21 7.00 $10.00 S22.50 $27.00 $30.50 $5.75 $25.80 $13.45 $17.99 $15.50 $3.00 $19.75 $6.35 S9.64 Problem 1 Problem 2 Problem 3 Sheet4 Sheet5 Sheeté Ready

Explanation / Answer

ANSWER:

Mark up = ( (selling price - cost price) / cost price) * 100

1) mark up = ( (10 - 7 ) / 7 ) * 100 = (3 / 7) * 100 = 0.4285 * 100 = 42.85%

2) mark up = ( (27 - 22.5) / 22.5) * 100 = (4.5 / 22.5) * 100 = 0.2 * 100 = 20%

3) mark up = ( (30.5 - 15.5) / 15.5 ) * 100 = (15 / 15.5) * 100 = 0.9677 * 100 = 96.77%

4) mark up = ( ( 5.75 - 3) / 3 ) * 100 = ( 2.75 / 3 ) * 100 = 0.9167 * 100 = 91.67%

5) mark up = ( (25.8 - 19.75) / 19.75 ) * 100 = ( 6.05 / 19.75) * 100 = 0.3063 * 100 = 30.63%

6) mark up = ( (13.45 - 6.35) / 6.35 ) * 100 = (7.1 / 6.35) * 100 = 1.1181 * 100 = 111.81%

7) mark up = ( (17.99 - 9.64) / 9.64 ) * 100 = ( 8.35 / 9.64 ) * 100 = 0.8661 * 100 = 86.61%

in excel use

1) ((c11 - b11) / b11) * 100

2)  ((c12 - b12) / b12) * 100

3)  ((c13 - b13) / b13) * 100

4)  ((c14 - b14) / b14) * 100

5)  ((c15 - b15) / b15) * 100

6)  ((c16 - b16) / b16) * 100

7)  ((c17 - b17) / b17) * 100

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.