You are trying to understand the relationship between demand and production. You requested an interim report with percentages, showing how the Production Department over produced or fell short against actual demand. The following report was received: Quarterly Production Fulfilment Report Month 1% Month 2 % Product Month 3% Total Quarter % Demand 992 Over(+) Short(-) 1.98% 5.52% Demand 1450 1529 Over(+) Short(-) 3.85% 4.14% Demand 1398 1375 1386 1260 0.00% 289 Over(+) Short(-) 3.91% 4.71% 5.50% -1.54% 15.19% 27.46% 281 7.15% 3.67% 17.33% 26.06% - 11.54% 9052 3394 7644 201 9045 3079 31 -2.43% 11.04% 29.40% -1.61% 11.64% 15.43% 4.91% -6.82% Description White Pan 567g WON 99 Wonder 100pct medium 475g WON 106 Wonder 100pct gde 680g SP WON 107 Precocious Baguette Cong 280g DH 108 Buns BK 4in 36p 1635g SL 131 Buns BK Sin 30p 1730g SL 132 Wholegrain Toast 180g MTA WON 49992 Tostado Integral 180g TAB WON 49993 Buns 5IN 6p 560g Consumption MTA BIM 43157 Flat Toast 15p 175g MTB MR 43159 7 Grains 680g MTA GOLD 43160 Flour Tortilla Gde RN 10p 540g MTB DH 43178 Tortillinas 10p 255g MTA TR 43179 Large Tortillinas 10p 510g MTB TR 43180 Tortillinas 20p 510g MTA TR 43181 Integral Bread 680g MTA BIM 43186 Stockings Nights 8p 340g MTA BIM 43188 Grand Totals 8756 2713 63 1814 2986 2323 - 8 1585 8.83% 2044 2620 Over(+) Short(-) 5.35% 4.51% 5.23% -7.80% 17.06% 27.30% -13.89% 6.82% 23.56% 5.05% -25.00% -10.53% -8.81% 6.03% 7.14% 3.87% 0.00% 11.52% Total Demand 3840 4290 8904 771 26853 9186 117 5443 8282 6951 18 26 693 4741 15129 2756 2 98002 19.61% 2241 -27.27% 7.89% 20.34% 4.52% -20.00% 0.00% -2.92% 7.52% 6.41% 3.19% -33.33% 12.12% 5 2676 2387 6 21 207 1262 4133 918 247 1858 7283 880 239 -25.00% 0.00% 5.59% 5.86% 3.43% 0.00% 10.54% 1621 3713 4.83% -24.90% -13.31% -3.67% 6.46% 6.48% 3.50% -33.33% 11.44% 958 0 33575 28459 35968 (a) (b) State whether the sample of data represents output at the operational, tactical or strategic level (1 mark) Explain what type of report has been provided. (2 marks) Based on the findings in the report, discuss two important points that should be raised and describe one other report and its contents that would be useful to assist in your analysis. (6 marks) MGMT Bakery, which operates in Barbados, has been acquired by the multinational company "Panes del Caribe headquartered in Ecuador. Discuss THREE (3) global challenges Panes del Caribe will face integrating MGMT Bakery into its operations. (6 marks) (d) You are trying to understand the relationship between demand and production. You requested an interim report with percentages, showing how the Production Department over produced or fell short against actual demand. The following report was received: Quarterly Production Fulfilment Report Month 1% Month 2 % Product Month 3% Total Quarter % Demand 992 Over(+) Short(-) 1.98% 5.52% Demand 1450 1529 Over(+) Short(-) 3.85% 4.14% Demand 1398 1375 1386 1260 0.00% 289 Over(+) Short(-) 3.91% 4.71% 5.50% -1.54% 15.19% 27.46% 281 7.15% 3.67% 17.33% 26.06% - 11.54% 9052 3394 7644 201 9045 3079 31 -2.43% 11.04% 29.40% -1.61% 11.64% 15.43% 4.91% -6.82% Description White Pan 567g WON 99 Wonder 100pct medium 475g WON 106 Wonder 100pct gde 680g SP WON 107 Precocious Baguette Cong 280g DH 108 Buns BK 4in 36p 1635g SL 131 Buns BK Sin 30p 1730g SL 132 Wholegrain Toast 180g MTA WON 49992 Tostado Integral 180g TAB WON 49993 Buns 5IN 6p 560g Consumption MTA BIM 43157 Flat Toast 15p 175g MTB MR 43159 7 Grains 680g MTA GOLD 43160 Flour Tortilla Gde RN 10p 540g MTB DH 43178 Tortillinas 10p 255g MTA TR 43179 Large Tortillinas 10p 510g MTB TR 43180 Tortillinas 20p 510g MTA TR 43181 Integral Bread 680g MTA BIM 43186 Stockings Nights 8p 340g MTA BIM 43188 Grand Totals 8756 2713 63 1814 2986 2323 - 8 1585 8.83% 2044 2620 Over(+) Short(-) 5.35% 4.51% 5.23% -7.80% 17.06% 27.30% -13.89% 6.82% 23.56% 5.05% -25.00% -10.53% -8.81% 6.03% 7.14% 3.87% 0.00% 11.52% Total Demand 3840 4290 8904 771 26853 9186 117 5443 8282 6951 18 26 693 4741 15129 2756 2 98002 19.61% 2241 -27.27% 7.89% 20.34% 4.52% -20.00% 0.00% -2.92% 7.52% 6.41% 3.19% -33.33% 12.12% 5 2676 2387 6 21 207 1262 4133 918 247 1858 7283 880 239 -25.00% 0.00% 5.59% 5.86% 3.43% 0.00% 10.54% 1621 3713 4.83% -24.90% -13.31% -3.67% 6.46% 6.48% 3.50% -33.33% 11.44% 958 0 33575 28459 35968 (a) (b) State whether the sample of data represents output at the operational, tactical or strategic level (1 mark) Explain what type of report has been provided. (2 marks) Based on the findings in the report, discuss two important points that should be raised and describe one other report and its contents that would be useful to assist in your analysis. (6 marks) MGMT Bakery, which operates in Barbados, has been acquired by the multinational company "Panes del Caribe headquartered in Ecuador. Discuss THREE (3) global challenges Panes del Caribe will face integrating MGMT Bakery into its operations. (6 marks) (d)