Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $$160,000.$ Processing costs and the material costs make up the variable cost per unit. Variable processing costs are estimated to be $$6$ per book. Variable material costs depend on the supplier that they get the materials from. The list of suppliers and their prices are provided in the worksheet titled "Problem $2".$ The publisher plans to sell singleuser access to the book for $$46.$

a$)$ Build a spreadsheet model to calculate the profit$/$loss for a given demand. The model should have an input cell for the supplier name and when the supplier name is typed or selected from a drop down menu, the material cost cell should populate with the correct material cost per unit amount. The template is provided for you. What profit can be anticipated with a demand of $3,500$ copies if Supplier C is used?

b$)$ Eastman Publishing Company wants to try various what$-$if scenarios using data tables. They want to see the profit amounts for different values of demand and revenue per unit $($selling price of each textbook$).$ Construct a two$-$way data table with demand as the column input, revenue per unit as the row input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value. Find the break$-$even intervals of demand for Supplier $C$ for each sales price value.

c$)$ Using conditional formatting colorize the negative and positive ranges and identify the largest value of profit in the table.

Can comeone help me do this in excel?