41. Write a program that, given a beginning balance in your savings accou calculates the balance at the end of 1 year. The interest is 5.3% c pounded quarterly. Show the interest earned and balance at the end d each quarter. Present the data in tabular columns with appropriate ha ings. Use separate functions to compute the interest and print the balan

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

code for number 41 problem

Projects
40. Prepare a payroll earnings statement for the sales force at the Arctic Ice
Company. All of Arctic's employees are on a straight commission basis of
12.5% of sales. Each month, they also receive a bonus that varies
depending on the profit for the month and their length of service. The
sales manager calculates the bonus separately and enters it with the
salesperson's total sales for the month. Your program is also to calculate
the withholding taxes and retirement for the month based on the follow
ing rates:
a. 25% Federal withholding
b. 10% State withholding
c.
8% Retirement plan
Use the test data in Table 4-2 to test the program.
Salesperson
Sales
Bonus
1
53,500
425
2
41,300
300
3
56,800
350
4
36,200
175
TABLE 4-2 Test Data for Project 40
41. Write a program that, given a beginning balance in your savings accout
calculates the balance at the end of 1 year. The interest is 5.3% con
pounded quarterly. Show the interest earned and balance at the end
each quarter. Present the data in tabular columns with appropriate hai
ings. Use separate functions to compute the interest and print the balan
Transcribed Image Text:Projects 40. Prepare a payroll earnings statement for the sales force at the Arctic Ice Company. All of Arctic's employees are on a straight commission basis of 12.5% of sales. Each month, they also receive a bonus that varies depending on the profit for the month and their length of service. The sales manager calculates the bonus separately and enters it with the salesperson's total sales for the month. Your program is also to calculate the withholding taxes and retirement for the month based on the follow ing rates: a. 25% Federal withholding b. 10% State withholding c. 8% Retirement plan Use the test data in Table 4-2 to test the program. Salesperson Sales Bonus 1 53,500 425 2 41,300 300 3 56,800 350 4 36,200 175 TABLE 4-2 Test Data for Project 40 41. Write a program that, given a beginning balance in your savings accout calculates the balance at the end of 1 year. The interest is 5.3% con pounded quarterly. Show the interest earned and balance at the end each quarter. Present the data in tabular columns with appropriate hai ings. Use separate functions to compute the interest and print the balan
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Datatypes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education