merchandising math – Flashcards
Unlock all answers in this set
Unlock answersquestion
merchandisers goal
answer
to maintain an inventory assortment that will be suffiecient to meet suomer demand and yet small enought to ensure a reasonable return on the store's investment in inventory.
question
stock-sales-ratio
answer
involves maintaining inventory in a specific ratio to sales. calculated by dividing the dollar value of stock by actual sales in dollars.
question
stock turnover rate
answer
one way to track the success of the balance between sales and inventory. How fast merchandise is sold, replenished, and sold again determines stock turnover.
question
stock sales ratio formula
answer
stock sales ratio = value of stock / sales
question
stock turnover rate formula
answer
stock turnover rate = sales / average stock
question
sales formula
answer
sales = stock turnover rate x average stock
question
merchandise planning includes
answer
-sales/profits -inventory/stock
question
merchandising plans
answer
help the merchandiser maintain a proper proportion between sales and inventory levels to ensure profits.
question
six month merchandising plans
answer
divide the year into two six month planning periods: 1. feg - july 2. aug - jan -large stores may plan by department or product line and then combine -small stores may plan for the entire store
question
steps in developing a 6 month plan
answer
1. planning sales: -first and most important step -basis for determining stock levels, reductions, purchases 2.determine amount of stock needed to meet the planned sales -basic stock -percentage-variation -weekly supply -stock-sales-ratio 3.planned reductions Includes: - predicting (forecasting) -what consumers will buy -how much they will buy
question
sales can be planned
answer
-top-down -bottom-up -combination
question
sales are affected by
answer
-internal factors -external factors
question
calculating planned sales
answer
planned sales = last years sales x (100% + change for this year) ex: if last years sales were 1,834,900 and a 9% sales increase is planned for this year whatare the planned sales? 1834900 x (100%+ 9%)= 200,004 (round to whole #'s)
question
planned monthly sales formula
answer
planned % of total sales x planned total sales = planned monthly sales ex: feb = 11.5% x $95,700 = $11,005
question
stock to sales ratio method
answer
defines the relationship between planned BOM inventory for a given month and the planned sales for the month
question
calculating stock-to-sales ratio
answer
stock-to-sales ratio = retail stock / sales ex: feb 1st boy dept had a retail stock level of 120,000. the planned sales for the month were $20,000. what was the stock to sales ratio for feb? 120,000/20,000 = 6 < mean 6 times that amount.
question
BOM stock formula
answer
BOM stock = planned monthly sales x stock-to-sales ratio ex: the linen dept. planned sales of $40,000 for july. from past experience the merchandise knows that an 8.2 stock to sales ratio was successful. what should the planned BOM stock be for july? 40,000 x 8.2 =$328,000
question
planned reductions
answer
retail reductions are the differences between the original retail value of merch, and the final sales value.
question
major types of reduction are:
answer
-markdown -employee and customer discounts -inventory shortages
question
steps in planning reductions
answer
1. determine the total reduction amount for the period as a % of the total seasons sales 2.convert the planned reduction from % of sales to total DOLLAR amount for the season 3.divide the total dollar amount planned for reductions by month
question
planned purchases
answer
-calculated to provide the $ amount available to purchase new merchandise each month -purchases are generally preplanned for each month at RETAIL value and then converted by formula to a cost amount
question
planned purchases at retail =
answer
+ planned sold + planned EOM + planned reductions - planned BOM
question
stock turnover
answer
-the speed at which merchandise moves into and out of a department or store
question
understanding turnover is important to:
answer
-make better use of capital investment -control inventories -maximize profit
question
calculating turnover
answer
turnover = net sales for period / average stockfor same period ex: infants dept. had net sales of $2,000,000 for the year. the average stock during the period was $500,000. what was the rate of stock turn? $200,000,000 (net sales) / 500,000 (stock)= 4
question
calculate sales goal
answer
sales = stock turn x avg. stock ex: planned an avg stock level for march $95,000 and a stock turn of 4.5.
question
average stock formula
answer
average stock = sales / turnover rate ex: sales during first 6 mo. period were $532,000. turnover rate was 3.2. what was the avg stock for the period? 532,000 /3.2 = 166,250
question
calculating average stock
answer
sum of beginning inventory + ending inventory for given period / # of inventories
question
calculating average stock when monthy inventories are known
answer
average stock is the sum of the retail inventories at the beginning of each year, season, month , or week, added to the ending inventory and divided by the # of inventories used. ex: sales = 140,000 BOM =195,000 / 13 = 15,000 turnover = netsales / avg stock = 14,000 / 15,000 = 9.3
question
open to buy (OTB)
answer
the amount of money available to spend at market
question
main purposes of OTB
answer
-to assure the planned relationship between stock on hand and planned sales in maintained - to allow for adjustments in merchandise purchases to reflect changes in sales and reduction
question
tracking OTB available should:
answer
- limit overbuying and underbuying -prevent loss of sales due to inedequate amound of stock -keep purchases within planned amounts -reduce markdowns -increase sales -improve stock turnover -ensure money to reorder fast-selling merchandise
question
OTB in planning process
answer
-OTB is equal to the planned purchases amount on the 6 month plan. - as purchases are made, their value is subtracted from the planned purchases amount -the unspent balance is the remaining OTB
question
calculating OTB at beginning of planning season
answer
ex: a review of a 6month plan showed the following plan for august: sales: 10,000 BOM: 31,000 EOM: 33,600 reduct: 1,000 if the orders for merch to be delivered in aug total 5,000 what is the remaining OTB? 10,000 +33,600 +1,000 - 31,000 = 13,600 (planned purch/OTB) - 5,000 (merch on order) OTB remaining = $8,600
question
calculating amount to spend at market
answer
during a 6 month planning period only a portion of the OTB (planned purchases) will be spent during the initial buying trip
question
OTB to save formula
answer
OTB to save = planned purch x % of planned purch. to save
question
$ amount to spend formula
answer
$ amount to spend = planned purch - OTB to save
question
OTB balance
answer
-planned purchases for the period -merch recieved -merch on order ex: planned = 17,000 - merch rec'd = 8,300 - on order merch=700 OTB balance = 8,000