Need the answer for a,d and e -2 3 4 5The space requirement and the leasing costs for the variousleasing periods are as follows.3.15. Larry EdisonBuckly College. He noter. It is open from 8 AhichThed thatRequired Space(Square Feet)usage of the center at vthe following numberstudents) are requirednts inMonth30,0001.40,000Time of Day3.mum000'0LMOuireduoou- 8Noon-4 PM4 PM-8 PM8 PM-midnightbillionCost perLeasing Period(Months)millionSq. Ft. LeasedTwo types of cand part-time. Thetive hours in any ebillion$ 65s in theseafternoon (noon-consultants are pa135minimiz-091Part-time cons061 for thislisted in the table.An additionalThe objective is to minimize the total leasing cost for meet-there must be atity of pur-ing the space requirements.asset 2, andwould thisa) Indicate why this is a cost-benefit-trade-off prob-lem by identifying both the activities and the ben-efits being sought from these activities.b Identify verbally the decisions to be made, the con-straints on these decisions, and the overall measurepart-time consulLarry wouldpart-time consurequirements at.years fromvested?or approachbest guessa. WHof performance for the decisions,c. Convert these verbal descriptions of the constraintsand the measure of performance into quantitativeexpressions in terms of the data and decisions.d. Formulate a spreadsheet model for this problem. Iden-tify the data cells, the changing cells, the objective cell,and the other output cells. Also show the Excel equa-tion for each output cell expressed as a SUMPROD-UCT function. Then use Solver to solve the model.e.) Summarize the model in algebraic form.b. Fototal amountC. Su3.16.* The !diagnostic eqhave placed clowing table sfrom each fa3.14.the number oConsider the following algebraic formulation of a cost-number of urbenefit-trade-off problem involving three benefits, where thedecisions to be made are the levels of fourA decisicfor how man would thismix of invesfromany mix of these feed types,mix will meet certain nutri-with the spreadsheet to develop your besachfor the optimal solution. VYat is the total amssa.st. The number of units ofent contained within a kilo-following table, along withfeed costs.invested for your solution?MinimumDailyKilogramKilogram ofTankageRequirementof Alfalfa20040180200915008097209mming model for thisUse Solver to find an optimal solution.Summarize the model in algebraic form.if (x,, xz, xz) = (1, 2, 2)so, what the daily costWeb Mercantile sells many household products13,through an online catalog. The company needs substantialwarehouse space for storing its goods. Plans now are beingmade for leasing warehouse storage space over the next fivemonths. Just how much space will be required in each of thesemonths is known. However, since these space requirements arequite different, it may be most economical to lease only theamount needed each month on a month-by-month basis. On theother hand, the additional cost for leasing space for additionalmonths is much less than for the first month, so it may be lessw many units of eachhis diet provide daily?al-and-error approachop your best guess forhe daily cost for yourolution.form.1 officer for the Alvaexpensive to lease the maximum amount needed for the entirefive months. Another option is the intermediate approach ofchanging the total amount of space leased (by adding a newlease and/or having an old lease expire) at least once but notMidwest. The com-hydroelectric plantseeds of the growingpany. To cover theevery month.

Question

Accepted Answer

Objective is to minimize leasing cost.Let Xij = the amount of space leased in a month i for a period…