header
 

My Model for the Meats Problem

A company produces Italian sausages and bratwursts at plants in Green Bay and Sheboygan. The Green Bay plant can make 800 sausages an hour and 800 bratwursts an hour. The Sheboygan plant can make 500 sausages and 1,000 bratwursts an hour. How many hours should each plant be scheduled to fulfill an order for 62,250 sausages and 76,500 bratwursts?

System of Equations

System of Equations

Complete Mathematical Model

800x1 +  500x2 = 62250
800x1 + 1000x2 = 76500
        x1, x2 ≥ 0

Excel Setup

Meats Model 

Cell B4 represents the number of hours the Green Bay plant will run and cell B5 is the number of hours the Sheboygan plant will run.

Note: click on the video icon to see one way to enter subscripts in cell text. video