How do I create a six month merchandise budget using the information from this case?

Case: Dollys Place

After years of teaching retailing and marketing at the University of Southern Mississippi, Dolly Loyd decided to retire and return to her first love -- running an apparel store on the Gulf Coast. Because she used to run such a department for a major retail chain before teaching, she kept up with the current trends in the industry. Dolly gained the support of an ex-high school classmate who, after making millions with an Internet startup, financed her new endeavor. Today Dolly is beginning to make plans for the upcoming fall season. Dolly anticipates planned sales of $400,000 for the fall season based on a planned initial markup of 48 percent. Within the season, planned monthly sales are projected to be as follows: 15 percent in August and September, 10 percent in October, 20 percent in November, 30 percent in December, and 10 percent in January. To ensure a profitable season, trade association records were consulted. The records indicated the following: (1) The stock-to-sales ratios need to be 3.5. for August, 3.0 for September, 4.0 for October, 3.0 for November, 2.5 for December, and 5.5 for January; (2) reductions can be planned at 10 percent for the first four months, 20 percent for December, and 40 percent for January; and (3) with Valentines Day approaching, an inventory of $220,000 will be necessary to begin the spring season. Complete a six-month merchandise budget for Dolly.

Calculate a six month merchandise plan for 6 months:

1. Planned BOM Stock

2. Planned Sales

3.Planned Retail Reductions

4. Planned EOM stock

5. Planned purchases @ retail

6.Planned purchases @cost

7.planned initial markup

8. planned gross margin

*NOTE - The reduction percentage for Dolly's is 16%.