Question: Write the program in a word document please. Thanks! Questions 1. Pay Roll Calculator: Assume that you are a young entrepreneur selling Mobile phones There

Write the program in a word document please. Thanks! Questions 1.

Write the program in a word document please. Thanks!

Questions 1. Pay Roll Calculator: Assume that you are a young entrepreneur selling Mobile phones There are 3 workers in your company who is JunHao, EngYong, and PingYih. Their basic salaries are fixed as listed in the table below. Each of them has different basio salary as they have different working ages. You are required to apply your programming skills and write a VBA program to calculate sales person's monthly salary. The program should get number of mobile phones sold by a sales person in that month and calculate their incentives based on the given condition. You need to deduct EPF and SOCSO from the total salary of the employee. EPF is calculated as 11% of total salary and RM 9.75 for SoCSO Note: Use SWITCH CASE statement to identify basic salary of an employee when his name is given as input. Use IF statement to calculate total incentives. * Text Name JunHao EngYorn PingYih Basic Salary (RM) 1800 1500 1900 Amount -10 and-10 and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Individual Case Analysis Four cases are available from Harvard (see first : Case pack of 4 cases available at: http://cb.hbsp.harvard.edu/cbmp/access/49960103 ). Answer each of these questions in...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

Please help ASAP Inspiration I drive by many businesses and often see this sign posted on the building, "Beware of guard dog". This can certainly be a deterrent for any thieves. But think about the...

Please answer based on the reading provided only 1. Describe the key resources, capabilities, and competitive strengths and weaknesses of HTC. 2. Discuss the sustainability of HTCs competitive...

For the exclusive use of S. Setiawan, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

For the exclusive use of F. Ortolano, 2015. 9-910-036 REV: APRIL 11, 2011 BENJAMIN EDELMAN THOMAS R. EISENMANN Go oogle In nc. Go oogle's mission is to organize the world's inf n nformation and make...

Crossing Borders: MTC's Journey through Africa You have two choices as a human being: to be a subject of history or a maker of history. We have chosen to belong to the second category. Dr. Saad...

Processing steps for 18 questions are required. Thanks so much for help! Queensland University of Technology QUT Business School School of Accountancy AYB 219 Taxation Law HandiTax Group Project...

this assignment is regarding return the tax of a client by using handy taxassignment. can anyone help me to complete the income section of this assignment, just write the solution in a pdf file?I...

e eBook Collection Media & Culture Bedford/St. Martin's - ISBN 9781457628313 Bedford/St. Martin's - ISBN 9781457628313 CHAPTER 1 MASS COMMUNICATION___3 6 Culture and the Evolution of Mass...

The torque required to loosen a nut that holds a wheel on a car has a magnitude of 58 N m. What is the minimum force required to loosen the nut if the wrench used is 0.37 meters long.

The following data refer to Chavis Companys ending inventory: Item code Quantity Unit Cost Unit Market Small Shirts 45 $32 $38 Medium Shirts 60 46 44 Large Shirts 65 42 40 Extra-Large Shirts 35 54 53...

How does free trade create situations in which companies can pit the workers of one country against the workers of another?

In 40 years, when you retire, you dream about having $2,000,000 to travel around the world. You open an investment account that promises to pay 8% per year compounded monthly. How much money must you...

5-17 Allowing employees use their own smartphones for work will save the company money. Do you agree? Why or why not? Just about everyone who has a smartphone wants to be able to bring it to work and...

5-18 What are the distinguishing characteristics of cloud computing and what are the three types of cloud services?

5-15 What management, organization, and technology factors should be addressed when deciding whether to allow employees to use their personal smartphones for work? Just about everyone who has a...