24. Figure 4-38 shows an EER diagram for a university dining service organization that provides dining services to a major university.
a. Transform the EER diagram to a set of relations and develop a relational schema.
b. Diagram the functional dependencies and determine the normal form for each relation.
c. Convert all relations to third normal form, if necessary, and draw a revised relational schema.

In: Other
7. Mr Slumber Kotoko was a full-time employee of Bank of Botswana earning P200, 000.00 per year when he decided to enrol for a four year course at the University of Botswana. He can only earn P70 000.00 per year as a part time worker. What is the opportunity cost of going to University for Mr Kotoko over the four year period
In: Economics
Give numerical values for order-of-magnitude estimates for the following quantities. Explain and justify the reasonableness of the assumptions and approximations that you need to make.
(a) The number of cars that pass through an intersection of two busy streets during the evening commute on a typical workday
(b) The number of bricks that form the exterior of a large building on a university campus
(c) The volume of concrete in the sidewalks on a university campus
In: Mechanical Engineering
Access the Bank of Canada web site to answer the four parts below.
In: Economics
|
Account |
June 30 2020 |
June 30 2019 |
|
$ |
$ |
|
|
Cash and cash equivalents |
95,800 |
64,000 |
|
Debtors |
231,600 |
157,200 |
|
Inventory |
96,720 |
104,400 |
|
Plant and equipment |
100,000 |
75,000 |
|
Accumulated depreciation – plant and equipment |
(40,000) |
(29,000) |
|
Total assets |
484 120 |
371,600 |
|
Creditors |
71,000 |
74,400 |
|
Accrued expenses |
30,000 |
33,000 |
|
Long-term loan |
100,000 |
50,000 |
|
Capital and reserves |
283,120 |
214,200 |
|
Total liabilities and owners equity |
484 120 |
371,600 |
|
Sales |
440,000 |
|
|
Less: Cost of goods sold |
296,000 |
|
|
Gross profit |
144,000 |
|
|
Operating expenses (including depreciation) |
84,000 |
|
|
Net profit |
60,000 |
|
Note: 1. No plant and equipment was sold during the year.
2. Dividends of $20,000 in cash were paid during the year.
3. All sales are on credit.
REQUIRED:
Prepare a statement of cash flows for the year ended 30 June 2020 using the direct method.
Triple Threat
Statement of Cash Flows for the year ended 30 June 2020
Cash flows from operating activities
Cash flows from investing activities
Cash flows from financing activities
Cash at end of the year
In: Accounting
1.)
The time college students spend on the internet follows a Normal distribution. At Johnson University, the mean time is 5.5 hours per day with a standard deviation of 1.1 hours per day.
2.)
A manufacturer knows that their items have a normally
distributed lifespan, with a mean of 10.1 years, and standard
deviation of 0.5 years.
If 19 items are picked at random, 3% of the time their mean life
will be less than how many years?
Give your answer to one decimal place.
In: Statistics and Probability
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 180 | units | @ $52.60 per unit | |||||||
| Mar. | 5 | Purchase | 265 | units | @ $57.60 per unit | |||||||
| Mar. | 9 | Sales | 340 | units | @ $87.60 per unit | |||||||
| Mar. | 18 | Purchase | 125 | units | @ $62.60 per unit | |||||||
| Mar. | 25 | Purchase | 230 | units | @ $64.60 per unit | |||||||
| Mar. | 29 | Sales | 210 | units | @ $97.60 per unit | |||||||
| Totals | 800 | units | 550 | units | ||||||||
1. Compute cost of goods available for sale and the number of units available for sale.
2. Compute the number of units in ending inventory.
3.Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 105 units from beginning inventory and 235 units from the March 5 purchase; the March 29 sale consisted of 85 units from the March 18 purchase and 125 units from the March 25 purchase. (Round weighted average cost per unit to 2 decimal places.)
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 105 units from beginning inventory and 235 units from the March 5 purchase; the March 29 sale consisted of 85 units from the March 18 purchase and 125 units from the March 25 purchase. (Round weighted average cost per unit to two decimals.)
In: Accounting
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 180 | units | @ $52.60 per unit | |||||||
| Mar. | 5 | Purchase | 265 | units | @ $57.60 per unit | |||||||
| Mar. | 9 | Sales | 340 | units | @ $87.60 per unit | |||||||
| Mar. | 18 | Purchase | 125 | units | @ $62.60 per unit | |||||||
| Mar. | 25 | Purchase | 230 | units | @ $64.60 per unit | |||||||
| Mar. | 29 | Sales | 210 | units | @ $97.60 per unit | |||||||
| Totals | 800 | units | 550 | units | ||||||||
Required:
1. Compute cost of goods available for sale and
the number of units available for sale.
2. Compute the number of units in ending inventory.
3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 105 units from beginning inventory and 235 units from the March 5 purchase; the March 29 sale consisted of 85 units from the March 18 purchase and 125 units from the March 25 purchase.
4. Compute gross profit earned by the company
for each of the four costing methods. For specific identification,
the March 9 sale consisted of 105 units from beginning inventory
and 235 units from the March 5 purchase; the March 29 sale
consisted of 85 units from the March 18 purchase and 125 units from
the March 25 purchase. (Round weighted average cost per
unit to two decimals and final answers to nearest whole
dollar.)
In: Accounting
5-1A Perpetual: Alternative cost flows LO P1
[The following information applies to the questions
displayed below.]
Warnerwoods Company uses a perpetual inventory system. It entered
into the following purchases and sales transactions for
March.
| Date | Activities | Units Acquired at Cost | Units Sold at Retail | |||||||||
| Mar. | 1 | Beginning inventory | 210 | units | @ $53.20 per unit | |||||||
| Mar. | 5 | Purchase | 280 | units | @ $58.20 per unit | |||||||
| Mar. | 9 | Sales | 370 | units | @ $88.20 per unit | |||||||
| Mar. | 18 | Purchase | 140 | units | @ $63.20 per unit | |||||||
| Mar. | 25 | Purchase | 260 | units | @ $65.20 per unit | |||||||
| Mar. | 29 | Sales | 240 | units | @ $98.20 per unit | |||||||
| Totals | 890 | units | 610 | units | ||||||||
Problem 5-1A Part 3
1. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, the March 9 sale consisted of 120 units from beginning inventory and 250 units from the March 5 purchase; the March 29 sale consisted of 100 units from the March 18 purchase and 140 units from the March 25 purchase.
4. Compute gross profit earned by the company for each of the four costing methods. For specific identification, the March 9 sale consisted of 120 units from beginning inventory and 250 units from the March 5 purchase; the March 29 sale consisted of 100 units from the March 18 purchase and 140 units from the March 25 purchase
In: Accounting
#3
REVISED PROBLEM 13-42
ACC 650 - Management Accounting
Megatronics Corporation, a massive retailer of electronic
products, is organized in four separate divisions.
The four divisional managers are evaluated at year-end, and bonuses
are awarded based on ROI.
Last year, the company as a whole produced a 13 percent return on
its investment.
During the past week, management of the company’s Northeast
Division was approached about the
possibility of buying a competitor that had decided to redirect its
retail activities. (If the competitor is
acquired, it will be acquired at its book value.) The data that
follow relate to recent performance of the
Northeast Division and the competitor:
| NE DIVISION | COMPETITOR | |
| SALES | $8,600,000 | $4,250,000 |
| VARIABLE COSTS | 75% of sales | 60% of sales |
| FIXED COSTS | $1,800,000 | $1,600,000 |
| INVESTED CAPITAL | $3,100,000 | $225,000 |
Management has determined that in order to upgrade the
competitor to Megatronics’ standards, an
additional $275,000 of invested capital would be needed.
REQUIRED:
3. What is the likely reaction of Megatronics’ corporate
management toward the acquisition? Why?
In: Accounting