"Refer to and use the following abbreviations for the problems below:
• BT = Box of tea
• S&H = Shipping and handling
• P = Desired profit per box of tea
• RFP = Rice-filled pad
"
1. What is the markup percentage for a box of ginger tea?
"(Show your work in this cell to solve for the markup percentage for a box of ginger tea.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Cost per BT=
S&H=
P=
Excel Formulas Ginger Tea % Markup
In the yellow cells, create the Microsoft® Excel® formula that will give you the ginger tea markup percentage. Use cell references in the formula—do NOT use numbers.
2. If the rice-filled heating pads sell for $7.00, $10.00, and $15.00 for small, medium, and large, respectively, what is the markup percentage on each one?
"(Show your work in this cell to solve for the markup percentages for small, medium, and large rice-filled heating pads.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
Excel Formulas Small % Markup=
Medium % Markup=
Large % Markup=
In the yellow cells, create the Microsoft® Excel® formulas that will give you the markup percentages for small, medium, and large rice-filled heating pads. Use cell references in the formula—do NOT use numbers.
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?
"(Show your work in this cell to solve for the profit she accumulates and the markup percentage based on cost she would have to use to make the same amount of profit.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Amount Sold
Variables Used Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
BT Selling Price
Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
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.
4. What prices should Karen charge (using the markup percentage) to obtain the same amount of profit as she did with the cost plus method? Do not include shipping.
"(Show your work in this cell to solve for the profit she accumulates and the markup percentage based on cost she would have to use to make the same amount of profit.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
BT Cost
Markup % based on cost=
Excel Formulas Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
BT Selling Price
In the yellow cells, create the Microsoft® Excel® formulas that will give you the selling prices based on markup percentage. Use cell references in the formula—do NOT use numbers.
PASSWORD: SHIV
AFTER PAYMENT ENTER PASSWORD : "SHIV" TO UNLOCK THE SOLUTION
• BT = Box of tea
• S&H = Shipping and handling
• P = Desired profit per box of tea
• RFP = Rice-filled pad
"
1. What is the markup percentage for a box of ginger tea?
"(Show your work in this cell to solve for the markup percentage for a box of ginger tea.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Cost per BT=
S&H=
P=
Excel Formulas Ginger Tea % Markup
In the yellow cells, create the Microsoft® Excel® formula that will give you the ginger tea markup percentage. Use cell references in the formula—do NOT use numbers.
2. If the rice-filled heating pads sell for $7.00, $10.00, and $15.00 for small, medium, and large, respectively, what is the markup percentage on each one?
"(Show your work in this cell to solve for the markup percentages for small, medium, and large rice-filled heating pads.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
Excel Formulas Small % Markup=
Medium % Markup=
Large % Markup=
In the yellow cells, create the Microsoft® Excel® formulas that will give you the markup percentages for small, medium, and large rice-filled heating pads. Use cell references in the formula—do NOT use numbers.
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?
"(Show your work in this cell to solve for the profit she accumulates and the markup percentage based on cost she would have to use to make the same amount of profit.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Amount Sold
Variables Used Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
BT Selling Price
Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
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.
4. What prices should Karen charge (using the markup percentage) to obtain the same amount of profit as she did with the cost plus method? Do not include shipping.
"(Show your work in this cell to solve for the profit she accumulates and the markup percentage based on cost she would have to use to make the same amount of profit.)
"
"Use the marked cells below to fill in the appropriate numbers for the variables to check your answers.
"
Variables Used Small RFP Cost=
Medium RFP Cost=
Large RFP Cost=
BT Cost
Markup % based on cost=
Excel Formulas Small RFP Selling Price=
Medium RFP Selling Price=
Large RFP Selling Price=
BT Selling Price
In the yellow cells, create the Microsoft® Excel® formulas that will give you the selling prices based on markup percentage. Use cell references in the formula—do NOT use numbers.
PASSWORD: SHIV
AFTER PAYMENT ENTER PASSWORD : "SHIV" TO UNLOCK THE SOLUTION
Comments
Post a Comment