SECTION 1- Logistics Decisions at VXL automotive 1 Exhibition 1 1 Exhibition 2 6 Exhibition 3 9 Section 2- Sheffield City Council Waste Management 10 Section 3- Reflection question 15
SECTION 1- Logistics Decisions at VXL automotive
Exhibition 1
1. Identify and explain all the constraints
In this report, city model is called as “C” and family model is simplified as “F”.
Owing to the head of Logistic and Supply Production Planning team has mentioned that the figure of car production in February should not over the forecast of March 2013 multiplied by 1.06 (corrective factor). Meanwhile, the figure must not lower than number in February.
3514 ≤ C ≤ 3784
Also, the amount of the Family model should higher than 1200.
1200 ≤ F
In terms of passenger doors:
City model has 2 doors while family mode has 4 doors and the contract indicates that the minimum number is 6000 doors for both figures whist the maximum is 18000.
6000 ≤ 2C+4F ≤ 18000
Turning to the assemble time:
Family model needs 20 hours to assemble a car whist the city one takes 15. The total worker is 650 people and each people work 40 hours per week, also this number should turn into monthly which means the result multiply 4. The outcome multiplies the absenteeism that is 4%.
Total work time:
650*40*4*(1-4%)= 99840
20F/ car family car
15C/car city car
20F + 15C ≤ 99840
The profit margin of family model is higher 15% than city one, so the formula can be assumed as F*115%
Max profit margin =F+C
Max profit margin= F115%+C
2. Solve it by using the graphical method
Chart 1
Chart 1
So the optimal product mix is: F = 2154, C = 3784
Max profit is 2154*115%+3784= 6261
3. Check the results by using the Excel Solver:
Chart 2
Chart 2
After predicted the De-seasonal series, the outcome can be list as below
De-seasonal series | 49 | 3540 | 50 | 3553 | 51 | 3565 | 52 | 3578 |