Identify and explain the benefits of the ict megatrends

Assignment Help Other Subject

Reference no: EM132546110

Task 1 Essay
Write an essay on any ONE of the below topics. Word limit is 1200 words excluding references.

Option 1
Vulnerabilities of IT systems. Use a case study based on any recent event to support your findings.

Option 2
Identify and explain the benefits of the ICT megatrends being implemented by any company of your choice from the list of fortune 500 companies

Task 2 Excel
This is a continuation of the previous assessment. Use the same data provided earlier.
A Company has 3 profitable retail brands in India (Jeramai, Marzudo and Xandreial). Post covid the company wants to study the following:

• Profitability Analysis
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.
• Covid analysis
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.

Reference no: EM132546110

Questions Cloud

Explain the five stages of process development : Figure 9.1 shows five stages of process development. Can you explain the five and how they can apply to your daily life? Additionally, there is a dotted line.

What would the annual yield to maturity be on the bond : What would the annual yield to maturity be on the bond if you purchased the bond today and held it until maturity round

Communication methods within organizational structure : What is the importance of these communication methods within the organizational structure?

Find what would the annual yield to maturity be on the bond : Find What would the annual yield to maturity be on the bond if you purchased the bond today? Round the answer to two decimal places in percentage form.

Identify and explain the benefits of the ict megatrends : Identify and explain the benefits of the ICT megatrends being implemented by any company of your choice from the list of fortune 500 companies

What is? anle equity cost of? capital : How much of? Anle's equity cost of capital is expected to be satisfied by dividend yield and how much by capital? gain?

What is country cupboards final cost of the inventory : What is Country Cupboards final cost of the inventory that it kept. Country cupboard purchased inventory for $4,300 and also paid a $260 freight bill.

Information systems management : Select one of the following businesses: a large bank, a government agency, or a hospital, and explain which systems you feel are mission-critical.

What is the marginal cost of capital : If the after tax cost of debt will rise from 7% to 8%, what is the marginal cost of capital?

User Account

All Pages