Complete a merchandise plan for Linens and Domestics based on the following data:

Planned net sales $98,000

Stock turnover 1.8

Operating expenses 39.2%

Planned profit 4.0%

Markdowns 9.8%

% of Seasons

Sales Reductions

February 12% 13%

March 13% 15%

April 15% 12%

May 19% 21%

June 21% 19%

July 20% 20%

Determine the initial markup and gross margin percent.

Determine sales for each month.

Calculate the reductions for each month.

Determine the BOM stocks for each month.

Determine the EOM stocks for each month.

Calculate the monthly planned purchases at retail.

Calculate the monthly planned purchases at cost.

Upload your answer in the form of a spreadsheet-buying plan and/or Google sheet.