Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[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

Order Now

Related Questions

Total Quality Management Discussion 5

This is the problem from week 1 I went with    One issue at the Cook County Courthouse that could benefit from quality improvement is invoice processing and how long it takes vendors to get paid. Cook County uses Net 60 payment terms, while many private companies operate under Net

SCMG201

see attached 5 Assignment 2 – Weeks 3 & 4 Essay Questions SCMG 201 – Principles of Supply Chain Management Enter Student Name Enter Date Chapter 3: Network and Systems Design (Questions 1 through 5) Question 1 Response: Question 2 Response: Question 3 Response: Question 4 Response: Question 5 Response:

DEFM200

see attached Instructions Assignment Directions This assignment assesses  CO-3 [content page]. Read the article by David Garvin (1987),  Eight Dimensions of Quality. Create a PowerPoint presentation consisting of eight slides, excluding the title and reference pages. List four to five main points (using bullet point format) on each main slide.

Business & Finance a homework project . The class is Estate Planning and the project is a memo for Client interview Assignment. a homework project . The class is Estate Planning and the project is a memo for Client interview Assignment.

a homework project . The class is Estate Planning and the project is a memo for Client interview Assignment.  BUSI 354 Memo: Client Interview Assignment Instructions Overview This assignment requires you to use the information you have studied in the first 5 modules of the course in order to identify

week 7

 corporate ethical dilemma or fraud case of their choice  Students will write a comprehensive 12–15 page paper analyzing a major corporate ethical dilemma or fraud case of their choice. The paper should include identification of ethical issues, stakeholders, analysis using at least two ethical frameworks, evaluation of leadership and organizational

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Discussion Assignment Week 7 Assignment: Final Project Signature Assignment: This assignment aligns with all course COs. Recommendation: Print complete Assignment to fully read and reference in preparing your paper! Paper outline is included. Prompt: Background For your final project, you are creating your own hypothetical scenario within the following parameters

case up

BUSI 642 Case Analysis: Approaches to Performance Management Assignment Instructions Overview Performance management systems are important because they deal with how employees achieve organizational goals. A key aspect of managing performance is accurately identifying why an employee may not be meeting expectations. This assignment allows you to hone your skills

discussion convey

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 a thread in response to

Alternative Energy

  Over the past two centuries, fossil fuels have helped us build the complex industrialized societies we enjoy today. Yet our supplies of conventional fossil fuels are declining. We have responded to this challenge by expanding our search for new sources of fossil fuels. This will eventually lead to us

discussion

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

discussion

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

Competitive advantages

   What are the primary means for gaining and sustaining competitive advantages for companies shifting downstream? Is that also the case in a circular economy? Explain and discuss these statements.

Logistics 5

see attached. BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is for

3-1 Discussion: Internal and External Analysis Reflect in ePortfolio

  Select at least one analysis tool, such as PESTEL, SOAR, or SWOT, to determine the internal and external factors influencing your selected organization’s foreign expansion. If you need more information, then review your resources section. If you would like to use a different tool, one that you are more

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

tutor discussion #foreign Intellectual Property There are four types of IP: Patent Trademark Copyright Trade secret Discussion (No more than 300 words) HYPOTHETHICAL FACTS FOR THIS DISCUSSION – DO NOT ADD OR ASSUME UNSTATED FACTS. COMMON LAW APPLIES. NOTE: THE NEXT DOOR NEIGHBOR WAS SITTING IN HIS YARD THE WHOLE

Prof Double R

  Competency In this project, you will demonstrate your mastery of the following competencies: Describe the components of the United States justice system and how they are interrelated Explain how various types of communication skills are utilized by sworn and civilian criminal justice professionals Scenario You are a community outreach

Energy Sources and Uses

Please respond to the following: Consider the amount of electricity and other energy your family uses. What are the sources of the energy your family uses? What specific actions could your family take to use less energy? Be sure to respond to at least one of your classmates’ posts.

2-1 Final Project Milestone One: Sport in a Global Context

 For this milestone, you will identify the organization you have chosen and the market to which your selected organization will expand internationally. You will describe the proposed project by providing a scope statement that consists of goals, requirements, and deliverables. You will also perform comprehensive research and analyze the industry,