what u have to do is.
Imagine you are responsible for reordering merchandise for a store. You have been asked to determine which skirt models should be reordered, and in what amounts, based on the sales results indicated in the table provided (see annex document). Once you have completed the tables for calculating the open-to-buy per line in dollars and the open-to-buy per model in units, you must fill out the reorder form appropriately.
The Calculation Table for Open-to-Buy document provides the financial objectives for the season. Based on this information, as well as the amount of allowable markdowns you determined previously, you must decide which models can be marked down, and by how much.
To carry out this project, you will have to consult the following data:
the product lines’ sales curves
the sales results per line
the sales results per model for the line of skirts
You must complete the following documents:
Calculation Table for Open-to-Buy per Line
Calculation Table for Open-to-Buy per Skirt Model
Calculation Table for Allowable Markdowns
Markdown Plan = List of Models to be Marked Down
Pleased find the attachment file .this is what u have to do.
Bu iş için 3 freelancer ortalamada $215 teklif veriyor
Robust, tested business solutions is what I do. Excel VBA solution proposed. My pedigree is in your PM. SteveP.