Decision Support System
AZOON Mart is one of the competitive super markets in the region. The company has a high market share and strong competitive position. They are adopting IT for taking decision and predicting the future. The company focuses mostly on the grocery and electronics productions.
The following are some of the historical data of the company:
Demand of years before 2011
Years Electronics Grocery
2005 260 1000
2006 230 1230
2007 210 1020
2008 240 1300
2009 199 1099
2010 230 1400
Demand of years after 2010 (Trend) T1= 20
Years Electronics Grocery
2011 200 1000
2012 230 1230
2013 300 1020
2014 320 1300
2015 350 1240
2016 365 1400
2017 370 1540
2018 385 1230
2019 230 1700
2020 120 1650
2021 100 1680
2022 240 1700
Cost of advertisement
Type of media Adv cost/unit
TV $3.50
Road Show $5.30
Web Banner $1.45
Social media $1.00
print adv $6.70
WOM $0.97
Relationship between demand and advertisement media
type of media GEOCERY ELECTRONICS
TV 3000 500
Road Show 2010 340
Web Banner 1340 250
Social media 4000 600
print adv 1500 290
WOM 3200 510
1.1: Use the above information and answer the following questions:
1- What is the demand of Electronic and Grocery for the year 2023.
2- How much it will cost the company for the advertisement of the demand on year 2023 (Elections and Grocery)
1.2: The previous years historical data revealed that there is a linear relationship between quarters, advertisement media and demand(regardless of the electronic or grocery) for the years from 1998 to 2019 as shown in the below table:
Year Quarter Advertisement Media Demand
1998 Q1 TV 6000
1999 Q2 TV 6500
2000 Q3 ROAD SHOW 4500
2001 Q4 TV 7300
2002 Q5 SM 8000
2003 Q6 WOM 7600
2004 Q7 WOM 7600
2005 Q8 SM 9400
2006 Q9 TV 5600
2007 Q10 TV 6100
2008 Q11 ROAD SHOW 4100
2009 Q12 PRINT 3400
2010 Q14 WEB BANNER 2300
2011 Q15 WEB BANNER 3100
2012 Q16 PRINT 2700
2013 Q17 TV 6400
2014 Q19 ROAD SHOW 5000
2015 Q20 SM 9300
2016 Q21 WOM 8700
2017 Q22 SM 8900
2018 Q24 PRINT 2800
2019 Q25 TV 7200
If the company will use the following advertisement media in the year 2020, 2021, 2022, and 2023, how much demand they will get? And how much it will cost them to get such demand?
Q1 Q2 Q3 Q4
2020 TV PRINT PRINT ROAD SHOW
2021 TV SM WOM SM
2022 PRINT ROAD SHOW SM TV
2023 SM WEB BANNER WOM WOM
PART TWO
The Funny-Stay Home (FSH) is an Instagram business. It has been lunched just on February 2020 as a result of the COVID 19 crisis. Mona, the owner of the business needs your help and consultation to take a decision either to continue on her business or withdraw. The following are some information have been collected based on the previous two months’ activities:
Game PRICE PRODUCTION COST Destination DEMAND/MONTH
SNAKES AND LADDERS 6 3 ISA TOWN 20
LUDO 10 4 MANAMA 12
MONOPOLY 8 4 ISA TOWN 5
CHEES 25 10 HAMAD ROWN 6
UNO 11 4 MANAMA 10
SCRABBLE 12 5 HAMAD ROWN 17
DELIVERY
AREA COST(BD)
MANAMA 2
ISA TOWN 3
HAMAD ROWN 5
Fixed cost 100
The monthly fixed cost includes the electricity, internet and the store rents are estimated to be BD 100.
Use the above information to:
1- Calculate the monthly profit of the company?
2- Based on their revenue, on which product the company should focus
3- Based on their revenue, on which area demand the company should focus
4- How much demand for all product they should get in order to reach a profit of BD1300 with the following restriction on production
Game Max production
SNAKES AND LADDERS 25
LUDO 15
MONOPOLY 10
CHEES 10
UNO 20
SCRABBLE 25
5- The company decided to sell the product to the three destinations, how much they should sell to get a revenue of BD2000. Note that the company can’t sell more then 50 units in each destination
6- How much they can sell from each product in each destination to achieve a profit of BD2000. The revenue generated from Hamad Town should not exceed BD1000.
Sample Solution
hazardous and have shaped with the point of unlawfully scouring sand from sea shores and streams around midnight. The Indian sand mafia is presumably the most famous. It is assessed that unlawful sand mining in India is worth about $2.3billion. As well as this cash not being accounted for and accordingly not burdened by the public authority, the sand mafias bring other adverse consequences like the maltreatment of common liberties. An illustration of a denial of basic freedoms from the Indian sand mafia was in 2004 they gone after and manhandled Sumaira Abdulali, a passerby who had seen her nearby ocean side contracting and chose to take a stand in opposition to it. This was not the first or last illustration of savagery from this mafia and the it is likewise purportedly answerable for passings. Sand mines' impact on the biological systems and especially marine life influence the vocations of anglers who depend on a steady and feasible environment for them to proceed with their positions. Notwithstanding, the environment disturbance made sense of later on in the exposition frequently prompts the deficiency of livelihoods for nearby anglers. So despite the fact that a sand mine can frequently make occupations in region it can likewise cause the deficiency of others.
Political
Governmental issues can likewise be impacted by this worldwide issue. Singapore have been accumulating sand anyway is approaching the finish of its stores. Singapore was dependent on Indonesia for sand to develop and grow anyway in 2004 Indonesia forced a boycott which made it against the law to send out sand to Singapore. The purposes for this were doubtlessly politically determined as the connection between these nations had separated. The boycott has truly intended that for Singapore bringing in sand is presently multiple times more costly than it was before the Indonesian boycott. This could negatively affect its financial advancement later on. The exchanging of sand overall is questionable, many individuals are persuaded that Indonesia are as yet trading to sand to Singapore. Besides, "information showed that Singapore revealed 73.6 million tons in sand imports from Cambodia beginning around 2007. However the Cambodian government detailed that main 2.7 million tons left for Singapore." This is characteristic of the defilement which is inserted at the center of this sand creation and utilization.
Natural
The climate likewise endures because of the sand mining. Marine sand mines are just expanding and these are having huge results on the marine life in the encompassing region. The sand is mined from the benthic zone and this digging obliterates living spaces for oceanic organic entities and modifies the biodiversity of an area, Desperez et al. guarantee that sand mining generally causes a total deficit in faunal biomass in the encompassing environment. The review embraced by Boyd et al. loans confidence to this point and adds that it in the drawn out the environment must be reestablished to its unique state assuming the first dregs sythesis is