Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

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.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 19 - Related-Party Transaction Ruse

Authors: Kate Mooney

1st Edition

0071719415, 9780071719414

More Books

Students also viewed these Accounting questions

Question

=+ Do you think it is a wise investment of the firm?

Answered: 1 week ago