Tuesday 26 January 2016

ADVANCED EXCEL LAB @ HOME 1

NOTE:ALL THE ANSWERS ARE IN ZIP FORMAT.

            CLICK AT THE BELOW LINK TO DOWNLOAD ANSWER AS ZIP.


1.

Fit-n-Fine Health Club, a recreational club in New York, provides a quality gymnasium and health related
services to its members. In addition, the club provides the various premium services, such
as the sauna and steam baths, the yoga classes, the aerobic classes, and the swimming pool
facilities, to its members. The club is managed by well-qualified instructors and coaches. All these
factors have helped the club to increase the number of registered members.

The Customer Relations (CR) department of the club serves as a liaison between the club and its
members. The main responsibilities of this department are to provide the details of the various
features of the club to the existing and prospective members, perform the registration process for
the new members, and monitor the members' feedback on the facilities and services of the club.

Currently, the club maintains the data related to the club, such as the details of the staff members,
club members, and plans offered to the club members, in text files and databases.
The club decides to expand its business in the US. For this, it decides to open various clubs in
different cities in the US. Therefore, the owner of the club conducts a meeting with the
management to:

Identify the cities in which the new clubs will be opened.
Establish the various endorsement strategies for promotion of the club.
Identify new investors.
Establish the various discount policies in the current plan types.
Identify the facilities and equipment to be provided in these clubs.


On the basis of the preceding case study, you need to accomplish the following tasks:

Extract the strategic and operational information.
Name the various sources from which the club needs to collect data.
Name at least four types of report formats that the club needs to use for creating the reports.


Explain any one report format in detail.

The Managers need to monitor the marketing activities to compare the current status with the
planned target. Name the type of report they should create. Explain the report type in detail.
The management needs to analyze the past data for performing the various analyses. Name
the tools that can be used. Explain all the tools in brief.



ANS:


CLICK HERE


2.


Britza, the Italian coffee giant, has ruled the retail coffee shop market in Europe. Britza currently
has 260 coffee shops in Italy, UK, Sweden, Denmark, and Norway. The past five years' balance
sheets of Britza show a constant growth in its financial status. Britza has captured 68% of the retail
coffee shop market in Europe. Now, Britza wants to expand its business by opening coffee shops
in various Asian countries. For this, the company is looking for partners to form a franchise.
Creating a market base in Asian countries is an easy task for the management. Therefore, the
management decides to organize a board meeting with the corporate, strategic, and business
management groups to:
Identify the right locations for opening the retail shops in each country.
Establish the distributor network channel for shipping raw materials and merchandise to each
country.
Establish the marketing and advertising strategies for each country.
Identify the strategies, such as store layout, recruitment, and price set up, for their products.
To take the important business decisions, Britza needs to analyze the vast amount of data.
Currently, it uses Microsoft SQL Server and Notepad to store the data related to the business
transactions and related business entities. However, for the analysis purpose, Britza needs to use
an information analysis tool. On the basis of the preceding case study, you need to accomplish the
following tasks:
Extract the strategic, operational, and statistical information.
Name the various sources from which Britza needs to collect data.
Identify if there is a need to refine the data collected from these sources. If yes, justify with a
reason.
Name at least two types of reports that Britza needs to create. Explain any one report type in
detail.
The management needs to use an inexpensive automated tool for making the business
decisions through information analysis. Name the tool that should be used.

ANS:

CLICK HERE

No comments:

Post a Comment