Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

project

working on a class excel sheet

Formulas

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 ERROR:#DIV/0!
estimated expenses
price reductions
profit
initial $ markup 0
planned sales
price reductions
original retail price 0
markup
original retail price
initial markup % ERROR:#DIV/0!
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 $ ERROR:#DIV/0!
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 $
cumulative retail $
cumulative markup % ERROR:#DIV/0!
cost retail markup %
Opening inventory 0 $0.00
Purchases STD 0 $0.00
Total Merchandise Handled 0 $0.00
cumulative markup 0
cumulative markup% ERROR:#DIV/0!
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 0
GROSS MARGIN % ERROR:#DIV/0! MAINTAINED MARGIN % ERROR:#DIV/0!
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%

Problems

Module Five Basic Markup Equations Used for Merchandising Decisions
Correct formula and answer
Initial Markup Concept One or more formula errors
Wrong formula or no formula
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
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%
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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Tutor discussion The Week 1 Lesson and eReserve readings introduce ePortfolios. Please review those materials before completing this Discussion. Engage in a Web search to locate a sample ePortfolio. Then, for your initial post: · Post the ePortfolio here by: · (1) a hyperlink to its location on the web,

Business Finance – Management QSO 321 Module One Assignment

PLEASE SEE ATTACHMENT Module One Assignment Guidelines and Rubric.html QSO 321 Module One Assignment Guidelines and Rubric Overview In this module, you have learned about the benefits, drawbacks, and overall value of using the triple bottom line (TBL) in business. In this assignment, you will take a closer look at

HRM 6304 VII E

2 Labor Relations and Collective Bargaining HRM 6304 Unit VII Essay As the corporate labor relations lawyer for a European car manufacturer, building a new facility in Middle Valley, Tennessee, you have been asked by corporate management to draft a position paper regarding the labor relations process at the new

Business Management

Communication  Communicating Your Leadership Vision 3109.1.1 :  Develops Self-Awareness and Personal Values The learner identifies their personal values, including honesty, integrity, respect, emotional intelligence, and ethical responsibility, to develop self-awareness through self-assessment. 3109.1.3 :  Demonstrates How Leadership Delivers Results The learner demonstrates how their leadership abilities, including active listening, influence, and ethical

redes

Criteria Ratings Points Strategic Alignment of Benefits 26 to >23 pts Advanced Clarity is brought to issues being discussed. Facts are supported by the textbook, practitioner, or a scholarly work 23 to >21 pts Proficient Some points are stated clearly. Support may not effectively strengthen the ideas. 21 to >0

Personal Brand

Platform for your Personal Brand r this portion; bullets can be used to help structure) Think • Core purpose • Core values • Ethical frame • Value proposition Feel • Brand personality • Enthusiasm (loyalty & engagement) Say  Brand identity elements (name, logo, tagline, jingle, color, cartoon character, etc.)

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

tutor discussion  Insider Trading week 1 (no more than 250 words 2 references)) Your research should provide a measure of information about the topic’s significance to the current business climate. At least two reference sources should be used to support a substantive and detailed response. Make sure to give credit

discussion replies

reply to the 2 prompts INDS 491 Discussion Assignment Instructions The discussions in this course are meant to be collaborative learning experiences that foster a spirit of community and collegiality, but you must also view these as academic assignments with formal requirements. For these discussions, you are required to submit

current event ethics

BUSI 301 Paper: Current Events Ethics Assignment Instructions Overview Our study of ethics in business can sometimes seem esoteric and removed from day-to-day management responsibilities, but media are filled with real-life examples of unethical business behavior that harms the businesses involved, as well as their shareholders, customers, employees, and other

Deliverable 4 – Creating Alternative Revenue Streams

Deliverable 4 – Creating Alternative Revenue Streams Scenario Health organizations continue to face challenges relative to costs and revenue. Changes in reimbursement structure is most often cited as one of the biggest challenges for providers. As a result, leaders are developing new approaches aimed at creating additional revenue streams. Traditionally,

DEFM200

see attached Instructions Assignment Directions Create a five-page essay that elaborates on the key ethical issues in federal government contracting and the differences between legislative and executive branch regulations in ethical behavior. Include the degree to which commercial contractors are bound by federal regulations. Remember, the two branches operate independently

Unit VII GSM

See attached 2 Teameco Broughton Institution: Columbia Southern University BUS 6320: Global Strategic Management Instructor: Professor: Robin Shah Date: 3/4/2026 Figure 1: Infographic on Johnson & Johnson Strategic Expansion References Johnson & Johnson. (2026, January 26). Johnson & Johnson named a 2026 Fortune World’s most admired company. Rothaermel, F. T.

Why Are Custom Candle Boxes Essential for Modern Candle Brands?

  What Are Custom Candle Boxes? Custom candle boxes are specially designed packaging solutions created to fit candles perfectly. But are they only about size and shape, or do they offer more than basic protection? Why Do Candles Need Custom Packaging? Candles are delicate—so how do you protect them from

Drinking Water Quality

Please respond to the following: Using the Internet or Strayer Library, research the work of U.S. government agencies to ensure the safety of your community’s water supply. Also, locate a current Consumer Confidence Report or City or Town water quality report to assess your community’s drinking water’s quality. Summarize your

Excel Questions Business Analysis

Answer the following questions excel. Assignment 6: Analyzing Distribution Types and Trend Lines in Excel Scenario: You are a data analyst for a small retail company, and your manager has asked you to analyze customer purchasing trends over the past year. You have been provided with sales data from different

SCMG201

see attached Discussion Prompt: Find an operations-based company you are familiar with and research its use of suppliers. First, take a look at what companies have already been reported on and try not to duplicate what someone else has analyzed.  Company: WALGREENS – Nationwide pharmacy and retail operations Discussion Points:

Climate Change Efforts

Please respond to the following: Consider what you learned about how COVID-19 shutdowns affected air quality. What can these events teach us about efforts to control global climate change? What do you think are fair and realistic expectations of the world’s more-developed and less-developed countries in this effort? Be sure