Follow the link to the excel sheet with tabs labeled P&L and 6-month plan. This is for a project where I partnered Nike with the video game Fortnite. They will have a collaboration where they will sell clothes branded with both Nike and Fortnite. You will also be able to access these items in the video game. You can make up the expenses for the following questions. Just make it up how much you think this stuff would be.

In the tab P & L, fill out the marketing expenses for signage, fixtures (if different), any social media posts, etc. Then whatever those expenses are, you need to put them in the expense line.

Points to include on the sales plan slide:

• Planned sales for the initial 6-month fall season are: $11,050,000
• The gross margin is planned at 70.3%, based on Nike owning inventory at LDP Costs and selling this product directly to consumers.
• Markdowns have been planned for styles not selling through as planned.
• Gift-giving promotional markdowns are planned for November and December.
• $1.5M of the initial assortment will be held back for reorders for stores with high sell-throughs
• Should sales and gross margin surpass the plan, the collection will be expanded with more styles and in more stores for the next season.

Please do not change the formulas.

Link to excel sheet https://1drv.ms/x/s!Ag6WjAqSgm6igTSiFGbec55UNYGg

Answer rating: 100% (QA)

Upon opening the Excel Sheet titled Project Profit and Loss Statement I updated the Marketing sectio... View the full answer