--%>

Case study of a local public utility commission

The local public utilities commission has been charged with inspecting and reporting utility problems in the area. They have three electrical inspectors and two gas inspectors, each available for 40 hours , to analyze structures in their respective areas of expertise. In addition the commission has $10,000 for up to 10 hours ( at $100 per hour) of expert consultant support to inspect insulation. Any facility inspected requires all three types of inspections ( naturally one of each per facility).

These experts will inspect private homes business ( office buildings) and industrial plants in the area. The goal is to inspect as many structure as possible however the minimum requirements are to inspect at least eight office buildings and eight industrial plants and to make sure that at least 60% of the inspection are of private homes.

Once the total number of each type of structure to be inspected has been determined, the actual inspection will be done by choosing a random sample from those that are served by the commission. The commission will plan using the following approximate inspection hours for each type of inspection:

1873_case study1.jpg

Formulate a linear program to help the commission determine how many of each structure they should inspect. You do not need to implement this model in excel. You do not need to solve the problem and report a solution. You may wish to do so as a means to verify your formulation and to check your work. I will not consider a working excel model as a substitute for the accurate mathematical formulation.

   Related Questions in Financial Accounting

  • Q : Describe Long Holding Period Describe

    Describe Long Holding Period briefly with suitable example?

  • Q : Case study of a global economy The

    The economic recovery is seemingly on track and in fact strengthened during the first half of 2010. The global financial market however, suffered a setback with the turmoil in sovereign debt markets leading to sharp currency movements. The extent of recovery varies ac

  • Q : Implement a user-defined matlab

    Your solution to the problem should be housed within a while loop, which allows the grader to test your solution repeatedly without having to re-execute the script, as shown in class. You should first display the purpose of the program, and then you should prompt the

  • Q : What is Corporate Social Responsibility

    Corporate Social Responsibility directly states that every company is responsible towards the society and the environment. So this is a duty of every company to create eco-friendly new products. In the current scenario when the fuel prices are increas

  • Q : Workings and nature of the financial

    Assume that you are really interested in investing in the shares of Nokia Corporation of Finland that is a world leader in the wireless communication. However, before making the investment decision, you might like to learn about company. Take a look of the website of

  • Q : What bid price per widget should you

    You are required to submit a bid to supply 200,000,000 widgets per year to the State of Illinois for the next five years. Your company has an idle tract of real estate that cost $1,500,000 ten years ago; if your company sold the land

  • Q : Capitalize earnings To transfer amounts

    To transfer amounts from retained earnings to contributed capital through stock dividends. The effect is to decrease retained earning and increase the stock account. Stock dividends also permanently retain the earnings in the corporation by moving it out of the retain

  • Q : Security returns Security returns are

    Security returns are found to be less correlated across various countries rather than within the country. Explain Why?

  • Q : Link financial accounting and

    is there a link between financial accounting and programmed decision

  • Q : Investment approach of Bill Miller

    Investment approach of Bill Miller: In comparison to both Warren Buffet and Peter Lynch, Miller is considered to be a slightly more aggressive investor.  Miller believed in playing big which meant that he used