I really need someone to dumb this down for me. I've searched every other answer on Chegg for this problem and still don't understand. I'm at my wits end. I cannot figure out how to plug all of this into Excel to get the correct answers.

M4.5 The Cullowhee Bicycle Shop (CBS) stocks three types of bicycle road, cross-country, and mountain. CBS buys these bikes from a supplier to sell. A road bike costs $1200, a cross-country cost $1400, and a mountain bike costs $900. CBS can spend up to $12,500 a month to restock their inventory. They sell road bike for $1900, a cross-country for $1800, and a mountain bike for $1200. Each bike must be assembled after they are delivered to the shop. The road bike takes 8 hours to assemble, the cross-country takes 12 hours to assemble, and the mountain bike takes 16 hours to assemble. The employees have 120 hours of available time per month to assemble the bikes. The store has room to store 15 new bike purchases per month. CBS sells more road than cross-country bikes, so they want to purchase twice as many road bikes as cross-country bikes. CBS purchase at least 2 bikes of each type every month. Assume they can sell each bike they purchase from the supplier, how many of each bike should they purchase to maximize their profit? (Hint: Profit = Revenue Cost). Formulate and solve this problem in Excel.

Our teacher uses this type of table for the Excel solver.

Can someone please list all of the formulations for this in as blatant language as possible?

I know the objective is to maximize profit and that the function is 700x + 400y + 300z

I cannot figure out all of the constraints, their equations, and how to input them into this table in standard format. I appreciate any help.

2 Y Z 6.583333 2 2 400 700 300 1400 900 = 1 >= 2 3 14 15