Six Month Buying Plan
The Objective
In my Merchandising, Planning, and Control class, we were tasked with completing a six-month buying plan. I was responsible for calculating:
season’s total sales
average inventory
markdowns
purchases
gross margin
turnover
Skills, And Such
My knowledge was applied via spreadsheet and essay form, showcasing the calculative and critical thinking necessary to run a profitable business.
-
I grew my strong foundational skills of this software, helping me to become organized and analytical.
-
By analyzing past performances, I was able to decide what inventory practices would be necessary to meet the business’s goals.
-
I utilized a multitude of different formulas to get accurate data revolving inventory, sales, markdowns, and more.
Key Findings…
This final project was very beneficial as it was a fantastic way to apply the cumulative knowledge that I acquired about merchandising by putting me in a real-life scenario. It also increased my comfort with using software such as Google Sheets/ Excel.