Closed Thread
Results 1 to 2 of 2

Can anyone help me how to do this question?

  1. #1
    Registered User
    Join Date
    01-21-2019
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    2

    Question Can anyone help me how to do this question?

    4. Postal Bill Calculator: Assume that you are working as the cashier in the poslaju office in Kedah. There are 3 types of charges summing up to be the total payment of customer goods' postal fee. Administration fee for each postal is RM2. Another charge will be distance charge which stands for RM0.02/KM. Third charge is customer postal weight’s charge which consists of the following:

    Weight Price (RM)
    <0.5 kg 3
    <3 kg 10
    <10 kg 20

    Assuming your office are sending to only 3 destinations which is Johor (762KM), KL(423KM), and Penang(52KM). Create a VBA program to automate final postage fee calculation. Your program should request for weight and destination of your customer postal weight and display the final amount that your customer need to pay.
    NOTE: 6% GST is charged on the final amount.

    a) Determine the inputs, processing and output for this program.
    b) Draw a flowchart illustrating the program design to solve this problem.
    c) Write visual basic program, execute the program with sample inputs and show the outputs.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,061

    Re: Can anyone help me how to do this question?

    1. Do not duplicate threads.

    2. re-read the six words that make up Rule 1 (that you just agreed to stick to) and amend your thread title.

    3. Is this homework or other coursework? What efforts have YOU made to help YOURSELF? If none, then I will not help you cheat yourself out of your own education.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Mathematical question or excel question? Multiple several numbers in a row.
    By douglascaixeta in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-22-2015, 05:48 PM
  2. [SOLVED] Objective Question: High light the right answer with green before next question.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2015, 12:38 PM
  3. database question, excel data sorting question
    By weblisterltd.com in forum Excel General
    Replies: 1
    Last Post: 12-17-2014, 01:35 PM
  4. code to progressively go throughly question based on answer to first question
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2014, 06:48 AM
  5. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  6. Replies: 3
    Last Post: 06-17-2011, 08:09 AM
  7. Two question, numeric code question and subtraction of two columns?
    By mgsweden78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2008, 02:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1