4. You are given the attached process (Excel file) and asked to:

a. Figure out how much to sell the product for (using your company’s 40% minimum profit margin on sales rate). Show all your work (you may do this in Excel if it’s easier for you).

b. Suggest some possible process improvements which could increase the profit to 50% or higher…..can you suggest some ideas to achieve this? You can increase up to 4 yields by 10%. Show all your work (you may do this in Excel if it’s easier for you).