read the article “boost profits with excel,” by james a. weisel in

 Read the article “Boost Profits With Excel,” by James A. Weisel in the December 2003 issue of the Journal of Accountancy (available online at the AICPA’s website, www.aicpa.org).

Download the sample spreadsheet discussed in the article.

quistion 1 is on file

question 2

Revert your data (Remove the labor hours and dollars assumption made in #1).
Rerun the Solver program to determine the effect of the following action on income:

question 3 

Double market share limitations for all three products

-Rerun the Solver program to determine the effect of the following action on income:

-Double market share limitations for all three products plus the following constraint:

• -Sauce case sales cannot exceed 50% of the sum of soup and casserole case sales