Pettibone Traverse Lift in Baraga is trying to determine if they should be making some of their machine frames in-house versus buying them from external suppliers. Engineering has determined internal consumption rates of steel and labor to produce each frame plus a setup cost required to create the frame production line. There is a demand 26, 26, 52, 12 respectively for the Cary-Lift, Speed Swing, Extendo and Traverse model frames. Labor cost is $36 per hour with a $18 per hour overhead rate. There are 1,200 hours of labor available during the planning period. Currently steel cost $1.98 per pound. The following table describes the revenue per machine; outsource cost per frame and consumption for each frame if made internally.

Create an Excel model to determine which models Pettibone should setup to make internally and buy to maximize revenue.