Computer Applications In Management
Question
Computer Applications in Management
Tutorial worksheet
Attempt all questions
1. You are a business owner and you want to recapitalize your business. The best option you have is to borrow a 1,500,000 AED loan from the bank with an annual interest of 10 %. The loan is compounded quarterly for a period of 5 years. Set up a loan amortization table.
2. After getting a loan from the bank, you decide to start a shirt printing business. You make some assumptions so that you can project on your profits. You assume that each shirt will cost 30 AED to print and 5 AED to distribute. You would need 15,000 AED for marketing, 20,000 AED on salaries and 10,000 AED overhead estimates. You are planning to sell each shirt for 60 AED and to produce 2000 shirts. Make a projections table and a data table. Give an estimate of the number of shirts you need to print in order to reach the breakeven point.
3. You are planning to ship your shirts using rail, ship or road. Come up with an order worksheet given the following information.
| Order number | Cust ID | Shipping | Quantity | Unit price | Total price | Unit shipping | Total shipping | Shipping discount | Grand Total |
| 1 | AA | Rail | 250 | ||||||
| 2 | AB | Rail | 40 | ||||||
| 3 | AC | Ship | 150 | ||||||
| 4 | AD | Ship | 215 | ||||||
| 5 | AE | Road | 100 | ||||||
| 6 | AF | Road | 20 |
You have three options to transport the order. You can either use rail, road and ship. The prices are listed in the table below.
| Method | AED/each |
| Rail | 0.50 |
| Road | 0.60 |
| Ship | 0.45 |
The pricing is as follows
| Quantity | AED/ each |
| 0 | 2.50 |
| 60 | 2.30 |
| 120 | 2.10 |
| 240 | 2.00 |
There is some shipping discount available depending on the quantity that you are transporting.
| Total price | 0 | 200 | 400 |
| Shipping discount 1 | 0% | 15% | 25% |
| Shipping discount 2 | 0% | 10% | 15% |
Solution
Title:
Computer Applications In Management
Length:
2 pages
(550 Words)
Style:
MLA
Preview
| shipping discount 2 | |||||||||
| Order number | Cust ID | Shipping | Quantity | Unit price | Total price | Unit shipping | Total shipping | Shipping discount | Grand Total |
| 1 | AA | Rail | 250 | 2 | 500 | 0.5 | 125 | 18.75 | 606.25 |
| 2 | AB | Rail | 40 | 2.5 | 100 | 0.5 | 20 | 2 | 118 |
| 3 | AC | Ship | 150 | 2.1 | 315 | 0.45 | 67.5 | 6.75 | 375.75 |
| 4 | AD | Ship | 215 | 2.1 | 451.5 | 0.45 | 96.75 | 14.5125 | 533.738 |
| 5 | AE | Road | 100 | 2.3 | 230 | 0.6 | 60 | 6 | 284 |
| 6 | AF | Road | 20 | 2.5 | 50 | 0.6 | 12 | 1.2 | 60.8 |
* Once your purchase is processed by paypal you will be redirected back to this page and you'll have the option to download the paper. We'll also send the paper to your paypal email address as proof of purchase.Download Paper
