Draw a line chart compare with last year sales data. Jan Feb Mar Apr May June Chart Title Last year Sales 8000 Data 5899 5473 5432 6547 4566 6543 7000 ( cases) promotional sales 800 550 560 600 6000 previous year base 5899 5473 4632 5997 4006 5943 5000 growth : 5% 294.95 273.65 231.6 299.85 200.3 297.15 base projection 6193.95 5746.65 4863.6 6296.85 4206.3 6240.15 4000 promotion 900 900 3000 sales forecast 6193.95 5746.65 4863.6 6296.85 5106.3 7140.15 2000 1000 Jan Feb Mar Apr May June -Last year Sales Data previous year base -sales forecastThe Inventory on hand data is Jan 130, Feb 200, March 200, April 200 , May 250 and June 300. Operating working days is 25 in each month. Their shipping capacity is 8000 cases . Calculate the capacity utilization rate. Here B&G have two types of production . One is frozen and another one is can based . So, 70% of their total production is can based and reamining 30% is frozen. Show the number of cases of two different forms of production. Represent it graphically . Explain the concept of rough cut capacity planinng. Jan Feb March April May June Sales forecast 6194 5747 4863 6297 5106 7140 Chart Title Production plan 6500 6000 5000 6500 5500 7500 30000 Chart Area Inventory 150 200 200 200 250 300 Working Days 25 25 25 25 25 25 25000 Capacity 8000 8000 8000 8000 8000 8000 20000 Utilization 81.25 75 62.5 81.25 68.75 93.75 CAN based 70% 4550 4200 3500 4550 3850 5250 15000 Frozen 30% 1950 1800 1500 1950 1650 2250 10000 5000 CAN based 70% Frozen 30% Jan Feb . March April May June