Background:

When Ava started her Business Accounting firm 2 years ago, with 10 employees. This company of hers offers both accounting and bookkeeping services to businesses and is busy between December and April (5 months). Today, her company has 80 employees, supported by a team of 3 Information Technology staff. Her company has a local area network, capable of supporting 100 users/employees. In order to maintain data integrity and security, all data records are accessed via a database server running on the company’s local area network. The database server, of course, enables real-time access to data records. (Hence, no data records are stored on the employee’s computer.)

In the last 2 months, her company lost several bids on potential business projects due to the lack of IT resources, specifically the lack of storage capacity. Ava has decided to adopt the necessary the cloud computing service in order to resolve this issue. In other words, she has decided to shifte from assess-based physical IT resources to service-based virtual resources.

Your task:

1. Research and study to understand the key business operations of Accounting and the key business operations of Bookkeeping. 2. Create a screening rubric (in MS Word or MS Excel) to be used to evaluate/select the cloud service provider for resolving the abovementioned issue for Ava’s Business Accounting firm.

Hints:  You need to determine the cloud service that may resolve the issue before you can create the screening rubric.  Due to data sensitivity (integrity and security), Ava’s business can only use the private cloud model.  Using the rubric created by you, can you select a cloud service provider that can meet Ava’s business requirements?

The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over.

Current Ratio = 1.33

Quick Ratio = 0.61

Days sales outstanding (DSO) = 59.14 days

Asset Turnover - 1.40

Inventory Turnover Ratio = 4.09

Return on Asset(ROA)= 2.70%

Return on Equity(ROE)= 9%

Net Profit Margin= 1.93%

Question: A). Using the following data, analyse the company's performance based on the ratio, explain what each ratio figure means in terms of the performance. (50-100 word on each ratio)

B). analyze the company overall performance (summary of A)

Write a program which compresses a given string of 1s and 0s and uncompress the string that was compressed. Use the run-length compression technique which replaces runs of 0s with a count of how many 0s.

The interactive input/output should allow users to select and run required processes.

The assignment submission on Blackboard should be as CIS_232_Project_LastName.zip file and include:

project report file: ProjectReportLastName.doc

program’s source file: ProjectLastName.java

program’s bytecode file:   ProjectLastName.class

and any other relevant files.

The project report should be prepared by using word processing software. To write a program you should complete and include in your assignment report the following steps:

      Title:

            Student’s name:
            CIS 232 Introduction to Programming  

            Programming Project
            Due Date: November 30, 2020

            Instructor Dr. Lomako:

1. Problem statement - A clear and concise description of the problem.
2. Analysis - An explanation of what the problem statement tells you to do and description of the general method used to solve the problem.
3. Design – Explanation of the algorithm designed to solve the problem. Concentrate on the general program logic that includes:
   1. Structure chart of the program.
   2. Description of data transmission between the modules.
   3. Description of the algorithms using pseudo code or flowchart.
4. Development of the program. Comment your code well at the top of each method, class, etc. including the title, inputs and outputs, etc. Comments are important because the well commented functions/logics are helpful to other programmers to understand the code better.
5. Test the program. Using the test data show testing results and compare them with what you expected to have.
6. Run the program to solve the problem. Show and explain results. The first lines of the output should have the title information.
7. Prepare user instructions of your program.

You are a legal assistant for the attorney of the FUN company. You must conduct research and find three (3) court opinions (i.e. cases that have been previously decided by the court) that are precedent (i.e. have similar facts and issues of law) to the case below. You must provide the case title and citation of each of the three (3) cases you find.

Three months ago the CEO for FUN Company sent a letter to the Pastor for the Church of Stranger Things pledging a $3,000,000.00 donation to the Church. Upon receipt of this news, the Pastor contacted FUN’s CEO who re-assured the Pastor that the Church would be receiving a check for this amount within the ensuing four to six weeks. The Pastor, who for several years had wanted to expand the Church in order to increase its congregation, immediately hired an architect and paid him $400,000.00 to design the new ambitious project. The Pastor was in love with the architect’s design, so he quickly hired a general contractor for $750,000.00 to start the building process. In addition to the $750,000.00 for the labor, the Pastor paid another 1,100,000.00 for the tools and materials needed for the project. Five weeks after receiving the letter and first speaking to FUN’s CEO on the phone, the bishop called FUN because he was nervous about the fact that he had not received the check and he had already incurred such significant expenses. Note that the only reason the Pastor engaged in this ambitious construction project was because of the extra money he was counting on getting from FUN since the Church’s structure did not need it to continue its regular operations. The CEO at that point told the Pastor that soon after committing to donate the money, FUN’s finances started going terribly wrong and as such at this point, they were not able to make a donation to the church. The Pastor is now demanding that FUN still true to its word and give the church the donation.

1. Create a descriptive statistics table for our variables in word for submission (simply export from excel and cleaning it up a bit)

2. Create a table showing the variable names, coefficients, and p-values, indicating which variables are statistically significant for submission (export from excel and clean up a bit)

3. Write out the regression equation for sales here based on excel output:

4. Interpret the coefficient on our own price here:

5. If a manager increases our price by $2 then what is the predicted impact on sales?

What are the proportions for the colors of M&M candy colors? You will need one Medium (approximately 12 ounce) bags of M&M’s. You may choose from any of the following varieties:

• • Peanut
• • Dark
• • Coconut
• • Almond
• • Crispy
• • Peanut Butter
• • Pretzel

Answer each of the questions below for your bags of candy in your project. Your final project should be in report form which includes the answers to the questions. The report should be typed. You may hand write neatly the mathematics symbols and your work. If you have any questions, you should contact your teacher.

1. A) Basics Information:

1. 1) Identify the colors of M&M’s that are in one of your packages. Be sure to indicate the variety of M&M and name the colors.
2. 2) Before you begin the data collection, state the percentages of colors that you think are in the bag. (2 points)
3. 3) Make a frequency distribution of the counts of the colors in your first bag and give the relative frequency for each color. (3 points)

4) The “color” of M&M is what type of data (two answers)? (1 point)

5) Graph the data by using an appropriate chart. (May use excel and paste the graph in the report). State why you chose you type of graph. (5 points)

B) Proportion test (you may use <, >, or ≠ for H₂):

Now, choose color. Just test one of the colors. Use the official proportion from M&M’s for p and compare to your proportion,. Use 5% for level of significance

1. 1) State the null and alternate hypotheses. (4 points)
2. 2) Find test stat and the P-value. (8 points)
3. 3) Sketch the sampling distribution and show the area corresponding to the P-value.(4 pts
4. 4) Will you reject or fail to reject the null hypotheses? State your conclusion in the context of the data. (9 points)

C) Good ness of fit

1) Do you think that the data you have gathered agrees with the company’s claims? (2 points)

2) Identify a procedure that you could use to check the goodness of fit for your data on one of the variety of M & M’s. (1 point)

3) Identify the H_o and H₁ you would use to verify the company’s claim. (4 points)

4) Display in a matrix the observed and expected cell values and perform a Chi-Square analysis for the one of M & M’s variety (10 points)

5) Write a word conclusion to the hypothesis test you have performed using the 1% level of significance. (Show all steps in your hypothesis test) (9 points)

D) Test for Independence

Now consider the type of M&M and the color. Use the one sample that you counted and one sample given to you (below) to test the hypothesis that the type of M&M is independent of the colors as listed.

1) Fill in your data in the chart below (3 points)

2) Filled in the expected amounts (6 points)

E = (Row total)(Column Total)/ Sample Size

3) Identify the H_o and H₁ you would use to verify the type of M&M is independent of the colors as listed.   

4) Perform a Chi-Square analysis for the two of M & M’s variety

5) Write a word conclusion to the hypothesis test you have performed using the 5% level of significance.   

Once you have the dataset, please use knowledge gained in other business and/or economics classes to realize what topic and theory the data could relate and a research question that it could allow you to answer. More specifically, please put together an analysis by making sure your project report includes the following:

1. Brief statement of the research topic and problem. As you get the dataset from me, you would need to use some imagination what research problem that data could be related to. Nevertheless, please state very briefly (i.e. in one paragraph) what theory (research literature or textbooks related to business or economics) says about the research problem – e.g. is there some dilemma or controversy that your research will help to clarify.
2. Clearly worded research question that limits the research problem to researchable task. (This is a short sentence that ends with the question mark and it is suggested that you draw from theory (research literature / textbook knowledge) in one of the business studies field to word it!)
3. Please identify the type of data that you are working with – on what type of measurement scale(s) where the selected variables measured by the original data collectors. (As you work with the dataset given by me, use your educated guess).
4. Describe the data with the tools of descriptive statistics, using both numerical as well as graphical methods. In addition to reporting and commenting on the values central tendency and diagrams, please also justify the choice of method (e.g. why a particular kind of measure of central tendency was selected and the chosen graphic is appropriate to use in this context).
5. Justify the selection of the specific data analysis method of inferential statistics. Recommendation – use the decision tree (introduced in Ch. 9ff) to make the selection and justification of it. You should look up also the assumptions and comment how your data meets them but I will not penalize you if it does not meet all the criteria. Nevertheless, please make sure that you include the basic information about distribution of the variables – are they more or less normally distributed (use both numerical as well as graphical methods). It is required that you restrict the choice of data analysis method(s) to the ones introduced in the class. (In addition to the fact that we covered only the most basic / frequently used methods in class, also the spreadsheet program (Excel) which the textbook is based on and that I presented during the course, has limited set of methods available).
6. Formulate the null and research (alternative) hypothesis – similarly to point 2 it is recommended that you word them on the basis of research literature / textbook knowledge in one of the business studies field that you know);
7. Determine the test criteria:

7.1. Specify the level of significance (Type I error associated with the null hypothesis),

7.2. Determine the test statistic (the appropriate statistical test as mentioned under point 5 above),

7.3. Determine the critical values (and region(s) if applicable),

8. Calculate the value of the test statistic (obtained value).
9. Make a decision about the null and research hypothesis by comparing the obtained value to the critical value and interpret the results of the data. You can pay attention also to the p-values.
10. Sum up you research report by relating the statistical test result(s) to the research question and theory that you set to test.

DATA :

This is a work integrated assessment item. The tasks are similar to what would be carried out in the workplace.

Tully Tyres sells cheap imported tyres. The manager believes its profits are in decline. You have just been hired as an analyst by the manager of Tully Tyres to investigate the expected profit over the next 12 months based on current data.

•Monthly demand varies from 100 to 200 tyres – probabilities shown in the partial section of the spreadsheet below, but you have to insert formulas to ge the cumulative probability distribution which can be used in Excel with the VLOOKUP command.
•The average selling price per tyre follows a discrete uniform distribution ranging from $160 to $180 each. This means that it can take on equally likely integer values between $160 and $180 – more on this below.
•The average profit margin per tyre after covering variable costs follows a continuous uniform distribution between 20% and 30% of the selling price.
•Fixed costs per month are $2000.

(a)Using Excel set up a model to simulate the next 12 months to determine the expected average monthly profit for the year. You need to have loaded the Analysis Toolpak Add-In to your version of Excel. You must keep the data separate from the model. The model should show only formulas, no numbers whatsoever except for the month number.

You can use this partial template to guide you:

The first random number (RN 1) is to simulate monthly demands for tyres.
•The average selling price follows a discrete uniform distribution and can be determined by the function =RANDBETWEEN(160,180) in this case. But of course you will not enter (160,180) but the data cell references where they are recorded.
•The second random number (RN 2) is used to help simulate the profit margin.
•The average profit margin follows a continuous uniform distribution ranging between 20% and 30% and can be determined by the formula =0.2+(0.3-0.2)*the second random number (RN 2). Again you do not enter 0.2 and 0.3 but the data cell references where they are located. Note that if the random number is high, say 1, then 0.3-0.2 becomes 1 and when added to 0.2 it becomes 0.3. If the random number is low, say 0, then 0.3-0.2 becomes zero and the profit margin becomes 0.2.
•Add the 12 monthly profit figures and then find the average monthly profit.

Show the data and the model in two printouts: (1) the results, and (2) the formulas. Both printouts must show the grid (ie., row and column numbers) and be copied from Excel and pasted into Word. See Spreadsheet Advice in Interact Resources for guidance.

(b)Provide the average monthly profit to Ajax Tyres over the 12-month period.

(c)You present your findings to the manager of Ajax Tyres. He thinks that with market forces he can increase the average selling price by $40 (ie from $200 to $220) without losing sales. However he does suggest that the profit margin would then increase from 22% to 32%.

He has suggested that you examine the effect of these changes and report the results to him. Change the data accordingly in your model to make the changes and paste the output in your Word answer then write a report to the manager explaining your conclusions with respect to his suggestions. Also mention any reservations you might have about the change in selling prices.

The report must be dated, addressed to the Manager and signed off by you.

Question 1:

Locate the Manufacturer tab. Test to determine if there is a significant difference between Mean Value Added by the manufacturer and the mean Cost of Materials in manufacturing assuming a 10% level of significance.

Must complete all the parts to this problem:

• PART 1: Use Excel to perform the Test for Equality of Variances. Copy and paste the output from Excel into a word document.
• PART 2: Write 1 – 2 sentences on the findings from the Test for Equality of Variances. Which two-sample t-test will be needed (equal variances or unequal variances)? Support your answer by using the output from the Test for Equality of Variances. You must include: the hypotheses for the F-test, a discussion of the p-value, and the decision you reach and why.
• PART 3: Run the test you chose in step 2 in Excel (t-test assuming equal variances or unequal variances) to test if there is a significant difference between Mean Value Added by the manufacturer and the mean Cost of Materials in manufacturing assuming a 10% level of significance. Copy and paste the output from Excel into a word document.
• PART 4: Write 3 - 4 sentences on the findings from the Two-sample T-test. Is there a significant difference between Mean Value Added by the manufacturer and the mean Cost of Materials in manufacturing assuming a 10% level of significance? Support your answer by using the output from the test. You must include: the hypotheses for the T-test, a discussion of the p-value, and the decision you reach and why.

Data: (Table was too large so I divided each data set into two columns)