| | Consider the following information regarding the expected demand for November 2020 and all costs involved in the operation at HP Production Plant (all prices in Euros) |
| | Products : HP Pavilon and HP Spectre |
| | Demand (units): 600 and 750 respectively |
| | Working days: Monday to Saturday (max. 24 hours a day) |
| | Hours per shift: 6 hours each shift |
| | Number of stations: 7 |
| | Number of workers required per station: 1 (assume workers can not help others since the process is made by a robot) |
| | Wages: 950 per worker (monthly) |
| | Sales price per unit: 1,000 and 1,400 respectively |
| | Raw Material Cost per unit: 390 and 410 respectively |
| | Utilities, maintenance and others expenses: 660 per hour (assume the Company will work 24 hours a day, from Monday to Saturday. So consider the number of real working days) |
| | Depreciation cost: 4,400 per station (monthly) |
| | Administrative expenses: 255,000 (monthly) |
| | Advertising costs (6% of total sales) |
| | Insurance costs: 4,000 per month |
| | Process time (in minutes) | | | | Number of units that can be processed at the same time |
| | Station / Product | Hp Pavilon | HP Spectre | | Station / Product | Hp Pavilon | HP Spectre | | Station | Rejection Rate % | Availability rate % | Performance rate % |
| | A | 60 | 70 | | A | 5 | 3 | | A | 5% | 98% | 96% |
| | B | 80 | 80 | | B | 3 | 5 | | B | 7% | 95% | 97% |
| | C | 30 | 36 | | C | 2 | 1 | | C | 5% | 95% | 90% |
| | D | 40 | 20 | | D | 1 | 2 | | D | 1% | 99% | 100% |
| | E | 60 | 50 | | E | 2 | 2 | | E | 8% | 99% | 100% |
| | F | 30 | 20 | | F | 1 | 1 | | F | 10% | 96% | 98% |
| | G | 40 | 60 | | G | 3 | 3 | | G | 15% | 92% | 97% |
| | | 340 | 336 | 676 |
| | Given the previous information, then answer the following questions: |
| 1 | Calculate the taktime to produce all the required units (in minutes) |
| 2 | Calculate the inputs table showing the production rate in minutes (minutes per unit) |
| 3 | Calculate the OEE per station |
| 4 | Calculate the production table per product per processes requiered to comply with the demand (required time per product per station) |
| 5 | Calculate the total required capacity per station |
| 6 | Calculate the availabe time |
| 7 | Calculate the Capacity utilization rate |
| 8 | Identify Constraints (in case you find) |
| 9 | Calculate Throuput per product |
| 10 | Calculate the throuput rate per product per minute |
| 11 | Which product has to be produced first? |
| 12 | Calculate the Mix of production which maximize profits |
| 13 | Calculate the EBIT given the mix of production already calculated |
| | Extra questions: |
| | Now imagine you have an other client who enter the 15 of November and needs 20% of your production capacity: |
| 14 | What impact will it have in the production of your first client, answer calculating the delay involved. |
| 15 | How could you avoid this delay and still deliver the first order on time? |
foroudt
midtermproductionexercise.xlsx
