A Company Manufactures Two Types of Lawn Mowers: Riding Mowers

A company manufactures two types of lawn mowers: riding mowers and push mowers.The company has the option of manufacturing the mowers in-house or outsourcing the entire operation.In-house manufacturing requires the following four operations: production,assembly,electrical wiring,and final inspection.The following table summarizes the weekly hours of processing time available and the processing time required by each operation.

The company has a weekly demand of 5 riding mowers and 3 push mowers.The company makes its riding mowers in-house for $500 each and its push mower for $200 each.Alternatively,it can outsource its riding and push mowers for $550 and $225 each,respectively.Use Excel to formulate and solve this "make" or "buy" problem.