Tombro Industries is in the process of automating one of its plants and developing a flexible manufacturing system. The company is finding it necessary to make many changes in operating procedures. Progress has been slow, particularly in trying to develop new performance measures for the factory. In an effort to evaluate performance and determine where improvements can be made, management has gathered the following data relating to activities over the last four months:

Month 1 2 3 4

Quality control measures: Number of defects 190 168 129 90

Number of warranty claims 51 44 35 32

Number of customer complaints 107 101 84 63

Material control measures: Purchase order lead time 8 days 7 days 5 days 4 days Scrap as a percent of total cost 1% 1% 2% 3%

Machine performance measures: Machine downtime as a percentage of availability 3% 4% 4% 6%

Use as a percentage of availability 94% 91% 88% 84%

Setup time (hours) 8 10 11 12

Delivery performance measures: Throughput time ? ? ? ? Manufacturing cycle efficiency (MCE) ? ? ? ? Delivery cycle time ? ? ? ?

Percentage of on-time deliveries 95 % 94 % 91 % 88 %

The president has read in industry journals that throughput time, MCE, and delivery cycle time are important measures of performance, but no one is sure how they are computed. You have been asked to assist the company, and you have gathered the following data relating to these measures:

Average per Month (in days) 1 2 3 4

Wait time per order before start of production 9.0 11.4 12.0 14.0

Inspection time per unit 0.9 0.7 0.7 0.7

Process time per unit 2.8 2.0 1.6 1.2

Queue time per unit 3.0 4.3 5.1 7.4

Move time per unit 0.3 0.6 0.6 0.7

Required: 1-a. Compute the throughput time for each month. 1-b. Compute the manufacturing cycle efficiency (MCE) for each month. 1-c. Compute the delivery cycle time for each month.

3-a. Refer to the inspection time, process time, and so forth, given for month 4. Assume that in month 5 the inspection time, process time, and so forth, are the same as for month 4, except that the company is able to completely eliminate the queue time during production using Lean Production. Compute the new throughput time and MCE.

3-b. Refer to the inspection time, process time, and so forth, given for month 4. Assume that in month 6 the inspection time, process time, and so forth, are the same as in month 4, except that the company is able to eliminate both the queue time during production and the inspection time using Lean Production. Compute the new throughput time and MCE.

in java Print a list of seats in a theater. Rows are numbered, columns lettered, as in 1A or 3E.

Print a space after each seat. Create a nested loop to print the following: 1A 1B 1C 1D 3A 3B 3C 3D 5A 5B 5C 5D

Article: Anheuser-Busch Orders 40 Tesla Semi Trucks (Brewer hasn't yet decided whether to buy vehicles outright or lease them as it seeks to cut fuel costs and vehicle emissions.

Forget the Clydesdales. Anheuser-Busch has reserved 40 of Tesla Inc.’sTSLA -1.15% all-electric Semi trucks, as the maker of Budweiser seeks to reduce fuel costs and vehicle emissions.

The U.S. subsidiary of Anheuser-Busch InBev BUD -2.22% NV plans to use the trucks for shipments to wholesalers within 150 to 200 miles of its brewery locations—well within the 500-mile range that Tesla Chief Executive Elon Musk has promised. The vehicles would be deployed among the brewer’s so-called dedicated fleets of about 750 trucks, which bear the company’s branding but are owned and managed by outside carriers.

One of the largest known reservations since the Semi was unveiled last month, Anheuser-Busch’s preorder is still tiny relative to the broader heavy-duty-truck market, which produces 250,000 to 300,000 big rigs a year.

Anheuser-Busch hasn’t yet decided whether to buy the vehicles outright or lease them, said James Sembrot, the company’s senior director of logistics strategy. It could also ask one of its dedicated carriers to buy or lease the trucks. The Semi won’t be available until 2019. “We put the reservations down so we can prioritize our place in line,” he said. “We don’t know who the carrier is going to be in two to three years when these things are actually produced.”

He declined to discuss the cost for the reservation, which he said was made before Tesla introduced the Semi in California last month. Tesla had set deposits at $5,000 at the time of the November announcement but has since raised the amount to $20,000. Tesla expects the trucks to list for $150,000 to $200,000; a new diesel-powered heavy-duty truck can sell for $150,000.

The Semi tractors are designed to travel as much as 500 miles on a single charge. Some question whether electric vehicles are a viable option for long-haul trucking, citing concerns about range and battery weight.

Still, companies looking to trim transportation costs are seeking to test out the Tesla truck. J.B. Hunt Transport Services Inc. and Wal-Mart Stores Inc., which each operate thousands of trucks, have reserved Semis, as has Deutsche Post AG’s DHL Supply Chain and truck-leasing and fleet-management company Ryder System Inc.

Fuel, along with labor, is historically one of the biggest expenses for trucking companies, according to the American Transportation Research Institute, an industry research group.

Anheuser-Busch spends about $120 million on fuel each year for its dedicated fleets and long-haul transportation by for-hire carriers moving beer between breweries and wholesalers, Mr. Sembrot said. The company wants to cut its carbon footprint by 30% by 2025, and has invested in alternative-fuel vehicles, such as leasing delivery trucks that run on compressed natural gas. It is also in discussions with Nikola Motor Co., which is developing hydrogen-electric semi-trucks.

Mr. Sembrot said Anheuser-Busch views the Tesla truck and the Nikola vehicle, which the company says will be able to travel from 800 to 1,200 miles on one fill-up, as potentially complementary technologies.

“We have needs for all those types of distances,” he said.

How much the Semi can haul remains in question, however.

“You don’t have a transmission, you don’t have an engine, but how much exactly does the battery weigh,” Mr. Sembrot said. “We’re not shipping cotton balls around, so the weight of the equipment matters to us.”

But many trucking companies, which move freight thousands of miles across the country, might not be as eager to test out the new Tesla trucks.

“We’re going to sit on the sidelines and watch that develop,” said James Welch, chief executive of YRC Worldwide Inc., one of the largest less-than-truckload carriers.

YRC trucks make both local and long-distance trips, and the Tesla truck’s 500-mile range would be a liability on long-haul routes, he said. The company would also have difficulty maximizing electric trucks’ time on the road because they need longer to recharge, compared with time needed to refuel a diesel-powered big rig.

“Recharging time has to be quick because you’re paying a driver whether he or she is running or sitting,” Mr. Welch said.

Question

What are the three key takeaway statements (please write a discussion)?

Build a conceptional model for a Hotel Management System. The solution should be presented as an ER-diagram. Base your design on the following requirements.

• The database should record information about Customer, Hotel, Booking, Rooms, Employee, Feedback, and Payments.

• A Customer has a name which consists of firstName, middleName and lastName. Customers are identified by a unique customerID. A Customer has an Address, phoneNo and email address – Customers can place any number of Bookings (including none). Customer may provide Feedback for each Booking they have placed (optional). For every Booking, a Booking has to make a Payment. Customer is associated with at least one address and multiple customer can live in the same place.

• A Room is identified by its number and has a type, and a description. – Rooms are part of a Hotel.

• A hotel is identified by it is name and address ID and has a stars rating

• A Booking is uniquely identified by a bookingId. A Booking is created by a Customer. For each booking we store a Total Amount of reserved rooms, and a price for room on the booked day, period and a Date. – A Booking is associated with one or more Rooms. For each Room in a Booking, we have to record how many of the Room type is reserved for the stay, for example (2 Queen, 1 king bedroom and a suite). A booking is a made at one hotel, some hotels may not have any booking.

• Employee is identified by an employee number. An employee works in one or more hotels. An employee has a name and address and birth year. In each hotel you have a permanent employee taking a yearly salary and temporary employee working on hourly rates.

• An Address consists of a unique addrID, street and has streetNumber, city, state and zipcode. The attributes city and state can be derived from the attribute zipcode. – There may be some Addresses which are not be associated with any Customer or Hotel.

• A Payment is identified by the Booking for which the payment was made. It consists of the amountPaid and paymentMethod (Credit Card, E-Check, etc.

Donald has recently lost his job as the President of a large North American country and has returned to the family hotel business. Their most prestigious hotel Tramp Tavern has been closed for two years whilst it has undergone refurbishment and the hotel is about to be relaunched. The hotel runs conventionally and has a number of cost centres such as Reception, Concierge, Repairs and Maintenance which are relatively fixed. The hotel also has variable costs relating to cleaning and servicing rooms. You have been provided with the following data regarding the re-furbished Tramp Tavern: Available Rooms 400 Average Room Tariff (per night) $230 Fixed Financing Costs $10 million Fixed Operating Costs $15 million Variable Operating Costs (per night when occupied) $50 Required a) What is the breakeven point (in total room rentals for the year) for the Tramp Tavern? Show the percentage of occupancy that the hotel must achieve in order to break even (show all calculations) (2.5 marks)
b) Donald expects the property to achieve 70% occupancy over the year. What will be his Net Profit (Loss) for the year if they achieve that level of occupancy? (2.5 marks)
c) Hotel rooms (like airline seat tickets) are services that are referred to as ‘perishable’ in that they expire if they are not used on a certain date (they cannot be stored). Donald has determined that he can increase the hotel’s occupancy from 70% to 95% by subscribing to a last-minute deals provider. However, should he do so the average room tariff Tramp Tavern will receive will fall from $230 per night to $190 per night. Provide the profit calculation to demonstrate whether Donald should or should not go ahead with the offer from the lastminute deals provider to sign. (2.5 marks)
d) Briefly discuss any other business issues that Donald should consider before making up his mind whether to proceed with the last-minute deals agreement.

Donald has recently lost his job as the President of a large North American country and has returned to the family hotel business. Their most prestigious hotel Tramp Tavern has been closed for two years whilst it has undergone refurbishment and the hotel is about to be relaunched. The hotel runs conventionally and has a number of cost centres such as Reception, Concierge, Repairs and Maintenance which are relatively fixed. The hotel also has variable costs relating to cleaning and servicing rooms. You have been provided with the following data regarding the re-furbished Tramp Tavern: Available Rooms 400 Average Room Tariff (per night) $230 Fixed Financing Costs $10 million Fixed Operating Costs $15 million Variable Operating Costs (per night when occupied) $50 Required a) What is the breakeven point (in total room rentals for the year) for the Tramp Tavern? Show the percentage of occupancy that the hotel must achieve in order to break even (show all calculations) (2.5 marks) b) Donald expects the property to achieve 70% occupancy over the year. What will be his Net Profit (Loss) for the year if they achieve that level of occupancy? (2.5 marks) c) Hotel rooms (like airline seat tickets) are services that are referred to as ‘perishable’ in that they expire if they are not used on a certain date (they cannot be stored). Donald has determined that he can increase the hotel’s occupancy from 70% to 95% by subscribing to a last-minute deals provider. However, should he do so the average room tariff Tramp Tavern will receive will fall from $230 per night to $190 per night. Provide the profit calculation to demonstrate whether Donald should or should not go ahead with the offer from the lastminute deals provider to sign. (2.5 marks) d) Briefly discuss any other business issues that Donald should consider before making up his mind whether to proceed with the last-minute deals agreement. (

Sammy Sosa was staying at the Holiday Inn Hotel in Manhattan when he tripped on a carpet that was buckled. He hit his head on a dresser and sustained severe injuries to his face. The week before, another patron of the hotel tripped on the carpet in the same room and broke her wrist as a result. The hotel management put in a work order to have the carpet fixed and it was to be repaired as soon as Mr. Sosa checked out of the room.

Greta Garbor, the hotel owner, has a franchise agreement with the Holiday Inn Corporation. The agreement allows Ms. Garbor to use the name Holiday Inn and requires that the style of the building, the furnishings, and all the equipment in the hotel conform to certain specifications. In order to repair the carpet, Ms. Garbor had to order a replacement part from a Holiday Inn authorized dealer. The replacement carpet had to conform to Holiday Inn’s specifications. It could not be delivered for ten (10) days, which delayed the repair.

According to the agreement between Ms. Garbor and Holiday Inn, Garbor is responsible for the day-to-day operations, the rates charged, and she keeps the profit after paying Holiday Inn a franchise fee. All the employees work for Garbor, although they are required to wear nametags with the Holiday Inn name and logo. Holiday Inn also provides stationary and pens with the Holiday Inn name and logo that are used by the employees and provided free of charge to the customers. The web site for this particular hotel can be accessed through the Holiday Inn platform. On Ms. Garbor’s hotel web site, the masthead says: Holiday Inn Manhattan Greta Garbor, Owner.  

Mr. Sosa is suing both Holiday Inn and Ms. Garbor for his injuries:

1. Explain why Holiday Inn should be held liable for the injuries; 2. Explain why Holiday Inn should not be held liable; 3. Do you think Holiday Inn should be held liable? Why or why not?   

A park claims that the average number of visitors per day is about 85. We monitor the park on 6 random days and find the following number of visitors on these days: 46, 79, 73, 90, 80, 55 Can we conclude at ? = 0.05 that the mean number of visitors per day in general is different from 85?

A survey of 1465 people who took trips revealed that 135 of them included a visit to a theme park. Based on those survey results, a management consultant claims that less than 10 % of trips include a theme park visit. Test this claim using the α=0.05 significance level.

The test statistic is
The PP-value is

A survey of 1375 people who took trips revealed that 125 of them included a visit to a theme park. Based on those survery results, a management consultant claims that less than 10 % of trips include a theme park visit. Test this claim using the α=0.01 significance level. The test statistic is The critical value is