The following budgeted price and unit cost information is availahilu fiu ane. muve a: Manuracturing overhead corts is allocated $6.00/ machine hour to all three procucts. 40% of the manufacturing overhead costs is considered variable. fuemaining are fored costs. Note 2: 1056 of the selling and admin conts are vaciable. The remaining are fored. PN monthiy machine hour capacity it limited to 1,500 hours. Monthy demand information is ai follows: Question 1: Prepare a product mix analyis, Determine the mathine hours required fer each of the product. Determine the ranking of the products in arder of its contribution margin per. constrained resourte, (11mark) Question 2 - Using the linear programaming model undier Solvet, determine the optinal number of units of each product PNBC should mate and sell tach month to mavimise the profie. (include the screen thot of your ip models and newita), (10 mark) Interpret the Answer Report and Sensitivity Heport. What are the tindinc constraints? Explain why the constraints are binding or not bindine, if the compaey an acquire more machine hourt, what price would the company be willing to pay? is maris) 21Px= bre at folowe The following budgeted price and unit cost information is availahilu fiu ane. muve a: Manuracturing overhead corts is allocated $6.00/ machine hour to all three procucts. 40% of the manufacturing overhead costs is considered variable. fuemaining are fored costs. Note 2: 1056 of the selling and admin conts are vaciable. The remaining are fored. PN monthiy machine hour capacity it limited to 1,500 hours. Monthy demand information is ai follows: Question 1: Prepare a product mix analyis, Determine the mathine hours required fer each of the product. Determine the ranking of the products in arder of its contribution margin per. constrained resourte, (11mark) Question 2 - Using the linear programaming model undier Solvet, determine the optinal number of units of each product PNBC should mate and sell tach month to mavimise the profie. (include the screen thot of your ip models and newita), (10 mark) Interpret the Answer Report and Sensitivity Heport. What are the tindinc constraints? Explain why the constraints are binding or not bindine, if the compaey an acquire more machine hourt, what price would the company be willing to pay? is maris) 21Px= bre at folowe