# Profit Margin Calculations for Sales Walehouses

Please set-up the following questions, which include the answers, on an "Excel" template.

18. A jewellery store purchased a diamond rig for $2500 less 40% and 5%. The store's average unit overhead expenses are 30% of cost. The "regular price" of the ring is established so that, if it is sold in a "20% off" sale, the unit operating profit at the reduced price will be 20% of cost.

a. What is the reduced price of the ring in a "20% off" sale?

C = N(1 - d1)(1 - d2) = $2500(0.6)(0.95) = $1425

E = 0.30C and P(reduced) = 0.20C

E = 0.30($1425) = $427.50

P(reduced) = 0.20($1425) = $285

S(reduced) = C + E + P = $1425 + $427.50 + $285 = $2137.50

b. What is the regular price of the ring?

S(regular) = 1

S(reduced) = S(regular) - D(discount)

D = 0.20S(regular)

$2137.50 = S - 0.20S

$2137.50 = 0.80S

S(regular) = $2137.50 Ã· .80 = $2671.88

c. What is the operating profit if the ring happens to sell at the "regular price?"

S(regular) = $2671.88

P = S(regular) - C - E = $2671.88 - $1425 - $427.50 = $819.38

20. Furniture Warehouse bought upright freezers for $1800 less 33 1/3% and 5%. The store's overhead works out to 30% of cost. The freezers are initially priced so that a profit of 16 2/3% of cost will be realized when a freezer is sold at a "15% off" price.

a. What is the initial full rate of markup on cost?

C = N(1 - d1)(1 - d2) = $1800(0.66667)(0.95) = $1134.30

E = 0.30C = 0.30($1134.30) = $340.29

P = 0.16667C = 0.16667($1134.30) = $189.05

S(reduced) = C + E + P = $1134.30 + $340.29 + $189.05 = $1663.64

S(reduced) = $1663.64 D = 0.15S(regular)

S(reduced) = S(regular) - 0.15S(regular) = 0.85S(regular)

0.85S(regular) = $1663.64

S(regular) = $1663.64 Ã· 0.85 = $1957.22

M = S(regular) - C = $1957.22 - $1134.30 = $822.92

b. During its Scratch-and-Save Sale, customers qualify for an extra discount of either 5%, 7%, or 10%. This extra discount appears when the customer scratches a ticket at the time of a purchase. It is added to the basic 15% discount, making the combined discount 20%, 22%, or 25%, respectively. What is the store's profit or loss per freezer at each of these discounts?

d1 = 20%, d2 = 22% and d3 = 25%

S(regular) = $1957.22

S1(reduced) = S(regular)(1 - d1) = $1957.22(0.80) = $1565.78

P1 = S1(reduced) - C - E = $1565.78 - $1134.30 - $340.29 = $91.19

S2(reduced) = S(regular)(1 - d2) = $1957.22(0.78) = $1526.63

P2 = S2(reduced) - C - E = $1526.63 - $1134.30 - $340.29 = $52.04

S3(reduced) = S(regular)(1 - d3) = $1957.22(0.75) = $1467.92

P3 = S3(reduced) - C - E = $1467.92 - $1134.30 - $340.29 = -$6.67

https://brainmass.com/business/profit-margin/profit-margin-calculations-sales-walehouses-370600

#### Solution Preview

Please see attachments.

PROBLEM 1

18. A jewellery store purchased a diamond rig for $2500 less 40% and 5%. The store's average unit overhead expenses are 30% of cost. The "regular price" of the ring is established so that, if it is sold in a "20% off" sale, the unit operating profit at the reduced price will be 20% of cost.

a. What is the reduced price of the ring in a "20% off" sale?

Total purchase discount 0.57

Purchase price of ring $1,425

Overhead rate 30%

Total cost of ...

#### Solution Summary

The following problem addresses purchases and pricing. Step by step answers are provided for each.