Your presentation $($and report$)$ should include:

Introduction: Briefly describe the background of your business organization: its procedures, activities and operations $-$ how it gathers, processes and uses input data and$/$or information to make daily$/$weekly$/$monthly$/$yearly business operations and decisions etc. Draw a data flow diagram showing how data and information moves or flows around basic operations in your business organizations.

Aims of your study $-$ describe the nature of your organization's DSS problem e$.$g$.$ maximizing the net income by increasing the production of profitable goods or minimizing the operational cost by cutting staff. Describe why and how this problem occurred $($global economic downturn due to the shortage of oil, or seasonal change$/$demand due to extreme hot weather, increased competition$),$ and what strategies $($e$.$g$.$ reduce rental expenses, increase sales by doing more advertising, cut labour cost or reduce number of staff etc.$)$ is used to solve this problem.

Build and demonstrate your decision support system using MS Excel and MS Excel's Solver. Descriptions of the optimization problem:

i$.$ Changing cells $($the factors you could change in order to$,$ say, maximize the profit$)$

ii$.$ What data you would input in the process $($e$.$g$.$ materials; manpower; money$).$ List and explain any facts and constants e$.$g$.$ tax rate.

iii. What data you would produce as target output $($e$.$g$.$ cash flow, net income$)$

iv$.$ Prepare an income statement in your spreadsheet. Explain any assumptions converting from the production into sales.

v$.$ Calculate all costs $($explain the formulae and constants involved$).$ List and explain all the formulas$/$calculations for any intermediate and final results.

vi$.$ Calculate the revenue $($explain the formulae and constants involved$).$ List and explain all the formulas$/$calculations for any intermediate and final results.

vii. Derive the net income

Prepare and explain $2$ strategies $($or $2$ sets of constraints$)$ and the rationale behind. See Tutorial D $($or case $18),$ which has $2$ sets of constraints. You must have at least $5$ constraints in each strategy$\_($or set of constraints$).$

A set of constraints is actually based on the business rules$/$conditions$/$limits imposed by your organization or economic factors imposed by external forces. You need to explain what your economic factors and business rules$/$conditions$/$limits are, and the constraints must be realistic enough to reflect the normal running operational procedures. You can use any accounting.principles, economic, management theories etc. you learnt from other subjects to formalize and$/$or explain your set of constraints. Explanation is required for each strategy$\_($or set of constraints$).$

The constraints within each set must not conflict with each other otherwise no solution will be found $-$ Microsoft Excel's Solver will inform you this when you run Excel's solver.

Each constraint may be set$/$based on the following:

input due to limited resources,

product mix, and

ratios,

other $($interesting$)$ constraints you could figure out from accounting.principles, economic theories.