I need all the formulas in the table

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. 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. CK Colors will be distributed in the following manner: White (50%) Blue (35%) Yellow (10%) Pink (5%) TH White Blue (70%) (30%) All colors will be purchased in the following size distribution: XS 5% S (Petite) 5% 20% M 30% M (Petite) 15% 15% XL 10% $20,000.00 Budget CK Unit Cost TH Unit Cost CK Units Needed TH Units Needed Size Distribution Size % S (Petite) M (Petite) XL Total 0% Color % CK Color Distribution White Blue Yellow Pink Total THI Color Distribution White Blue Total Calvin Klein Units 1 XS S (Petite) S M M (Petite) L XL Color/Size White Blue Yellow Pink Total Units: Tommy Hilfiger Units Totals White Blue Total Units: 238