EXCEL HOMEWORK HELP
dtg05
go_e04_grader_h3.xlsxWarehouse Purchase
| Warehouse Purchase in Chicago | |
| Amount of Loan | $1,025,000 |
| Period (years) | 10 |
| Interest rate (per year) | 5.50% |
| Payment (per month) | $11,123.94 |
| Option #1 Reduce the Loan | |
| Amount of Loan | $921,436 |
| Period (years) | 10 |
| Interest rate (per year) | 5.50% |
| Payment (per month) | $10,000.00 |
| Option #2 Increase the Years | |
| Amount of Loan | $1,025,000 |
| Period (years) | 11.6 |
| Interest rate (per year) | 5.50% |
| Payment (per month) | $10,000.00 |
Warehouse Payment Table
| Loan Options for Warehouse Purchase: Rates versus Months | |||||||
| Amount of Loan | $1,025,000 | ||||||
| Period (months) | 120 | ||||||
| Interest rate (per year) | 5.50% | ||||||
| Payment Options | |||||||
| Number of Monthly Payments | |||||||
| 60 | 120 | 180 | 240 | 300 | 360 | ||
| Rates | 8.00% | ||||||
| 7.50% | |||||||
| 7.00% | |||||||
| 6.50% | |||||||
| 6.00% | |||||||
| 5.50% | |||||||
| 5.00% | |||||||
| 4.50% |
Staffing Plan
| Jesse Jewelers | |||||
| Store Staff Planning Form | |||||
| Name | Richmond | ||||
| Store # | N211 | ||||
| Date | 9-Jan | ||||
| Job Code | Description | # of Positions | Type | Salary | Budget Amount |
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| 0 | |||||
| Total: |
Job Information
| Jesse Jewelers | ||
| Job Classification List | ||
| Job Code | Description | Salary |
| M-MG | Manager | $ 52,000 |
| M-AMG | Assistant Manager | $ 37,500 |
| C-CASH | Cashier | $ 27,000 |
| C-CSA | Customer Services Assistant | $ 28,000 |
| S-STR | Stockroom Assistant | $ 23,500 |
| B-BYR | Buyer | $ 35,600 |
| CC-J | Maintenance Attendant | $ 21,000 |
Revenue
| Jesse Jewelers | ||||||||||||
| Last Year: Online Bracelet Sales | Projected: Online Bracelet Sales | |||||||||||
| Product | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % |
| Crystal Bracelets | 1,613 | 1,707 | 1,595 | 1,828 | 6,743 | 22% | 1,855 | 1,963 | 1,834 | 2,102 | 7,754 | 20% |
| Beaded Bracelets | 1,136 | 1,066 | 1,408 | 1,702 | 5,312 | 17% | 1,454 | 1,226 | 1,802 | 2,179 | 6,661 | 17% |
| ID Bracelets | 1,823 | 1,501 | 1,763 | 1,917 | 7,004 | 22% | 1,951 | 1,606 | 1,886 | 2,051 | 7,494 | ERROR:#DIV/0! |
| Ankle Bracelets | 2,015 | 1,828 | 1,875 | 1,772 | 5,718 | 18% | 2,579 | 2,340 | 2,400 | 2,268 | 9,587 | 25% |
| Mens Bracelets | 1,408 | 1,221 | 1,744 | 2,104 | 6,477 | 21% | 1,577 | 1,368 | 2,006 | 2,356 | 7,307 | 19% |
| Total | 7,995 | 7,323 | 8,385 | 9,323 | 31,254 | 9,416 | 8,502 | 9,929 | 10,957 | 38,803 | ||
| Assumptions | ||||||||||||
| Item | Growth | |||||||||||
| Crystal Bracelets | 15.0% | |||||||||||
| Beaded Bracelets | 28.0% | |||||||||||
| ID Bracelets | 7.0% | |||||||||||
| Ankle Bracelets | 28.0% | |||||||||||
| Mens Bracelets | 12.0% |
