45

50

55

Homework: Weeks 05-06, Chapter 11, Spreadsheet Modeling an Save Score: 8 of 20 pts 7 of 7 (6 complete) HW Score: 64.5%, 64.5 of 100 pts B 11.6.47 Question Help Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 35 to 55 in increments of 5 and the intermediate markdown varies from 20% to 55% in increments of 5%. Click here to view the Markdown Pricing Model spreadsheet model with numbers. Click here to view the Markdown Pricing Model spreadsheet model with Excel functions. Fill in the two-way data table below. (Round to the nearest dollar as needed.) Intermediate Markdown Days at 20% 25% 30% 35% 40% 45% 50% full Retail 55% 35 $ 49665 $50645 $51037 $ 50841 $ 48860 $ 46218 $ 43575 $ 40933 40 $ 47215 $47950 $48244 $48097 $47509 $ 46480 $44800 $42280 45 Enter your answer in the edit fields and then click Check Answer. 2 parts Clear All Check Answer remaining eeks 05-06, Chapter 11, Spreads 7 of 7 (6 complete) i Markdown pricing model spreadsheet model numbers el es elow $70.00 1000 55 40 30% 70% ned vedi 3 Data 4 Retail Price 5 Invenery 6 Selling Season (days) 7 Days at full retail 8 Intermediate markdown 9 Clearance markdown 10 11 Sales Data Price(X) 13 $70 14 $49 15 Demand function parameters 16 Intercept 17 Slope $ $ 12 Average Daily Sales 7.00 32.20 91 - 1.2 1R Hit fiel Print Done lvez mework.aspx?homeworkId=577221988&questionid=5&flushed=true&cld=6206339¢erw