1 / 33

BA 5001 Final Coursework

BA 5001 Final Coursework . Final coursework: Lamberts Heating Submission date: Friday 24 th May 2013 This coursework is worth 40% of your final mark for this module . Part A: 50 marks Part B: 20 marks Part C: 30 marks. Part B : Installing the new machinery. Part B : Instructions .

vahe
Download Presentation

BA 5001 Final Coursework

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BA 5001 Final Coursework • Final coursework:Lamberts Heating • Submission date: Friday 24th May 2013 • This coursework is worth 40% of your final mark for this module. • Part A: 50 marks • Part B: 20 marks • Part C: 30 marks

  2. Part B : Installing the new machinery

  3. Part B : Instructions • You may complete this task manually or by using MS project. • Assuming that the project starts on Monday 3rd June 2013, determine the shortest duration for the entire project, using the normal duration times. Specify the date at which the project can finish and the number of weeks required. • Produce a Gantt chart showing the starting and finishing times of each activity • Identify which activities form the critical path(s) of the project.

  4. Part B : Example from booklet • Estate Agency : pages 113 to 115 for manual example • Estate Agency: pages 124 to 127 for MS Project

  5. Estate Agents: Network Diagram The critical path is ADEG. The shortest finishing time for the project is 16 weeks.

  6. Estate Agents: Floats • Float = Latest finish time (LFT) – Earliest finish time (EFT)

  7. Estate Agents : gantt Chart

  8. UsinG MS project: network diagram

  9. UsinG MS project: Gantt Chart

  10. Part B : continued • If the project could be speeded up by a maximum of 3 weeks at a cost of £200 a day, where should this money be spent? Produce a new network diagram to show the new critical path(s) and total duration. • example of crashing on pages 117 to 120 (coursework is easier than this ) • make sure you take note of the minimum durations • calculate the extra cost of speeding up the project

  11. Part B : Report (about 500 words) Give details of the proposed calendar of works, making it clear which activities are critical and which activities have some slack. This section should be written so that the management can understand the advice being given without reference to the work in the appendix. Give details of the starting date, the finishing date and the duration of the project. Explain how, by spending more money, the project duration can be shortened. Explain which activities have been shortened and which activities are now critical. Give details of the starting date, the finishing date and the duration of the project. Give details of the extra cost involved in shortening the project.

  12. Final Coursework : part C • Cost of procuring boilers This part of the coursework requires you to use linear programming techniques to determine the best way to minimise the cost of supplying boilers to Lamberts Heating As well as manufacturing radiators (as mentioned in Part A), Lamberts Heating is also reviewing the way it procures boilers to enable the installation of domestic heating systems.

  13. Part C : Identify the decision variables The purchasing department has identified three possible suppliers of boilers; Apex, Brunswich and Centrale. It has also identified five kinds of domestic boiler that it wants to purchase so it can supply and fit these boilers to a variety of sizes of homes. The five boilers are known and coded by Italian numbers as most are manufactured in Italy ; Uno (1), Duo (2), Tre (3), Quattro (4) and Cinque (5).

  14. PArt C : Identify the consTraints The table below gives the cost of each boiler (in £s) from each supplier. The final row of the table specifies the minimum requirement of each type of boiler per year. Please note that not all boilers are available from each supplier.

  15. PArt C : Identify the consTraints There are certain limitations that have to be taken into account; • Apex can supply no more than 1,000 of the Tre boiler each year. • Brunswichcan supply no more than 800 of the Duo boiler each year. • Centralecan supply no more than 1,800 Uno boilers each year. • Lamberts Heating wants to meet its requirement for the number of boilers needed each year at the minimum cost.

  16. Example from Module booklet page 105 Farm Production A farmer has two farms, Home Farm and Meadow Farm, in which he grows corn and wheat. Both farms are 40 acres in size. To satisfy a contract with a local mill, the farmer must produce 7,000 barrels of corn and 11,000 barrels of wheat each year. The farmer wishes to minimise the cost of meeting the contract.The data for each farm is given below:

  17. Definition of Decision variables Variables: We need to distinguish between production at Home and Meadow Farm. Let CH be the number of acres of corn planted at Home Farm Let CM be the number of acres of corn planted at Meadow Farm Let WH be the number of acres of wheat planted at Home Farm Let WM be the number of acres of wheat planted at Meadow Farm

  18. Formulation of problem Minimise Cost: Minimise 100CH + 90WH + 120CM + 80WM subject to: yield corn(1) 400CH + 650CM ≥ 7,000 wheat (2) 300WH + 350WM ≥11,000 area Home Farm (3) CH + WH ≤ 40 Meadow Farm (4) CM + WM ≤ 40 • CH ≥ 0, CM ≥ 0, WH ≥ 0 WM≥ 0

  19. Farm production : Input

  20. Farm’s Answer Report

  21. Farm’s Sensitivity Report

  22. Coursework requirements: Appendix • Define the meaning of any decision variables you are using. • Formulate the situation as a linear programming problem. • Include your computer input of the problem (and show any formulae used) • Include the “Answer Report” and “Sensitivity Report” printouts

  23. Coursework requirements: Report [about 500 words] Write a brief report to the management of Lambert Heating detailing the cheapest way of meeting their need for boilers. This report, written in a formal style of English, should include: The nature of the problem being solved The suggested purchasing plan The cost of the suggested purchasing plan. The robustness of the plan. Provide details of the ranges of costs of boilers from each suggested supplier for which your suggested plan remains optimal, and advise the company when they will have to generate a new plan

  24. coursework requirements Do not just provide lists but consider your answers in the context of the question. At present, Apex can supply no more than 1,000 of the Tre boiler each year. If this limit was changed so that Apex could now supply 1,100 Tre boilers, explain what effect this would have on the total minimum cost?

  25. Farm Production : Notes for a report This is taken from page 106 of the module booklet 1. Planting Plan • In order to minimise the planting costs, the following should be implemented: • Plant Home Farm with 2.56 acres of wheat • Plant Meadow Farm with 10.77 acres of corn and 29.23 acres of wheat. • This will incur costs of £3,861.54, the minimum that can be achieved.

  26. Farm Production : Notes • 2. Implications of Suggested Planting Programme • The planting plan given above will result in exactly 7,000 barrels of corn and exactly 11,000 barrels of wheat being produced. • [S1 = 0, S2 = 0] • 37.44 acres of Home Farm will not be planted, whilst all 40 acres of Meadow Farm will be used.

  27. Farm Production : Notes • 3. Scope of the recommendations • 3.1 Change in Costs • The planting plan given above will result in a minimum cost whilst the following conditions hold: • * The cost of planting corn at Home Farm stays above £89.23 per acre. • * The cost of planting corn at Meadow Farm stays below £137.50 per acre. • * The cost of planting wheat at Home Farm stays in the range £68.57 to £105 per acres. • * The cost of planting wheat at Meadow Farm stays in the range £62.50 to £105 per acre.

  28. Farm Production : Notes • If any one of the conditions above fails to hold then a new planting plan will be required. Furthermore, if two or more of the present costs change, a new plan will be required. • As these ranges are relatively large, the proposed plan should hold good for some time

  29. Farm Production : Notes • 3.2 Change in Contract • The proposed plan exactly meets the contracts for 7,000 barrels of corn and 11,000 barrels of wheat. • If the requirement for corn was to increase by one barrel, the extra costs incurred in meeting this target would be 22.3 pence. This marginal cost of 22.3 pence per barrel applies for levels of production between 5,571.43 and 26,000 barrels. • If the minimum amount of wheat required was increased, the extra cost would be 30 pence per barrel. This extra cost per barrel will apply whilst the contract for wheat lies in the range 10,230.8 to 22,230.8 barrels. • If the minimum requirement for corn or wheat fell outside these ranges, a new planting plan would be required.

  30. Farm Production : Notes 3.3 Changes in Farm Size • In total only 2.56 acres of Home Farm are being used. Clearly it would not make sense to consider increasing the size of Home Farm.All 40 acres of Meadow Farm are being used. If the size of Meadow Farm could be increased by 1 acre the minimum cost could be reduced by £25. This marginal reduction in cost applies when the size of Meadow Farm lies in the range 10.77 acres to 42.2 acres. • Similarly, if the size of Meadow Farm is reduced by 1 acre, the minimum cost will rise by £25.

  31. Farm Production : Notes If we could increase the size of Meadow Farm by 1 acre, we could produce an extra 350 barrels at Meadow Farm at a cost of £80. • At the same time we would reduce the yield from Home Farm by 350 barrels • i.e. 350/300 = 1.16666 acres. This reduction would save 1.16666*90 =105. • Thus the net reduction would be 105 - 80 = £25 ]

  32. Marking Scheme: Part B • 40

  33. Marking scheme: Part C

More Related