In Java

The Order class should have:  Seven instance variables: the order number (an int), the Customer who made the order, the Restaurant that receives the order, the FoodApp through which the order was placed, a list of food items ordered (stored as an array of FoodItem), the total number of items ordered (an int), and the total price of the order (a double).  A class constant to set the maximum number of items that can be ordered (an int). Set it to 10.  A constructor that accepts three parameters, the Customer, the Restaurant and the FoodApp, and initializes the corresponding instances variables. The array of FoodItems will be a partially filled array. It should be initialized according to the maximum number of items that can be ordered, and be empty at the beginning. The total number of items ordered should be initialized accordingly. The total price shall be initialized to 0. The order number shall have 6 digits, and start with a 9. Every order should have a distinct order number, starting from 900001, then 900002, then 900003 and so on. You will need to add either an instance variable or a class variable to accomplish this (choose wisely).  An addToOrder(FoodItem) method that adds the FoodItem received as a parameter to the FoodItem array, only if it is available (i.e. not sold out) and if there is space left in the array. If the FoodItem was added, the method returns true (it returns false otherwise). You can assume that the FoodItem belongs to the restaurant’s menu (no need to check if it’s on the menu). Don’t forget to update here: the amount in stock for the FoodItem (decrement by 1), the total price of the order, and the total number of items ordered.  A toString method that returns a String containing the FoodApp name, the order #, the customer name, the Restaurant name, the list of items ordered and the total price (formatting it exactly as shown in the example below). You will need to add some accessors in the previous classes (aka get methods) to get only the name of the Customer, FoodApp and Restaurant, instead of the full String representation of those.

=============================================

public class FoodItem {

    /*Four instance variables: a name (a String), a cost (a double), a selling price (a double), and the number of

items available in stock for selling (an int)*/

    String name;

    double cost;

    double price;

     int   numberOfItem;

/* A constructor that takes four parameters, in the above order, which are used to initialize the four instance

variables.*/

    public FoodItem(String name, double cost, double price, int numberOfItem){

        this.name = name;

        this.cost = cost;

        this.price = price;

        this.numberOfItem = numberOfItem;

    }

/* A method isAvailable that checks if there are items available for selling (returns false is no items are available,

true otherwise)*/

    public boolean isAvailable(int numberOfItem){

        if ( numberOfItem <= 0)

            return false;

        else

            return true;

    }

/* A toString method which returns a String containing the name of the food item and the selling price. If the

item is not available, add “(SOLD OUT)” next to the price, making use of the isAvailable method. Follow the

format shown in the example output below.*/

    @Override

    public String toString(){

        String update ="";

        if ( this.numberOfItem <= 0)

            update =" (SOLD OUT)";

        return"- "+this.name +"\n$ "+ this.price + update;

    }

// A method setSellingPrice that takes a new price as a parameter, and updates the selling price instance variable.

    public void setSellingPrice( double TheSellingPrice){  

        price = TheSellingPrice;

    }

// A method decrementStock that decrements the number of items in stock by 1.

    public int decrementStock(int x){

        return numberOfItem -= x;

    }

// A method increaseStock that takes an amount of additional stock as a parameter, and adds it to the existing stock available for selling. */

    public int increaseStock(int x){

        return numberOfItem += x;

    }

}//FoodItem

You have been promoted to Assistant Director of your Laboratory Department. One of your first assignments is to prepare a recommendation for the replacement of one of your Coulter Counters.

Your Department Director has asked that you work with the Financial staff in preparing this recommendation. Upon contacting the financial staff they tell you that their department has lost a number of analysts and ask if you could help in preparing the analysis since you are a recent graduate of SHU. You tell them that you are well versed in Capital Decision making and would be able to complete the analysis for them and submit to your Department Director.

You decide to prepare a Net Present Value Analysis and begin the discussions with your staff. They emphasize to you the importance of replacing the existing equipment due to quality and safety concerns for the patient. You first plan on completing a Time Line and from the discussion with the staff plan on incorporating the following assumptions in your analysis:

Assumptions to use:

Time Line for 5 years

Initial cost of equipment $3000000

Additional volume from increased efficiency 1000 test per month

Average reimbursement per test is $50

Cost of supplies will be reduced by $2000 per month

The existing equipment is fully depreciated

The only other expense is the depreciation for the new equipment and it is a non cash item

The financial staff tells you to use 5% as your Cost of Capital

What would be the NPV for your analysis?

What would be your recommendation to your Director based on both your quantitative analysis and also qualitative issues?

The data from Exhibit 3 is also in the Excel file income.xls on the course website. Use Excel, along with this file, to determine Mrs. Bella’s real income for the last fifteen years. Do this by first converting each price index from percent by dividing by 100. Then, divide gross income by your converted (adjusted) price index. Using Excel, find the mean, median, standard deviation, and variance of her past real income. Explain the meaning of these statistics. Can you use mean income to forecast future earnings? Take into account both statistical and non-statistical considerations.

Accounting:

Celebrity Inc. has the following shares outstanding at December 31, 2019:

Common shares, $1,500,000 no par value, 10,000 shares issued and outstanding, unlimited number authorized.

Preferred shares, $200,000, $5.00, no par value, non voting shares, 2,000 shares issued and outstanding.

The preferred shares are noncumulative and non-participating.

   Dividends declared are $47,500.

What is the total preferred share dividends?

Celebrity Inc. has the following shares outstanding at December 31, 2019:

Common shares, $1,500,000 no par value, 10,000 shares issued and outstanding, unlimited number authorized.

Preferred shares, $200,000, $5.00, no par value, non voting shares, 2,000 shares issued and outstanding.

The preferred shares are noncumulative and non-participating.

Dividends declared are $47,500.

What is the total common share dividends?

Celebrity Inc. has the following shares outstanding at December 31, 2019:

Common shares, $1,500,000 no par value, 10,000 shares issued and outstanding, unlimited number authorized.

Preferred shares, $200,000, $5.00, no par value, non voting shares, 2,000 shares issued and outstanding.

The preferred shares are cumulative and non-participating.

   Dividends have not been declared for the past two years.

   Dividends declared are $30,000.

What is the total preferred share dividends?

Celebrity Inc. has the following shares outstanding at December 31, 2019:

Common shares, $1,500,000 no par value, 10,000 shares issued and outstanding, unlimited number authorized.

Preferred shares, $200,000, $5.00, no par value, non voting shares, 2,000 shares issued and outstanding.

The preferred shares are cumulative and non-participating.

   Dividends have not been declared for the past two years.

   Dividends declared are $30,000.

What is the total common share dividends?

We want to provide home-delivery service to our customers. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

The system must use 128-bit encryption techniques to store data. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

The Chief Financial Officer needs to know when overdue payments are reaching unsustainable levels.

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

The system needs to record the date and time when the order is paid-for. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

We want to know when there is an increase in the number of customers coming from particular towns where we don’t have a physical shop in the town. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

The Deliveries Supervisor will be able to see the number of orders that are waiting to be sent in a delivery truck, on their main screen at all times. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

The on-screen font size and default font face should be adjustable to suit each user's personal preference. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

When the 'pay now' button is clicked, the customer’s credit card must be charged the full amount. Select one:

a. Business Requirement b. User/Stakeholder Requirement c. Functional Requirement d. Non-Functional Requirement

1. Calculating Annuity Values. You want to have $60,000 in your savings account 12 years from now, and you’re prepared to make equal annual deposits into the account at the end of each year. If the account pays 6.4 percent interest, what amount must you deposit each year?
2. Calculating Annuity Values. Your company will generate $47,000 in annual revenue each year for the next seven years from a new information database. If the appropriate interest rate is 7.1 percent, what is the present value of the savings?

Use the International Stock Market database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict the Nikkei by the DJIA, the Nasdaq, the S&P 500, the Hang Seng, the FTSE 100, and the IPC. Assume a 1% level of significance.

What percent of residuals are within 1 standard error? Write your answer as a number rounded to 1 decimal place. Do not include the % sign in your answer.

Excel Data: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

Listed below is the relational database schema for an online store(SQL/Java):

MEMBER(last_name, first_name, email, password, user,street, city, state, zip, card_type, card_no, expiration, name_on_card)

book_SALE(listing_no, seller, isbn, condition, price)

ORDERS(order_no, buyer, order_date, tot)

ITEMS(order_no, listing_no)

BOOK(isbn, title, author, edition, publisher, keywords)

The bold attribute(s) in a relation is the primary key of that relation. The italized attributes in some relations denote foreign keys.

Create/Define the table.