This answer is not correct

home / study / business / operations management / operations management questions and answers / check my work wk qu. 4-13 a student prepare... Question: Check my work Wk Qu. 4-13 A student prepared the following..... See this question in the app Check my work Wk Qu. 4-13 A student prepared the following.. 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. B 2 Original Price 3 Discount (5) 4 Discount ($) 5 Net Price 6 Sales Tax(%) 7 Sales Tax($) 8 Final Price 180 0.2 - B2 X B3 = B2 - 84 0.09 - ROUND (B5 X 36,2) = ROUND (B5 + 7,2) Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.) Value Cell B4 (Discount in dollars) B5 (Net Price) B7 (Sales tax in dollars) B8 (Final Price) Swati B. Jan Expert Answer Nirun B. Indian Inst Shelly Sachdeva answered this Was this answer helpful? i 22 answers Find me Here is my answer: Given price is 180 and discount is 0.2% then the net discount in Sin box B4 is Discount = 180 * 0.2 100 = 0.36 1 Hence Net price in B5 is B2-B4 =180 0.36 = 179.64 The sale tax is 0.09% of net price in B7 is 0.09 Tar = 179.64 * 100 = 0.16 After adding sale tax the Final price in B8 is Tar = 179.64 +0.16 = 179.80 Hence answers are: B4 0.36 B5 179.64 B7 0.16 B8 179.80