Part B. (30%) Submit in Week 12.  Using the figures provided below, you will cal

Part B. (30%) Submit in Week 12. 
Using the figures provided below, you will cal

Part B. (30%) Submit in Week 12. 
Using the figures provided below, you will calculate your stores open to buy.   
Use the Excel Spreadsheet provided to complete this part. I must be able to see your calculation in the sheet. Show all work on an Excel spreadsheet in a traditional OTB grid format as the example indicates. I have completed the first month for you.  
Assume you have an OTB of $1,025,000 at retail to spend to stock your store for the Spring 2025 season, which will encompass Feb, March, April, May, June and July of 2025.  
B1. Calculate the open to buy for each month using the following calculations. 
Planned sales + Planned reductions + Planned EOM Stock = Total monthly needs 
Total monthly needs – BOM Stock = Planned purchases 
Planned purchases – Merchandise on order = Open to buy 
B2. Calculate average monthly sales 
B3. Calculate average monthly on order
B1
OTB TERM PROJECT SPING 2025 Season
MONTHS
FEBRUARY
MARCH
APRIL
MAY
JUNE
JULY
TOTAL
PLANNED SALES
$400,000
$300,000
$200,000
$150,000
$100,000
$125,000
$1,275,000
EMPLOYEE DISCOUNT PERCENT
0.02
0.03
0.04
0.02
0.02
0.03
EMPLOYEE DISCOUNT DOLLAR
$8,000.00
MARKDOWN PERCENT
15%
MARKDOWN DOLLARS
$60,000
$45,000
$30,000
$22,500
$15,000
$18,750
$183,750
SHORTAGE DOLLARS
$6,000
SHORTAGE PERCENT
0.015
0.020
0.020
0.050
0.040
0.030
EOM
$300,000
$250,000
$150,000
$100,000
$75,000
$100,000
TOTAL MONTHLY NEEDS
$774,000
BOM
$300,000
$300,000
$250,000
$150,000
$100,000
$75,000
PLANNED PURCHASES
$474,000
MONTHLY ON ORDER
$87,500
$75,000
$50,000
$37,500
$25,000
$31,250
$306,250
OPEN TO BUY
$386,500
$1,025,000
B2
AVERAGE MONTHLY SALES
B3
AVERAGE MONTHLY ON ORDER

Write a report in the form of a 6-8-page paper deck that assesses the current st

Write a report in the form of a 6-8-page paper deck that assesses the current st

Write a report in the form of a 6-8-page paper deck that assesses the current state, and future viability, of a fashion retailer, including an overview of the retailer, a spotlight on at least one garment they sell, an evaluation of their marketing strategies, and a research-backed prediction of their longterm viability.
The goal of your final project is to tie together the various aspects of the fashion industry that have been discussed over the course of the semester in relation to what is going on in the marketplace. The retail environment has changed dramatically as a result of Covid-19, climate change, Black Lives Matter, and other PESTEL movements. As aspiring fashion industry professionals, it is imperative that you reflect on current events and the impact these events have on the fashion and retail environments.Your final project submission should demonstrate your understanding of the relationship between:
Retailer
Target market
Marketing initiatives
Product and service offerings
Current marketplace
Project Snapshot:
Choose a retailer to research
Choose a garment to analyze
Understand their marketing strategies and tactics
Explain short-term and long-term retailer viability
Part I. The Retailer
What is the name of the retailer and what is the story behind the name?What type of retailer is it? (Revisit Ch. 11 in your text.)
Describe the style or aesthetic of the store (virtual and/or bricks and mortar).
Who is the retailer’s target market? (Look at Ch. 2 of your text as well as materials from class and in Canvas)
Describe the merchandise assortment. What categories do they carry? (See Ch. 8) Is this assortment a good fit for the customer? Why or why not?
What are the different ways to shop the brand? (ie. E-commerce, app, s-commerce, catalog, etc)
Part II. The Garment
Choose at least one garment to analyze.
Use WGSN to see how this garment aligns with FW23 trends. What trend is this garment inspired by? Does it appear that this garment is on trend for FW23? Why or why not? Explain your findings. Include the trend report.
Basic description: includes color, style, silhouette, texture, design details.
Describe the fabric: What is the fabric(s)? Is the fabric appropriate for the design and style? Why or why not?
Where is the garment made? Is that a good country to source from why or why not? (Google “Apparel Production in name of country” if we haven’t talked about it in class. What can you learn about the conditions in that country?
What is the price point and classification? (See Ch. 3 from Apparel Evaluation on Canvas)
Is the garment worth the money? Is it a good value?
What is the Suggested Retail Price if listed? Is it different than the price on the tag? If you were to purchase the garment today, would the sales price be different from the MSRP? Explain.
How is the garment displayed online? Where is the garment found within the e-commerce site?
Is it effectively merchandised? (Think about the 5 R’s of merchandising.)
Part III. Marketing
Look at the retailer’s social media accounts, website, etc…who are they trying to reach? Who is their target market? How does this align with your findings re: target market from Part 1?
Now it is your turn to recommend how the chosen garments will be marketed. You have been asked to style a look to be used for their marketing campaign. This look may be used in print, television, digital or in-store promotions.
Identify where the image is to be used. (billboard, social media, catalog, commercial, etc) Why is this an effective place to reach the target market? (Revisit target market study)
Rather than execute an actual photo shoot, you will create a vision board for your photo shoot to give us an idea of what you have in mind. Include:
All apparel and accessory items that will be included in the photo
Where the photo will be taken (background, imagery, etc)
Inspiration for overall look of the photo
Included any written content, such as a hashtag, tagline, and/or image description
Part IV: Current Marketplace
How has the retailer been affected by Covid-19 and/ or other PESTEL movements (current events)? (ie. Have they closed any store locations? Are they now offering new ways to shop, such as curbside pick-up, Zoom consultations, etc?) Explain how the retailer has adopted new uses of technology (ie. AR/VR, pop-up shops, contactless payment, etc.).
Based on industry reports and trade publications, do you think the retailer will survive the aftermath of the pandemic and other current PESTEL events? Why or why not? Your opinion should be based on both personal experiences as well as research. anywhere where it says chap, please review the INfashion book by sheryl A farnan.