Question: Changing a Six-Month Plan Using Historical Data Using last year's figures for a luggage department, plan a 10% decrease for the next year, maintaining the

Changing a Six-Month Plan Using Historical Data Using last year's figures for a luggage department, plan a 10% decrease for the next year, maintaining the same monthly sales percentages, the same stock-to-sales ratios, and the same markdown percents, as last year. Last year's fall season figures were as follows: Sales Volume August $36,600 September $42,400 October $46,200 November $66,000 December $72,100 $ 62,700 February --------- Last year's departmental markup was 42%. BOM Stock $130,680 $132,990 $133,890 $165,000 $159,720 $163,020 $150,000 Markdowns $ 1,650 $ 2,640 $5,610 $3,960 $9,900 $9,240 January --------- First, fill in last year information on the six-month plan form and analyze the following statistics: 1. Monthly sales percentages by month 2. Last year's stock-to-sales ratio 3. Last year's total markdown percentage 4. Last year's monthly markdown percentage Then, calculate: 5. Last year's monthly purchases at retail 6. Last year's monthly purchases at cost 7. Last year's average stock 8. Last year's stock-turnover rate Changing a Six-Month Plan Using Historical Data Using last year's figures for a luggage department, plan a 10% decrease for the next year, maintaining the same monthly sales percentages, the same stock-to-sales ratios, and the same markdown percents, as last year. Last year's fall season figures were as follows: Sales Volume August $36,600 September $42,400 October $46,200 November $66,000 December $72,100 $ 62,700 February --------- Last year's departmental markup was 42%. BOM Stock $130,680 $132,990 $133,890 $165,000 $159,720 $163,020 $150,000 Markdowns $ 1,650 $ 2,640 $5,610 $3,960 $9,900 $9,240 January --------- First, fill in last year information on the six-month plan form and analyze the following statistics: 1. Monthly sales percentages by month 2. Last year's stock-to-sales ratio 3. Last year's total markdown percentage 4. Last year's monthly markdown percentage Then, calculate: 5. Last year's monthly purchases at retail 6. Last year's monthly purchases at cost 7. Last year's average stock 8. Last year's stock-turnover rate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
