You are the buyer for Missy Weekend Wear, a casual outlet store. For April in store, you have already purchased a coordinate group, modern contrast. The total cost for the order is $476,735. The total retail spent is $1,339,542. Therefore, the cumulative markup % is 64.4%. As the buyer, you still need to place an order for key item T-shirts for April. These T-shirts will retail for $16.99, and you need to buy 48,944 units. The total open-to-buy for the month is $2,171,101.

Your planned cumulative markup % for April is 68.5%. Please calculate the markup percentage that you must achieve on any remaining open-to-buy to achieve the planned cumulative markup % for April. If the vendor states that the cost for the T-shirts will be $5.00, what other actions could you take to achieve the planned markup percentage?

Please show your calculations in excel, and your talking points right on the excel sheet as well. Follow the instructions below

Transcribed image text: Read the info carefully to see what is considered.... you will essentially be creating two cumulative markup "grids" as outlined below. What is in BLUE is provided for you in the case study: Which, when you solve, will see is below the planned goal of 68.5%. So then you should consider a SECOND CUMULATIVE MU grid with the following: Talk through your calculations, answering this from the case study: Please calculate the markup percentage that the buyer must achieve on any remaining open to buy to achieve the planned CMU \% for April. If the vendor states that the individual cost for the tee shirts will be $5.00, what other actions can a buyer take to achieve the planned markup percentage