Assume that a household tools maker company plans to encourage customers to buy their newly designed products. Therefore, this company intends to apply a promotion on their products, however the time and the amount of promotion is needed to be calculated to maximize the profit during this period. The amount of discount is going to be 4% (new price=$480) while the average price of products is around 500$. The demand for the next 6 months periods is given below. Period Demand January 20000 February 30000 March 45000 April 50000 May 60000 June 55000 The company’s managers believe that in the case of applying any discount at any period, the demand in that period will rise 10% and the 20% of the following period also will move to the discount period. In this period stock out is strictly prohibited by company management and it is not allowed to miss any demand from customers. The table below shows the various costs induced during the production and distribution process. This company currently employs 100 workers. Item Cost Material Cost $200 /unit Inventory Holding Cost $2 /unit/month Hiring and training cost $1000 / worker Firing cost $2500 / worker Labor hours required per unit production 0.5 hr/ unit Regular time cost $30/hr Overtime cost $35/hr Subcontracting cost $550 /unit Now the question is you need to find out when company needs to apply the discount on products to maximize the profit in this process. You are asked to provide an Excel file including the constraints, target function and calculation methodologies. Providing only numbers without functions, constraints and relations is unacceptable.