100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

Management of a petrochemical company

Management of a petrochemical company
Answers, excluding the data and computer output, should not exceed 4 pages. Therefore, answer each question briefly and precisely without omitting relevant points. Tables containing summary of the results should be included in the main text while data, estimation output, etc. should be relegated to appendices. Each group should submit three files
1- A typed coursework in word or pdf.
2- One excel file contain data and analysis.
3- One Eviews workfile for econometric analysis.
Having completed this coursework the students should be able to:
• Use excel to process and analyse the data, produce tables graphs and perform regression analysis, including diagnostic tests and hypothesis testing,
• Perform forecast and evaluate the performance of different types of forecasting techniques,
• Perform simulations, analyse the outcome and make decisions based on the outcome,
• Solve linear programming problems and use them for optimisation
Management of a petrochemical company producing special type of polymer is trying to control its inventory costs. The weekly cost of holding one unit of this product in inventory is $300 (one unit is 100kg). The marketing department reckons that weekly demand is reasonably close to a lognormal distribution with an average of 120 units and standard deviation of 40 units.
If the demand exceeds the amount of product on hand, those sales are lost – i.e. there is no backlogging of demand. The production department can produce at one of the three levels: 100, 120 or 140 units per week. The cost of changing production from week to the next is $30,000.
Management would like to evaluate the following production policy. If the current inventory is less than l=30 units, then produce 140 units in the next week. If the current inventory is more than u=80 units, then produce 100 units next week. Otherwise, if the current inventory is between u=80 and l=30 units, then produce 120 units next week. The company currently has 60 units of inventory on hand and last week’s production level was 120.
1- Create a spreadsheet to simulate 52 weeks of operation at this manufacturer. Graph the inventory of the product over time. What is the total cost (inventory cost plus production change cost) for the 52 weeks?
2- Use a simulation of 10,000 trials to estimate the average 52-week cost with values of u ranging from 50 to 100 in increments of 5. Keep l=30 for all trials.
3- Calculate the sample mean and standard deviation of the 52-week cost under each policy. Using those results, construct 90% confidence intervals for the average 52-week cost for each value of u. Make and present a graph of the average 52-week cost versus u. What is the best level of u when l=30?
4- What would be the optimum production quantity if we follow the policy: produce 140 if inventory level less than 30, produce 100 units if inventory level is more than 80, but keep the production level same as last week if 30

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

Instant Quote

Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Total Cost: NaN

Get 10% Off on your 1st order!