Deck 8: The Dollar Merchandise Plan

Question 1

Planned sales for June this year are $120,000. Last year, the actual sales for June were $110,000. Determine the planned percent increase in sales for the month.

Answer 1

The planned sales figures must be accurate and realistic because this is a basic figure on which all other figures are planned. Sales are planned on net sales basis that is gross sales minus customer return. Many factors are influence sales.
To analyze all sales figures, two steps must be followed.
1. Obtain sales from last year for each month of the plan.
2. Determined projected sales volume for each month in the plan.
To find percentage increase or decrease in sales, planned sales for this period should be minus from last year sales of this period. This amount should be divided by last sales of the same period and multiplied with 100.
In this case a planned sale for June of this year is $120,000 and last year sales of June month is $110,000. Calculation for the same is as under.
Hence, the sale of this June month increase compare to last June month in percentage is
.

Question 2

The rug department is planning a 15% reduction in sales this year. If last year's sales were $525,000, what is this year's planned sales figure?

Answer 2

The planned sales figures must be accurate and realistic because this is a basic figure on which all other figures are planned. Sales are planned on net sales basis that is gross sales minus customer return. Many factors are influence sales.
To analyze all sales figures, two steps must be followed.
1. Obtain sales from last year for each month of the plan.
2. Determined projected sales volume for each month in the plan.
To find planned sales of this year, last year sales should be minus from decrease in sales expected this year compare to last year.
In this case a planned sale last year is $525,000 and 15% reduction is expected this year compare to last year. Calculation for the same is as under.
Hence a planned sale of this year is
.

Question 3

Establish a six-month percentage sales curve for dress shirts, given the following sales information: February, $1,560; March, $2,040; April, $2,160; May, $2,160; June, $2,280; July, $1,800.

Answer 3

Sales curve serves an important role in the process of distributing of sales among the months in a merchandizing plan. It is a retailing tool used to express the variations in the sales of a retail unit, an item, or a merchandise category over a certain period, usually six months or a year.
Sales curve indicate relative importance of sales from one month to another by showing the picks and valleys in customers demand for a particular item or category. Here we calculate sales curve as a percentage. In this each month is expressed as percentage of the total six month's sales.
Sales percentage can be calculated, the formulae is given below:
A total sale of six month is $12,000 that is summation of sales of six months. Assume that total sales of six months will be 100%, following calculations sales in percentage for each month.
To find sales in percentage, sales for the month is divided by total sales of six months and multiplied with 100.
For the month of February calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of February will be
.
For the month of March calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of March will be
.
For the month of April calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of April will be
.
For the month of May calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of May will be
.
For the month of June calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of June will be
.
For the month of July calculation of sales percentage is given below:
Sales percentage can be calculated as given below:
Hence sales in percentage for a month of July will be
.
In this case, unit sale can be converted into percentage as given below:
Following is the six month sales curve for dress shirts on basis of the above mentioned data of six months given below.

Question 4

Express the sales curve in problem 3 as a ratio.

Question 5

In planning for the next year, the buyer in problem 3 noted that she ran out of white shirts on June 12 and did not receive more in stock until the end of the month. She estimated that she could have sold an additional 12 of the shirts in June at an average retail price of $30.00. Revise the percentage sales curve to reflect these lost sales.

Question 6

Determine the average stock for the spring season for a department that has the following beginning of the month inventories: $32,800 for February; $30,600 for March; $31,950 for April; $33,650 for May; $32,700 for June; $34,250 for July; and $34,500 for August.

Question 7

A buyer is expecting a seasonal stock turnover rate of 13 and seasonal sales of $1,947,400. Calculate a) the weeks' supply, b) the average weekly sales, and c) the inventory needed if using the average weekly sales.

Question 8

If last year's sales were $906,050 and a store was planning an increase in sales of 3.75% and a markdown percent of 18.25%, what is planned markdown in dollars?

Question 9

What was the markdown percent for last year if the net sales totaled $79,005 while markdowns were as follows:

Question 10

The planned sales for a department are $38,000 and the stock-sales ratio is planned at 1.8. Find the BOM stock that is needed to realize this ratio.

Question 11

During a six-month period, a department had planned sales of $250,000 and a planned turnover of 3.2. The planned sales for May are $38,000. Using the basic stock method, determine the BOM stock for May.

Question 12

During February, junior dresses had BOM stock of $200,000 and net sales for the month were $151,250. The EOM inventory was $275,000. What was the stock turnover for the month?

Question 13

Determine the dollar sales for April, May, June, and July, given the following seasonal sales distribution (you must first determine total sales for the season):

Question 14

Calculate the average stock in a department with annual sales of $1,840,000 and an annual stock turnover of 5.4.

Question 15

Determine the stock turnover for a six-month period (February to July) from the following information:

Question 16

Determine the stock-sales ratio when the planned sales for August are $36,000 and the retail stock for August 1 is $120,000.

Question 17

Find the planned April purchases at retail with the following figures:

Question 18

Using the figures provided in problem 17, calculate the planned April purchases at cost.

Question 19

Calculate monthly planned purchases at retail and at cost for the men's clothing department if the planned total fall-winter season's sales are $860,000. (Use the merchandise plan form provided.) Total markdowns for the season are planned at 14.6% of the season's sales. January's EOM inventory is planned at $510,000. Initial markup percent is planned at 52%.

Question 20

The linen department has planned sales of $375,000 for the spring-summer season. The turnover goal for the season is 1.8. Using the form provided, develop a six-month merchandise plan on the basis of the following information:


(a) Calculate initial markup %.
(b) Distribute monthly planned sales.
(c) Determine monthly dollar markdowns.
(d) Determine BOM stock figures.
(e) Find monthly planned purchases at retail.
(f) Find monthly planned purchases at cost.

Question 21

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
Calculate the planned markdown percent. Include the planned markdown percent along with the planned initial markup percent, net profit percent, and turnover on the six-month merchandise plan.

Question 22

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
Calculate the percent difference between planned and actual for sales and markdowns for February and March.

Question 23

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
Calculate the actual planned purchases at retail, and at cost. What will be the immediate impact on planned purchases for April?

Question 24

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
If business continues on this track, what results would you expect to see at the end of the six months?

Question 25

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
Propose two different solutions that might enable your department to end the season on plan for sales.

Question 26

Markdown Mayhem
Tammy Kinley, Ph.D. University of North Texas
Congratulations! You have just been hired as a buyer in the missy department in Gregory's Department Store. This department, one of several in a large national department store, contains dresses, suits, and career separates for missy sizes 2-16. The target market is working professional women age 30 to 55, with a combined household income of $100,000 or more. Most are in the full-nest family cycle stage, meaning that they have children living at home.
Today is April 3, and this is the first time you have seen the actual figures for the current plan, part of which is as follows:


The second month of the spring season has just ended. The seasonal goals are an average initial markup of 47.30%, a net profit of 5.50%, and a turnover of 2.3.
Propose two different solutions that might enable your department to end the season on plan markdowns.

Question 27

Key Sales and Inventory Analysis of a Jewelry Company
Gary Wolf, M.S. Fashion Institute of Technology*
After their success in the United States, Fine Fashion Ltd (FF Ltd), a fashion jewelry company has expanded operations to London, UK.
(A) The company recently added a new line of fine jewelry to their inventory portfolio. The carry forward inventory as of January 1, included 50 ruby necklaces, 150 wedding rings, and 35 sapphire earrings. By the end of January only 22 ruby necklaces and 70 wedding rings were left. However, more inventories of fine jewelry were purchased in February. The preceding and subsequent inventory overview is only of fine jewelry :
• The EOM stock in February was only 12 ruby necklaces.
• The net sales during this two month period of January and February were of 637 units (pieces) in total.
(B) Although FF Ltd, achieved success in their segment of fine jewelry in the United Kingdom, they were unable to attain their desired goals in their mainstream business of fashion jewelry in London. The inventory carried into January for fashion jewelry was £ 180,200 and that in February was £ 112,300. Incremental inventory was sold by the end of February when inventory was £ 93,100.
When a research team looked into the cause of the company's failure, it was concluded that FF Ltd had to differ its merchandise strategy used in the United Kingdom from the one used in the United States despite sharing the same demographics. The psychographics of the target customers are contrasting in the US vs. the UK market. Too many markdowns, such as 30% in January and 25% in February, worked well in the United States, but devalued the brand's image in the United Kingdom.
Another reason for their failure was the false lighting in the store. Under the bright yellow light of the store, the real color of the jewelry was often not visible to customers. The lighting issue made the jewelry appear sparkling which increased sales, which were £ 124,200 in January and £ 98,200 in February. However, when the customers reached home, they were dissatisfied to find the real color of their newly bought jewelry, which resulted in excessive returns of 16% and 12% in January and February, respectively.
(C) To recover the loss, the company has redefined its merchandise strategy. The company is now minimizing markdowns, which are $3,000 for the month of March. Moreover the company is also hoping to achieve its desired stock turnover of four times for a six-month period.
1. PART A
• Find the average stock and stock turnover in units of fine jewelry.

Question 28

Key Sales and Inventory Analysis of a Jewelry Company
Gary Wolf, M.S. Fashion Institute of Technology*
After their success in the United States, Fine Fashion Ltd (FF Ltd), a fashion jewelry company has expanded operations to London, UK.
(A) The company recently added a new line of fine jewelry to their inventory portfolio. The carry forward inventory as of January 1, included 50 ruby necklaces, 150 wedding rings, and 35 sapphire earrings. By the end of January only 22 ruby necklaces and 70 wedding rings were left. However, more inventories of fine jewelry were purchased in February. The preceding and subsequent inventory overview is only of fine jewelry :
• The EOM stock in February was only 12 ruby necklaces.
• The net sales during this two month period of January and February were of 637 units (pieces) in total.
(B) Although FF Ltd, achieved success in their segment of fine jewelry in the United Kingdom, they were unable to attain their desired goals in their mainstream business of fashion jewelry in London. The inventory carried into January for fashion jewelry was £ 180,200 and that in February was £ 112,300. Incremental inventory was sold by the end of February when inventory was £ 93,100.
When a research team looked into the cause of the company's failure, it was concluded that FF Ltd had to differ its merchandise strategy used in the United Kingdom from the one used in the United States despite sharing the same demographics. The psychographics of the target customers are contrasting in the US vs. the UK market. Too many markdowns, such as 30% in January and 25% in February, worked well in the United States, but devalued the brand's image in the United Kingdom.
Another reason for their failure was the false lighting in the store. Under the bright yellow light of the store, the real color of the jewelry was often not visible to customers. The lighting issue made the jewelry appear sparkling which increased sales, which were £ 124,200 in January and £ 98,200 in February. However, when the customers reached home, they were dissatisfied to find the real color of their newly bought jewelry, which resulted in excessive returns of 16% and 12% in January and February, respectively.
(C) To recover the loss, the company has redefined its merchandise strategy. The company is now minimizing markdowns, which are $3,000 for the month of March. Moreover the company is also hoping to achieve its desired stock turnover of four times for a six-month period.
PART B
• Determine the average stock and stock turnover for January and February in US Dollars
• Find the stock-sales ratio for FF Ltd's fashion jewelry division for January and February
• What is the planned purchase for January and February?

Question 29

Key Sales and Inventory Analysis of a Jewelry Company
Gary Wolf, M.S. Fashion Institute of Technology*
After their success in the United States, Fine Fashion Ltd (FF Ltd), a fashion jewelry company has expanded operations to London, UK.
(A) The company recently added a new line of fine jewelry to their inventory portfolio. The carry forward inventory as of January 1, included 50 ruby necklaces, 150 wedding rings, and 35 sapphire earrings. By the end of January only 22 ruby necklaces and 70 wedding rings were left. However, more inventories of fine jewelry were purchased in February. The preceding and subsequent inventory overview is only of fine jewelry :
• The EOM stock in February was only 12 ruby necklaces.
• The net sales during this two month period of January and February were of 637 units (pieces) in total.
(B) Although FF Ltd, achieved success in their segment of fine jewelry in the United Kingdom, they were unable to attain their desired goals in their mainstream business of fashion jewelry in London. The inventory carried into January for fashion jewelry was £ 180,200 and that in February was £ 112,300. Incremental inventory was sold by the end of February when inventory was £ 93,100.
When a research team looked into the cause of the company's failure, it was concluded that FF Ltd had to differ its merchandise strategy used in the United Kingdom from the one used in the United States despite sharing the same demographics. The psychographics of the target customers are contrasting in the US vs. the UK market. Too many markdowns, such as 30% in January and 25% in February, worked well in the United States, but devalued the brand's image in the United Kingdom.
Another reason for their failure was the false lighting in the store. Under the bright yellow light of the store, the real color of the jewelry was often not visible to customers. The lighting issue made the jewelry appear sparkling which increased sales, which were £ 124,200 in January and £ 98,200 in February. However, when the customers reached home, they were dissatisfied to find the real color of their newly bought jewelry, which resulted in excessive returns of 16% and 12% in January and February, respectively.
(C) To recover the loss, the company has redefined its merchandise strategy. The company is now minimizing markdowns, which are $3,000 for the month of March. Moreover the company is also hoping to achieve its desired stock turnover of four times for a six-month period.
PART C
• Calculate weeks' supply of inventory for March
• Calculate the company's OTB at retail and at cost as of March 1, given:
• The planned sales for March are $93,200
• Planned EOM stock is $133,000
• The company ordered inventory of $32,000 as on March 1
• Planned initial markup is 25%

Question 30

Six-Month Merchandise (Dollar) Planning
Lucy Simpson , M. S. The University of Tennessee
After completing her training period, Heather has been placed in a planning position with the Moderate Sportswear Buying team. The Planning Divisional has given her the project of planning sales, markdowns, and stock levels for Misses Coordinates for the next fall season. Since she is new to the company and does not know the history of last year, she is given last year's report and the following goals and notes:

*all figures in thousands
Misses Coordinates Fall Goals

Notes:
a. The company is adding a new major sale event to the month of September.
b. On the 5-4-5 calendar, Christmas is one day earlier in the week.
c. The direction from upper management is that old season goods should be cleared out in August and January.
d. Last year, because of poor receipt flow from vendors, August and September were under-receipted to plan and October was over receipted to plan.
e. The largest promotional sale continues to be in October.
f. The most current OTB projection shows July EOM at $950.0
New Plan

*all figures in thousands
As a new planner, Heather has worked diligently on the six-month plan, and has planned her sales, markdowns, inventory levels, and purchases by month. She is ready to set up a meeting with her Planning Divisional and go over her plan.
Calculate the stock-sales ratio and purchases by month.

Question 31

Six-Month Merchandise (Dollar) Planning
Lucy Simpson , M. S. The University of Tennessee
After completing her training period, Heather has been placed in a planning position with the Moderate Sportswear Buying team. The Planning Divisional has given her the project of planning sales, markdowns, and stock levels for Misses Coordinates for the next fall season. Since she is new to the company and does not know the history of last year, she is given last year's report and the following goals and notes:

*all figures in thousands
Misses Coordinates Fall Goals

Notes:
a. The company is adding a new major sale event to the month of September.
b. On the 5-4-5 calendar, Christmas is one day earlier in the week.
c. The direction from upper management is that old season goods should be cleared out in August and January.
d. Last year, because of poor receipt flow from vendors, August and September were under-receipted to plan and October was over receipted to plan.
e. The largest promotional sale continues to be in October.
f. The most current OTB projection shows July EOM at $950.0
New Plan

*all figures in thousands
As a new planner, Heather has worked diligently on the six-month plan, and has planned her sales, markdowns, inventory levels, and purchases by month. She is ready to set up a meeting with her Planning Divisional and go over her plan.
Analyze each element of the plan by month. Do you agree that each one is planned correctly? Why or why not?
• Sales?
• Markdowns?
• Inventory levels?
• Purchases?

Question 32

Six-Month Merchandise (Dollar) Planning
Lucy Simpson , M. S. The University of Tennessee
After completing her training period, Heather has been placed in a planning position with the Moderate Sportswear Buying team. The Planning Divisional has given her the project of planning sales, markdowns, and stock levels for Misses Coordinates for the next fall season. Since she is new to the company and does not know the history of last year, she is given last year's report and the following goals and notes:

*all figures in thousands
Misses Coordinates Fall Goals

Notes:
a. The company is adding a new major sale event to the month of September.
b. On the 5-4-5 calendar, Christmas is one day earlier in the week.
c. The direction from upper management is that old season goods should be cleared out in August and January.
d. Last year, because of poor receipt flow from vendors, August and September were under-receipted to plan and October was over receipted to plan.
e. The largest promotional sale continues to be in October.
f. The most current OTB projection shows July EOM at $950.0
New Plan

*all figures in thousands
As a new planner, Heather has worked diligently on the six-month plan, and has planned her sales, markdowns, inventory levels, and purchases by month. She is ready to set up a meeting with her Planning Divisional and go over her plan.
What suggestions would you give to Heather before she goes into her meeting with her Divisional?

Question 33

Planned sales for the month of August this year are $145,000. If the actual sales for the month last year were $130,000, what is this year's planned percent increase in sales?

Question 34

Actual sales in the stationery department last year totaled $518,000. If the department planned a 15% increase for this year, what is the dollar amount of sales planned?

Question 35

Due to a reduction in the number of stores with a formalwear department, the buyer is planning a 20% reduction in sales for the department. If last year's sales were $218,000, what is this year's planned sales figure?

Question 36

This year's sales totaled $90,000 for August and $96,000 for September. If the planned seasonal sales distribution is as follows, figure the dollar sales for the remaining months of the period:

Question 37

Figure the percent increase in sales for each of the following months, and determine the probable sales for June in a department that had the following sales pattern:

Question 38

Plan sales for the months of August through January, given the following information:

Question 39

Determine the sales curve percents by month on the basis of the following unit sales curve data for one misses' swimwear style: February, 10 units; March, 22 units; April, 32 units; May, 48 units; June, 66 units; and July, 22 units.

Question 40

You are planning the sales of the same style of swimsuit as that in problem 7 for the coming plan period. You estimate that this year you will sell 260 of the suits. On the basis of the percentage sales curve you found in problem 7, calculate planned unit sales by month so that purchases can be made for this year.

Question 41

A store had a BOM stock of $300,000 at retail. Net sales for the month were $146,000. The EOM inventory was $350,000. What was the stock turnover for the month?

Question 42

Junior dresses had an opening inventory of $36,000 at retail. Net sales for the period were $12,389. If the closing inventory was $37,000, what was the rate of stock turnover for the period?

Question 43

Determine the average stock in a department with annual sales of $1,650,000 and an annual stock turnover of 4.5.

Question 44

What is the six-month stock turnover based on the following figures and net sales of $450,000?

Question 45

Find the turnover for the six-month spring-summer season (February to July) from the following data:

Question 46

Using the data in the previous problem, calculate turnover for the following periods:
(a) four-month period, February-May
(b) three-month period, October-December
(c) the month of June

Question 47

At the beginning of September, sleepwear and robes had a retail stock of $65,000. Sales for the month were $18,200. What was the stock-sales ratio for September?

Question 48

Planned sales in the seasonal back-to-school department for July are $32,000, and the planned stock-sales ratio is 3.8. How much stock should be on hand on July 1?

Question 49

If planned sales for the month are $18,000, and the stock-sales ratio is expected to be 1.5, what BOM stock is needed to realize that ratio?

Question 50

Planned sales in the costume jewelry department for May are $130,000, and the planned stock-sales ratio is 3.4. How much stock will be needed on May 1?

Question 51

What is the planned stock-sales ratio when BOM stock is planned at $64,500 and planned sales are $29,000?

Question 52

For the fall season the stock turnover is expected to be 5.0, what is the weeks' supply?

Question 53

Given annual sales of $520,000 and an annual turnover rate of 8, what inventory is needed for the first week of the year when the sales are planned at $11,000?

Question 54

During a six-month period, a department had planned sales of $180,000 and a planned turnover of 3.2. Using the basic stock method, determine the BOM stock for March if planned sales for March are $28,000.

Question 55

A department has a planned stock turnover of 4.2 and planned sales of $252,000 for a six-month period. August sales are estimated at $38,000 and September sales at $45,000. Using the basic stock method, determine the BOM stock for August and September.

Question 56

Calculate BOM inventory values for February through July on the basis of the following information:

Question 57

If markdowns in the shoe department were $7,680 and net sales were $48,000, what was the markdown percent for the month?

Question 58

Calculate planned June purchases at cost, given the following information:

Question 59

Determine planned purchases (a) at retail and (b) at cost for a month with the following planned figures:

Question 60

Determine the planned purchases for September (a) at retail and (b) at cost for the children's department when the seasonal merchandise plan indicates the following planned figures:

Question 61

Develop a merchandise plan on the basis of the information that follows. Sales for the six-month spring-summer season have been planned to total $650,000. Markdowns for the total season are to be 22.0% of planned sales, and season's turnover should be 1.9. BOM inventory values are to be planned by the basic stock method. In this problem, ending inventory will be the same as the average inventory. (A merchandise plan form is provided to complete the problem.)

(a) Total sales for the season are $650,000. Determine sales for each month.
(b) Calculate total $ markdowns and allocate markdowns to each month on the basis of the percentages given.
(c) Using the basic stock method, calculate BOM inventory values for each month.
(d) Enter the EOM inventory values on the form. July's ending inventory has been given as the average inventory.
(e) Calculate planned purchases at retail.
(f) Calculate initial markup percent needed, given the following information:

Question 62

Using the merchandise plan completed in Problem 1, calculate stock-sales ratios for each month.

Question 63

The sport dress classification of a specialty store was given the following figures to use in developing a merchandise plan for the spring/summer season:

Develop a merchandise plan, using the form provided.
(a) Distribute total season's sales of $222,600 over each month.
(b) Calculate monthly dollar markdowns and total season dollar markdowns if the season markdown percent is 5.5%.
(c) Plan BOM stock values.
(d) Enter EOM values. Use $124,359 for the July EOM.
(e) Calculate monthly planned purchases at retail.
(f) Calculate monthly planned purchases at cost if the initial markup percent is 50.5%.
(g) Calculate turnover for the season.