fill in table with formulas shown please

Miss Jay Tee is a buyer for a specialty store in Chicago. She reviewed the current stock and determined the following figures for the coming quarter: - The merchandise on hand (Current) of 500 pairs of leather boots is selling well at $200 retail with a 52% markup. - She intended to buy additional 4,000 pairs of leather boots in this quarter. - The first 1000 pairs (Purchase 1) will be sent by air with a landed cost of $55 per pair. Miss Tee can combine the current stock and this new purchase to make a balanced size and color. Thus, the price tag for this new purchase will match the current inventory (the same as the current). - The second 1,200 pairs (Purchase 2) have a landed cost of $50 and will be sent by sea. Miss Tee intends to put a price tag of $150 on these boots. - The remaining boots (Purchase 3 ) are billed at $60 per pair. Miss Tee planned an initial markup of 50% for this purchase. - The overall quarterly markup percentage (\%) is planned at 56%. So, the average markup for the entire merchandise needs to be larger than 56%. Naw Stock Miss Jay Tee is a buyer for a specialty store in Chicago. She reviewed the current stock and determined the following figures for the coming quarter: - The merchandise on hand (Current) of 500 pairs of leather boots is selling well at $200 retail with a 52% markup. - She intended to buy additional 4,000 pairs of leather boots in this quarter. - The first 1000 pairs (Purchase 1) will be sent by air with a landed cost of $55 per pair. Miss Tee can combine the current stock and this new purchase to make a balanced size and color. Thus, the price tag for this new purchase will match the current inventory (the same as the current). - The second 1,200 pairs (Purchase 2) have a landed cost of $50 and will be sent by sea. Miss Tee intends to put a price tag of $150 on these boots. - The remaining boots (Purchase 3 ) are billed at $60 per pair. Miss Tee planned an initial markup of 50% for this purchase. - The overall quarterly markup percentage (\%) is planned at 56%. So, the average markup for the entire merchandise needs to be larger than 56%. Naw Stock