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

Integration of Faith

see attachment BUSI 690 Integration of Faith Assignment Instructions Review the Thompson text and apply your knowledge of strategy/policy and your Christian worldview as you evaluate the firm used in the case study. Search the Bible (either the Old or New Testament) for verse(s) that would guide you in answering

case study

AB InBev Case Study: Company, Supply Chain & Marketing — Strategies, Issues, Solutions Purpose of this Case Provide a concise, decision‑oriented briefing on Anheuser‑Busch InBev (AB InBev): who they are, how their supply chain and marketing engines work, what’s breaking, and practical solutions. This front section is designed to set

Business

PSYC 320 Behavior Modification Project: PowerPoint Assignment Instructions Overview You will present your research via a PowerPoint presentation of your Behavior Modification Project. Instructions There should be a minimum of ten slides which should clearly and concisely present the experiment in an interesting and creative manner. One slide for a

MIS – 6

Welcome to week six. Now that you’ve defined your MVP and started building your prototype, it’s time to get clear on what you still need to learn. This week, you’ll write a short testing plan that outlines your riskiest assumptions and how you’ll know if your MVP is working. Every

5-2 MTwo

The assignment will be uploaded, it has to do with Accounting. This assignment is posted for Dr. Freya

Business Finance – Management week 4 assignment

need done by tommorow Innovation Ambition Continuum Comparison Worksheet <Your Name> The University of Arizona Global Campus GEN499 <Your Instructor’s Name> <Date> Part 1: Complete this part of the worksheet to evaluate the two potential solutions to the best possible solution for your selected problem. Provide a brief description of

PowerPoint 2021 In Practice – Ch 2 Guided Project 2-3

Information Technology Working to . . . Solve business problems Design solutions Lead digital advances Develop innovations The Evolution of Information Technology Mainframe PC/Internet Cloud/Mobile IT Automation/Shifting Skills Job changes Obsolete tasks New skills needed Improved decision making Efficiency increased Better analytics More relevant information Growing Trends Cloud Security IoT—Internet

real estate appraisal

How does one reconcile the three valuation approaches when making a value estimate? Using the sample URAR found at the end 6f Chapter 16 of the text, explain the adjustments made to the comparable sales. Be attentive to additions and subtractions. Chapter 16 doc Using the internet, determine the levels

Deliverable 03 – Engaging Stakeholders

  Scenario After reviewing the new proposed vision from Healthy Dynamics that includes updated mission, focus area, and objectives, the CEO has decided to contract a project manager. The project manager understands the importance of identifying stakeholders early in the strategic planning process. The project manager will be responsible for

faith

Bible BUSI 606 FAITH AND LEARNING ASSIGNMENT INSTRUCTIONS For this assignment, you will write an essay with a minimum of 500 words where you will integrate the Bible into one of the topics related to global financial markets covered in this course. You will briefly describe how the Bible is

int9

   Financial Management of Multinational Firm BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner, without

ACC 5301 V DB R2

2 Management Applications of Accounting ACC 5301 DB V Reply 2 Post 1: Initial post addressing the discussion board topic is due by the end of day on Saturday. •   Your response post should be at least 250 words in length. •   Your response post should include at least one APA-formatted scholarly,

Deliverable 04 – Relationship Management Document

  Scenario Recall a time when you were involved with a conflict in the workplace or witnessed a conflict at work. This situation should be one that involves a relationship of some kind (i.e. manager-employee, employee-employee, etc.) where a conflict occurred. Think about how this experience could have been improved

Deliverable 03 – Self-Management Plan

  Scenario As such, you need to consider how to manage yourself before you can really manage others. You need to think about what your personal and professional stress levels are–what might be the breaking points between succeeding and failing? How can I manage that stress? What emotions come to

D6

Introduction You will analyze the Modeling the  Causes and Mitigation Measures for Cost Overruns in Building Construction: The Case of Higher Education Projects case study by Alhammadi, Y., Al-Mohammad, M., & Rahman, R. A. (2024) and cover the pertinent facts of the case in the context of the respective project management

MBA510 Week TWO Discussion Post 1. Please answer the discussion post in 250 min

Instructions · Choose a company that had a disruptive business model (e.g., Netflix, Uber, Amazon…), either existing today or in the past. · Describe its model and how it disrupted its industry. Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references

MBA510 Week TWO Discussion Post 2. Please answer the discussion post in 250 min

Instructions · How might a company’s technology systems change by utilizing AI? Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under a “References” section