Please answer the whole question using the given information

Given the information below, determine the production plan and the resulting weekly profit corresponding to the bottleneck ratio approach (prioritization from your answer to part b above). Here production plan specifies the number of units of P and Q produced each week) and relevant weekly costs include raw material, labor, and machine-time operating cost. 2. PQ Problem: LCB-Balsa, Inc. produces two models of toy airplanes, for which the relevant data are summarized below: All data are per unit of product Toy Airplane p Toy Airplane "Q" Selling price 39 S/unit 42 $/unit Labor required 0.75 hour/unit 1 hour/unit Machining time required 1.5 hour/unit 0.8 hour/unit Raw material required per unit 2 bf/unit 1 bf/unit Maximum weekly demand 160 units 100 units Each week, up to 440 board feet (bf) of raw material is available at a cost of $4.5/bf. The company employees four workers, who work 40 hours per week for a total regular-time labor supply of 160 hours per week. They work regardless of production volumes so their salaries are treated as a fixed cost; the wage rate is 10$/hour, per worker. There are 320 hours per week of machining time available (if useful, you can think that each worker can operate two machines concurrently). The relevant weekly operating cost for 320 hours of machine time is only 1000$, corresponding to a low cost rate = 3.125$/hour of machine time. 2.B The product that will be receiving the highest priority will be Product Q. Product $39 $9 $30 Product Q $42 $4.50 $37.50 Unit Selling Price Unit Raw Material Cost Unit Profit Unit Processing Time (minutes) Weely Demand in Units Bottleneck (Labor) 90 160 48 100 220 Bottleneck Ratio 0.14 0.17