that is all inform the exercise has

no more information

11.6.47 Use the Markdown Pricing Model model and a two-way data table to find the total vendays till vary from 30 to 50 in increments of and the water varies from this Globe te iw the Meadow Pring Modestoel sumber Dr. Makdown Pring Modelreeds Exections in the two-way die table below intermediate Markdown 30% 30% 40% 49% Days Full Retail 10 var2 Row vard Var3 var varl. Markdown Pric 2 3 Data Retail Price Inventory Selling Season Days at full reti Intermediate m Clearance mark 70 1000 50 5 6 7 8 40 30 70 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Sales Data Price(X) Average Daily 70 7 49 32.2 Demand functie Intercept 91 Slope -1.2 Model 25 19600 27 28 29 30 31 32 33 34 Full Retail Sale Retail price 70 Daily sales 7 Duys at retail p 40 Units sold at re 280 Retail revenue Discount Sales Discount 30 Discount price 49 Daily sales 322 Unit sold 322 Discount reven Clearance Sales Clearance price 15778 var varl. Model Row 19 20 21 22 23 24 25 26 27 28 29 30 31 19600 Full Retail Sale 70 Retail price Daily sales 7 40 Days at retail p Units sold at re 280 Retail revenue Discount Sales Discount 30 Discount price 49 Daily sales 32.2 Unit sold 322 Discount reven Clearance Sale: Clearance price 21 Units sold at ck 398 Clearance revei 32 15778 33 8358 Total revenue 43736 34 35 36 37 38 39 40 41 42 43 44 45 46 Markdown Pricing Model spreadsheet model with Excel functions B 1 Markdown Pricing Model 3 Data 5 6 7 8 9 Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown 70.00 1000 55 40 30% 70% 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 70 7.00 14 49 32.20 15 Demand function parameters 16 Intercept=INTERCEPT(B13:B14,A13:A14) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+B17 B22 24 Days at retail price =B7 25 Units sold at retail =B23B24 26 Retail revenue 27 Discount Sales Dimenu =B25B22 20 -RO Print Done Markdown Pricing Model spreadsheet model with Excel functions 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 70 7.00 14 49 32.20 15 Demand function parameters 16 Intercept=INTERCEPT(B13:B14,A13:A14) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+B17"B22 24 Days at retail price =B7 25 Units sold at retail =B23*B24 26 Retail revenue =B25*B22 27 Discount Sales Discount =B8 29 Discount price =B22"(1-B28) 30 Daily sales =B16+B17"B29 31 Unit sold =MIN(B30* 16-B24),B5-B25) 32 Discount revenue =B31B29 33 Clearance Sales 34 Clearance price =B4"(1-B9) 35 Units sold at clearance =MAX(O,B5-B25-B31) 36 Clearance revenue =B34B35 37 38 Total revenue-C26+C32+C36 28 Print Done 11.6.47 Use the Markdown Pricing Model model and a two-way data table to find the total vendays till vary from 30 to 50 in increments of and the water varies from this Globe te iw the Meadow Pring Modestoel sumber Dr. Makdown Pring Modelreeds Exections in the two-way die table below intermediate Markdown 30% 30% 40% 49% Days Full Retail 10 var2 Row vard Var3 var varl. Markdown Pric 2 3 Data Retail Price Inventory Selling Season Days at full reti Intermediate m Clearance mark 70 1000 50 5 6 7 8 40 30 70 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Sales Data Price(X) Average Daily 70 7 49 32.2 Demand functie Intercept 91 Slope -1.2 Model 25 19600 27 28 29 30 31 32 33 34 Full Retail Sale Retail price 70 Daily sales 7 Duys at retail p 40 Units sold at re 280 Retail revenue Discount Sales Discount 30 Discount price 49 Daily sales 322 Unit sold 322 Discount reven Clearance Sales Clearance price 15778 var varl. Model Row 19 20 21 22 23 24 25 26 27 28 29 30 31 19600 Full Retail Sale 70 Retail price Daily sales 7 40 Days at retail p Units sold at re 280 Retail revenue Discount Sales Discount 30 Discount price 49 Daily sales 32.2 Unit sold 322 Discount reven Clearance Sale: Clearance price 21 Units sold at ck 398 Clearance revei 32 15778 33 8358 Total revenue 43736 34 35 36 37 38 39 40 41 42 43 44 45 46 Markdown Pricing Model spreadsheet model with Excel functions B 1 Markdown Pricing Model 3 Data 5 6 7 8 9 Retail Price Inventory Selling Season (days) Days at full retail Intermediate markdown Clearance markdown 70.00 1000 55 40 30% 70% 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 70 7.00 14 49 32.20 15 Demand function parameters 16 Intercept=INTERCEPT(B13:B14,A13:A14) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+B17 B22 24 Days at retail price =B7 25 Units sold at retail =B23B24 26 Retail revenue 27 Discount Sales Dimenu =B25B22 20 -RO Print Done Markdown Pricing Model spreadsheet model with Excel functions 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 70 7.00 14 49 32.20 15 Demand function parameters 16 Intercept=INTERCEPT(B13:B14,A13:A14) 17 Slope =SLOPE(B13:B14,A13:A14) 18 19 Model 20 21 Full Retail Sales 22 Retail price =B4 23 Daily sales =B16+B17"B22 24 Days at retail price =B7 25 Units sold at retail =B23*B24 26 Retail revenue =B25*B22 27 Discount Sales Discount =B8 29 Discount price =B22"(1-B28) 30 Daily sales =B16+B17"B29 31 Unit sold =MIN(B30* 16-B24),B5-B25) 32 Discount revenue =B31B29 33 Clearance Sales 34 Clearance price =B4"(1-B9) 35 Units sold at clearance =MAX(O,B5-B25-B31) 36 Clearance revenue =B34B35 37 38 Total revenue-C26+C32+C36 28 Print Done