Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
QUESTION TWo (30 MARKS) The Financial officer at RGI wants you to develop an application that will evaluate the company's asset's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful ife). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DOB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the sum-of-the-years digit depreciation. The Financial.DD8 method syntax is Financial.DDB (cost, salvage, ife, period). The Financial.SYD method syntax is Financial.SYD (cost, salvage, ife, period). In both syntaxes, the cost, salvage and life arguments are the asset's cost, salvage value and useful life respectively. The period argument is the period for which you want the depreciation amount calculated. Both methods return the depreciation amount as double number. Code the application, save the solution and run the application Budle di Sede Figure 2: Interface for RGl annual asset depreciation App Page 15 of 21

QUESTION TWo (30 MARKS) The Financial officer at RGI wants you to develop an application that will evaluate the company's asset's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful ife). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DOB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the sum-of-the-years digit depreciation. The Financial.DD8 method syntax is Financial.DDB (cost, salvage, ife, period). The Financial.SYD method syntax is Financial.SYD (cost, salvage, ife, period). In both syntaxes, the cost, salvage and life arguments are the asset's cost, salvage value and useful life respectively. The period argument is the period for which you want the depreciation amount calculated. Both methods return the depreciation amount as double number. Code the application, save the solution and run the application Budle di Sede Figure 2: Interface for RGl annual asset depreciation App Page 15 of 21

Database System Concepts
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
See similar textbooks
icon
Related questions
Question

can you please help solve this

1.200.00 Adobe Reader Touch QUESTION TWO (30 MARKS) The Financial officer at RGI wants you to develop an application that will evaluate the company's assetť's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the sum-of-the-years' digit depreciation. The Financial.DDB method syntax is Financial.DDB (cost, salvage, life, period). The Financial.SYD method syntax is Financial.SYD (cost, salvage, life, period). In both syntaxes, the cost, salvage and life arguments are the asset's cost, salvage value and useful life respectively. The period argument is the period for which you want the depreciation amount calculated. Both methods return the depreciation amount as double number. Code the application, save the solution and run the application <> 2 RGIT annual asset depreciation App Asset cost 5000 Deprociation schedulos Salvage value: 100 Double declining balances: Sum of-the year's digits: Deprecialion 2 D00.00 Year Year Depreciaton 1,633.33 Uselul lile 720.00 432.00 653.33 259.20 26 67 Display depieciation schedules Exit Figure 2: Interface for RGI annual asset depreciation App Page 15 of 21 22:44 O Type here to search G ) ENG 2021/05/07
Transcribed Image Text:1.200.00 Adobe Reader Touch QUESTION TWO (30 MARKS) The Financial officer at RGI wants you to develop an application that will evaluate the company's assetť's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the sum-of-the-years' digit depreciation. The Financial.DDB method syntax is Financial.DDB (cost, salvage, life, period). The Financial.SYD method syntax is Financial.SYD (cost, salvage, life, period). In both syntaxes, the cost, salvage and life arguments are the asset's cost, salvage value and useful life respectively. The period argument is the period for which you want the depreciation amount calculated. Both methods return the depreciation amount as double number. Code the application, save the solution and run the application <> 2 RGIT annual asset depreciation App Asset cost 5000 Deprociation schedulos Salvage value: 100 Double declining balances: Sum of-the year's digits: Deprecialion 2 D00.00 Year Year Depreciaton 1,633.33 Uselul lile 720.00 432.00 653.33 259.20 26 67 Display depieciation schedules Exit Figure 2: Interface for RGI annual asset depreciation App Page 15 of 21 22:44 O Type here to search G ) ENG 2021/05/07
Adobe Reader Touch QUESTION THREE (30 MARKS) The sales manager at ITI Hub has asked you to design and implement a Windows application that will display the total sales made in there three regions in South Africa: Kwazulu-Natal, Gauteng and Western cape. The application should display the total sales of the company as well as the percentage that each region contributed to the total sales. Display the sales amounts with a Rand sign and no decimal places. Display the percentages with a percent symbol with no decimal places. The sales amounts for six months are shown in Figure 3. Create a windows application form for this project using the name ITI Hub regional sales. Store the sales amount in a two-dimensional array. Create a suitable interface with an image for the project and run the application. Month Kwazulu-Natal sales (R) Gauteng sales (R) Western cape sales (R) 1 120,000 90,000 65,000 190,000 85,000 64,000 175,000 80,000 71,000 4 188,000 83,000 67,000 125,000 87,000 65,000 163,000 80,000 64,000 <> Figure 3: ITI Hub sales amount TOTAL MARKS: 100 Page 16 of 21 22:45 O Type here to search G ) ENG 2021/05/07
Transcribed Image Text:Adobe Reader Touch QUESTION THREE (30 MARKS) The sales manager at ITI Hub has asked you to design and implement a Windows application that will display the total sales made in there three regions in South Africa: Kwazulu-Natal, Gauteng and Western cape. The application should display the total sales of the company as well as the percentage that each region contributed to the total sales. Display the sales amounts with a Rand sign and no decimal places. Display the percentages with a percent symbol with no decimal places. The sales amounts for six months are shown in Figure 3. Create a windows application form for this project using the name ITI Hub regional sales. Store the sales amount in a two-dimensional array. Create a suitable interface with an image for the project and run the application. Month Kwazulu-Natal sales (R) Gauteng sales (R) Western cape sales (R) 1 120,000 90,000 65,000 190,000 85,000 64,000 175,000 80,000 71,000 4 188,000 83,000 67,000 125,000 87,000 65,000 163,000 80,000 64,000 <> Figure 3: ITI Hub sales amount TOTAL MARKS: 100 Page 16 of 21 22:45 O Type here to search G ) ENG 2021/05/07
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Bare Bones Programming Language
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
SEE MORE TEXTBOOKS