Struggling a little bit with one of my homework questions. we are to create an ER digram from the following business rules using UML notation, we are encouraged to uses weak entities, sub classes and ternary relationships. Thank you in advance
You have just been employed as a database designer in a well-established software development firm. Your first job is to design and implement a database system for an airline booking company. The following information has been gathered after analysing the current practices of the company.
• The system records information about flight bookings by customers.
• Customers are identified by an email address and have a phone number and a name.
• Customers make bookings for specific instances of a flight. The booking has a reference number for easy lookup and records the credit card number and the seat number on the flight. Each customer makes their own booking.
• Each flight has a unique flight code, which identifies the scheduled departure time, departure gate and departure airport of the flight, as well as the scheduled arrival time, arrival gate and arrival airport of the flight.
• Each airport has a unique airport code, and has a city.
• Flights repeat each day, e.g. a flight with the code QF430 is scheduled to depart Melbourne Airport at 9:30am each day from gate 3 and arrive at 10:55am at Sydney Airport at gate 2. Your design should not repeat common information for each daily flight.
• The status of a specific flight (e.g. boarding) will depend on the scheduled date of the specific flight instance.
• The pilot will also vary from flight to flight, but each specific flight has exactly 2 pilots. Pilots have an employee id and a name.
• Similarly, the aircraft used can vary from flight to flight, but each specific flight is on board a specific aircraft.
• Aircrafts have a tail number to identify them and have a specific model.
In: Computer Science
The Award Plus Company manufactures medals for winners of athletic events and other contests. Its manufacturing plant has the capacity to produce 10,000 medals each month.
Current production and sales are 7,500 medals per month. The company normally charges $150 per medal.
Cost information for the current activity level is as follows:
Variable costs that vary with number of units produced
| Direct materials | $262,500 |
| Direct manufacturing labour | 300,000 |
| Variable costs (for setups, materials handling,qualitycontrol, and so on) that vary with number of batches, 150 batches * $500 per batc | 75,000 |
| Fixed manufacturing costs | 275,000 |
| Fixed marketing costs | 175,000 |
| Total costs | $1,087,500 |
Award Plus has just received a special one-time-only order for 2,500 medals at $100 per medel.
Accepting the special order would not affect the company's regular business.
Award Plus makes medals for its existing customers in batch sizes of 50 medals (150 batches 50 medals per batch = 7,500 medals). The special order requires Award Plus to make the medals in 25 batches of 100 each.
1. Should Award Plus accept tis special order? Show your calculations.
2. Suppose plant capacity were only 9,000 medals instead of 10,000 medals each month. The special order must either be taken in full or be rejected completely.
Should Award Plus accept the special order? Show your Calculations.
3. As in requirement 1, assume that monthly capacity is 10,000 medals. Award Plus is concerned that if it accepts the special order, its existing customers will immediately demand a price discount of $10 in the month in which the special order is being filled
They would argue that Award Plus's capacity costs are now being spread over more units and that existing customers should get the benefit of these lower costs.
Should Award Plus accept the special order under these conditions? Show your calculations.
In: Accounting
The
Gold Plus
Company manufactures windows. Its manufacturing plant has the capacity to produce
6,000
windows each month. Current production and sales are
5,000
windows per month. The company normally charges
$200
per window.
|
Variable costs that vary with number of units produced |
|
|
Direct materials |
$150,000 |
|---|---|
|
Direct manufacturing labor |
75,000 |
|
Variable costs (for setups, materials handling, quality control, and so on) that vary with number of batches, 200 batches × $1,000 per batch |
200,000 |
|
Fixed manufacturing costs |
200,000 |
|
Fixed marketing costs |
25,000 |
|
Total costs |
$650,000 |
Gold Plus
has just received a special one-time-only order for
1,000
windows at
$175
per window. Accepting the special order would not affect the company's regular business or its fixed costs.
Gold Plus
makes windows for its existing customers in batch sizes of
25
windows
(200
batches ×
25
windows per batch =
5,000
windows). The special order requires
Gold Plus
to make the windows in
10
batches of
100
windows.
|
1. |
Should
Gold Plus accept this special order? Show your calculations. |
|
2. |
Suppose plant capacity were only
5,500 windows instead of6,000 windows each month. The special order must either be taken in full or be rejected completely. ShouldGold Plus accept the special order? Show your calculations. |
|
3. |
As in requirement 1, assume that monthly capacity is
6,000 windows.Gold Plus is concerned that if it accepts the special order, its existing customers will immediately demand a price discount of$5 in the month in which the special order is being filled. They would argue thatGold Plus's capacity costs are now being spread over more units and that existing customers should get the benefit of these lower costs. ShouldGold Plus accept the special order under these conditions? Show your calculations. |
In: Accounting
Financial information for two companies are presented below.
Fill in the missing amounts.
|
Sandhill Company |
Carla Vista Company |
|||
| Sales revenue | $ 90,800 | $ | ||
| Sales returns and allowances | $ 5,000 | |||
| Net sales | 83,000 | 127,000 | ||
| Cost of goods sold | 55,200 | |||
| Gross profit | $ | 41,000 | ||
| Operating expenses | 14,580 | |||
| Net income | $ | 18,000 |
eTextbook and Media
List of Accounts
Calculate the profit margin and the gross profit rate for each company. (Round answers to 1 decimal place, e.g. 15.5%.)
|
Sandhill Company |
Carla Vista Company |
|||||
| Profit margin | % | % | ||||
| Gross profit rate | % | % | ||||
In: Accounting
Purchase-Related Transactions Using Perpetual Inventory System
The following selected transactions were completed by Niles Co. during March of the current year:
| Mar. 1. | Purchased merchandise from Haas Co., $18,800, terms FOB shipping point, 2/10, n/eom. Prepaid freight of $525 was added to the invoice. |
| 5. | Purchased merchandise from Whitman Co., $15,350, terms FOB destination, n/30. |
| 10. | Paid Haas Co. for invoice of March 1. |
| 13. | Purchased merchandise from Jost Co., $4,900, terms FOB destination, 1/10, n/30. |
| 14. | Issued debit memo to Jost Co. for $900 of merchandise returned from purchase on March 13. |
| 18. | Purchased merchandise from Fairhurst Company, $12,750, terms FOB shipping point, n/eom. |
| 18. | Paid freight of $260 on March 18 purchase from Fairhurst Company. |
| 19. | Purchased merchandise from Bickle Co., $11,350, terms FOB destination, 2/10, n/30. |
| 23. | Paid Jost Co. for invoice of March 13, less debit memo of March 14. |
| 29. | Paid Bickle Co. for invoice of March 19. |
| 31. | Paid Fairhurst Company for invoice of March 18. |
| 31. | Paid Whitman Co. for invoice of March 5. |
Required: Journalize the entries to record the transactions of Britt Co. for March.Sales-Related Transactions Using Perpetual Inventory System
Sales-Related Transactions Using Perpetual Inventory System
The following selected transactions were completed by Green Lawn Supplies Co., which sells irrigation supplies primarily to wholesalers and occasionally to retail customers:
| July 1. | Sold merchandise on account to Landscapes Co., $14,300, terms FOB shipping point, n/eom. The cost of merchandise sold was $8,600. |
| 2. | Sold merchandise for $20,500 plus 6% sales tax to retail cash customers. The cost of merchandise sold was $13,300. |
| 5. | Sold merchandise on account to Peacock Company, $35,100, terms FOB destination, 1/10, n/30. The cost of merchandise sold was $22,800. |
| 8. | Sold merchandise for $12,400 plus 7% sales tax to retail customers who used VISA cards. The cost of merchandise sold was $7,400. |
| 13. | Sold merchandise to customers who used MasterCard cards, $5,500. The cost of merchandise sold was $3,500. |
| 14. | Sold merchandise on account to Loeb Co., $11,700, terms FOB shipping point, 1/10, n/30. The cost of merchandise sold was $6,900. |
| 15. | Received check for amount due from Peacock Company for sale on July 5. |
| 16. | Issued credit memo for $1,800 to Loeb Co. for merchandise returned from sale on July 14. The cost of the merchandise returned was $1,000. |
| 18. | Sold merchandise on account to Jennings Company, $6,300, terms FOB shipping point, 2/10, n/30. Paid $230 for freight and added it to the invoice. The cost of merchandise sold was $3,800. |
| 24. | Received check for amount due from Loeb Co. for sale on July 14 less credit memo of July 16. |
| 28. | Received check for amount due from Jennings Company for sale of July 18. |
| 31. | Paid Black Lab Delivery Service $1,900 for merchandise delivered during July to customers under shipping terms of FOB destination. |
| 31. | Received check for amount due from Landscapes Co. for sale of July 1. |
| Aug. 3. | Paid Hays Federal Bank $1,100 for service fees for handling MasterCard and VISA sales during July |
| 10. | Paid $2,410 to state sales tax division for taxes owed on sales. |
Required:
Journalize the entries to record the transactions of Green Lawn Supplies Co. For a compound transaction, if no entry is required, leave the entry box blank.
In: Accounting
M. K. Gallant is president of Kranbrack Corporation, a company whose stock is traded on a national exchange. In a meeting with investment analysts at the beginning of the year, Gallant had predicted that the company’s earnings would grow by 20% this year. Unfortunately, sales have been less than expected for the year, and Gallant concluded within two weeks of the end of the fiscal year that it would be impossible to report an increase in earnings as large as predicted unless some drastic action was taken. Accordingly, Gallant has ordered that wherever possible, expenditures should be postponed to the new year—including canceling or postponing orders with suppliers, delaying planned maintenance and training, and cutting back on end-of-year advertising and travel. Additionally, Gallant ordered the company’s controller to carefully scrutinize all costs that are currently classified as period costs and reclassify as many as possible as product costs. The company is expected to have substantial inventories at the end of the year.
Required:
1. Why would reclassifying period costs as product costs increase this period’s reported earnings?
2. Do you believe Gallant’s actions are ethical? Why or why not?
In: Accounting
On January 1, 20X1, Metro Plaza Inc. (MPI), a real estate company using IFRS, issued$1,000,000, 8%, five year bonds for a cash price of $1,250,000. Interest is payable semi-annually on June 30 and December 31. Each $100 bond includes 20 warrants. Each warrant can be exchanged for one common share of MPI at an exercise price of $10 per share. The market rate of interest is 6% for similar bonds without warrants and the fair market value of these bonds was determined to be $1,085,302.
Required:
Note: You may find it useful and easier to answer this question by preparing a bond amortization table.
In: Accounting
On January 1, 20X1, Metro Plaza Inc. (MPI), a real estate company, using IFRS, issued $1,000,000, 8%, five year bonds for a cash price of $1,250,000. Interest is payable semi-annually on June 30 and December 31. Each $100 bond includes 20 warrants. Each warrant can be exchanged for one common share of MPI at an exercise price of $10 per share. The market rate of interest is 6% for similar bonds without warrants and the fair market value of these bonds was determined to be $1,085,302.
Required:
Note: You may find it useful to answer this question by preparing a bond amortization table.
In: Accounting
QUESTION TWO
|
Class I |
Class II |
Class III |
Class IV |
|
Sh. |
Sh. |
Sh. |
Sh. |
|
875,000 |
2,500,000 |
1,750,000 |
3,725,000 |
Disposals during the year.
|
Class I |
Class II |
Class III |
Class IV |
|
900,000 |
125,000 |
- |
90,000 |
The new hotel building was brought to use on 1.9.2019
Required
In: Accounting
Net Present Value Method—Annuity
E & T Excavation Company is planning an investment of $222,900 for a bulldozer. The bulldozer is expected to operate for 1,000 hours per year for five years. Customers will be charged $130 per hour for bulldozer work. The bulldozer operator costs $26 per hour in wages and benefits. The bulldozer is expected to require annual maintenance costing $10,000. The bulldozer uses fuel that is expected to cost $34 per hour of bulldozer operation.
| Present Value of an Annuity of $1 at Compound Interest | |||||
| Year | 6% | 10% | 12% | 15% | 20% |
| 1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
| 2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
| 3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
| 4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
| 5 | 4.212 | 3.791 | 3.605 | 3.353 | 2.991 |
| 6 | 4.917 | 4.355 | 4.111 | 3.785 | 3.326 |
| 7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
| 8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
| 9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
| 10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
a. Determine the equal annual net cash flows from operating the bulldozer. Enter all amounts as positive numbers.
| Cash inflows: | ||||
| Hours of operation | ||||
| Revenue per hour | ×$ | |||
| Revenue per year | $ | |||
| Cash outflows: | ||||
| Hours of operation | ||||
| Fuel cost per hour | $ | |||
| Labor cost per hour | ||||
| Total fuel and labor costs per hour | ×$ | |||
| Fuel and labor costs per year | ||||
| Maintenance costs per year | ||||
| Annual net cash flow | $ | |||
b. Determine the net present value of the investment, assuming that the desired rate of return is 10%. Use the table of present value of an annuity of $1 above. If required, round to the nearest dollar and use the minus sign to indicate a negative net present value.
| Present value of annual net cash flows | $ |
| Less amount to be invested | |
| Net present value | $ |
c. E & T Excavation should Selectsupportnot supportItem 14 the investment because the bulldozer cost is SelectgreaterlessItem 15 than the present value of the cash flows at the SelectmaximumminimumItem 16 desired rate of return of 10%.
In: Accounting