FMM 225 Module Two Merchandising for a Profit (1)

.xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

225

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

9

Uploaded by HippieDippie

Report
Module Two: Merchandising for a Profit I. DEFINING THE BASIC PROFIT FACTORS A. ELEMENTS OF BASIC PROFIT FACTORS 1. OPERATING INCOME: SALES a. Gross Sales Quantity Price Total Item A 0 Item B 0 Item C 0 Gross Sales 0 b. Customer Returns and Allowances Total Total Total Quantity Price Time PD 1 Quantity Price Time PD 2 Returns + Return A 0 0 Return B 0 0 Return C 0 0 Allowance A 0 0 Allowance B 0 0 Allowance C 0 0 Total 0 0 0 Customer returns and allowances % Total returns Allowances Gross sales Returns allowances % #DIV/0! Gross sales Returns/allowances Net sales 0 Dept Net Sales as a % of total store sales Net sales Customer returns and allowances % Gross sales % 0 2. COST OF MERCHANDISE SOLD Billed cost Inward transportation Workroom costs Cash discount Total cost of merchandise 0 3. GROSS MARGIN Net sales Total cost of goods sold Gross margin 0 Direct expenses c. Net Sales 4. OPERATING EXPENSES
Indirect expenses Total $ operating expenses 0 Operating expense $ Net sales $ Operating expenses % #DIV/0! 5. OPERATING NET PROFIT Net sales Cost of merchandise sold Operating expenses Profit 0
Allowances
Module Two: Merchandising for a Profit Operating Income (Gross Sales and Net Sales) Customer returns and allowances $5,500 Gross sales $100,000 Return Percentage 5.5% Gross sales $ $1,150,000 Reductions $ $345,000 Net sales $ $805,000 a. The dollar amount of reductions b. The net sales Gross Sales $248,000 Reduction % 20% Dollar amount of reductions $49,600 Net sales men's store $198,400 LY % TY Loungeware net sales $649,903.36 89.5% $764,372.70 Customer returns $76,245.65 10.5% $71,007.30 Loungewear gross sales $726,149.00 100.0% $835,380.00 Total store sales $3,500,000 1. Return Percentages: Customer returns and allowances for Department #620 came to $5,500. Gross sales in the department were $100,000. What percentage of merchandise sold was returned? 2. Net Sales $: If gross sales for Store A are $1,150,000 and reductions are $345,000, what are the net sales? 3. Men's Store: If gross sales for Main Street Men's Store were $248,000 and the reduction % was 20%, calculate the following: 4. Loungewear Department: After Mother's Day this year, the loungewear department had customer returns of 8.5%. The department's gross sales amounted to $835,380. As the buyer reviewed last year’s figures for the same period, the customer returns were 10.5%, with gross sales of $726,149. Compute the department’s performance in dollars and percentages for this year and last year, with regard to gross sales, customer returns, and net sales. 5. Towel Department Net Sales: The towel department represents 2% of total store sales, which are $3,500,000. What are the net sales planned for the towel department?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help