Please use EXCEL SOLVER for this problem and show me screenshots from excel of how you did it. Thank you!

Problem 1: Make or Buy You own a company that makes bicycles. You manufacture many of your own parts, but you also have the option to buy some of your parts. You've budgeted $13 for each bearing assembly and $11 for each pedal. Your cost to make a bearing assembly is $8 and your cost per pedal is $9. The difference between those is the Margin Contribution by part. You need 4,000 bearings and 8,000 pedals. The table below shows the time it takes in Machining, Assemly and Transportation it takes for each component, as well as the hours available. You can also buy any mix of the needed components, up to 5,000 total pieces, for $10.75 each. What mix of Make and Buy for Bearings and Pedals is needed to give you the highest Margin Contribution? Which process is your bottleneck preventing you from Making more in-house