Cumulative markup formula

UNIT III THE RELATIONSHIP OF MARKUP TO PROFIT I TYPES OF MARKUP

A. Initial Markup Concepts dollars %

original or first retail price billed cost of merchandise initial markup 0

estimated expenses price reductions profit initial $ markup 0

planned sales price reductions original retail price 0

markup original retail price initial markup %

B. Calculating Initial Markup

1. finding initial MU% when gross margin % and retail reduction % are known gross margin % retail reductions % sales (100%) 100.00% initial markup % 0.00%

2. Finding initial MU % when gross margin and retail reductions in $ are known gross margin $ retail reductions $ sales $ initial markup $

3. Finding initial MU% when cash discounts and alteration costs are known gross margin % alteration costs % cost discount earned % retail reductions% sales % 100.00% initial markup % 0.00%

C. Cumulative Markup cumulative markup $

�1

cumulative retail $ cumulative markup %

cost retail markup % Opening inventory 0 $0.00 Purchases STD 0 $0.00 Total Merchandise Handled 0 $0.00

cumulative markup 0 cumulative markup%

D. Maintained Markup

GROSS MARGIN CALCUATION cost retail MAINTAINED MARGIN CALCUATION NET SALES $0.00 NET SALES cost of goods sold cost of goods sold new purchases new purchases inward freight inward freight Total merchandise handled 0 Total merchandise handled closing inventory closing inventory Gross Cost of Merchandise 0 Gross Cost of Merchandise cash discounts earned Net Cost of Merchandise Sold 0 alteration/workman costs Total Cost of Merchandise Sold 0 $0.00

GROSS MARGIN $0.00 MAINTAINED MARGIN GROSS MARGIN % MAINTAINED MARGIN %

1. Finding Maintained MU when Initial MU and Retail Reductions are known Initial Markup % Retail Reduction % Maintained Markup% 0.00%

2. Finding Retail Reduction when Initial MU and Maintained MU are known Initial Markup % Maintained Markup % Retail Reduction % 0.00%

�2

�3

0

�4

Module Five Basic Markup Equations Used for Merchandising Decisions

Initial Markup Concept

1. A men's swim buyer determines that the department has net sales of $875,000, expenses of $345,000, and total reductions of $95,000. This buyer also wants to attain a net profit of 4.5%. Find the initial markup percentage.

Net sales $875,000 Expenses $345,000

Reductions $95,000 Net profit-4.5%

IMU %

Calculating Initial Markup

2. A retailer in a boutique jewelry store has estimated expenses of 49%, markdowns at 15%, and stock shortage at 6.3%. A profit of 4% is desired. Calculate the initial markup percentage required.

Markdowns 15.0% Expenses 49.0% Shortage 6.3%

Profit 4.0% IMU %

Cumulative Markup

3. A sleepwear buyer has an opening stock figure of $170,000 at retail, which carries a 61% markup. On March 31, new purchases since the start of the period were $990,000 at retail, carrying a 63% markup. Find the cumulative markup percentage on merchandise handled in this department to date.

Cost Retail MU % MU $

Opening inventory $70,200 $170,000 61.0% + New Purchases $346,500 $990,000 65.0% TMH

4. A belt department had an opening inventory of $86,000 at retail, with a 56.8% markup. Purchases during November were $63,000 at cost and $142,000 at retail. Determine:

a. The cumulative markup percentage Cost Retail MU % MU $

Opening inventory $37,152 $86,000 56.8% New purchases $63,000 $142,000

b. The markup percentage on new purchases Cost Retail MU $ MU %

$64,000 $142,000

Maintained Markup

�1

5. A sporting goods store has an initial markup of 54.5%. The expenses are 34%. Markdowns are 12%. The cost of assembling bicycles and so on (e.g., workroom costs) is 6%, and shortages are 0.8%. What was the maintained markup percentage?

Initial markup 54.5% Expenses 34.0%

Markdowns 12.0% Workroom costs 6.0%

Shortages 0.8%

Total Reductions MMU %

6. The men's shorts department buyer determined that the department’s initial markup should be 45.5%. The buyer also wanted to attain a maintained markup of 39%. Under this plan, what retail reduction (in percentage) would be allowed?

IMU % 45.5% MMU % 39.0%

Net Sales % 100.0% Reduction %

Average Cost

7. A buyer plans to purchase 8,600 pairs of socks for a pre-Christmas sale. The unit retail price is planned at $7.50, and the markup goal for the purchase is 60%. The buyer purchases 4,400 pairs at the Sock Company showroom at a cost of $3.25 each.

a. What is the maximum total cost the buyer can pay for the balance of the total purchase?

Units Retail Total Retail MU %

Cost Purchases Planned

8,600 $7.50 60.0% Units Cost Placed Total Cost 4,400 $3.25

Cost Balance Cost Balance

b. What will be the average cost per pair for the socks (4,200 socks) yet to be purchased?

Unit Balance Cost Balance Avg. Cost 4,200 $0

8. A buyer who needs $10,000 worth of merchandise at retail for a housewares department has written orders for $2,875.50 at cost. The planned departmental markup percentage is 43.5%. How much (in dollars) is left to spend at cost? Cost Planned Retail Planned MU %

$10,000.00 43.5% Cost Placed

$2,875.50 Cost Balance

Average Retail Practice Problems

9. An dress buyer confirms an order reading as follows: a. 165 maxi dresses costing $39 each b. 85 tunics costing $28 each If a retail price of $85 is placed on the maxi dresses, and a markup average of 55.5% is sought, what retail price must the tunics carry?

Units Cost Total Cost MU % Total Retail Planned

Maxi 155 $39.00 Tuni 85 $28.00

55.5%

�2

Retail Placed Total Retail Maxi 155 $85.00

Retail Balance Retail Various Pricing Strategies (list at least two) Tunic 85

Average Markup

10. A suit buyer who plans sales of $95,000 at retail during April has an average markup goal of 54%. An order is placed with the B&C Sportswear Company for April delivery in the amount of $5,975 at cost and $12,500 at retail. What markup percentage must be made on the balance of the April purchases to achieve the planned markup?

Retail Planned MU % Cost Planned MU $ MU % $95,000 54.0%

B & C order placed $12,500 $5,975

�3

�4

�5

�6

Correct formula and answer

One or more formula errors

Wrong formula or no formula

�7

�8

�9

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com