decision support systems , using excel , please show answers in excel and the used formula's

PART ONE: The XYZ-company has received offers for subcontracting from NOOR-Company's and AL-SALAM company. Table (1) shows information on these two offers: No. Units Period Price Fine NOOR Company 20 60 Days $100 $15 ALSALAM Company 30 40 Days $130 $20 Table (2) show information about the two Production Units of XYZ-Company (in hours) Production unit A Units Labor 1 Labor 2 Labor 3 Labor 4 Labor 5 10 70 99 78 90 101 20 73 81 73 83 99 30 64 74 67 78 94 59 68 61 68 89 SO 55 56 63 84 60 49 54 51 56 81 70 46 49 48 52 781 40 43 40 45 72 90 32 39 36 401 69 100 24 31 33 62 RI Production Unit B Units Labor 1 Labor 2 Labor 3 Labor 4 Labor 5 10 100 90 99 120 86 20 96 83 94 117 30 921 78 113 76 40 891 68 88 109 72 sel 85 63 85 105 61 60 80 56 79 101 52 70 75 51 74 99 47 80 70 450 69 951 41 90 651 40 64 91 37 100 60 33 58 30 NOOR ALSALAM Company Company $60 590 $500 Production cost Fixed cost 1. The company has three months (April. May and June) for subtracting the units for both NOOR-Company's and AL-SALAM company 2- The company should first satisfy AINOOR company demand then AL-SALAM company demand 3. Both production units will work in producing the units 4 Production Unit B will be busy during April 5- The company can work up to 24 hours per day 6- The profit should be at least $1500 Do you think that XYZ-Company should accept or reject the offer? PART TWO: ALSALAM Company offer the company an offer for subcontracting 100 units in two months. 1- The company will assign only workers with LR of %90 or less to do this work. 2- Workers can work up to 18 hours per day 3- The company consider the offer profitable at profit of $2500. Do you think that XYZ-Company should accept or reject this offer