You and your college roommates open a business designing and crafting dog and cat leashes with your college logo and colors. You have decided to offer leashes in three lengths: 6, 8, and 12 feet. Further, you have two types of leash: "standard" or "decorative." While the decorative leashes take longer to create, they have a large profit margin per each. However, the standard leashes are in higher demand. You and your two roommates have put a schedule together so that you can fit everything into your week - this includes classes, social events, and crafting time. Since you are enrolled in the data analytics in accounting course, you have volunteered to calculate how many of each type of leash you should produce weekly based on demand, gross profit for each product, and the constraint of work hours. Upload your completed Excel file and the answer to the below question in Word when complete. Perform a linear optimization using Excel Solver. Click here to view the Excel. 1. How many of each unit should you and your two roommates produce each week? 2. What is the total gross profit you should expect to earn based on the weekly production of dog leashes? T Upload files Supported file formats: Excel, Word 0/2 File Limit