Hi

I need some help. I was attepmting this question and it seems that when I input to Excel Solver, I am stucked when I use the solver function in excel.

Can you help me?

Jay Co. is a contract manufacturer that produces two products, Prod A and Prod B; and supply the two products to various retailers. The numbers of units for Prod A and Prod 13 that Jay Co is contracted to supply for next four months are given in the following table: The production processes for Prod A and Prod B are quite labour intensive. It takes two hours direct labour to produce one unit of Prod A and six hours of direct labour to produce one unit of Prod B. One factory worker gets paid $4'l} per month. Each factory worker works up to 200 hours per month as regular working hours. If a factory worker works more than 2.00 hours per month, those \"over-time" portion will get compensated at the rate of $3 per hour. However, due to the agreement made with the labour union, total hours of overtime work cannot exceed ID% of regular working hours. Currently, the industry suffers from labour shortage. As such, every newly hired factory worker receives twomonth salary as a signing bonus. On the other hand, every worker made being redundant (Le. fired} by the company receives a half-month salary as a severance payment. Another cost element that Jay Co must consider is the inventory holding cost. The monthly inventory holding cost for Prod A is $5 per unit and the monthly inventory holding cost for Prod B is $33 per unit. Due to its labour intensive nature of production processes, Jay Co does not consider any other production related costs. Their main concerns are manpower cost and inventory holding cost. Every single contracted unit of Prod A or Prod B must be delivered. Due to the severe penalty Jay Co must pay to the retailers, it is not an option for Jay Co not to meet the contracted units. [a] Apply linear programming model to develop a formulation for Jay Co's decision problem. Describe any assumptions you made for your formulation