QuestionQuestion

Write a program that calculates and displays in a MsgBox the bill for a cellular telephone company. The company offers two types of service. The rates are computed as follows:

Regular service: $10.00 plus first 60 minutes are free. Charges for over 60 minutes are $0.15 per minute.

Premium service: $20.00 plus:
a. For calls made from 6:00 am to 6:00 pm, the first 90 minutes are free: charges for over 90 minutes are $0.07 per minute.
b. For calls made from 6:00 pm to 6:00 am, the first 120 minutes are free: charges for over 120 minutes are $0.04 per minute.

Your program should prompt the user to enter an account number (text, you chose what it looks like) and a service code (allow both r or R for regular service and both p or P for premium service). Any other service code characters are errors and the user should correct or omit. In the MsgBox your program should display the account number, the type of service, the number of minutes the telephone service was used, and the amount due from the user.

For the premium service, the customer may be using the service during the day and the night. Therefore, to calculate the bill, you must ask the user to input the number of minutes the service was used during the day and the number of minutes the service was used during the night. Do this only for premium customers.

Use a Do While to allow the user to continue entering data for additional customers or quit the program.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsm.

    $30.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Visual Basic Programming Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats