manufactures three-speed, five-speed, and ten-speed bicycles. Each bicycle passes through three departments:fabrication, painting & plating, and final assembly. The relevant manufacturing data are given in the table below. Furthermore, due to a recent rise in demandfor the three-and five-speed bicycles,the company has decided to manufacture at least 20bicyclesfrom the three-and five-speed bicycles combined.Using Excel Solver, determine how many bicycles from each type the company should manufacture per day to maximize its profit. chart beneath

Labour Hours per bicycle

Department Three Speed Five Speed ten speed Max labour hours available per day

Fabrication 2.5 4 5 200

Planting and Plating 5 3.5 5 220

Final Assembly 4 3 5.5 190

Profit Per Bicycle 75 85 110