Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. use the markdown pricing model spreadsheet model a

Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the...

60.1K

Verified Solution

Question

Accounting

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 20 to 40 in increments of 5 and the intermediate markdown varies from 25% to 60% 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
$49 32.2
Demand function parameters
Intercept 91
Slope -1.2
Model
Full Retail Sales
Retail price $70.00
Daily sales 7
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.2
Unit sold 322
Discount revenue $15,778.00
Clearance Sales
Clearance price 21
Units sold at clearance 398
Clearance revenue $8,358.00
Total revenue $43,736.00

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Suppose a batch of steel rods produced at a steel plant have a mean length of...

Statistics
Q

Bower birds are unique to Australia. These ground dwelling birds build elaborate grass nests and decorate...

Biology
Q

Companies are turning to Customer Relationship Management (CRM) to improve their customer focus. List and explain...

General Management
Q

Joe has an annual income of $80,000. His employer pays all of his health insurance premiums. Joe...

Accounting
Q

Jen Psaki, an auditor with Martinez CPAs, is performing a review of Sergei Company's inventory account....

Accounting
Q

If a solid line represents a covalent bond and a dotted line represents intermolecular attraction...

Biology
Q

Bashir correctly graphed the quadratic function y=-3x2 +5 Which of these is true about Bashir's...

Basic Math
Q

Assume a merchandising company's estimated sales for January, February, and March are $104,000, $124,000, and...

Accounting
Q

The Asia Pacific Regional Director of the Olympus hotel group has told the regions hotel...

Accounting
Q

Pro-Weave manufactures stadium blankets by passing the products through a weaving department and a sewing...

Accounting
Q

a. The initial cost of the extraction equipment is $2,500,000. In addition to this cost,...

Accounting
Q

Using historical records, a manufacturing firm has developed the following probability distribution for the number...

Accounting