ACCT 3300
Excel Budgeting Project
 
 
Open the Excel spreadsheet and click on the Problem tab at the bottom to view the instructions for the project. Click on the Worksheet tab and begin entering the formulas provided below.
 
Scroll down the Worksheet page until you come to the Answer Section. The Sales Budget section is listed first. In the shaded cells, enter the appropriate formula for each cell shown below. After typing in the formula, click Enter on your keyboard. Be sure you have each formula in the exact cell (row and column) as shown below.
 

 
You will notice that the amounts and formulas for August and September will appear when you complete the July entries. These additional formulas have been pre-programmed into the spreadsheet to save time. Also notice that the cell references in the formulas (for example, B10 is cell reference for the cell in column B, row 10) are to the data section at the top of the worksheet tab.
 
Formulas for the Unit Purchases budget will be entered next. See below.

 
 
Next, enter the formulas for Cash Budget. Do not be concerned when the August and September amounts do not display immediately. The will show when you complete this section. Note there is one formula for Column C in this section.
 

 
When these formulas are completed, move down to the Income Statement section and enter the following formulas.
 

 
Then complete the Balance Sheet formulas.
 

 
Once you have completed all the formulas, you have completed Items 1 and 2 of the problem. Save your worksheet as instructed in Item 2 and use the check figures to verify your amounts. Continue to Items 3 and 4 and when finished with those sections, save your file again as instructed in Item 4 and submit both files using the Assignment link at the top of the Blackboard section describing the assignment.

Teles, G., Rodrigues, J. J., Rabê, R. A., & Kozlov, S. A. (2020). Artificial neural network and Bayesian network models for credit risk prediction. Journal of Artificial Intelligence and Systems, 2, 118-132.
Lakhani, M., Dhotre, B., & Giri, S. (2019). Prediction of credit risks in lending bank loans using machine learning. SAARJ Journal on Banking & Insurance Research, 8(1), 55-61.
Sun, T., & Vasarhelyi, M. A. (2018). Predicting credit card delinquencies: An application of deep neural networks. Intelligent Systems in Accounting, Finance and Management, 25(4), 174-189.
Fitzpatrick, Trevor & Mues, Christophe, 2016. “An empirical comparison of classification algorithms for mortgage default prediction: evidence from a distressed mortgage market,” European Journal of Operational Research, Elsevier, vol. 249(2), pages 427-439.
Huang, X., Liu, X., & Ren, Y. (2018). Enterprise credit risk evaluation based on neural network algorithm. Cognitive Systems Research, 52, 317-324.
Chi, G., Uddin, M. S., Abedin, M. Z., & Yuan, K. (2019). Hybrid Model for Credit Risk Prediction: An Application of Neural Network Approaches. International Journal on Artificial Intelligence Tools, 28(05), 1950017.
Barboza, Flavio & Kimura, Herbert & Altman, Edward. (2017). Machine Learning Models and Bankruptcy Prediction. Expert Systems with Applications. 83. 10.1016/j.eswa.2017.04.006.
https://www.sciencedirect.com/science/article/abs/pii/S0957417418301179(Predicting mortgage default using convolutional neural networks)
Graves, J. T., Acquisti, A., & Christin, N. (2018). Should Credit Card Issuers Reissue Cards in
Response to a Data Breach? Uncertainty and Transparency in Metrics for Data Security
Policymaking. ACM Transactions on Internet Technology (TOIT), 18(4), 1-19.
Dal Pozzolo, A., Boracchi, G., Caelen, O., Alippi, C., & Bontempi, G. (2017). Credit card fraud
detection: realistic modeling and a novel learning strategy. IEEE transactions on neural
networks and learning systems, 29(8), 3784-3797.
Makki, S., Assaghir, Z., Taher, Y., Haque, R., Hacid, M. S., & Zeineddine, H. (2019). An
experimental study with imbalanced classification approaches for credit card fraud
detection. IEEE Access, 7, 93010-93022.
Kalid, S. N., Ng, K. H., Tong, G. K., & Khor, K. C. (2020). A Multiple Classifiers System for
Anomaly Detection in Credit Card Data with Unbalanced and Overlapped Classes. IEEE
Access, 8, 28210-28221.
Taha, A. A., & Malebary, S. J. (2020). An Intelligent Approach to Credit Card Fraud Detection
Using an Optimized Light Gradient Boosting Machine. IEEE Access, 8, 25579-25587.
Can, B., Yavuz, A. G., Karsligil, E. M., & Guvensan, M. A. (2020). A Closer Look into the
Characteristics of Fraudulent Card Transactions. IEEE Access, 8, 166095-166109.
Kundu, A., Panigrahi, S., Sural, S., & Majumdar, A. K. (2009). Blast-ssaha hybridization for
credit card fraud detection. IEEE transactions on dependable and Secure Computing,
6(4), 309-315.
Al-Khater, W. A., Al-Maadeed, S., Ahmed, A. A., Sadiq, A. S., & Khan, M. K. (2020).
Comprehensive Review of Cybercrime Detection Techniques. IEEE Access, 8, 137293-
137311.
Randhawa, K., Loo, C. K., Seera, M., Lim, C. P., & Nandi, A. K. (2018). Credit card fraud
detection using AdaBoost and majority voting. IEEE access, 6, 14277-14284.

 
 
 
 
 
 
MIS    328-Business    Telecommunications Course Project
 

 
The purpose of this project is to provide the students with hands-on experience with computer networks.
 
There are three deliverables for this project (submission deadline week 12):
 

  1. Final report describing the software and simulation results.

 

  1. Project Teams

 
You can work individually or with a smaller team, (each team consists of 2 students). All students in a team are working on the same project.
 
All team members must take part in all project activities, although responsibilities may be divided so that different members take lead in different activities. However, no activity should be done exclusively by a single person. While the volume of work of group members on each project component may not be equal, their contribution to the overall project should equal out.
 

  1. Project report

 
For this deliverable, every team is expected to submit a document describing their project.
 
The report should contain the following:
 
Every report must have a cover page containing:
. the course title,
. group number,
. project title,
. submission date, and all team-member names.
 
 
 
The second page of each report must detail the breakdown of individual contributions of each team member to the project.
 
The rest of the report must contain the following sections:
 

1)       Project Definition and usage.

  • Your project goal must be defined to support network connectivity for specific organization (Hospital, University, Ministry, country, city, firm… etc).

2)       Network Implementation Strategy Design.

  • Geographical Distribution
  • Bandwidth Requirements
  • Media Requirements

3)       Technology ( Minimum of 700 words)

  • What is available now
  • Minimum required for the job
  • Technology improvements during next 5 years
  • Required to support expected growth

4)       Draw and Describe the Network topology that will be used.

  • Hub-Based Ethernet
  • Switch-Based Ethernet

5)       Security plan for your project.

  • References:

List all the references (books, journal/conference papers), web pages (include URL and webpage title) that have been used in the project.