1. The manager of a company dinner club would like to have an information system that assists him to plan the meals and to keep track of who attends the dinners, and so on.

Because the manager is not an IS expert, the following table is used to store the information. As a member can attend many dinners and a member will not attend more than 1 dinner on the same date, the primary key of the following table is Member ID and Dinner ID. Dinners can have many courses, from one-course dinner to as many courses as the chef desired.

1. Transform the table above into first normal form 1NF. (To do this, check if there are multivalued attributes and transform the table to get rid of them)
   1. Identify the dependencies and which type they are (full dependencies, partial dependencies, transitive dependencies
2. Transform the table above into second normal form 2NF. (To do this separate partial dependencies into separate tables).
3. Transform the table above into third normal form 3NF. (To do this, remove the transitive dependencies by creating separate tables and relate them with the common attribute)

unit 7:1 DB Food

Food and beverage managers use various purchasing methods to control inventory, reduce waste, and build vendor relations. The way materials are processed through the operation, including receiving and storage is vitally important not only to the efficient and profitable operation of the eatery, but also for quality control and health reasons.

Topic 1: Receiving and Storage

Proper purchasing, receiving, and storage of food and beverage items is critical to a food and beverage department’s or eateries’ success. In this Discussion, you will apply what you learned in the Learning Activity and Reading to the following scenario and then respond to the questions.

Scenario: Your hotel restaurant is planning a big Thanksgiving dinner for 400 guests that includes many different types of pie all requiring whipped cream. As the Food and Beverage Manager, you inform your vendor 30 days in advance of the event that you will need 10 gallons of cream. Your vendor misunderstands and has 20 gallons in ten 2-gallon containers, delivered 5 days later to a new receiving clerk who stores nine (9) of the 2-gallon containers the cream immediately. The cook sees 1 of the 2-gallon containers on a preparation table about an hour later and proceeds to use a gallon of the cream in his gravy for that night’s meal. He leaves the remainder on the preparation table shouting to his sous chef’s assistant to put the cream away when he can. Two hours later, the assistant stores the remainder in the refrigerator. Note: The cream has an expiration date three and a half weeks from the sending date.

• What were the problems in this scenario?
• Who should be responsible to remedy this situation and how should they resolve this problem while still obtaining the required amount of cream?
• What changes should be instituted going forward?

This is a comprehensive project evaluation problem bringing together much of what you have learned in this and previous chapters. Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $3.9 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. The land was appraised last week for $4.4 million on an after-tax basis. In five years, the after-tax value of the land will be $4.8 million, but the company expects to keep the land for a future project. The company wants to build its new manufacturing plant on this land; the plant and equipment will cost $37 million to build. The following market data on DEI’s securities are current:

Debt: 210,000 6.4 percent coupon bonds outstanding, 25 years to maturity, selling for 110 percent of par; the bonds have a $1,000 par value each and make semiannual payments.

Common stock: 8,300,000 shares outstanding, selling for $68 per share; the beta is 1.3.

Preferred stock:450,000 shares of 4.5 percent preferred stock outstanding, selling for $79 per share.

Market: 6 percent expected market risk premium; 3.5 percent risk-free rate.

DEI uses HSOB as its lead underwriter. Wharton charges DEI spreads of 10 percent on new common stock issues, 6 percent on new preferred stock issues, and 4 percent on new debt issues. HSOB has included all direct and indirect issuance costs (along with its profit) in setting these spreads. HSOB has recommended to DEI that it raise the funds needed to build the plant by issuing new shares of common stock. DEI’s tax rate is 32 percent. The project requires $1,300,000 in initial net working capital investment to get operational. Assume DEI raises all equity for new projects externally.

Calculate the project’s initial Time 0 cash flow, taking into account all side effects.

(This includes an adjustment for the flotation costs described in the above paragraph.The total costs will be the opportunity cost of the land, the cost of the building and the cost of the working capital.The cost of the building and working capital will require new financing and therefore finance costs.Thus the building and working capital must be adjusted for the flotation costs as discussed in section 14-7 of the 11^th edition and 14-6 of the 10^th edition of the text.It is not necessary to adjust the land costs since we already own the land.)

The new RDS project is somewhat riskier than a typical project for DEI, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of +2 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating DEI’s project.

The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (that is, the end of Year 5), the plant and equipment can be scrapped for $5.1 million. What is the after-tax salvage value of this plant and equipment?

The company will incur $6,700,000 in annual fixed costs. The plan is to manufacture 15,300 RDSs per year and sell them at $11,450 per machine; the variable production costs are $9,500 per RDS. What is the annual operating cash flow (OCF) from this project? Remember in year 5 that besides the cash flows from operation, you also get the salvage, tax benefit, land and the working capital back. Note that while the WC outlay includes the financing costs, the amount back in time 5 will only be the WC amount. So the outlay for WC is 1,300,000 plus financing costs, but you only recover the $1,300,000 since the financing costs have been paid out to your underwriter.

Finally, DEI’s president wants you to throw all your calculations, assumptions, and everything else into the report for the chief financial officer; all he wants to know is what the RDS project’s internal rate of return (IRR) and net present value (NPV) are. What will you report?

Regis International Corporation (RIC), a Denver based technology company, has been applying its expertise in microprocessor technology to develop a small computer specifically designed to control home appliances. Once programmed, the computer would automatically control the heating and air-conditioning system, hot water heater, and even small appliances such as coffee makers. By increasing the energy efficiency of a home, the appliance control computer can save on costs hence pay for itself in a few years. This effort has now reached the stage where a decision on whether or not to go forward with production must be made.RIC’s marketing department plans to target sales of the appliance control computer to the owners of larger homes - the computer is cost effective only on homes with 2,000 or more square feet of heated/air-conditioned space. The marketing vice-president forecasts sales in 2018 to be $40 million and to increase by 7 percent per year. The engineering department has estimated that the firm would need a new manufacturing plant; this plant could be built and made ready for production in 1 year, once the “go” decision is made. The plant would require a 25-acre site, and RIC currently has an option to purchase a suitable tract of land for $1.2 million; the land option must be exercised on December 31, 2016. Building construction would begin in early 2017 and would continue through the end of 2017. The building, which would fall into the MACRS 39-year class (ignore any half-year convention), would cost an estimated $8 million, payable on December 31, 2017.The necessary manufacturing equipment would be installed late in 2017 and would be paid for on December 31, 2017. The equipment, which would fall into the MACRS 7-year class, would have a cost of $6.5 million, including transportation, plus another $500,000 for installation.The project would also require an initial investment in net working capital equal to 12 percent of the estimated sales in the first year. The initial working capital investment would be made on December 31, 2017, and on December 31 of each following year, net working capital would be increased by an amount equal to 12 percent of any sales increase expected during the coming year. The project’s estimated economic life is 6 years. At that time, the land is expected to have a market value of $1.7 million, the building a value of $1.0 million, and the equipment a value of $2 million. The production department has estimated the variable manufacturing costs would total 65 percent of dollar sales, and that fixed overhead costs, excluding depreciation, would be $8 million for the first year of operation. Fixed overhead costs, other than depreciation, are projected to increase with inflation which is expected to average 7 percent per year over the 6 year life of the project.RIC’s marginal tax rate (federal and state) is 40 percent; its weighted average cost of capital is 15%; and the company’s policy, for capital budgeting purposes, is to assume that operating cash flows occur at the end of each year. Since the plant would begin operations on January 1, 2018, the first operating cash flows would thus occur on December 31, 2018. The capital gains tax rate is the same as the ordinary income tax rate.As one of the company’s financial analysts, you have been assigned the task of supervising the capital budgeting analysis. For now, you may assume that the project has the same risk as the firm’s current average project, and hence you may use the corporate cost of capital, 15 percent, for this project. Calculate the NINV, NPV, IRR, and payback period for the appliance control computer project. Create Best Case and Worst Case scenarios based on the Sales number only. Assume the Best and Worst are +/- 25% for Revenues. Also, conduct a best/worst case scenario with operating expenses being 60% and 70% of sales. This will give you a base case, and 4 risk analysis scenarios.In addition to showing the values for the NINV, FCFs, NPV, IRR, and payback period, please provide a copy of your spreadsheet that shows your calculated values for the initial investment, the cash flows, and the salvage value.

Evaluate the proper accounting for transactions with respect to interim and segment reporting using the accounting codification and other accounting research tools.

Scenario

CM Corporation (CMC) was founded six years ago by Phil Connor and Eric Martin. The company designs, installs, and services security systems for high-tech companies. The founders, who describe themselves as "entrepreneurial geeks," met in a computer lab when they were teenagers and found they had common interests in working on security systems for critical industries. CMC hired you as a junior accountant this year.

Lately, Connor and Martin have been working with "radio frequency identification" (RFID) technology. They have developed a detailed system designed to track inventory items using RFID tags embedded invisibly in products. This technology has numerous inventory applications in multiple industries.

One of the most basic applications is tracking manufacturing components; if tagged components "go walking" (if employees attempt to take them), companies can easily track and find them. Connor and Martin have sold their system to several high-tech companies in the area. These companies have a number of government contracts that require extensive security systems to protect sensitive data from infiltration by terrorists and others. To date, CMC's cash flow from sales and services has adequately funded its operations.

CMC expects much growth potential for its products. As a result, they are considering going public and expanding internationally in the near future. Many of the issues you will address in this course project involve researching topics involving these anticipated events.

Instructions

Connor and Martin have heard that IFRS is used internationally for financial statements, but they know very little about it. Since they will most likely be going public and expanding internationally in the near future, they are considering switching to IFRS from GAAP and would like more information. They also realize if they go public and expand their business, they will have to deal with some issues they have not had to deal with previously, such as interim and segment reporting. Prepare a research memorandum for Connor and Martin addressing their questions below:

What are the similarities between GAAP and IFRS?

What are the major differences between GAAP and IFRS?

What are the requirements for interim reporting under both GAAP and IFRS?

Are there any problems or issues associated with interim reporting?

What are the advantages and disadvantages of providing segmented reporting?

What are the requirements for segment reporting under both GAAP and IFRS? Include the definition of an operating segment.

Memorandum Mechanics should be as follows:

The body of the memorandum should be a professional presentation centered on clear and concise writing. The responses to the questions should be detailed, well researched, and specifically related to CMC's industry.

Use the FASB Codification and IFRS to address all technical accounting issues presented in the questions, being certain to reference the applicable sections of the Codification and IFRS in your report. You may quote directly from the Codification and IFRS as long as all direct quotes are included in quotation marks.

Any other sources used to support your responses should similarly be properly documented. You should have other credible sources in addition to the Codification and IFRS.

For the ASC FASB Codification content, please reference asc.fasb.org.

For the Authoritative IFRS standards content, please reference eifrs.ifrs.org.

Suppose the lengths of human pregnancies are normally distributed with muμequals=266266 days and sigmaσequals=1616 days. Complete parts ​(a) and​ (b) below. ​(a) The figure to the right represents the normal curve with mu equals 266μ=266 days and sigmaσequals=1616 days. The area to the leftleft of Upper X equals 240X=240 is 0.05210.0521. Provide two interpretations of this area. Provide one interpretation of the area using the given values. Select the correct choice below and fill in the answer boxes to complete your choice. ​(Type integers or​ decimals.) A. The proportion of human pregnancies that last moremore than nothing days is nothing. B. The proportion of human pregnancies that last lessless than nothing days is nothing. X font size decreased by 3 266266 font size decreased by 3 240240 A normal curve has a horizontal axis labeled "X" and two horizontal coordinates, 240 and 266. The curve's peak is near the top of the graph at horizontal coordinate 266. Two vertical line segments run from the horizontal axis to the curve at 240 and 266. The area under the curve to the left of 240 is shaded. Provide a second interpretation of the area using the given values. Select the correct choice below and fill in the answer boxes to complete your choice. ​(Type integers or​ decimals.) A. The probability that a randomly selected human pregnancy lasts lessless than nothing days is nothing. B. The probability that a randomly selected human pregnancy lasts moremore than nothing days is nothing. ​(b) The figure to the right represents the normal curve with mu equals 266μ=266 days and sigmaσequals=1616 days. The area between xequals=280280 and x equals 295x=295 is 0.15580.1558. Provide two interpretations of this area. Provide one interpretation of the area using the given values. Select the correct choice below and fill in the answer boxes to complete your choice. ​(Type integers or decimals. Use ascending​ order.) A. The proportion of human pregnancies that last between nothing and nothing days is nothing. B. The proportion of human pregnancies that last less than nothing or more than nothing days is nothing. X font size decreased by 3 266266 font size decreased by 3 280280 font size decreased by 3 295295 A normal curve has a horizontal axis labeled "X" and three horizontal coordinates, 266, 280, and 295. The curve's peak is near the top of the graph at horizontal coordinate 266. Three vertical line segments run from the horizontal axis to the curve at 266, 280, and 295. The area under the curve between the vertical line segments at 280 and 295 is shaded. Provide a second interpretation of the area using the given values. Select the correct choice below and fill in the answer boxes to complete your choice. ​(Type integers or decimals. Use ascending​ order.) A. The probability that a randomly selected human pregnancy lasts between nothing and nothing days is nothing. B. The probability that a randomly selected human pregnancy lasts less than nothing or more than nothing days is nothing.

1. What is the importance of the skull?
2. What lightens the skull and warm and moisten the air as it passes into the respiratory system?
3. How many divisions are there for the vertebrae?
4. What are the divisions of the vertebrae?
5. What is another name for coccyx?
6. How many total bones are there in all 5 regions?
7. The sternum belongs to which skeletal region?
8. The ilium belongs to which skeletal region?
9. What is another name for patella?
10. Which is the largest bone in the body?
11. What is the flexible, connective tissue called?
12. Ethmoid, frontal, occipital, parietal, sphenoid, and temporal are all part of what?
13. This plate exists at the ends of long bones where lengthwise growth takes in the immature skeleton.
14. What is the soft spot between the skull bones of an infant?
15. Opening of the occipital bone through which the spinal cord passes is called?
16. What is the upper portion of the sternum called?
17. What is the round projection on the temporal bone behind the ear called?
18. What is the flared portion of a long bone, between the diaphysis and the epiphyseal plate?
19. What is the name of a medical doctor who specializes in bone, joint, and muscle conditions?
20. What is the process of bone formation?
21. Name the bone cells that helps form bony tissue.
22. Name the medical doctor who specializes in rehabilitation?
23. Name the twelve pairs of curved bones that form the chest wall.
24. What is the pole-like process extending from the temporal bone on each side of the skull?
25. What is the immovable joint between bones?
26. Name the Lower, narrow portion of sternum.
27. What is the knuckle-like process at the end of a bone near the joint.
28. Name the upper arm bone.
29. What is the lower jaw bone called?
30. What is the upper jaw bone called?
31. What are free, movable joints such as ball and socket or hinge type of joints called?
32. What is a crescent-shaped fibrocartilaginous structure that partly divides a join cavity?
33. Closed sacks of synovial fluid with a synovial membrane located near, but not within a joint.
34. What is loss of articular cartilage and formation of bone spurs at articular surfaces?
35. The disease that causes inflammation due to excessive uric acid in body.
36. What is the compression of median nerve as it passes between transverse ligament and bones and tendons of the wrist?
37. What is a fluid-filled cyst arising from the joint capsule or a tendon in the wrist?
38. What disease is often marked by a “bull’s eye” rash at the site of the tick bite?
39. What chronic inflammatory disease involves joints, skin, kidneys, nervous system, heart and lungs affecting collagen in tendons, ligaments, bones, and cartilage all over the body?
40. Name 3 types of muscles.
41. What type of muscles are under voluntary control?
42. Which type of muscle is not consciously controlled and found exclusively in the heart?
43. Which type of movement is away from the midline of the body?
44. Which type of movement is toward the midline of the body?
45. Which type of movement is circular movement around a central point?
46. Name a group of inherited diseases with progressive muscle weakness and degeneration?
47. What is a uric acid test used to diagnose?
48. What is the acronym for nonsteroidal anti-inflammatory drug?
49. For what conditions might an ESR be requested?
50. Which type of movement is bending the sole of the foot downward toward the

Read the following article to assess if this claim scientific by answering the questions that follow:

The term lunar effect refers to correlations between specific stages of the roughly 29.5-day lunar cycle and behavior in humans or other living things. In some cases these rhythms may depend on external cues, such as a greater or smaller amount of moonlight due to the moon's phases. A considerable number of studies have examined the effect on humans. By the late 1980s, there were at least 40 published studies on the purported lunar-lunacy connection,and at least 20 published studies on the purported lunar-birthrate connection. However, several extensive literature reviews and meta-analyses found no correlation between the lunar cycle and human biology or behavior.

.

Other studies found evidence that those with mental disorders i.e. Schizophrenia generally exhibit 1.8% of increased violent or aggressive episodes during the full Moon, but a more recent study found no such correlation to that of non-schizophrenic human beings^. An analysis of mental-health data found a significant effect of Moon phases, but only on schizophrenic patients.

A recent study of 33 volunteers that did not account for age and sex found a statistically significant connection between sleep quantity and quality and lunar phases, even though the subjects could not see the moon or its light.  A July 2013 study carried out at the University of Basel in Switzerland suggests a correlation between the full Moon and human sleep quality.^[5] Professor Cajochen and colleagues presented evidence that a lunar rhythm can modulate sleep structure in humans when measured under the highly controlled conditions of a circadian laboratory study protocol without time cues. Studying 33 volunteer subjects, the researchers found that subjective and objective measures of sleep varied according to lunar phase and thus may reflect human circalunar rhythmicity. Stringently controlled laboratory conditions, in a cross-sectional setting, were employed to exclude confounding effects such as increased light at night or the potential bias in perception. Measures of lunar influence on sleep structure, electroencephalographic activity during non-rapid eye movement sleep (NREM), and secretion of the hormones melatonin and cortisol, were retrospectively analyzed.   Cajochen said: "The lunar cycle seems to influence human sleep, even when one does not 'see' the Moon and is not aware of the actual Moon phase."

However, there are suggestions that the 2013 Cajochen study is faulty because of a relatively small (n=33) sample size and inappropriate controls for age and sex. A 2014 study with larger sample sizes (n1=366, n2=29, n3=870) and better experimental controls found no effect of the lunar phase on sleep quality metrics. A 2015 study of 795 children found a 3 minute increase in sleep duration near the full moon, but a 2016 study of 5,812 children found a 5 minute decrease in sleep duration near the full moon. No other modification in activity behaviors were reported, and the lead scientist concluded: "Our study provides compelling evidence that the moon does not seem to influence people's behavior."

1. What are the scientific bases for the claim that there is a lunar effect on human behavior?

Kat works as a global marketing manager for New Balance, a sneaker and apparel company located just outside of downtown Boston. She loves to eat at the restaurant near her office. Her favorite food is their specialty, Cuban sandwiches. If you're looking for Kat, you never have to look too far; you can find her here daily.
Kat hires a new member for her team, Marnie who recently transferred from their Middle East location. Marnie joins Kat for the Cuban sandwich on her first day and loves it. When they get on the elevator to go back to their office, Kat chuckles and says that every time she leaves the restaurant she says she smells like a cab driver.
Marnie was silent, not sure how to respond to Kat's comment. Marnie was offended, her boyfriend drives a cab.
What if the elevator was occupied by workers whose parents drove cabs? How could Kat's comments be taken? Choose all that apply.

Select one or more:

a. Kat's comment could be viewed as ignorant, racist, or offensive

b. Kat's comment is funny

c. Wow, what kind of company does she work for?

d. Ugh, I don't want to want to come here again

Kat works as a global marketing manager for New Balance, a sneaker and apparel company located just outside of downtown Boston. She loves to eat at the restaurant near her office. Her favorite food is their specialty, Cuban sandwiches. If you're looking for Kat, you never have to look too far; you can find her here daily.
Kat hires a new member for her team, Marnie who recently transferred from their Middle East location. Marnie joins Kat for the Cuban sandwich on her first day and loves it. When they get on the elevator to go back to their office, Kat chuckles and says that every time she leaves the restaurant she says she smells like a cab driver.
Marnie was silent, not sure how to respond to Kat's comment. Marnie was offended, her boyfriend drives a cab.
Kat has a meeting with a new client Abe from Algeria. He was riding in the elevator when Kat made the comment about smelling like a cab driver. Abe's father is a cab driver. His mother was recently diagnosed with breast cancer and the doctor said that it was likely caused by the deodorant she was wearing and requested that she stop wearing deodorant while she is being treated with chemotherapy. She is very self-conscious about not wearing deodorant. Abe is extremely appalled at Kat's comments and requests to speak with Kat's manager. What could happen as a result of Kat's behavior? Choose all that apply.

Select one or more:

a. Kat's manager removes Kat from the project

b. Kat receives additional training on how to be more culturally aware

c. Abe does not sign the contract and claims that it was Kat's comments that was the deciding factor

d. Marnie becomes head of the project and Abe signs the contract

e. Nothing, Kat was trying to be funny and this has been taken out of context

Misc Information: Mr. Burns sold off all of his fixed assets from the nuclear power plant. Also, there was an adjustment to the allowance for uncollectible account during your brief respite. Mr. Smithers performed the necessary entries to get the books up to date; this included the reduction of the mortgage payable. However, you will calculate interest expense, bad debt expense, and depreciation expense. These amounts will not be given to you. Good luck and time manage appropriately. ***For any note/mortgage payable, you find interest expense the same way you find interest revenue. ***

Check Figures:

                        Unadjusted Net Loss: ($9,737)

                        Adjusted Net Loss: ($360,991)

Journal Entries:

1. January 2: After returning from exile, Mr. Burns invested $600,000 of personal funds directly in the business (retained earnings) to strengthen his grip on the cookie market. No common stock ownership was given.

2. January 3: In order to keep the IRS off his trail, Mr. Burns transferred money from his personal account into a Cayman Island secret account for $1,000,000.

3. January 3: In order to expand his cookie factory and be able to dump toxic waste without being impeded by the Feds, Mr. Burns bought land for cash for $500,000. The bald children in the park were drawing attention from the Environmental Protection Agency.

4. January 4: After threatening to block out the sun, Mr. Burns was able to collect $115,000 of the 2020 accounts receivable beginning balance.

5. January 5: In order to ease his beginning of the year cash flow crunch, Mr. Burns issued Common Stock (1,500,000 shares at $2.00 per share). The Par Value is $1.00 per share.

6. February 1: In order to keep up with being 104 year old hip evil billionaire, Mr. Burns decided to purchase a new truck. The truck cost $60,000. Mr. Burns put a down payment on the truck of $10,000 and took out a note for the rest (long term). The interest rate of the note is 10%. The truck will depreciated by miles. The expected life of the truck is 100,000 miles.

7. February 20: Mr. Burns sold his delicious cookies to Candy Store on account $300,000. Mr. Burns offered terms 2/20, n40. The cost of merchandise sold was $150,000.

8. February 28: Mr. Burns bought cookie dough (inventory) to keep the cookie assembly line going. Mr. Burns paid cash for the cookie dough $400,000

9. March 1^st. Mr. Burns reclassed the current portion of long term notes payable. Reclass only the portion on the balance sheet as of January 1st, 2020.

10. March 5: Mr. Burns paid for the following expenses that came in: Sales Salary Expense $70,000, Advertising Expense $50,000, and Delivery Expense $40,000. All of the expenses were paid in one transaction.

11. March 6: Mr. Burns collected $30,000 of the 1/1/2020 balance of the note receivable from Mayor Quimby. The interest rate was 15% and the Note was written on July 1^th, 2019

12. March 7: The Candy Store paid Mr. Burns what they owed him on account.

13. March 15: Mr. Burns paid income tax payable owed from last year.