decision support system
arosehn
ITIS361-ASS1-2022-2023-FS.docx
University of Bahrain
College of Information technology
Department of Information Systems
ITIS361: Decision Support System
Assignment one
Due date Saturday 12th Nov 2022
PART ONE
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 |
|
3400 |
|
2010 |
Q14 |
WEB BANNER |
2300 |
|
2011 |
Q15 |
WEB BANNER |
3100 |
|
2012 |
Q16 |
|
2700 |
|
2013 |
Q17 |
TV |
6400 |
|
2014 |
Q19 |
ROAD SHOW |
5000 |
|
2015 |
Q20 |
SM |
9300 |
|
2016 |
Q21 |
WOM |
8700 |
|
2017 |
Q22 |
SM |
8900 |
|
2018 |
Q24 |
|
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 |
|
|
ROAD SHOW |
|
2021 |
TV |
SM |
WOM |
SM |
|
2022 |
|
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:
|
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.
