Question
Using the following info, calculate the remaining values in the spreadsheet. Equations for working backwards, one for dollar margins and another for percent margins: Supplier
Using the following info, calculate the remaining values in the spreadsheet.
Equations for working backwards, one for dollar margins and another for percent margins:
Supplier Selling Price ($) = Customer Selling Price ($) Customer Margin ($)
Supplier Selling Price ($) = Customer Selling Price ($) * [1 Customer Margin (%)]
Equations for working forwards, one for dollar margins and another for percent margins:
Customer Selling Price ($) = Supplier Selling Price ($) / [1 Customer Margin (%)]
Customer Selling Price ($) = Supplier Selling Price ($) + Customer Margin ($)
8oz 32 oz $0.74 $2.70 27.0% 27.0% 15.0% 15.0% Supermarket Channel Retail Price Retail Margin Retail Purchase Price (RPP) Distributor Margin Distributor Purchase Price (DPP) Manufacturer Sales Price (MSP) Cost Per Unit Contribution per Unit Sold Manufacturer Gross Margin 8oz 32oz $0.88 $3.19 Multipack $2.84 35.0% 35.0% 35.0% 9.0% 9.0% 9.0% Natural Foods Channel Retail Price Retail Margin Retail Purchase Price (RPP) Natural Foods Distributor Margin Natural Foods Distributor Purchase Price Wholesaler Margin Wholesaler Purchase Price (WPP) Manufacturer Sales Price (MSP) Cost Per Unit Contribution per Unit Sold Manufacturer Gross Margin 7.0% 7.0% 7.0% 36.00% 43.60% 37.60% 8oz 32 oz $0.74 $2.70 27.0% 27.0% 15.0% 15.0% Supermarket Channel Retail Price Retail Margin Retail Purchase Price (RPP) Distributor Margin Distributor Purchase Price (DPP) Manufacturer Sales Price (MSP) Cost Per Unit Contribution per Unit Sold Manufacturer Gross Margin 8oz 32oz $0.88 $3.19 Multipack $2.84 35.0% 35.0% 35.0% 9.0% 9.0% 9.0% Natural Foods Channel Retail Price Retail Margin Retail Purchase Price (RPP) Natural Foods Distributor Margin Natural Foods Distributor Purchase Price Wholesaler Margin Wholesaler Purchase Price (WPP) Manufacturer Sales Price (MSP) Cost Per Unit Contribution per Unit Sold Manufacturer Gross Margin 7.0% 7.0% 7.0% 36.00% 43.60% 37.60%
Step 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