For this assignment you will be creating a basic Hotel Reservation System. The program must meet the following guidelines:

• User can reserve up to 3 rooms at a time
  • Your program will need to loop through to continue to ask needed questions to determine cost.
• Room rates (room variants):
  • Suite $250
  • 2 Queens $150
  • 1 King $175
  • Ocean view add $50
  • Fridge for Room $25
  • Pets additional $50
• Sales tax rate will be 5.5%
• Your program will show out the total for each room reserved after the user has put in the necessary information. Once all rooms are entered the program will print out the grand total.

Make sure you are using Variables, Looping, and decision statements!

Homework 3:

A car dealer pays $17,985 for each car purchased. The annual holding rate is estimated at 25%, and the ordering cost is $7,558. The dealer is selling an average of 516 cars a year.

3. Note the new information:

• The dealership can only park 45 cars in its small parking lot. Therefore, if needed, it will lease a nearby bigger parking lot, and use it to park access inventory.

• The dealer can get a discount of $1000 on the car's price if his order size is 275 cars or more.

3-1: If the dealer rejects the discount offer, what will be his order size?

a. 42 cars

b. 43 cars

c. 45 cars

d. None of the above.

3-2: If the dealer decides to accept the offer to order 275 cars, he uses the leased parking lot as a "Warehouse", and each time a car is sold from the small parking lot, he transfers a car from the leased large lot. Therefore, in his own lot, there are all the time 45 cars on display, but the inventory in the large lot is gradually depleting. What is the average inventory the dealership carry in the leased parking lot?

a. 275 cars    

b. 275/2 cars

c. 38+(275/2)      

d. 237/2

3-3 A car kept in the leased parking lot costs the dealer additional $250 in holding cost (which increases Ch¬). Calculate the annual total cost if the dealer decides to accept the "275" deal. Break down the costs: Annual Ordering cost, Annual Holding cost in the small parking lot, Annual Holding cost in the leased parking lot, Annual Purchasing cost. (not multiple choice, show work)

Pleasanton Studios Kersten Brown, the CEO of Pleasanton Studios, is having a tough week - all three of her top management level employees have dropped in with problems. One executive is making questionable decisions, another is threatening to quit, and the third is reporting losses (again). Kersten is hoping to find simple answers to all her difficulties. She is asking you (her accountant) for some advice on how to proceed. Pleasanton Studios owns and operates three decentralized divisions: Entertainment, Streaming, and Parks. Pleasanton Studios has a decentralized organizational structure, where each division is run as an investment center. Division managers meet with the CEO at least once annually to review their performance, where each division manager's performance is measured by their division's return on investment (ROI). The division manager then receives a bonus equal to 10% of their base salary for every ROI percentage point above the cost of capital. The Entertainment division manager, John Freeman, was the first to knock on Kersten's door this morning. Entertainment, Pleasanton Studios' first endeavor, produces movies for the big screen. Entertainment has been in operation since 1965. Last month, John had mentioned a proposal to build a new animation studio. The build would cost $4,910,000 with an estimated life of 20 years and no salvage value and would allow Entertainment to start producing animated movies. Animated movies were projected to bring in an additional $1,210,000 in revenues each year, but would increase annual production costs by $574,000. John had dropped in to let Kersten know he had decided not to move forward with the animation studio. This surprised Kersten - her quick mental calculation indicated that the studio would have a payback period of 8 years, much shorter than the expected life of the studio. Not entirely sure that her quick assessment was valid, Kersten needed to check with her accountant on the matter. Next to Kersten's door was the manager of Streaming, which produces short-form (30 minute to one hour) episodes in addition to streaming the movies developed by Entertainment. Customers then buy subscriptions to the service. Run by division manager Reyna Imanah, Streaming was introduced in 2016 and has increased subscriptions by 20% every year since. Reyna's complaint was that, based on the current bonus payout schedule, John Freeman's bonus last year was significantly higher than hers. She points to the increasing subscription rates at Streaming, and says that her division is being punished for having opened so recently (her division's facilities are much more recent than those in Entertainment). She currently has an employment offer from another company at the same base pay rate, and stated that she will accept this offer unless she feels her performance is being appropriately acknowledged and compensated. Kersten needs to look at the relative performance across divisions to determine how to proceed with Reyna. Pleasanton Parks is a theme park based on the movies from Entertainment and the series from Streaming. For many years, it was a popular year-round destination, with characters, rides, and a hotel. This park has lost popularity in recent years, and has been 'in the red' for the past two years. If the park is not profitable this year, you will need to decide whether to permanently close that division. Included in the 'Fixed COGS' for Parks is an annual $1,650,000 mortgage payment on the land and buildings for the park, which would still need to be paid (as a corporate level cost) if the park is closed and that segment is removed from the financial statements. Incidentally, you recently had a conversation with a Marriott Hotels executive, who would like to expand into the area. If you decided to close Parks, you are fairly certain that you could lease the hotel facilities to Marriott for $650,000 annually. A partial report of this year's financial results for Pleasanton Studios can be found in Table 1 below. The 'Selling and admin costs' listed in Table 1 are directly incurred by each division, and are determined at the beginning of each year (that is, they do not change with increased/decreased production). In addition to the divisional information above, there are $2,000,000 in corporate costs that are currently allocated evenly between the three divisions. These costs are primarily due to employee benefits costs, which are billed at the corporate level. If the Parks division is closed, the decreased employee base would reduce allocated corporate costs by $500,000. Pleasanton Studios has a cost of capital of 12 percent (and Kersten uses the cost of capital as their required rate of return) and are subject to 32% income taxes. Before she can make any decisions, Kersten needs to evaluate this year's performance results. She sets off to see you, the company's accountant, for answers.

Table 1: Pleasanton Studios current year data Experience Streaming Parks Revenues $54,583,520 $30,184,570 $7,564,270 Fixed COGS $3,356,850 $4,074,530 $3,159,430 Variable COGS $40,257,310 $22,020,695 $3,698,928 # of customers 15,264,200 1,420,060 30,240 # of employees 11,562 1,954 1,378 Average net operating assets $29,014,000 $19,252,000 $420,000 Selling and admin costs $3,259,520 $944,620 $231,900  

b. Evaluate Entertainment's decision not to invest in the new animation studio (i.e., was the decision appropriate and in the best interests of Pleasanton Studios), including the appropriate financial analyses to support your evaluation. c. Evaluate the validity of Reyna Imanah's complaint regarding her evaluated performance. Explain why it is (or is not valid), and what further information would be necessary. d. Provide a recommendation on whether to close the Parks division, including all necessary financial analyses.

Kersten Brown, the CEO of Pleasanton Studios, is having a tough week - all three of her top management level employees have dropped in with problems. One executive is making questionable decisions, another is threatening to quit, and the third is reporting losses (again). Kersten is hoping to find simple answers to all her difficulties. She is asking you (her accountant) for some advice on how to proceed. Pleasanton Studios owns and operates three decentralized divisions: Entertainment, Streaming, and Parks. Pleasanton Studios has a decentralized organizational structure, where each division is run as an investment center. Division managers meet with the CEO at least once annually to review their performance, where each division manager's performance is measured by their division's return on investment (ROI). The division manager then receives a bonus equal to 10% of their base salary for every ROI percentage point above the cost of capital. The Entertainment division manager, John Freeman, was the first to knock on Kersten's door this morning. Entertainment, Pleasanton Studios' first endeavor, produces movies for the big screen. Entertainment has been in operation since 1965. Last month, John had mentioned a proposal to build a new animation studio. The build would cost $4,910,000 with an estimated life of 20 years and no salvage value and would allow Entertainment to start producing animated movies. Animated movies were projected to bring in an additional $1,210,000 in revenues each year, but would increase annual production costs by $574,000. John had dropped in to let Kersten know he had decided not to move forward with the animation studio. This surprised Kersten - her quick mental calculation indicated that the studio would have a payback period of 8 years, much shorter than the expected life of the studio. Not entirely sure that her quick assessment was valid, Kersten needed to check with her accountant on the matter. Next to Kersten's door was the manager of Streaming, which produces short-form (30 minute to one hour) episodes in addition to streaming the movies developed by Entertainment. Customers then buy subscriptions to the service. Run by division manager Reyna Imanah, Streaming was introduced in 2016 and has increased subscriptions by 20% every year since. Reyna's complaint was that, based on the current bonus payout schedule, John Freeman's bonus last year was significantly higher than hers. She points to the increasing subscription rates at Streaming, and says that her division is being punished for having opened so recently (her division's facilities are much more recent than those in Entertainment). She currently has an employment offer from another company at the same base pay rate, and stated that she will accept this offer unless she feels her performance is being appropriately acknowledged and compensated. Kersten needs to look at the relative performance across divisions to determine how to proceed with Reyna. Pleasanton Parks is a theme park based on the movies from Entertainment and the series from Streaming. For many years, it was a popular year-round destination, with characters, rides, and a hotel. This park has lost popularity in recent years, and has been 'in the red' for the past two years. If the park is not profitable this year, you will need to decide whether to permanently close that division. Included in the 'Fixed COGS' for Parks is an annual $1,650,000 mortgage payment on the land and buildings for the park, which would still need to be paid (as a corporate level cost) if the park is closed and that segment is removed from the financial statements. Incidentally, you recently had a conversation with a Marriott Hotels executive, who would like to expand into the area. If you decided to close Parks, you are fairly certain that you could lease the hotel facilities to Marriott for $650,000 annually. A partial report of this year's financial results for Pleasanton Studios can be found in Table 1 below. The 'Selling and admin costs' listed in Table 1 are directly incurred by each division, and are determined at the beginning of each year (that is, they do not change with increased/decreased production). In addition to the divisional information above, there are $2,000,000 in corporate costs that are currently allocated evenly between the three divisions. These costs are primarily due to employee benefits costs, which are billed at the corporate level. If the Parks division is closed, the decreased employee base would reduce allocated corporate costs by $500,000. Pleasanton Studios has a cost of capital of 12 percent (and Kersten uses the cost of capital as their required rate of return) and are subject to 32% income taxes. Before she can make any decisions, Kersten needs to evaluate this year's performance results. She sets off to see you, the company's accountant, for answers.

Table 1: Pleasanton Studios current year data Experience Streaming Parks Revenues $54,583,520 $30,184,570 $7,564,270 Fixed COGS $3,356,850 $4,074,530 $3,159,430 Variable COGS $40,257,310 $22,020,695 $3,698,928 # of customers 15,264,200 1,420,060 30,240 # of employees 11,562 1,954 1,378 Average net operating assets $29,014,000 $19,252,000 $420,000 Selling and admin costs $3,259,520 $944,620 $231,900  

a. Evaluate this year's performance results for the three divisions. Your financial analysis should include a segmented income statement for Pleasanton Studios, as well as the current annual ROI, residual income and EVA for the three divisions. b. Evaluate Entertainment's decision not to invest in the new animation studio (i.e., was the decision appropriate and in the best interests of Pleasanton Studios), including the appropriate financial analyses to support your evaluation. c. Evaluate the validity of Reyna Imanah's complaint regarding her evaluated performance. Explain why it is (or is not valid), and what further information would be necessary. d. Provide a recommendation on whether to close the Parks division, including all necessary financial analyses.

Kersten Brown, the CEO of Pleasanton Studios, is having a tough week – all three of her top management level employees have dropped in with problems. One executive is making questionable decisions, another is threatening to quit, and the third is reporting losses (again). Kersten is hoping to find simple answers to all her difficulties. She is asking you (her accountant) for some advice on how to proceed.

Pleasanton Studios owns and operates three decentralized divisions: Entertainment, Streaming, and Parks. Pleasanton Studios has a decentralized organizational structure, where each division is run as an investment center. Division managers meet with the CEO at least once annually to review their performance, where each division manager’s performance is measured by their division’s return on investment (ROI). The division manager then receives a bonus equal to 10% of their base salary for every ROI percentage point above the cost of capital.

The Entertainment division manager, John Freeman, was the first to knock on Kersten’s door this morning. Entertainment, Pleasanton Studios’ first endeavor, produces movies for the big screen. Entertainment has been in operation since 1965. Last month, John had mentioned a proposal to build a new animation studio. The build would cost $4,910,000 with an estimated life of 20 years and no salvage value and would allow Entertainment to start producing animated movies. Animated movies were projected to bring in an additional $1,210,000 in revenues each year, but would increase annual production costs by $574,000. John had dropped in to let Kersten know he had decided not to move forward with the animation studio. This surprised Kersten – her quick mental calculation indicated that the studio would have a payback period of 8 years, much shorter than the expected life of the studio. Not entirely sure that her quick assessment was valid, Kersten needed to check with her accountant on the matter.

Next to Kersten’s door was the manager of Streaming, which produces short-form (30 minute to one hour) episodes in addition to streaming the movies developed by Entertainment. Customers then buy subscriptions to the service. Run by division manager Reyna Imanah, Streaming was introduced in 2016 and has increased subscriptions by 20% every year since. Reyna’s complaint was that, based on the current bonus payout schedule, John Freeman’s bonus last year was significantly higher than hers. She points to the increasing subscription rates at Streaming, and says that her division is being punished for having opened so recently (her division’s facilities are much more recent than those in Entertainment). She currently has an employment offer from another company at the same base pay rate, and stated that she will accept this offer unless she feels her performance is being appropriately acknowledged and compensated. Kersten needs to look at the relative performance across divisions to determine how to proceed with Reyna.

Pleasanton Parks is a theme park based on the movies from Entertainment and the series from Streaming. For many years, it was a popular year-round destination, with characters, rides, and a hotel. This park has lost popularity in recent years, and has been ‘in the red’ for the past two years. If the park is not profitable this year, you will need to decide whether to permanently close that division. Included in the ‘Fixed COGS’ for Parks is an annual $1,650,000 mortgage payment on the land and buildings for the park, which would still need to be paid (as a corporate level cost) if the park is closed and that segment is removed from the financial statements. Incidentally, you recently had a conversation with a Marriott Hotels executive, who would like to expand into the area. If you decided to close Parks, you are fairly certain that you could lease the hotel facilities to Marriott for $650,000 annually.

A partial report of this year’s financial results for Pleasanton Studios can be found in Table 1 below. The ‘Selling and admin costs’ listed in Table 1 are directly incurred by each division, and are determined at the beginning of each year (that is, they do not change with increased/decreased production). In addition to the divisional information above, there are $2,000,000 in corporate costs that are currently allocated evenly between the three divisions. These costs are primarily due to employee benefits costs, which are billed at the corporate level. If the Parks division is closed, the decreased employee base would reduce allocated corporate costs by $500,000. Pleasanton Studios has a cost of capital of 12 percent (and Kersten uses the cost of capital as their required rate of return) and are subject to 32% income taxes.

Before she can make any decisions, Kersten needs to evaluate this year’s performance results. She sets off to see you, the company’s accountant, for answers.

Table 1: Pleasanton Studios current year data

Required:

a. Evaluate this year’s performance results for the three divisions. Your financial analysis should include a segmented income statement for Pleasanton Studios, as well as the current annual ROI, residual income and EVA for the three divisions.

A plant to make 30 000 t y^-1 of glycerine and comprising 11 process steps was built in the UK five years ago, with a total investment cost of GBP 48 million. A new plant for the production of 50 000 t y^-1 of glycerine is now to be built near Ankara, Turkey. Because of more stringent international legislation, new glycerine plants require additional pollution control equivalent to 3 further process steps. Estimate the total investment cost in TRY (Turkish Lira) of such a plant using the data below.

Scale factor = 0.6

Fatima Hopkins, the CEO of Central Adventures, is having difficulties with all three of her top management level employees. With one manager making questionable decisions, another threatening to leave, and the third likely ‘in the red’, Fatima is hoping there is a simple answer to all her difficulties, and needs some advice from her accountant on how to proceed.

Central Adventures owns and operates three amusement parks in Michigan: Central Funland, Central Waterworld, and Central Treetops. Central Adventures has a decentralized organizational structure, where each park is run as an investment center. Each park manager meets with the CEO at least once annually to review their performance, as measured by their park’s ROI. The park manager then receives a bonus equal to 10% of their base salary for every ROI percentage point above the required rate.

Central Funland is an outdoor theme park, with twelve roller coaster rides and several other attractions. This park has first opened 1965, and most of the rides have been in operation for 20+ years. Attendance at this park has been relatively stable over the past ten years. The park manager of Funland, Janet Lieberman, recently shared with Fatima a proposal to replace one of their older rides with a new roller coaster, a hybrid steel and wood rollercoaster with a 90 degree, 200 foot drop and three inversions. The proposal indicated that the ride would cost $8,000,000 with an estimated life of 20 years. In addition, this new style of coaster would require additional maintenance, costing $125,000 each year. However, it projected that this new attraction would boost attendance, earning the park an additional $1,190,000 per year in revenues. Janet ultimately decided not to invest in this new attraction.

Central Waterworld is an indoor water park, operating year-round. Run by park manager David Copperfield, Waterworld was built in 2016 and has increased attendance by 20% every year since. David recently sent you an email complaining that, based on the current bonus payout schedule, Janet Lieberman’s bonus last year was significantly higher than his. He points to the increasing attendance, and says that his park is being punished for having opened so recently (his park assets are much more recent than the roller coasters at Funland). He currently has an employment offer from another company at the same pay rate, which he says he will accept if his performance is not appropriately acknowledged.

Central Treetops includes a high ropes course and has a series of ziplines that criss-cross over the Chippewa River. For many years, it was a popular venue for corporate team-building activities, so it is equipped with a main indoor facility with cafeteria and overnight guest rooms. This park has lost popularity in recent years, and has been ‘in the red’ for the past two years. If the park is not profitable this year, you will need to decide whether to close it - permanently. Central Adventures has a $86,000 mortgage payment on the land and buildings for Treetops, which would still need to be paid if the park is closed. Incidentally, you recently had a conversation with the regional head of the YMCA, who would like to open a summer camp in the central Michigan region. If you decided to close Treetops, you are fairly certain that you could lease that land to the YMCA for $250,000 annually.

A partial report of this year’s financial results for Central Adventures shows the following:

In addition to the information above, there are $2,542,920 in corporate costs, which are currently allocated evenly between the three parks. These costs are primarily due to employee benefits costs, which are billed at the corporate level. If the Treetops park is closed, the allocated corporate costs would decrease by $12,000. Central Adventures has a required rate of return of 12 percent (set at the company’s weighted-average cost of capital) and are subject to 18% income taxes.

Fatima needs to see this year’s performance results before she can make any decisions. Is David’s complaint about the performance evaluation metrics valid? Is that also affecting management decisions in the form of Janet’s rejection of the proposed new rollercoaster? And is the company better off without Treetops? She sets off to the company accountant’s office to help get some answers.

This is all one question:

A theater uses the following table/sheet to manage ticket sales, which turned out to be a very bad practice. The manager of theater hires you to design a database to manage the ticket sale information.   

TICKET-SALES (InvoiceNumber, CustomerID, ShowTitle, SeatType, SeatLocation, TicketPrice, CustomerName, CustomerCell, ShowTime, Director_of_Show)

Note: A customer can purchase multiple seats in one order (with one InvoiceNumber). It is also the common sense that the price of a ticket/seat depends on the show, it’s showtime and seat location. Also note this theater may have multiple shows at the same time.  

To do your job, you need to answer the following questions:  

-List al Functional Dependencies

-List Multivalued Dependencies, if there is any.

-What is the key of original table (TICKET-SALES)?

-What normal form this table is in and Why? Give a clear justification/explanation

-How do you normalize it? Show the result of normalization