Question: Use the Markdown Pricing Decisions spreadhseet model and a two-way data table to find the total revenue if days at full retail vary from 20

Use the Markdown Pricing Decisions spreadhseet model and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the itnermediate markdown varies from 15% to 50% in increments of 5%
Markdown Pricing Model
Data
Retail Price $70.00
Inventory 1000
Selling Season (days) 50
Days at full retail 40
Intermediate markdown 30%
Clearance markdown 70%
Sales Data
Price(X) Average Daily Sales (Y)
$70 7.00
$49 32.20
Demand function parameters
Intercept 91
Slope -1.2
Model
Full Retail Sales
Retail price $70.00
Daily sales 7.00
Days at retail price 40
Units sold at retail 280
Retail revenue $19,600.00
Discount Sales
Discount 30%
Discount price $49.00
Daily sales 32.20
Unit sold 322
Discount revenue $15,778.00
Clearance Sales
Clearance price 21.00
Units sold at clearance 398
Clearance revenue $8,358.00
Total revenue $43,736.00
Markdown Pricing Model
Data
Retail Price $70.00
Inventory 1000
Selling Season (days) 50
Days at full retail 40
Intermediate markdown 30%
Clearance markdown 70%
Sales Data
Price(X) Average Daily Sales (Y)
$70 7.00
$49 32.20
Demand function parameters
Intercept 91
Slope -1.2
Model
Full Retail Sales
Retail price $70.00
Daily sales 7.00
Days at retail price 40
Units sold at retail 280
Retail revenue $19,600.00
Discount Sales
Discount 30%
Discount price $49.00
Daily sales 32.20
Unit sold 322
Discount revenue $15,778.00
Clearance Sales
Clearance price 21.00
Units sold at clearance 398
Clearance revenue $8,358.00
Total revenue $43,736.00
This is Tab Form

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Use the Markdown Pricing Decisions spreadhseet model and a two-way data table to find the total revenue if days at full retail vary from 15 to 35 in increments of 5 and the itnermediate markdown...

Q:

use the markdown pricing decisions spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown...

Q:

4. A garage band wants to hold that concert. The expected crowd is 3000. The average expenditure on concessions is $15. Ticket sells for $10 each, and the band's profit is 80% of the gate, along with...

Q:

4. A garage band wants to hold a concert. The expected crowd is 3,000. The average expenditure on concessions is $15. Tickets sell for $10 each, and the bands profit is 80% of the gate, along with...

Q:

15. Use the Markdown Pricing Decisions spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown...

Q:

THIS IS FOR QMB 4680 PART 2- = Homework: Homework 2 - Sprea... Question 5, 11.6.43 HW Score: 34%, 34 of 100 points O Points: 0 of 15 Save The director of a nonprofit ballet company is planning its...

Q:

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 30 to 50 in increments of 5 and the intermediate markdown varies...

Q:

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

Q:

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

Q:

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 30 to 50 in increments of 5 and the intermediate markdown varies...

Q:

A and B are two alloys of bronze and platinum prepared by mixing metals in the ratio of 4:3 and 9:5, respectively. If equal quantities of alloys A and B are melted to form a third alloy C, then find...

Q:

Calculate the pH of the following solutions : a) HF 0.01 M. b) NH4Cl 0.01 M. c) 0.01 M ammonium acetate.

Q:

The price of Jane's Book Co . is now $ 7 6 . The company pays no dividends. Ms . Johnson expects the price four years from now to be $ 1 0 0 per share. Should she buy Jane's Book Co . stock if she...

Q:

Find the present value of the following ordinary simple annuity. Periodic Payment Payment Interval Term Interest Rate Conversion Period $375.00 1 month 8.5 years 7% monthly The present value is...

Q:

(LO 8-3) Go to Loughran and McDonalds sentiment word lists at https://sraf.nd.edu/textual-analysis/resources/ and download the Master Dictionary. These lists are what theyve used to assess sentiment...

Q:

(LO 8-1) The preceding question asked you to figure out how the stock market responded to Amazons announcement that it would purchase Whole Foods. The question now is if the stock market for Amazon...

Q:

(LO 8-1) Match the following descriptions or equations to one of the following components of the DuPont ratio: Return on stockholders equity Profit margin Asset turnover Equity multiplier Return on...