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

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

tutor discussion Week 5 Discussion: Agency Regulation (No more than 300 words) Discussion Prompt Background and Resources In 1934 Congress created the Securities & Exchange Commission (SEC) to regulate publicly traded stocks and securities. The SEC’s responsibilities cover a range of activities. Two types of violations found in SEC cases are:

biblical

good to go  BUSI 502 Biblical Integration Project Assignment Instructions Overview The purpose of the individual biblical integration paper is to explore the topic of servant leadership in a non-exhaustive scholarly manner that will be useful in your chosen field. In this individual project, learners will be able to demonstrate

Write up report

Please read directions Purpose The purpose of this assignment is to create an analysis of the results you received from Unit 4 Assignment 1. You will use this assignment to write about the results and analyze the data and main results of the model. Task Write a 2-3 page (600

Discussion Response

Please see attachment.    In your responses, evaluate the conclusions made by your classmates regarding loan request of this company, the possible source of funding to expand the market in a fo2. reign country, and whether you agree with these. 

ITC 5301 VDBR1

2 Management Information Systems ITC 5301 Unit V Discussion Board Reply 1 Your initial post should be at least 250 words in length. Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. Reply

ITC 5301 VDBR2

2 Management Information Systems ITC 5301 Unit V Discussion Board Reply 2 Your initial post should be at least 250 words in length. Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. Reply

HED101

Part I: Please explain how important commitments are to you and how successful you are at following through with your commitments. What % of days do you believe you will complete for the 21 Day Challenge?   Part II: Describe 2 ways that you can see or feel that the

Week 5

 ecent real-world scenario where ethical challenges  Assignment Directions This assignment assesses  CO-5 [content page].  Students will select a recent real-world scenario where ethical challenges were evident across multiple business functions. Submission Instructions: Prepare a 6–8 page report analyzing how each function contributed to or mitigated ethical risk, referencing ethical frameworks.

Week 5

 The product and package will be produced in a small town in China and then shipped  Instructions: Assume you are given the task of developing retail packaging for a new product. The product and package will be produced in a small town in China and then shipped and sold in the

Unit 3 GSM

See attached Unit III Assignment This four-page assignment measures your mastery of ULOs 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 3.1, and 3.2. In Unit II you selected a firm (Johnson & Johnson) with global operations and discussed the key points from its global strategy and your perceptions of the firm.

5-2 Milestone Two

ATTACHED IS MILESTONE 1 AS WELL. This file is too large to display.View in new window

BUS 206 Project Two Guidelines and Rubric Module 5

please see attachment Project Two Guidelines and Rubric.html BUS 206 Project Two Guidelines and Rubric Competency In this project, you will demonstrate your mastery of the following competency: Differentiate between matters of law and matters of ethics in business situations Scenario Evaluate the issues raised by employee Daris Jones in

ITC 5301 IV J

2 Management Information Systems ITC 5301 Unit IV Journal This journal measures your mastery of ULOs 3.2, 5.2, 5.3, and 6.1. In what ways have telecommunications and networks transformed organizational strategies, particularly in the realms of data management and information security? Provide specific examples, and explain the importance of telecommunications

ITC 5301 V DB

2 Management Information Systems ITC 5301 Unit V Discussion Board Your initial post should be at least 300 words in length. Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material. You are the

Urgent Help

I have six questions that need to be answer that correlate with the attachment I will need them today right now. Instructions Short Essay Quiz on Weekly Redemption Incorporated Assigned Reading: · Chapter 14 – A Second Chance is the Best Choice Quiz requirements: Answer the questions fully, with at

Genetically Modified Plants

Please respond to the following: Assess the benefits and risks associated with genetically modified crops. Be sure to respond to at least one of your classmates’ posts.

Business & Finance Investment Project PowerPoint Assignment

  Investment Project PowerPoint Assignment  Read: Bodie, Kane, & Marcus: Chapter 15 Read: Bodie, Kane, & Marcus: Chapter 16 Read: Bodie, Kane, & Marcus: Chapter 22 Read: Option Valuation Read: Options Markets Read: Investors and the Investment Process Read: Chapter Fifteen Options Markets Read: Chapter Sixteen Option Valuation Read: Twenty Two