Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Im doing all the correct steps here what if> data table > row input is intermediate markdown and column input is days at full retail.
Im doing all the correct steps here what if> data table > row input is intermediate markdown and column input is days at full retail. However, it keeps giving me incorrect numbers. Not sure what i am doing wrong.
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 25 to 45 in increments of 5 and the intermediate markdown varies from 10% to 45% 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 10% 15% 20% 25% full Retail 25 $ 30% 35% 40% 45% $ $ B A i Markdown Pricing Model 2 30% 3 Data 4 Retail Price $70.00 5 Inventory 1000 6 Selling Season (days) 50 7 Days at full retail 40 8 Intermediate markdown 9 Clearance markdown 70% 10 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 $70 7 14 $49 32.2 15 Demand function parameters 16 Intercept 91 17 slope -1.2 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.2 31 Unit sold 322 32 Discount revenue $15,778.00 33 Clearance Sales 34 Clearance price 21 35 Units sold at clearance 398 36 Clearance revenue $8,358.00 37 38 Total revenue $43,736.00 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 25 to 45 in increments of 5 and the intermediate markdown varies from 10% to 45% 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 10% 15% 20% 25% full Retail 25 $ 30% 35% 40% 45% $ $ B A i Markdown Pricing Model 2 30% 3 Data 4 Retail Price $70.00 5 Inventory 1000 6 Selling Season (days) 50 7 Days at full retail 40 8 Intermediate markdown 9 Clearance markdown 70% 10 11 Sales Data 12 Price(X) Average Daily Sales (Y) 13 $70 7 14 $49 32.2 15 Demand function parameters 16 Intercept 91 17 slope -1.2 18 19 Model 20 21 Full Retail Sales 22 Retail price $70.00 23 Daily sales 7 24 Days at retail price 40 25 Units sold at retail 280 26 Retail revenue $19,600.00 27 Discount Sales 28 Discount 30% 29 Discount price $49.00 30 Daily sales 32.2 31 Unit sold 322 32 Discount revenue $15,778.00 33 Clearance Sales 34 Clearance price 21 35 Units sold at clearance 398 36 Clearance revenue $8,358.00 37 38 Total revenue $43,736.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started