use the excel solver

1.TheElectrocompCorporationmanufacturestwoelectricalproducts:airconditionersandlargefans.The assemblyprocessforeachissimilarinthatbothrequireacertainamountofwiringanddrilling.Eachair conditioner takes 3 hours of wiring and 2 hours of drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are available and up to 140 hoursofdrillingtimemaybeused.EachairconditionersoldyieldsaprofitofPHP250.00.Eachfan assembledmaybesoldforaPHP150.00profit.Formulateaproductionmixsituationtofindthebest combination of air conditioners and fans that yields the highest profit.

2.Electrocomp's management realizes that it forgot to include two critical constraints (See #3). In particular, managementdecidedthattoensureanadequatesupplyofairconditionersforacontract,atleast20air conditioners shouldbe manufactured.BecauseElectrocomp incurredan oversupplyof fansinthe precedingperiod,management alsoinsiststhatnomorethan80fansbeproducedduringthisproduction period.Reformulateaproductionmixsituationtofindthebestcombinationofairconditionersandfans that yields the highest profit.

3.A candidate for mayor in a small town has allocated PHP 400,000.00 for last-minute advertising in the days precedingtheelection.Twotypesofadswillbeused:radioandtelevision.EachradioadcostsPHP 2,000.00andreachesanestimated3,000people.EachtelevisionadcostsPHP5,000.00andreachesan additional7,000people.In planningtheadvertisingcampaign,thecampaignmanagerwouldliketoreach as many people as possible, but she has stipulated that at least 10 ads of each type must be used. Also, the number of radio ads must be at least as great as the number of television ads. Formulate an LP problem.

4.The Outdoor Furniture Corporation manufactures two products: benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters (labor force) and a supply of narra for use in the furniture.Duringthenextproductioncycle,1,200hoursoflaborareavailableunderaunionagreement. Thefirmalsohas astockof3,500feetofgoodqualitynarra.Eachbenchproducedrequires4laborhours and10feetofnarra;eachpicnictabletakes6laborhoursand35feetofnarra.Completedbencheswill yield a profit of PHP 900.00 each, and tables will result in a profit of PHP 200.00. Formulate an LP problem.5.The Dean of the Western College of Business must plan the school's course offering for the fall semester. Students' demands make it necessary to offer at least 30 undergraduate and 20 graduate courses in the term. Faculty contracts also dictate that at least 60 courses be offered in total. Each undergraduate course taught costs the college an average of PHP 25,000.00 in faculty wages, and each graduate course costs PHP 30,000.00. How many undergraduate and graduate courses should be taught in the fall so that total faculty salaries are kept to a minimum?