Beach Style is a manufacturer of outdoor furniture. The firm\'s product line includes four side tables designs:

Production:

Cement $

Polystone $

TravertineLook $

Travertine $

Total CM

Prepare a page memo which:

Discusses the key features of the results of a linear programming analysis using Excel Solver that identifies the optimal sales mix which maximises the total contribution margin.

Suggests and discusses two possible ways in which the firm could improve the contribution margin in light of your original Solver analysis. Provide financial information to support your recommendations and clearly illustrate how your proposals impact the sales mix and the firm\'s contribution margin. Relevant tables chartsfigures to illustrate the comparative results under each of your options must be provided.