Case-social local global mobile company

Assignment Help Business Management
Reference no: EM132924702

The Social Local Global Mobile Company

SLG Mobile offers five plans for cellular phone service. Plan A has a base cost of $9.99 per month and each minute costs $0.40. The cost for Plan B is $19.99 per month with the first 100 minutes free and a charge of $0.30 for each additional minute in excess of 100. The cost for Plan C is $39.99 per month with the first 250 minutes free and a charge of $0.20 for each additional minute. The cost of Plan D is $79.99 per month with the first 1,000 minutes free and a charge of $0.10 for each additional minute. Plan E costs $159.99 per month with unlimited calling.

Make a worksheet for a SLG Mobile employee to calculate a customer's monthly bill based on two inputs:

(1) the customer's contracted cellular plan (A-E) and

(2) the number of minutes used by the customer during that particular month.

Model results should update based on changes to the two input cells.

Reference no: EM132924702

Questions Cloud

Writing qualitative research questions : Select the three factors that you think may be the most important considerations when writing qualitative research questions. Justify your choice.
Pulling ahead of the competition : Starting a new business can be both rewarding and intense. As a new business owner, how can you establish yourself in the marketplace while pulling ahead of the
Discuss shoprite competitive advantages position : Discuss Shoprite's competitive advantages position regarding the other four aspects of Porter's Five Forces Model?
What methods and sources should they use : What is the performance problem and is it important? Who are the stakeholders? What information would you collect by doing an organizational
Case-social local global mobile company : SLG Mobile offers five plans for cellular phone service. Plan A has a base cost of $9.99 per month and each minute costs $0.40. The cost for Plan B is $19.99 pe
Draw an activity diagram showing the customer : Misha's Supermarket, a small chain of grocery stores, is building a website to allow customers to place orders for groceries and other items they sell. The cust
What is the best way to learn business fundamentals : What is the best way to learn business fundamentals? Can you please tell me any keywords that i should search up in course hero for resources that could provide
Percent of the distribution : A new extended-life light bulb has an average service life of 700 hours, with a standard deviation of 100 hours. If the service life of these light bulbs approx
Calculate the cash payments to suppliers during the year : Calculate the cash receipts from customers during the year and Calculate the cash payments to suppliers during the year

Reviews

Write a Review

Business Management Questions & Answers

  Health care approach patient confidentiality

Explain how HIPPA affects the way workers in health care approach patient confidentiality.

  How can a hospitality manager monitor team

How can a hospitality manager monitor team and individual performance against agreed goals and objectives? Please provide at least 2 methods.

  Mild sensibility and intense equality

What does it mean to have a Mild Sensibility and Intense Equality result as primary values from ELI?

  Organization production function

How your organization's production function is related to its marginal product of labor.1st Bullet How your organization's marginal product of labor is related to the value of its marginal product.2nd Bullet How your organization's marginal product i..

  Explain costs and benefits of secularization

Explain costs and benefits of secularization, with some emphasis on sub-prime loans.

  Vaccine distribution and safetyhow does vaccine

vaccine distribution and safetyhow does vaccine distribution relate to key operations and supply chain management

  When technology leads to unemployment

Should companies be responsible for unemployment caused by their information systems? Why or why not?

  Tak about homeland security from a history perspective

List the types of crime and other hazards that threaten the operation, and design measures to prevent the threats from materializing.

  What is meant by the culture of a society

What is meant by the culture of a society, and why is it important that international managers understand it? Describe the four dimensions of culture proposed by Hofstede.

  Mintzburg basic parts of the organization

Explain how Mintzburg basic parts of the organization fit together to perform needed functions. If an organization have to give up one of these five parts, such as during to a severe downsizing, which one could it survive the longest without?

  Recommendations for organisation future strategic

Your client "Telstra Corporation (Telecommunication services)" is recalibrating its strategy and hired you, as an expert in strategic planning and management

  How do they assist in keeping coca-cola strategies

How would you describe Coca-Cola's control systems (budgets, inventory control, annual objectives, functional strategies, policies and procedures

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!

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