Assume that the resource availabilities shown are for a planning period of one week and that partial values in the solution represent work-in-process. B C D H 1 Kingston Metal Ceramics Casting Natal caramic Surface coat Firing Profit 3 DATA: Variables Prices Timechirp Clay jop) material igms| Inc phraj 30 15 0.75 TypL 1.425 ED 7.5 74 Typ#D 15 12 cont 10 MODEL 11 Type A Type D TYPIC TypeO 12 116786047 13 Prof 14 1543.208313 14 16 Coding One jhin 1.3 1.12 112 240 240 16 Metal ceramic clay (Hp) 12 16 210 17 Burfees coal material Ignat 13450 18 Firing Lie [fval 1450 A B E H Microsoft Excel 12 0 Sensitivity Raport 2 Kingston Metal Ceramics Report Created: 1/202012 10:46:49 AM 6 Adjustable Cella Final Reduced Objective Aonable Allowable Cell Name Value Com Coefficient Increase Decrease 18$12 Type A 16.AGEGEG7 6.1875 9.5120 IC812 Type B 5.MENTS 6.341876 18+30 11 50$12 Type C 0.334378 SE$12 Typ: D -10.44 1.4 10.44 16+30 4 Constraints Final Shadow Constraint Allowable AViewable Cell Name Value Price R.H. Side Increase Decrease 17 51 $15 Casting time [hral 18 SF$16 Metal ceramic clay (high 181.6 210 E+10 1E.G SF817 Surface cost material jgmaj 13850 15000 IE+10 SP$18 Firing time Thrap 1350 0958 840464 1350 100.9090904 340 21 Please note: Consider each question below independently. Each question is worth 2 marks. 1. How much of an increase in price would the manager have to negotiate in order to make production of type D blades economic? 2. How much would the price of type A blades have to rise before she would increase type A production? 3. A person who has the skills to do casting work has moved into the neighborhood and is willing to consider some part-time work. Should the manager hire him? What is the maximum wage the manager should be willing to pay? How many hours would she want to hire at this rate? 4. The manager has been approached by another company that urgently needs 15 Kg of metal ceramic clay. The manager would like to help the company out, but doesn't think she should lose money thereby. What minimum price should she charge for 15 kg of clay