Can you guide me into the steps for each section to help me understand how to tackle this project?

$$

$1.$ OBJECTIVE:

Handy Manny$$s Hardware Co$.($Client$)$ operates several retail and wholesale outlets throughout North America.$$ Specifically, Students in the George Brown College $($GBC$)$ Supply Chain Program, MGMT$3027$ Integrative Supply Chain Management Course, have been asked to run an assessment and provide recommendations on optimizing inventory management strategy at its recently renovated Mississauga retail$/$warehouse location. Recommendations from this assessment will be considered and may be incorporated into this location$$s inventory management strategy.

Primary areas of review include the following:

A$.$ Product Assortment$/$SKU Balancing

B$.$ Product Rationalization and Implementation Strategy

C$.$ Product Over$/$Under Reporting

D$.$ Safety Stock Analysis

$$

$2.$ STUDENTS FROM THE MGMT$3027$ COURSE

Integrative Supply Chain Management is a $6$th semester course that students are permitted to take after fully and successfully completing all of their $5$th semester courses.$$ At this point in the academic career at GBC$,$ students are well versed in the fundamentals and the strategies pertaining to the supply chain management.$$

$$

$3.$ PROJECT SCOPE:

Project scope is subject to the availability of information provided by the Client for students to conduct the applicable analysis. Students may use outside sources for data as required.$$ Students are provided with $1$ year of applicable supply chain data for approximately $2800$ different SKUs.$$

$$

I.$$ Data includes the following:

$$

A$.$ Assumptions

$1.$ Service level Target $=95\%$

$2.5$ Deliveries per week $($Mon$-$Fri$)$

$3.$ Fiscal Period equivalent to $4$ weeks

$4.$ Fiscal Year April$1$ through March $31($assume it is April $1)$

$5.3$ main seasons: Peak$-$Summer Periods $4-7,$ Peak$-$Fall Periods $9-10,$ Trough$-$Winter Periods $11-13$

$$

$$

$$

B$.$ Database Headings

$1.$ Year$-$ Fiscal Year $($April $1-$ March $31)$

$2.$ Period $-$ Period Only

$3.$ Item No$-$ Item Number

$4.$ Item$-$ Item Description

$5.$ Commodity$-$ Product Category

$6.$ Supplier$-$ Product Supplier

$7.$ Average Price$-$ Average Price

$8.$ Margins$-$ Product Margin

$9.$ Lead Time$-$ Average Order Lead$-$time in days from Distribution and$/$or Manufacturers

$10.$ "List Delist Status$-$

a$.2-$ Current $($Priced$)-$ Current and Marketable Inventory

b$.3-$ Delisted$($Whse$,$ RTL INV $>0)-$ Delisted Inventory, Stock in the Warehouse, Stock at the Retailers

c$.4-$ Delisted$($Whse Inv$=0,$Rtl Inv$>0)-$ Delisted Inventory, $0$ Stock in the Warehouse, Stock at the Retailers

d$.5-$ Delisted$($Whse$,$Rtl Inv$=0)-$ Delisted Inventory,$$ Stock in the Warehouse, $0$ Stock at the Retailer"

$11.$ Bulletin Date$-$ Date item was listed as a marketable product

$12.$ Contractor Sales Units TY$-$ Contractor sales, THIS year, for the period

$13.$ Contractor Sales Units LY$-$ Contractor sales, LAST year, for this period

$14.$ Total Sales TY$-$ Total Sales $($Contractor Sales included$),$ This Year

$15.$ Total Inventory TY$-$ Total Inventory, This Year, at the End of the Period

$$

II$.$ Deliverables include the following:

Develop an optimizing inventory management strategy: product rationalization and inventory rebalancing strategy, with the goal of optimizing key performance measures

$1.$ Complete an assortment review and analysis; Determine$/$develop applicable tools for the analysis

$2.$ Product Assortment$/$SKU Balancing; Product Rationalization Strategy

$3.$ Develop Strategy for Safety Stock and provide recommendations to the safety stock levels. As part of the strategy, assess possible capacity constraints specific to the capacity constraints of the facility and resources, and applicable financial$/$inventory$/$working capital constraints.$$

$4.$ When developing a safety stock strategy, ensure that the applicable Inventory level allows the Client to meet the provided service level target.

$5.$ Determine current working capital as it pertains to the current inventory level.$$ Determine increase$/$decrease to the working capital $$resulting from the proposed inventory strategy

$6.$ Provide an implementation strategy for the team$$s strategy.$$ Marks provided on the credibility of the strategy and how it relates to the analysis. $$