This assignment covers applications of Excel’s financial functions and data analysis tools. Solve each problem in its own worksheet and identify each sheet with the question number. Order the sheets sequentially in the workbook.

Create an Excel file. Use the following naming convention:

Your last name, the last four digits of your student number, section number, and then the text “Assign2”. Example: Smith1234L10Assign2.xlsx

1. The Tamiko Company brews four types of beer: Langley Ale, Surrey Stout, Richmond Malt and Delta Lager. Tamiko anticipates demand for Langley Ale to be 75 cases, 50 for Surrey Stout, 50 for Richmond Malt and 150 cases for Delta Lager in any given week. The company has five employees that can brew only specific products. What each employee can brew, and the time taken for an employee to brew a case of a beer type is displayed in the table below. Every week, Tamiko must supply 50 cases of Langley Ale to the pubs in the Langley area. The tables below display the contribution margin for each beer and the number of hours each employee can work during the week. The brewery does not brew part cases. Design a linear programming model using the simplex method that shows how Tamiko can maximize its weekly profit?