2. (40 points) PQ Problem: This question deals with a version of the PO problem discussed in class and in the PQ exercise documents (refer to Canvas Intro Module 1). Bcarcat Industries makes (BT) manufactures a mix of affordable guitars (P, Q, R) that are fabricated and assembled using four different processing stations (W X, Y, Z). The process flow chart for Products P.Q. R is depicted in the figure below and includes information on unit price, weekly demand, and processing time on specific stations Bearcat Industries can make and sell up to the limit of its weekly demand with no penalties for not meeting the full demand. One worker staff's each workstation; cach worker is dedicated to work on that workstation alone and is paid $15 per hour regardless of how much the worker or station is used. The plant operates one 8-hour shift per day on a 5-day week, or 40 hours/weck, with no overtime. Overhead costs are $9000/week. Flowchart for Products P, Q, R [Inverted triangles represent purchased parts / raw materials consumed per unit process steps at different workstations are denoted by rectangles, note that this is not a flow show, 1.e. cach product can visit different workstations in a different order) P SI1 Step at Workstation W Step 2 Workstation 2 I Finish with Step 3 Workstation X (10 min) 55/used Product Price Demand 60 Juni Raw Manis Product Step 2 Workstation Y Workstation W (9 min) Finish with Step Workstation Z (10 min) Product O Price 5195/unit Demand 80 Raw Material 54 Purchased Part Product R $14 R Step 1 Workstation X (10 min) Step 2 at Workstation W Finish with Step 3 Workstation Y (5 min) Purchased Puri Product Price 5110 Demand 60 Raw Materials 55 1. (8 points) Which workstation is the bottleneck? Show all calculations used to answer the question. 1 b. (9 points) Calculate the bottleneck ratios and determine which product is given higher production priority by the bottleneck ratio method. Is this prioritization the same as that obtained using the unit profit method instead of bottleneck ratios? c. (8 points) Determine the production plan umber of units of P, Q, and R produced weekly) using the bottleneck ratio method d (7points) Calculate the weekly net profit corresponding to your production plan after labor cost and overhead c. (8 points) Answer ANY ONE of the following Would you increase capacity on any source. Sing overtime paid at time-and-a-half (1.5 x 15 - 22.55/hour)? If yes, on which resource(s) and for how long? If not, why not? Brictly explain your reasoning (ii) The PO problem above deals with the short-term problem of weekly production planning. Consider the corresponding long-term strategic capacity and demand-planning problem. Listspecific Jonger Icom.choices to be made and discuss how they affect the weekly production planning