$\backslash$table$[[,$A$,$B$,$C$,$D$,E,F,$G$,H$

Answer And how to find the rest of the data on excel? thanks

Hint: For part $2,$ think about what can give you average underestimation and overestimation.

$3.$ The COO also wants to know the optimal product mix quantities for each product for the first four months of the coming year. This can vary from month to month, but as of now the COO is happy to have just the answer for January $2024$ and this will be the solution for every month till April. Note that in the coming year the company must adhere to the following constraints regarding their budget, supplier raw materials and demand.

a$.$ Demand constraints: Produce according to your forecast.

b$.$ Budget: Production costs are $$1200$ per product for product $A,$$$1500$ for product B and $$1400$ for product $C.$ Total budget is for production is $$4000000.$

c$.$ The three products need raw materials $x,Y$ and $Z.$ the following table gives how much raw material is need $($in lbs$)$ for each unit of a product. Maximum available quantity of X$,$ Yand Z is $12000lbs$ each.

$\backslash$table$[[,$Products$],[\backslash$table$[[$Raw$],[$materials$]],$A$,$B$,$C$],[$X$,0,5,7],[$Y$,1,1,1],[Z,3,3,2]]$

Note

You can round your forecasts to the nearest integer for cost computations.

For the product mix problem above, use the rounded value of your final forecast.