Can someone please show me how to solve this problem in excel? It would be much appreciated :) Thumbs up guaranteed for answering!

The Weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However, Weedwacker's production capability is limited in three departments: production, assembly, and packaging. The following table summarizes the hours of processing time available in the processing time required by each department for both types of trimmers. The company makes its electric trimmer in-house for $55 and it's gas trimmer for $85. Alternatively, it can buy electric and gas trimmers from another source for $67 and $95 respectively. How many gas and electric trimmers should Weedwacker make, and how many should it buy from its competitor in order to fulfill its contract in the least costly manner? Production Assembly Packaging Hours Required Electric Gas 0.20 0.40 0.30 0.50 0.10 0.10 Hours Available 10,000 15,000 5,000 Demand Make cost Buy cost 30000.00 15000.00 $55.00 $85.00 $67 $95