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 enrolied in the data analytics in account ing course, you have volunteered to calculate how many of each type of leash you should produce weckly 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 whencomplete. Perform a finear optimization using Excel Solver. Click here tovicus the Excel. $1.$ How many of each unit should you and your two roommates produce each weck? $2.$ What is the total gross profit you should expect to earn based on the weekly production of dog leashes?