PLEASE SHOW STEP BY STEP ON EXCEL WITH FORMULAS, THANK YOU

You have a nice place in a rural setting with a little kitchen and a few cows out in the back. You figure you can make $4 profit per cake (C) that you can bake or $3 profit per dozen cookies (D) you make. The main constraints for you are that you can only use the oven in the kitchen nine hours per day (and the oven will only fit one cake or one dozen cookies at one time), and you can only have 10 pounds of butter per day. Each cake takes 45 minutes to bake and requires one half pound of butter. A dozen cookies require 30 minutes in the oven and one pound of butter. You will want to use Excel for this question. Your objective is to maximize profit from cakes and dozens of cookies per day. A Formulate this problem in Excel, solve the problem using the SOLVER tool, generate an Answer Report and Sensitivity Report for the problem, and submit an Excel file as part of your answer. B From your answer report what is the original value of profit and the final value of profit? C From your answer report what are the original values and the final values for cakes and cookies? D From your sensitivity report what is the range of optimality on the cake coefficient and what does this range mean (give numbers from the report)? E From your sensitivity report what is the range of feasibility on the butter constraint and what does this range mean in the context of the shadow price (give numbers from the report)?