90.2K

Verified Solution

Link Copied!

I need the answer.

Fizzy & Crispy Co. The beverage and snacks company "Fizzy & Crispy is one of the largest juices, drinks, and snacks producers in Norway. Their products are famous over all Europe. They are mainly known for their soft drinks and salty chips. Their oldest factory is now due for renewal because of quality control issues. A team has been hired to help in the overhaul by assessing the conditions in the factory, and to work also as a consultant for their operations of that same factory. The company faced a serious challenge and they asked you, the Industrial Engineers team, to help them out with it. Lately, the farm from which Fizzy & Crispy buy its potatoes has been struggling with sales for two years now. The reason is that the overall monthly production has been lower than expected. They know that the production process is designed to yield an average of 800 tons per month, and this number of sales is enough to keep them afloat. The company's statistical experts claim that there is not a specific reason contributing to the decline in production in the last two years, and they are confident that this is due to pure variation. If the company does not act now, it will be forced to shut down the operations of the farm a year from now. However, if they can produce over 600 tons monthly in at least four of the 12 months preceding the closure deadline, they will stay in operation. Otherwise, they will have to take a very expensive loan now to improve the production, which the company is trying to avoid by any means possible. You, being the newly appointed team at the company, wants to challenge the opinion given by the experts and you have a plan that could help the top management decide on what they need to do. You asked your supervisor to provide you with the historical monthly production figures available in the company's archive for the last 10 years (see the Excel file shared). Use the appropriate statistical and probability tools to assess the experts claim first, then to explain and perform your analytical plan. Based on the obtained results, clearly indicate whether the company should take the loan or not. 435 > x fx C A B D E G H Month Production Month Production Month Production Month Production Month Production January 12 897.94 January-13 807.98 January-141 712.25 January 15 855.27 January 16 715.16 February 12 862.15 February 13 756.75 February-14 902.64 February 15 976.07 February-16 811.16 March-12 950.74 March-13 824.68 March-14 747.02 March-15 908.44 March-16 829.21 April-12 661.75 April-13 841.65 April-14 922.25 April 15 607.57 April-16 820.17 May-12 706.9 May-13 634.84 May-14 837 May-15 664.24 May-16 819.6 June-12 695.94 June-13 990.47 June 14 824.36 June-15 754.83 June-16 980.95 8 July-12 825.03 July-13 876.32 July-14 848.48 July-15 719.41 July-16 969.78 2 August-12 920.48 August-13 834.21 August-14 721.52 August-15 930.08 August 16 744.84 0 September-12 919.55 September 13 773.41 September 14 799.67 September-15 806.17 September 16 729.27 11 October 12 615.94 October-13 755.34 October 14 697.54 October 15 690.48 October 16 897.35 12 November 12 932.15 November-13 838.33 November-14 798.04 November 15 696.34 November-16 714.04 13 December-12 768.43 December-13 899.89 December 14 861.73 December 15 886.58 December 16 631.67 14 Month Production Month Production Month Production Month Production Month Production 15 January 17 704.62 January 18 959.48 January 19 974.52 January-20 761.47 January 21 580.28 16 February 17 813.94 February-18 990.53 February 19 910.67 February-20 422.22 February-21 634.85 17 March-17 818.75 March-18 851.86 March-19 745.41 March-20 595.12 March-21 491.13 18 628.81 April-17 April-18 828.37 April-19 849.66 April 20 551.45 418.94 April-21 19 May-17 828.97 May-18 880.72 May-19 759.89 May-20 454,74 May-21 648.99 June-17 June-18 20 June 19 876.66 883.4 S44.55 774.4 766.04 June-21 June-20 21 925.72 July-17 July-18 582.35 July-19 920,47 953.25 July 20 318.1 July 21 22 564.17 801.67 365.08 725.48 August 19 799.47 August 18 August-20 August 17 August-21 813.01 928.37 386.36 636.07 September-18 23 September-17 993.44 September-20 September 19 September-21 October-20 636.51 October 21 24 695.79 October-19 October 17 632.46 773.48 845.74 October 18 438.27 November-21 496.07 822.19 777.79 November 20 November 19 November 18 836.34 25 November-17 426.55 508.22 December 21 December-20 26 December-17 629.93 December 18 December 19 706.38 658.14 27 28 SINESS

Answer & Explanation Solved by verified expert

See Answer