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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!