1) (30 points) PQ Problem: There are three products P. Q. and R. each made using bottleneck machine B. You can make and sell only whole units of each product. Machine B can be used for a maximum of 22 hours/dayit can make only one product at a time. Answer all parts a bands below a) (15 points) Fill all missing information below to completely specify the bottleneck ratio method for determination of the priority and daily production quantities for the three products. Product P O R Unit Selling Price (S/ unit) 330 230 200 Unit Profit Margin(unit) 200 100 Maximum Daily Demand 40 02 0.5 Unit Production Time on Machine B (hours/ unit) Bottleneck Ratio (S7 hour) 300 400 40 Production Priority (First-1 Second - 2. Third - 3) Daily Production Quantities (units/day) Production on Machine (hoursday) Daily Protit from cach Product (5 day Total Daily Profit for parta- b) (7 points) Would your daily production quantities and profit change if there is additional demand for 20 units of Pin a different market at 80% of its current selling price. Assume that satisfying this additional demand will have no detrimental impact on the firm's demand and reputation in its current market. Fill in the blanks below (including the table For P in the different market: New Unit Profit Margin= New Bottleneck Ratio 1 Q R Product New Daily Production Quantities (units/day) New Daily Profit from each Product day! Total Daily Profit for part c) (*8 points) Due to unexpected supply constraints (relating to COVID-19) there currently is limited daily supply of raw material X that is needed to make each of the products P. Q, and R. as specified in the table below. The supply of X is 1000 pounds/day. Based on the data in parta and the table below, which resource is currently more restrictive machine time on Bor raw material X? Explain your choice: define and interpret the metric you use to determine which resource is more restrictive. Product P O R Consumption of raw materialX 10 15 per unit of product (pounds / unit)