Price \$5

# 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
\$5.00

* 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.

#### Order a high quality custom written paper

With a team of proficient and enthusiastic writers, we are able to produce a compelling text on practically any topic.

Or

## Related Essays

\$19.00

### IT Audit and Control A...

\$16.00
Computer science 12 Pages

\$17.00