2. Pull the sales forecast data form last exercise. Consider thir production plan as a round number/figure of cases ( like 500 cases , 1000 cases or 1500 cases) The inventory on hand data is Jan 150, 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. Pull the monthly data from sales and opeation plan 2 Work on week wise demand management Page 4 + Show the day wise demand managementPull the monthly data from sales and opeation planning Work on week wise demand management Show the day wise demand management Graphically represent the day wise demand management.nto.ca/courses/885/assignments/9704 1.Copy or take a snap shot of each tables and graphs( under the broad headings) and submit It in CANVAS. Please ensure you have to upload two files one is WORD FILE and another one is EXCEL FILE. Page1. The following table shows the B&G Foods Last year sales data, In last year they initiated a rigorous campaign activities which enhance their sales in last quarter April to June by 550 cases, 560 cases and 600 cases. In addition, in the month of March ( last year) they offered a discount program as their promotional activity for their 10th anniversaries. It also created a positive vibes In the market and enhanced their sales in that month 800 cases as a promotional sale too The estimated growth rate B&G assumes as 5%. In addition, Marketing Team have a plan for providing volume sales discounts policy in the month of May and June Which enhance the additional sales of 900 cases in each month. On the basis of this information calculate the sales forecast for the month of January to June. Draw a line chart compare with last year sales data. Jan Feb Mar Apr May June Last year Sales Data 5899 5473 5432 6547 4566 6543 ( cases) Page 1 / 4 Q + Q Search hp