CREATING AND USING YOUR OWN SPREADSHEET

You can develop assortment plans very quickly using a computerized spreadsheet which provides you the opportunity to easily make changes in your plan.

$1.$ Download and Open SPREADSHEET F$.$ Using Spreadsheet #$1$ on the file, enter the dollar budget that is presented in the sample problem above. Your calculations should be the same as in the sample problem.

$2.$ Now develop assortment plans for the problems that follow. Record all your answers on the tables provided.

$3.$ When you have completed the lesson, save the file as SPREADSHEET F$\_$COPY, and then close the file.

PROBLEMS

$1.$ Determine the assortment plan for the sample problem if you just learned that your budget has been reduced to $$4,000.$