A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount. To be complete, the student included a calculation of sales tax in the final price, given the original price (180), discount (0.2), and sales tax rate (0.09) shown below. A B 1 2 Original Price 180 3 Discount(%) 0.2 4 Discount ($) = B2 × B3 5 Net Price = B2 − B4 6 Sales Tax(%) 0.09 7 Sales Tax($) = ROUND(B5 × B6,2) 8 Final Price = ROUND(B5 + B7,2) Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.)
A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount. To be complete, the student included a calculation of sales tax in the final price, given the original price (180), discount (0.2), and sales tax rate (0.09) shown below. A B 1 2 Original Price 180 3 Discount(%) 0.2 4 Discount ($) = B2 × B3 5 Net Price = B2 − B4 6 Sales Tax(%) 0.09 7 Sales Tax($) = ROUND(B5 × B6,2) 8 Final Price = ROUND(B5 + B7,2) Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.)
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
A student prepared the following spreadsheet model to calculate the final
| A | B | |
| 1 | ||
| 2 | Original Price | 180 |
| 3 | Discount(%) | 0.2 |
| 4 | Discount ($) | = B2 × B3 |
| 5 | Net Price | = B2 − B4 |
| 6 | Sales Tax(%) | 0.09 |
| 7 | Sales Tax($) | = ROUND(B5 × B6,2) |
| 8 | Final Price | = ROUND(B5 + B7,2) |
Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education