ch08qz02a

# ch08qz02a - Selling Price Markup Rate Based on Cost Markup...

This preview shows page 1. Sign up to view the full content.

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 08 - Quiz 02 Sunny’s Casual Patio Furniture Cost \$279.00 \$310.99 11.5% ––––– \$59.12 \$110.75 87.3% ––––– \$68.45 \$107.00 56.3% ––––– \$117.25 \$220.59 88.1% ––––– \$85.64 \$160.75 ––––– 46.7% \$28.94 \$165.65 ––––– 82.5% \$26.50 \$39.79 ––––– 33.4% \$117.00 \$145.50 ––––– 19.6% Directions: c. Format for Percentage and 1 Decimal place.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Selling Price Markup Rate Based on Cost Markup Rate Based on Selling Price a. For items in Cells C5 through C8, enter formulas to calculate Markup Rate based on Cost. b. For items in Cells D9 through D12, enter formulas to calculate Markup Rate based on Selling Price. d. Save the file as ch08qz02a.xls. A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online