fill in assortment spreadsheet attached based on the data provided. Please include steps/formulas used! Plz help!

Assortment Plan: (25 points) As the buyer for women's fashion tops (sweaters), you need to purchase long-sleeve, cable knit, solid-color, 50/50 blend, acrylic/cotton sweaters from two vendors, Calvin Klein (CK) and Tommy Hilfiger (TH). You have a $20,000 budget that will be divided in the following distribution- CK, 75 percent and TH, 25 percent. Each CK sweater will cost $15 while each TH sweater will cost $21. IMPOK . ANT: remember when calculating assortment plans that you initially are dealing with decimals (\%) to calculate quantities needed, then you use WHOLE numbers (units) to acutally create the plan. Therefore, you must not simply allow the calculations to "round up" and assume your totals will be correct. You will need to adjust specific units within both CK and TH to ensure that both the unit column totals and the row totals all equal each other. First, calculate how many sweaters of each brand will be purchased. Then, determine how many of each color will be purchased for each brand. Finally, calculate the number of each size that will be purchased by color and brand and input data into spreadsheet. Colors will be distrihuted in the following manner: All colors will be purchased in the following size distribution