Gobble Gobble smokehouse has 500 pounds of grade 1 ketchup and 1,000 pounds of grade 2 ketchup available. GG produces premium and regular BBQ sauces, which are produced by blending the two types of ketchup together along with other spices and seasonings. Each pound of grade 1 ketchup has a taste level of 10, and each pound of grade 2 ketchup has a taste level of 5. Premium BBQ sauces must have an average taste level of at least 8, whereas regular BBQ sauces must have an average taste level of at least 6. Premium sauces sell for $7 per pound while regular sauces sell for $5 per pound. a a Develop an optimization model that finds the combination of sauces to be produced and how much of each grade of ketchup will be used to produce the sauces, with the goal of maximizing revenue while meeting tasting constraints and staying within the availability of ketchup.

Assume that your group has been commissioned by a private tertiary education institution to produce a proposal to the board showing how Business Intelligence initiative can be beneficial to the business. Your group work is to discuss how data warehousing, data mining, OLAP, and visualization business intelligence tools could assist the executives/management team in their decision making. Write up a proposal describing your findings. Include discussions on benefits, disadvantages as well as diagrams in your report as you see appropriate. Your proposal should be in the form of a report, describing the background of the business (business scenario – which you will come up with), problem faced (from the context of business intelligence only), recommendation for a BI solution and a conceptual BI system overview (supported by architectural diagram and other necessary details). Screen mock-ups (dashboards or scorecards) to demonstrate the end users’ side will also be useful. You are not required to produce any working software. Screen mock-ups can be originated in any technology/software of your choice.

TASKS

• The business scenario (write your own)

• This business scenario should be the platform that will justify the choice/approaches for the questions

• The types of business questions that will require business intelligence initiative • Critical views on how BI can be beneficial to the management team from business perspectives

• Discuss the architecture and data warehouse model approach – include diagram and justify the choice of approach

• Discuss whether your team will recommend the organization to purchase tools from vendors or build the system itself. Justify your suggestion.

• Discuss and build the mock screen to demonstrate support for decision making for the users mentioned in the business scenario (images of dashboards/scorecards will be good)

• Discuss what are the possible implementation issues your team foresees to happen in the organization and how it can be addressed

• Discuss how web analytics and customer analytics aspect in data mining can be applicable for data in your assignment project.

Please, if you don’t know it, don’t do it. I will give a down vote if it is a nonsense solution. I need experienced professional to help do it. I will surely upvote for a good answer.