User Account

All Pages

Calculate the 12-month subscription rate

Assignment Help Business Management
Reference no: EM132830803

SkyConnect is located at Kuching, Sarawak and this telecommunication provider was established on 1st January 2015. Siti Raisa Anandra is a newbie, working as a Sales Executive at the SkyConnect. Currently, her first task given is to key in the details regarding the newest internet plan provided to their potential customers.

1. Please key in all of the followings starting from cell A2. Use Currency format (with no decimal places) for cells containing RM (Ringgit Malaysia). 

Plan /Quota (GB) /Rates (monthly) /Rates (weekly)/ 12-month Subscription Rates/ Discounted Rates

Basic 50 RM80 RM22

Extra 80 RM98 RM26

Avant 100 RM108 RM29

Super 150 RM128 RM34

Premium 500 RM148 RM38

Gigas 10000 RM188 RM50

1. Calculate the 12-month Subscription Rate. 

2. Calculate the Discounted Rate. Discount rate is 15% for each plans based on 12-month Subscription Rates. 

3. Insert a new column after Discounted Rates and rename the column as Rates after Discount. 

4. Calculate the Rates after Discount amount by subtracting the 12-month Subscription Rates with Discounted Rates. 

5. Insert a new column after Rates after Discount column and rename the column as Free 1-month Subscription. 

6. Use IF function (YES or NO) to calculate the Free 1-month Subscription column. If the value of 12-month Subscription Rates is equal or more than RM1500, the result should be YES. If the value of 12-month Subscription Rates is below RM1500, the result should be NO. 

7. Use Conditional Formatting tool for Free 1-month Subscription column by changing the colour of the table containing YES to yellow.

8. In cell A10, make a new table (as shown below) and calculate the Highest, Lowest, and Average for each columns Quota (monthly), Rates (monthly), Rates (weekly), 12-month Subscription Rates, Discounted Rates, and Free 1-month Subscription.    

Reference no: EM132830803

Questions Cloud

About managing manufacturing floor : You have learned that operations management is not just about managing a manufacturing floor,
What are the types of leasing arrangements : What are the types of leasing arrangements and their pros and cons relating to depreciation expense
Describe marketing exchange relationship : Describe the marketing exchange relationship that exists between Southwest Airlines and its customers.
What the balance of investment in joint venture after sale : In 2014, PaulJoint Venture, Inc. reported a net income P2, 100,000. What the balance of investment in joint venture after the sale
Calculate the 12-month subscription rate : SkyConnect is located at Kuching, Sarawak and this telecommunication provider was established on 1st January 2015. Siti Raisa Anandra is a newbie, working as a
Provide the general journal entries recording the exchange : Provide the General Journal entries recording the exchange assuming Samsung paid $32,000 cash and the exchange has commercial substance.
What will you do to address the error : You are the unit supervisor of a medical-surgical unit. Jane is an RN on your unit. She graduated 3 years ago from nursing school and has made a number.
Prepare the required journal entries to record the note : During a recession many businesses borrow money. Prepare the required journal entries to record the note on November 1, 2018.
Creativity and strategic innovation management : Creativity and strategic innovation management: Directions for future value in changing times (2nd ed.). Routledge ISBN: 978-1138675100

Reviews

Write a Review

Business Management Questions & Answers

  Small gas station economic cost of dispensing

small gas station economic cost of dispensing gasolineowner-operator of small gas station rarely pay themselves an

  Group and individual incentive plans

Compare group and individual incentive plans by listing the pros and cons of each. For a supervisor position, would individual or group incentives be more appropriate?

  National procurement authority of afghanistan

Describe and analyze the structural dimensions and contingency factor of your organization.

  Leader in the workplace regardless of your position

In a 1-2 page essay, Describe how you will be a leader in the workplace regardless of your position. A robust essay will include explanation of topics discussed

  Illustrates the best practices of mckinseys situation

Identify a problem for which you can create a presentation that illustrates the best practices of McKinsey's situation-complication-resolution framework.

  Finding examples for mode

What examples can you find for mode?

  Develop or review an existing work plan

Choose a time period - week or month (or aligned to your current work cycle). Develop or review an existing work plan for your role detailing:

  Determining the communication dilemma

As an employee, you receive an email that was misdirected. The content of the email implies that the sender of the email is involved in criminal behavior.

  Make decisions based on data from other modules

Most businesses are made up of several departments. You may have HR, Finance, Material Management, Sales department, etc. ERP system usually

  List the forces from outside an organization

List the forces from outside an organization that act to bring about change within it.

  Essential functions of leadership

If you were asked to identify the 10 most essential functions of leadership, what would be on your list?

  Political and strategic system processes

Elaborate as to why it is essential that DNP-prepared leaders understand their organization political and strategic system processes.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd