Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please fill in the blanks for the question below on the excel spreadsheet. I have attached some formulas to make it easier. Thanks! Formulas: %

please fill in the blanks for the question below on the excel spreadsheet. I have attached some formulas to make it easier. Thanks!

Formulas:

% MC = ($MC/$First Price) * 100
%IMU = ($First Price - $MC)/$First Price * 100 OR 100% - %MC
$ IMU = $First Price - $MC OR $First Price * %IMU/100
$AMU = ($First Price * %AMU)/100
$Premium Price = $First Price + $AMU
$TemMD =( $First Price *%TemMD)/100
$Promotional Price = $First Price - $TemMD
$PermMD = (%PermMD * $First Price)/100
$Clearance Price = $First Price - $PermMD

Question:

Prestige Pricing Strategy
$First Price $MC %MC %IMU $IMU %AMU $AMU $ Premium Price %PermMD $PermMD $Clearance Price
65.00 30.00 20.00 35.00
70.00 30.00 20.00 35.00
75.00 35.00 20.00 35.00
80.00 35.00 20.00 35.00
85.00 35.00 20.00 35.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

Machine Learning In Finance From Theory To Practice

Authors: Matthew F Dixon, Igor Halperin, Paul Bilokon

1st Edition

3030410676, 978-3030410674

More Books

Students also viewed these Finance questions