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

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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