Question: This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3.

This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3. A B C D E F 123 2 AllTech Group 3 Forecasted Global Revenue Dashboard for 2021 4 Country Q1 Q2 Q3 Q4 56 5 Canada 15000 16000 18000 17000 6 Singapore 20000 23000 22000 21000 7 Pakistan 25000 21000 22000 21000 8 Nigeria 10000 9000 11000 8000 9 UAE 27000 26000 28000 27000 10 Spain 19000 22000 21000 22000 11 Germany 26000 28000 30000 29000 Question 1: Answer the following questions: a) Which are the top 3 countries in terms of projected annual revenue (state them in descending order of amount. b) Which quarter is projected to bring in the most revenue? Question 2 a) Produce an appropriate fully labelled chart to reflect the quarterly totals for each region. b) Use a suitable and fully labelled chart to reflect the contribution of each region to the overall project annual revenue. Question 3 Imagine a scenario where you are the CEO of the AllTech group. What information could you gather from calculating the mean, median, mode, and range of each region? Discuss the importance of each measure of central tendency separately (max. 300 words).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Does a multicasting router need to know how many subscribers are on a network that it connects to for a multicast group? Explain

answer all questions as instructed below. attend all questions. 4 Computer Vision (a) Explain why such a tiny number of 2D Gabor wavelets as shown in this sequence are so efficient at representing...

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

TASK TWO - SUMMATIVE This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3. A B C D E F 1 2 AllTech Group 3 Forecasted...

TASK TWO-SUMMATIVE This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3. B D E F 1 2 3 4 5 6 AllTech Group Forecasted...

Excel Analytics 09-01 (Static) Flexible Budget Performance Analysis [LO9-2, LO9-3, LO9-5, LO9-6] Skip to question To complete this activity, you will need to have Excel installed on your computer....

\ACCT 311 Intermediate Accounting I Long-Term Liability Excel Assignment Instructions: For each of the scenarios below you will be expected to prepare an amortization schedule in Excel, and answer...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Selected year-end financial statements of Cadet Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2008, were inventory, $56,900; total assets, $219,400;...

Required Identify each of the following events as an accrual, deferral, or neither: a. Incurred other operating expenses on account. b. Recorded expense for salaries owed to employees at the end of...

3. Criticize the following arguments in light of the material presented in this section: A quality-control inspector for a food-processing fi rm needed assurance that the cans of fruit in a...

Analyze the buyer decision process of a traditional Porsche customer. Porsche (pronounced Porsh-uh) is a unique company. It has always been a niche brand that makes cars for a small and distinctive...

Contrast the traditional Porsche customer decision process to the decision process for a Cayenne or a Panamera customer. Porsche (pronounced Porsh-uh) is a unique company. It has always been a niche...

Which concepts from the chapter explain why Porsche sold so many lower-priced models in the 1970s and 1980s? Porsche (pronounced Porsh-uh) is a unique company. It has always been a niche brand that...

Explain how both positive and negative attitudes toward a brand like Porsche develop. How might Porsche change consumer attitudes toward the brand? Porsche (pronounced Porsh-uh) is a unique company....

What role does the Porsche brand play in the self-concept of its buyers? Porsche (pronounced Porsh-uh) is a unique company. It has always been a niche brand that makes cars for a small and...

( systems ) enable management to make better decisions regarding obtaining raw materials and communicating with vendors. CRM ESS SCM MIS

Discuss some of the disadvantages of U.S. companies using Chinese suppliers that might drive them to near-shore their supply chains.

Professor Cook teaches operations management at State University. She is scheduled to give her class of 35 students a final exam on the last day of exam week, and she is leaving town the same day....

Discuss the types of decisions that are involved in creating a process strategy. Apply the four elements of process strategy to the process of completing a project or paper for one of your classes....

Drawing from your experiences and preferences, would perks and fringe benefits similar to those that Clif Bar offer be an effective motivator for you? Would the companys development and job...

The Ohio State University and University of Michigan two-dimensional leadership styles identified in the 1940s havent changed much over the years, as they are still being taught and used today....

Do you agree with Demings statement that U.S. companies need to change to a group approach to compete in a global economy?