Champions’ Shoes Ltd is a manufacturer of sport shoes,specialized in the production of basketball and soccer shoes. TheMarketing Director of the company is about to draw the 2014/2015plan for allocating the marketing resources to the sponsorship ofbasketball and soccer teams. Each soccer teams requires that 120pairs of shoes must be provided whether sponsored, while eachbasketball team requires 32 pairs of shoes to be supplied.Furthermore, additional promotional and sponsorship costs include £150,000 for each sponsored soccer team and £ 225,000 for eachsponsored basketball team. The overall monetary budget available tothe Marketing Director for the sponsorship campaign is equal to £20,000,000. The production of promotional shoes for sponsoringteams is constrained to the availability of raw materials and inparticular to the availability of a special gel used for brandingshoes. Champions’ Shoes has 4,000 cm3 of gel available for the next2014/2015 sponsorship campaign. Producing one pair of basketballshoes requires 3 cm3 of gel, while producing one pair of soccershoes requires 1 cm3 of gel. The Marketing Director desires to findthe maximum number of teams to be sponsored, constrained to theavailable monetary and production resources. You are required tohelp the Director to achieve this target by: a) Formulating thealgebraic linear programming problem [35% of the marks of thisSection] b) Solving the problem through the graphical method [30%of the marks of this Section] c) Formulating the linear programmingproblem on a spreadsheet and finding the optimal solution via theSolver [35% of the marks of this Section]