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

Workplace Hazards

Please respond to the following: What are the distinctive features of the workplace as a setting where exposure to chemical and physical hazards occurs? Be sure to respond to at least one of your classmates’ posts.

What Makes 3D Game Development a Smart Business Investment for Game Studios?

For studios and startups, 3D game development offers both creative flexibility and commercial advantages. High-quality visuals and realistic mechanics help attract modern players who expect console-level experiences across all devices. At the same time, 3D assets can be reused, scaled, and optimized for multiple platforms, making development more efficient in

Prof Double R

  Take a position. Do you agree or disagree that an emphasis on discipline and a zero tolerance approach in schools with a large minority or disadvantaged population creates a school-to-prison pipeline? First, title your initial post either “An emphasis on discipline / zero tolerance in schools with large minority

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM, A+ WORK

Tutor Discussion and Assignment BUSN623 Week 6 Assignment Case Studies Selection The following three Case Studies are hypothetical simulations related to business tort situations. Choose ONE of these to complete your Week 6 Assignment. References to support your analysis and conclusion for recommendations should be drawn from your research using

Administrative Simulation

 Administrative Simulation   Download and complete the attached check sheet. When completed, upload a scan or image of the PDF here.   Discussion Topic 1.1   You get a call from an angry customer who tells you she had booked an adventure for her husband as a surprise for his 45th birthday only

Module Six Case Analysis BUS 206

see attachment Module Six Case Analysis Guidelines and Rubric.html BUS 206 Module Six Case Analysis Guidelines and Rubric Overview In the case of Lucy v. Zehmer, Zehmer spent the night drinking with his friend Lucy. During the evening, a piece of paper was signed whereby Zehmer agreed to sell his

Simulation Email 4

 You are working at First in My Family Education as an executive assistant to Mariam Raza, the President.  Mariam has sent you the following request:  I’ve drafted an email to Anne Vaccaro, the Social Media Manager at First in My Family Education, regarding a marketing plan and budget request. Please

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM, A+ Work

Tutor discussion Hypothetical Case Simulation You are the CEO of business (in an industry you will select) that is considering a new AI application called Dublin-10, to automate a system and bring efficiency to operations. An ROI study has convinced you this innovation will enable the business to eventually save costs

Business Finance – Management HOMEWORK

attached. Reference: David, F. R., David, F. R. & David, M.E. (2023). Strategic management: a competitive advantage approach, concepts and cases (18th ed.). Upper Saddle River: Pearson. Homework 1: PHASE 2… 5 pages (additional/continuation to the phase 1) HOMEWORK 2: 1 page with 2 references: Overview In this exercise, compare

HRM 6304 VIII J

2 Labor Relations and Collective Bargaining HRM 6304 Unit VIII Journal You have been asked to make a short speech to the executive team on how this course could help shape labor relations within the organization, including the history of the American labor movement, dispute resolutions, avoidance, models, strategies, and

ITC 5301 VIII J

2 Management Information Systems ITC 5301 Unit VIII Journal This journal measures your mastery of ULOs 2.3, 3.3, 3.7, and 5.5. Reflect on how you can apply the concepts learned in this course in your future professional, personal, or academic pursuits. Given the ubiquity of global corporations in the current

Tesla

  Step 1 Review the Strategic Management: A Competitive Advantage Approach, Concepts, and Cases textbook and find and study the case information about your selected company. List the firm’s strengths, weaknesses, opportunities, and threats. Consider both internal and external factors when compiling your list. Go to that firm’s website and

Logistics Discussion 3

BUSI 615 Discussion Assignment Instructions You will complete 4 Discussions over the duration of this course. These Discussions will cover the following topics: · Manufacturing Resource Planning · Enterprise Resource Planning · Logistics Information Systems · Implementation of a Logistics System Each will be completed over a period of 2

EXP A3

A2 is a completed assignment. A2 has to be reviewed in order to complete A3.  Student Name: firstName lastName [A3 – Assignment 3] Create Personas and User Stories based on your interview. This is another application of the Empathize step in the Design Thinking framework. Here, you restate or depict

Business Finance – Accounting Week Two Assignment 3. See Instructions

Top of Form Assignment 3: Dissect Bonds and Stocks BOOK LINK: Corporate Finance: A Focused Approach Michael C. Ehrhardt; Eugene F. Brigham https://bookshelf.vitalsource.com/reader/books/9798214584249/epubcfi/6/2[%3Bvnd.vst.idref%3Dcover-page]!/4/2[cover-page]/6[EYBS9QXYGD16YZT2E049]/2%4051:2 I will message the username and password for access to the book. Top of Form Hide Assignment Information Instructions Instructions · Textbook Chapter 5: Question 5-1 (p. 226),

Business Finance – Accounting Week Two Assignment 4. See Instructions

Top of Form Assignment 4: Define Capital Budgeting BOOK LINK: Corporate Finance: A Focused Approach Michael C. Ehrhardt; Eugene F. Brigham https://bookshelf.vitalsource.com/reader/books/9798214584249/epubcfi/6/2[%3Bvnd.vst.idref%3Dcover-page]!/4/2[cover-page]/6[EYBS9QXYGD16YZT2E049]/2%4051:2 I will message the username and password for access to the book. Instructions Chapter 9: Mini-case a. through l. only (p. 404 – 405).  Complete the above textbook

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

ITC 5301 VII PPP

Printed by: [email protected]. Printing is for personal, private use only. No part of this book may be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted. Printed by: [email protected]. Printing is for personal, private use only. No part of this book may be reproduced or transmitted without publisher’s