$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 $12000$ ?lbs each.

Products

Raw

materials A B C

X $057$

Y $111$

Z $332$

Note

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

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

For example, if your forecast for January $2024$ ?for a product is $145\mathrm{.}67,$ ?use $146.$

$3.$ ?The forecasting methods we learnt are $$One$-$step$-$ahead$$ ?forecast i$.$e$.,$ ?they give us

the forecast till period $($T$+1)$ ?where T is the last period of the historical data. In

general, for such cases we assume that forecast for every period after T is same as

the forecast of period $($T$+1).$ ?In this case study, wherever applicable consider that

the forecast for the first four months of $2024$ ?is same as the forecast of January

$2024$

Please copy over what I set up and show me how to use solver to solve the question in excel. $($Attach screenshots$)$