Project on Selling Malibu

Malibu Mix

Different from the Part I, there are five sheets in total ,which are named “One-day-Optimisation”, “Main sheet”, “Data Set”, “Data for optimisation” and “Stored Information” respectively.

In the first sheet, clients can click on the “Click to generate temperature” to get a temperature number in relative cell, then click “Click for Optimization” button to compute the one day optimized results including revenue, profit and decision made and more detailed data. If client want to play once more, just click ”Clean the data” button to clear previous data, then operate the previous two buttons again. In the second sheet, which is the main sheet, clients can enter the data for Price, Malibu per jug, Ice cubes per cup, which are in blue, and click on cell that is in C4, click “Click to generate one temperature” to obtain value in cell(C4), then click ”Strict(automatic) computation based on Input variable” to generate rest of results that are needed. If clients want more flexible decision making, they can firstly put data into Price, Malibu per jug , and Ice cubes per cup, then click “Total Demand” to get the result that is stored in cell(C9). After it, they can put data they want into cells of “Quantity bought”, then click ”Test whether input variables is satisfied” to examine if the input data is available. If it can meet the budget, click on “Balance and Sale, Profit” button to get the rest of results that are needed. For ten days optimization, clients can click ”Clear all data”, then click ”Click to generate ten days’ temperature”, then click ”Click for ten days optimisation” to get all the results. After client try different input data to get the result for the first day, they can click ”store the information”, then click “Go to “Stored Information””, then choose cell in row cells of “temperature”, and click “store Information” to input data recorded in that column. Click “Clear all data” if clients tend to delete them.

This model is established to let...