Task 1 Essay
Write an essay on any of the below topics. Word limit is 1200 words excluding references.
Vulnerabilities of IT systems. Use a case study based on any recent event to support your findings.
Task 2
A Company has 3 profitable retail brands in India (Jeramai, Marzudo and Xandreial). Post covid the company wants to study the following:
- ProfitabilityAnalysis
o Apart from expenses mentioned in the master sheet store wise, company has Cost of Good sold as 24.5%, Taxes of 8.22% of MRP and corporate overheads of 7.12% ofMRP.
o Give a graphical representation on the company’s profitability month wise and regionwise.
o Advice the company on which stores to continue and which stores to shut down basis the profitability, sales trends and costsinvolved.
- Covidanalysis
o Post Covid hitting the country, the company estimates a 15% rise in sales of brand Jeramai while a Monthly drop of 50%, 42%, 21%, 11% and 2% respectively in the months of Mar, Apr, May, Jun, Jul respectively from the existing 6 months avgsales.
o Give a graphical representation of projected sales based on the above information.
o Advice the company on which stores it should retain and which stores it should shut down basis the store wise profitabilityanalysis.
Use the Master Sheet and other excel sheet provided to work out the above, you must combine data from all excel sheets in one to display results.
</pclass=”msobodytext”>
