Please show all work with explanations and provide excel solver solution (screenshots of formulas)!

Bexter Labs produces three products: A, B, and C. Bexter can sell up to 30 units of product A, up to 20 units of product B, and up to 20 units of product C. Each unit of product C uses (up) 2 units of A and 3 units of B and incurs $5 in processing costs. Products A and B are produced from either raw material 1 or raw material 2. It costs $6 to purchase and process 1 unit of raw material 1. Each process unit of raw material 1 yields 2 units of A and 3 units of B. It costs $3 to purchase and process 1 unit of raw material 2. Each process unit of raw material 2 yields 1 unit of A and 2 units of B. The unit prices or the products are A,$5; B, $4; C,$25. The quality levels of each product are A,8; B, 7; C, 6. The average quality level of the units sold must be at least 7. Determine how to maximize Bexters profit.

The correct answer is $420.

Selling Price Product Sales Limit Quality 8 30 $5 Category Raw Material 1 Raw Material 2 Product C Costs Produces Needs $6 2A & 3B $3 1A & 2B 2A & 3B B 20 $4 $25 $5 20 Average Needed ed 7 Selling Price Product Sales Limit Quality 8 30 $5 Category Raw Material 1 Raw Material 2 Product C Costs Produces Needs $6 2A & 3B $3 1A & 2B 2A & 3B B 20 $4 $25 $5 20 Average Needed ed 7