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

Unit 6

See attached Fundraising, Marketing, and Communication Planning Purpose: • Develop the key components of a nonprofit’s fundraising, marketing, and communication plan. • Apply strategic thinking to align these components with the organization’s mission and goals. Task In this assignment, you will develop key components of the Wounded Warrior Project nonprofit’s

Unit 5-670

See attached  Comprehensive Environmental Analysis Project Purpose: To evaluate your ability to conduct a thorough environmental analysis of a publicly traded company, identify its competitive advantages, and assess the sustainability of those advantages in the context of changing market conditions. Associated Skills: · Applying analytical frameworks to systematically evaluate organizational

ahhaha

  The Future of Digital Leadership 1. What specific skills and roles will be essential for leaders and their teams in the next decade, and what are the best strategies for upskilling and reskilling existing talents? 2. How can leaders ensure their organizations adoption of AI is balanced with the

Excel Questions Business Analysis HW4

Please answer the following questions accordingly. Thanks Sheet1 You have been provided with the following dataset, which includes the monthly sales figures (in thousands of dollars) for a retail company over the past two years: Month Sales ($’000) January 35 February 40 March 38 April 45 May 50 June 42

Unit IV GSM JRL

See attached Unit IV Journal This one-page journal measures your mastery of ULOs 3.3, 3.4, and 3.5. In a one-page journal, address the following questions: · How is innovation a key concept in strategy for any global firm? (You may use the global firm you selected in Unit III as

Unit V DB GSM

See attached BUS 6320, Global Strategic Management 1 Course Learning Outcomes for Unit V At the end of this unit, you should be able to: 4. Explain methodologies in the overall evaluation of business strategies. 4.1 Evaluate different types of corporate diversification. Required Unit Resources Chapter 8: Corporate Strategy: Vertical

Logistics 4

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 everyone to

SCMG201

SEE ATTACHED Instructions Assignment Directions: This week’s project involves creating a PowerPoint presentation that introduces, explains, and evaluates one of the following subjects: Choose one (1) Topic: · Explain the characteristics of a competitive supply chain network Requirements: Project 1 PowerPoint Presentation should have: · A minimum of 12 content

DEFM200

SEE ATTACHED Instructions Assignment Directions Write a three-page essay explaining issues related to the U.S. Federal Acquisition Regulation (FAR), as discussed in Lesson Two. Elaborate on the topics by paraphrasing information from at least three library articles. Your work must be formatted according to APA guidelines, including a proper title

Week 8 pj

 In this company, the Packaging Design Briefs are initiated by the marketing group and forwarded to the Package Engineering group. 

Excel Questions Business Analysis

1 Excel Questions. Please follow the instructions and answer accordingly. Thanks Sheet1 You are provided with a dataset that includes sales performance across different regions over the past five years. Your task is to create multiple charts in Excel to visualize the trends and patterns in the data. You will

HRM 6304 V DBR2

2 Labor Relations and Collective Bargaining HRM 6304 Unit V Discussion Board Reply 2 Initial post to be a minimum of 250 words and at least one supporting reference. You should also include at least two references. Reply to post below When labor and management negotiate a labor agreement, disagreements

QSO 355 Final Project Part I Guidelines and Rubric Overview

  QSO 355 Final Project Part I Guidelines and Rubric Overview The final project for this course is divided into two parts. The first part is the creation of an Initial Schedule and Budget Report. Project managers play an important role in helping to complete successful projects. Often, they are

Economics

Explain the set to me Governors State University Department of Health Administration & Informatics HLAD 4104 Health Care Economics Problem Set 1 (Total: 20 Points) 1. Please explain the three major tasks of economics, what are they, and provide an example for each of the tasks. (6 points) 2. The

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

Tutor discussion C J (respond no more than 100 word) Company Context TTEC Holdings, Inc. is a global innovator in AI-enabled customer experience (CX) technology and services. Operating in over 20 countries with approximately 60,000 employees, the company provides both the digital infrastructure (TTEC Digital) and the human workforce (TTEC Engage)

question

Attached Use 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, 2 pages with atleast 2 references. Follow below SWOT and BCG examples. Overview Exercises 6A and 6C: You will begin

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.