Assessment of Supply Chain Improvement Statistics Project

Assessment of Supply Chain Improvement - Statistics Project Example The dangers in using predictive models are in the quality of input assumption. If we underestimated our lawmakers and their willingness to impose import tariff for scooter imports from China is 70% and not 30% this would change the result in favour of production in Scotland as it would suggest that the result expressed as daily profit for outsourcing to China would come to only Ã…  425,33 which is less than Ã…  453,33. The simplicity with which I checked the result under changed assumption may be considered as one of advantages of EMV modeling approach. The same goes for all other assumptions like sales probability prediction. In original scenario I would recommend that everything for Milton Keynes be made in Manchester. I would recommend that Toulouse makes as much as possible for Paris and Madrid and Stuttgart to fill in where Toulouse can not deliver for Paris and Madrid. It turns out that Toulouse does not make Professional model so it should make more profitable Weekender and less profitable De Luxe model. From available material Toulouse can make 1500 sets of Weekender and 100 sets of De Luxe model. Limitations are available steel and aluminum. Toulouse makes â‚ ¬ 297.700 in profits. Stuttgart would be able to make Professional and De Luxe models but not Weekender so available materials there allow for production of 400 Professional sets for Paris and 200 professional sets for Madrid as well as 1000 De Luxe sets for Madrid and 900 De Luxe sets for Paris. Stuttgart makes â‚ ¬ 411.700 in profits. ... It turns out that Toulouse does not make Professional model so it should make more profitable Weekender and less profitable De Luxe model. From available material Toulouse can make 1500 sets of Weekender and 100 sets of De Luxe model. Limitations are available steel and aluminum. Toulouse makes â‚ ¬ 297.700 in profits. Stuttgart would be able to make Professional and De Luxe models but not Weekender so available materials there allow for production of 400 Professional sets for Paris and 200 professional sets for Madrid as well as 1000 De Luxe sets for Madrid and 900 De Luxe sets for Paris. Stuttgart makes â‚ ¬ 411.700 in profits. Manchester can make all three sets, thus it supplies all the needs of Milton Keynes (600 professional, 800 De Luxe and 800 Weekender) as well as 100 De Luxe sets for Madrid and 1000 Weekender set for Madrid. Manchester unit makes â‚ ¬ 616.900 in profits. b) However, if in above scenario we deduct fixed costs from profits we find out that our Toulous e unit does not cover fixed costs. Therefore I would recommend closing down facility in Toulouse and transferring materials to Manchester to make demanded units there. If we have no possibility of transferring materials than we can fulfill our 80% obligation by transferring production of Weekender Sets to Manchester (we can not make them in Stuttgart) where we have surplus materials. We have to transfer production of De Luxe sets from Toulouse to Manchester as Stuttgart is close to limit in steel and can not accept 100 De Luxe sets more. We do not want to lower production of professional sets (they were not produced in Toulouse at all) as they carry the biggest profit margin if possible. If we lower production for De Luxe sets for