On I-5, you see the bright pink Almond Roca sign. You know they produce Almond Roca, but you wonder if they have ever thought about Brazil Roca, or Cashew Roca! You think these would be delicious, and you aren’t really an almond fan.

Industry Background

Candy has been a part of our world for thousands of years. The first candy was made from honey. It was reserved, as were most good things, for the wealthy for a long time. In the Industrial Revolution, candy started to be more widely available. Latest figures place candy sales at $118 billion world-wide.

There are about 100 different candy manufacturers in the US, both large and small, from Mars, Inc. which is the 6^th largest company in the US with $33 billion in sales; to local Almond Roca, with an estimated $50 million in sales.

Current Issues

One of the biggest issues facing this company is the rise in prices of raw materials, especially the iconic almond, which due to drought in California, has seen a price rise in recent years (although market forces are starting to correct for this).

In order to diversify their product, Almond Roca, Inc., has started to expand its repertoire to including other nuts, such as cashews and macadamia nuts. They are considering expanding to even more types of nuts, even mixed nuts!

Part 1 – Manufacturing Methods

Almond Roca is considering three nut mixes for inclusion in a new product line, Mixey Nuts!: Regular Mix, Deluxe Mix, and Holiday Mix. Each mix is made from 5 nuts, in different combinations.

The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut.

The Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts.

An accountant at Almond Roca, Inc., analyzed the cost of packaging materials, sales price per pound, etc, and determined that the profit contribution per pound is $1.65 for the Regular Mix, $2.00 for the Deluxe Mix, and $2.25 for the Holiday Mix. The price of the nuts can vary from month to month.

The estimate the customer orders for the different types to be as follows:

The president of Almond Roca wants to commit to these a minimum, even if not immediately profitable, in order to introduce these new mixes to the market.

Report:

Summarize this problem, and discuss the following topics, in a Word Document:

1.     The cost per pound of the nuts included in the Regular, Deluxe, and Holiday mixes.

2.     The optimal product mix and the total profit contribution.

3.     Recommendation regarding how the total profit contribution can be increased if additional quantities of nuts could be found.

4.      A recommendation as to whether Almond Roca should purchase an additional 1000 pounds of almonds for $1000 from a supplier who overbought.

5.      Recommendations on how profit contribution could be increased (if at all) if Almond Roca does not satisfy the minimums listed above.

For this assignment, you will use the provided database in the Unit 5 script file. You will add statements to this file to query the database tables. For your reference, below is a screenshot of the enhanced entity relationship diagram (ERD) as a reference when you write your queries. With the data types listed in the diagram, this will help you identify the types of operators that you can use for particular queries.

Use paiza.io for MySQL to execute and troubleshoot your Structured Query Language (SQL) statements. It is recommended that you use Notepad to write your SQL statements. Then, copy and paste your SQL statements to paiza.io to test your statements to ensure that they execute without errors. Save your work frequently.

The asterisk (*) indicates that a column is not null (i.e., required to have a value).

1. If you would like to see the test SQL statements, click on “Run” to see the statements execute. You should see “Hello” appear in the Output window (see the following screenshot).
2. Because you do not require these test SQL statements for your assignment, delete the sample SQL statements. To do this, select the text, and click on the Delete key on your keyboard. Your MySQL paiza.io screen should now be blank, as you see in the following screenshot. Note that if you ran the test statements, “Hello” will still appear in the Output window.
3. Copy and paste the code from the provided script file into the code editor, and click on “Run” (“Ctrl + Enter”). You should see no error messages displayed in the Output area at the bottom of your paiza.io screen. After you click on “Run,” you should see a green bar with “Success” at the top. You will see this circled in the following screenshot:
4. Next, you will write 1 query to respond to each of the following questions. Note that you can only use the information that is in the question or the enhanced ERD. Write a query to do the following:
   1. Display all of the rows in the publisher table.
   2. Display all of the books in the book table that were written by the author whose author ID is 1504192.
   3. Display all of the purchases in the shopbasket that were ordered on 2020-02-29.
   4. Display the largest quantity ordered in the shopbasket.
   5. Display the authors' first and last names sorted by their last name.
   6. Display a count of the number of orders placed via the shopbasket.
   7. Display the order date and quantity of orders in the shopbasket that have a quantity of more than 25.
   8. Display the first and last names of those authors who have a null Facebook.
   9. Display all of the customers' names, city, and state if they live in GA, FL, or CA.
   10. Display the book titles of those books that were not published by Scholastic Press.
   11. Display the first and last names of the authors and the book titles. Only display those authors who wrote a book with the word database in the title.
   12. Add a multiline comment before the first CREATE TABLE statement that includes your name, the course code (ITCO231), and the date when you are submitting your assignment.
5. Save your script file using your last name, ITCO231, U5, and the file extension .sql, as in “Smith_ITCO231_U5.sql.”
   1. Tip: When saving a Notepad file, you can change the file extension to .sql as required for the assignment by changing the “Save as type” to “All Files” and then typing the .sql extension, as shown in the example.

I didnt understand by what you mean by SQL TEST. If what you are asking me is that an SQL TEST? Yes! It is SQL QUERY TEST!!

How to do a blackjack game with the following rules and WITHOUT USING ARRAY

Part 1 – Displaying Cards
Write a function to display (print) a card.
sample program output
void displayCard(int card)
Prints the name of the card (ten of spades, queen of diamonds etc.). The parameter should be a value between 1 and 13, from which the type of card can be determined (1 = ace, 2 = two, …, 10, == ten, 11 = jack, 12 = queen, 13 = king).
The card suit (clubs, diamonds, hearts or spades) should be determined randomly.

Part 2 – Generating Cards
Write a function to get a card.
int getCard()
Returns a random value between 1 and 13, representing a card (ace, 2, …, queen, king). You do not have to keep track of which cards are dealt. So, if the game deals the queen of spades five times in row that is perfectly acceptable.

Part 3 – Determining a Cards Score
Write a function to return a card's score.
int cardScore(int card)
Returns a value between 2 and 11 as described in the rules. Recall that the score is the card's value except that aces are worth 11 and face cards are worth 10. The card parameter represents the card for which the score is to be determined.

Part 4 – Dealing Cards
Now that you've completed Parts 1 and 2 you can write a function that handles dealing cards.
int deal(bool isPlayer, bool isShown)
This function is responsible for:
1. Generating the next card to be dealt (Part 1)
2. Printing out what card was dealt (Part 2) and to whom, if needed (see below)
3. Returning the card's score (Part 3)
The two Boolean parameters are related to printing out the card. The isPlayer parameter is used to determine whether the word PLAYER or DEALER should be printed at the start of the output. The isShown parameter is used to determine if the card should be printed – recall that the second card dealt to the dealer is hidden.

Part 5 – Playing a Hand
Parts 1 to 4 should be enough to get you started, and the detailed instructions end here. Your next function should be to play a hand of Blackjack, following the rules described above.
int playhand()
Responsible for playing a hand of Blackjack. Returns 1 if the player won, -1 if the player lost and 0 if the player drew (magic number alert).
There is quite a lot that goes into this function, and it is the heart of the assignment. I would strongly recommend breaking it down into other functions that implement the various phases of a hand of Blackjack.

Part 6 – Game Loop
In your main function (or in another function called by main) write a loop to ask the user if they want to play Blackjack, as shown in the sample program output. The user should continue to play hands of Blackjack until they choose to quit (enter a character other than 'y').
Your program should keep track of whether the user wins, loses or draws a hand (see the return value of the hand function) and print a summary of these results when they exit the program.
The random sequence for the game must not be the same each time it is played.

User Input and Program Output
Assume that the user enters correct input (lowercase 'y' to play a hand, and lowercase 'h' or 's' to hit or stand) – but see Extras.
Your output, wording, spacing and so on may differ from the samples shown above. To receive full marks, it must correctly describe the game and must be at least as pretty as mine (not that mine is particularly pretty).

“Money Can’t Buy Happiness”

Along with this clichéd statement, you’ve probably heard that money does buy happiness.
Both may be true. Economist Richard Easterlin argued that once basic financial needs have been met, more money doesn’t really do much to make a person happy. Researchers set the limit at around $75,000, recently prompting one CEO to give away all his earnings above that amount to his employees.

This is by no means the last word, nor a directive to be unhappy until you make $75,000 and no happier afterward. More recent research worldwide indicates the exact opposite: The more money, the better. The authors said, “If there is a satiation point, we are yet to reach it.” Given these mixed findings, the relationship between happiness and income is probably not direct. In fact, other research suggests your level of income is less important than how you spend it. Think about why you may be motivated by money. Do you envision the number of zeroes in your bank account increasing? Probably not. You’re probably more motivated by what you can buy with the money than by the money itself. From research, we know:

• Giving money away makes people happier than spending it on themselves. In one study, students were given money and told to either give it away or spend it on themselves. Then the study asked people to give away their own money. Either way, people were happier giving away the money, even if the givers were relatively poor. What seems to matter is not the amount, but how much impact you think your donation will have on others.
• People are happier when they spend money on experiences rather than products. Research professor Thomas Gilovich says we think to ourselves, “I have a limited amount of money, and I can either go there, or I can have this. If I go there, it’ll be great, but it’ll be over in no time. If I buy this thing, at least I’ll always have it. That is factually true, but not psychologically true. We adapt to our material goods.”
• People are happier when they buy time . . . but only if they use it well. Outsource tasks when you can, for instance, and “think of it as ‘windfall time’ and use it to do something good,” says researcher Elizabeth Dunn.

Saying that money brings more happiness when spent on our experiences (and the time to do them) may seem counterintuitive until we think about it closely. What did you think of your cell phone when you bought it compared to what you think of it now? Chances are you were interested and engaged when you bought it, but now it is an everyday object. For experiences, what did you think of your greatest vacation when you were on it, and what do you think of it now? Both the experience at the time and the recollection now may bring a smile to your face.

Sources: A. Blackman, “Can Money Buy Happiness?” The Wall Street Journal, November 10, 2014, R1, R2; D. Kurtzleben, “Finally:
Proof That Money Buys Happiness (Sort Of),” USNews.com, April 29, 2013; and A. Novotney, “Money Can’t Buy Happiness,” Monitor on Psychology (July/August 2012): 24–26.

Discussion Question

Do you believe money can buy happiness and is a good motivator in the workplace? Why or why not? Thoughts? Ideas?

1. In the Wall Street Journal, looking at the stock transactions on the New York Stock Exchange, the price of a share of McDonald's stock was: $53.67. You buy the stock. Unfortunately, this gets you thinking and you're hungry. (I know, what does this last bit of information have to do with finance? Trust me - read on. FYI, this is obviously NOT a test bank question.) You buy a Big Mac for $2.79. Considering these two transactions (the stock and the Big Mac in that order), they are examples of

2. Below are three-line items from a corporation's Income Statement. Select the correct line to use and compute the federal tax.

Sales:                          $335,000

Cost of Goods Sold:     $225,000

Net Profit Before Tax: $ 92,000

3. A corporation with sales of $250,000 (OK it's a small corporation!) paid $11,250 federal tax on taxable income of $65,000. They also had an end-of-year party where they ordered 50 Big Macs at $2.79 each. Given the above what was their: average tax rate and marginal tax rate?

4. MTU Corporation (it stand for " Made This Up") had sales last year of $1,000,000. They sell heat shields to place on your lap for stupid McD's customers who insist on placing a cup of hot coffee between their legs. The materials cost $80,000 (that's good) but the labor to put them together costs $750,000 (yes they are union and yes the company is looking to move this operation "off-shore" next year but that's beyond the scope of this course). Advertising was just $50,000, as they mostly use word-of-mouth. They did need to raise some money this year. The bank loaned them $150,000 at 8% (that interest is due this year). The interest didn't worry them too much as it was partyly off-set by the dividend check they received from McDonalds for $8,000 (hmmmmm - I wonder if there is a cinflict of interest here?) Anyway, all things considered, "it was a very good year" (and they are not even 17 - there's a joke or trivia item imbedded here - one bonus point if you can explain what it is), so much so they paid their loyal shareholders $50,000 in common stock dividends. OK, given all that, what was their Federal tax bill? NOTE: you MUST show (type in) all work. Label each line item and indicate clearly what your final answer is.

5. According to the May 19th edition of the WSJ, 6 month CDs were yielding 1.45% (nominal rate of interest). If risk were considered to be 0 (zero) and inflation was expected to average .95% for the next two years, what should one conclude the real rate of interest to be?

6. The Acme Bank and Storm Dood Company (good old "AB&SDC") is trying to determine what rate of interest they should pay on the new 6 month CDs they are trying to get customers to buy. Looking at the WSJ here's some interest rates they found:

Prime: 5%; LIBOR: 3.25%; Fed Funds: 1.5%; 10 Month T-Note: 2.42%; 3 Month T-Bill 1.25%.

Believe it or not, AB&SDC has a rather shaky reputation - so much so knowledgeable investors would require an additional 8% to buy Acme's CDs to make up for their high risk of default (ignore maturity and liquidity issues).

Given the above, what nominal rate of interest must Acme's CDs have to pay?

Scholarship essay required questions:

Tell a story with three main parts:

1. What are the most significant challenges you have faced?

2. What accomplishments are you most proud of?

3. What will the scholarship mean to you/allow you to do?

4. Bonus: Can you connect your story in any way to the story of Martin Langan himself (story below)

——————

Try to connect yourself with Mark Langan. (Read below)

Mark Langan’s Bio:

Martin W. Langan was born in Reading, Pa., in 1907. His sweet temperament, combined with his love for candy, earned him the nickname “Fudge” as a child. That name stuck with him throughout his lifetime.

Following his graduation from high school, he commuted hours each day from Reading to Philadelphia to take night courses in business and accounting.

Lesson: Langan was dedicated to education/improving his future.

After receiving a certification, he worked as an accounting clerk at a large insurance company in Reading. He was there for 40 years until he reached a mandatory retirement age.

Lesson: Patient; hard worker

In his mid 20’s, while in a local hospital for an appendectomy, he met a young nurse, Mae Westley, who was to become his wife. Mae was also born in Reading and, like him, had taken night courses—in her case, to earn credits needed to enter nursing school. Martin and Mae were married for 54 years and had three children.

For decades, he arrived home like clockwork at 5:20 pm, and almost every day the family would sit down to dinner at 5:30.

Lesson: Family-oriented/dedicated to his family

He ate heartily, often finishing what was left on others’ plates. A quiet man with a generous belly, he loved his children unconditionally and would help them with the dishes before moving for the evening to a large rocking chair. There, he would watch TV, nap, smoke a cigar, organize his shopping coupons, and plan his bets for the office football pool.

Lesson: Organized, good at routines. Self care?

He went to church every week and took particular pleasure in priests who gave the shortest sermons. When teaching his son how to drive, he advised the boy to “Move along quietly,” and this directive became a guideline that has served his son ever since.

Lesson: religious

During all their years at home, his children never heard him swear or utter or a single word of disrespect for any race or religion. Once in the row house community where the Langan family lived, a mixed-race couple moved in next door. Neighbors came to Fudge, a respected elder in the neighborhood, to ask for help in driving the couple away. He refused, saying that Christians should not do such a thing, and his children bore silent witness.

Lessons: open-minded, kind to all people

Martin “Fudge” Langan died in 1992; his wife Mae Wesley Langan died in 1999. Their three children remember them as people who never put on airs, worked hard, moved along in life with quiet care and modesty, and did their best to live honest, decent lives.

Closing bullet points:

• Hard worker

• Humble/modest

• Caring

• Honest

• Kind

• Family-oriented

A study was undertaken to investigate the effectiveness of an aquarobic exercise program for patients with osteoarthritis. A convenience sample of 70 individuals with arthritis was selected, and each person was randomly assigned to one of two groups. The first group participated in a weekly aquarobic exercise program for 8 weeks; the second group served as a control. Several pieces of data were collected from the individuals, including their total cholesterol (mg).

Determine if there is a significant difference in the mean cholesterol for the two groups (aquarobic & control) at the start of the study using a significance level of 0.10.   

• What hypotheses should be tested? Make sure to select the hypotheses which are written with notation consistent with the type of samples selected.

  Ho:μ1=μ2Ho:μ1=μ2
  Ha:μ1>μ2Ha:μ1>μ2

  Ho:μ1=μ2Ho:μ1=μ2
  Ha:μ1≠μ2Ha:μ1≠μ2

  Ho:μd=0Ho:μd=0
  Ha:μd≠0Ha:μd≠0

  Ho:μ1=μ2Ho:μ1=μ2
  Ha:μ1<μ2Ha:μ1<μ2

  Ho:μd=0Ho:μd=0
  Ha:μd<0Ha:μd<0

  Ho:μd=0Ho:μd=0
  Ha:μd>0Ha:μd>0

• αα  =
• TS: t =   (round to 3 decimal places)
• probability = Select an answer 0.4497 0.8994 0.5503
• decision: Select an answer reject H₀ fail to reject H₀
• What conclusion is reached based upon the decision made in your test?
  • At the 0.10 level, there is not sufficient evidence to conclude there is a difference in the mean cholesterol of individuals participating in the aquarobic program and those in the control group.
  • At the 0.10 level, there is sufficient evidence to conclude there is a difference in the mean cholesterol of individuals participating in the aquarobic program and those in the control group.

After the 8-week program, those who participated in the aquarobic program had their ending cholesterol measured, and the change in cholesterol was recorded for each participant. Estimate the mean cholesterol change using 90% confidence.

• The formula which should be used for this interval is:
  • (¯y1−¯y2)±t√s21n1+s22n2(y¯1-y¯2)±ts12n1+s22n2
  • ¯yd±tsd√ndy¯d±tsdnd
• With % confidence, we estimate that the mean cholesterol before participating in 8 weeks of aquarobics is between mg and mg  than the mean cholesterol after participation. Note: Round the limits of your interval to three decimal places. In the last box type the appropriate word - more or less. Think carefully about what positive and negative differences mean about the change in cholesterol based on how the differences were taken.

A 90% confidence interval was also calculated for the change in total cholesterol (pre - post) for the control group. That interval was found to be (-2.005, 2.192). Based on this interval and the one which you calculated for the aquarobic group, what conclusion would you draw?

• Neither group had a significant change in mean cholesterol.
• The control group did not have a significant change in mean cholesterol, while the aquarobic group had a significant decrease in mean cholesterol.
• The mean cholesterol for the control group increased, while the aquarobic group had a significant decrease in mean cholesterol.
• Both groups had a significant decrease in mean cholesterol. However, the decrease for the aquarobic group was larger.
• The aquarobic group did not have a significant change in mean cholesterol, while the control group had a significant increase in mean cholesterol.

Topic: Corporate Social Responsibility

Involved Parties:

Bob, President
John, Chemical Engineer
Henry, Controller
Kirk, Assistant Controller

Kirk is a bright individual who is being groomed for the Controller’s position in a medium-sized manufacturing firm. After his first year as Assistant Controller, the officers of the firm were starting to include him in major company functions. For instance, today he was attending the monthly financial statement summary given at a prestigious consulting firm. During the meeting, Kirk was intrigued at how all the financial data he had been accumulating was transformed by the consultant into revealing charts and graphs.

Kirk was generally optimistic about the session and the company’s future until the consultant started talking about the new manufacturing plant the company was adding to the current location and the costs per unit of the chemically plated products it produced. At that time, Bob (the President) and John (the chemical engineer) started talking about waste treatment and disposal problems. John mentioned that the current waste facilities were not adequate to handle the waste products that would be created by the “ultramodern” new plant in a manner that would meet the industry's fairly high standards, although they could still comply with federal standards. Kirk’s boss, Henry, noted that the estimated cost per unit would be increased if the waste treatment facilities were upgraded according to recent industry standards.

While industry standards are presently more stringent than federal regulations, environmentalists are strongly pressuring for more stringent regulations at the federal level. Bob mentioned that since their closest competitor did not have the waste treatment facilities that already existed at their firm, he was not in favor of further expenditure in this area. Most managers at this meeting resoundingly agreed with Bob, and business continued on to another topic.

Kirk did not hear a word during the rest of the meeting. He kept wondering how the company could possibly have such a casual attitude toward the environment. Yet he did not know if, how, or when he could share his opinion. Soon he started reflecting on whether this was the right firm for him. What should Kirk do? Putting Corporate Responsibility first, but recognizing the politics at play, what is the most ethical thing to do? The most practical? What strategy would you suggest to Kirk if he came to you for advice?

Use the Instructions for Case Analyses to craft a response to this case, articulating the main issues and ethical dilemma. Review the assessment criteria below before you begin writing.

Submit a written paper which is 2-3-pages in length exclusive of reference page and that is double-spaced. You should cite relevant resources in APA format.

Papers will be assessed using the following criteria:

The Written assignment:

identifies all the relevant facts of the case
articulates all of the ethical issues including the extent of Kirk's responsibility to take action; how the interests of the firm (and stockholders) can be balanced against the environmental interests; what obligation the company has to future generations and citizens.
identifies all stakeholders
poses all possible alternatives and describes the ethical considerations attached to each
identifies all practical constraints
recommends a specific action Kirk should take (may include leaving the company)
is of high quality, writing is clear and professional
conforms to the structural requirements including APA style guidelines for References.