I am not able to upload a image of the question or in tables as it is formated. Any suggestions how i can do this? Thank you

Penny’s Rent A Car
Penny’s Rent a Car offers three rental plans as shown in Table 1. Please note that the fixed cost is provided in terms of months. Later, you will be asked to construct a cost table in terms of annual cost.
Table 1. Rental plan characteristics
Plan
Fixed Monthly Payment
Additional costs per annual miles
I
$200
$0.095 per mile
II
$300
$0.061 for each of the first 12,000 miles and $0.05 per mile thereafter
III
$150
$0.10 for each of the first 12,000 miles and $0.20 per mile thereafter
A customer is considering which option to take. This customer estimates the likely annual mileage as shown in Table 2.
Table 2. Estimated annual mileage probabilities
Annual Miles
10,000
15,000
20,000
25,000
30,000
Probability
0.1
0.1
0.2
0.3
0.3
Create a cost matrix for this problem using total annual cost. Show all costs as negative values (i.e. accounting format).
1) What alternative is selected using the Maximax criterion?
2) What alternative is selected using the Maximin criterion?
3) What alternative is selected using the Expected Monetary Value criterion?
4) What alternative is selected using the Minimax Regret criterion?
5) What alternative is selected using the Expected Regret (or Expected Opportunity Loss) criterion?
HINT: Be sure to answer to develop a spreadsheet that is robust and is developed in a dynamic manner. Develop formulas to make it clear which decision that would be made based on the methods described. Remember, everything that is a cost should be negative (i.e. accounting format).

Above is the question and below is what is on the excel sheet to start answering the question. Can you please show all steps (showning the excel formulas)?

Read the details regarding “The Plaza Hotel” and answer the questions below:

The Plaza Hotel is a 20-story luxury hotel and condominium apartment building in Midtown Manhattan in New York City. It opened in 1907 and is now owned by Katara Hospitality. The Plaza Hotel has many services including a butler on every floor, baby-sitting and concierges, a shopping mall, the Palm Court under the restored stained glass ceiling, the Champagne Bar located in the hotel lobby with views of Grand Army Plaza, the Edwardian Room, the Terrace Room, the Rose Club, the Grand BallRoom, The Plaza Food Hall and The Todd English Food Hall Restaurant and Marketplace, as well as meeting rooms and conference rooms. Guests not only come from the 50 states but from all over the world. The hotel scores in the top 5% of the

national benchmark studies in terms of customer satisfaction. The hotel managers analyze the data received through customer questionnaires on a daily basis. Corrective measures are taken without any delay in case of any problems. The Plaza believes that quality improvement is a never ending process and the staff and management are continuously striving to come up with strategies to improve customer satisfaction. When the staff observes some kind of problem, they take care of it themselves; delay in room service is followed by small gifts to the guests, delay in food service is followed by a complimentary dessert and so on. Katara Hospitality keeps a check and balance on the hotel’s performance. Different areas are monitored, compared to a selected standard and the feedback report is shared on a monthly basis with the hotel. Automated inventory system is used for inventory management. Whenever an item is removed from the inventory for customer use, the item is automatically billed to that account, and usage is noted at the main supply area. Supplies are delivered on a Just-in-time basis to keep the costs low and to avoid any quality related problems. From their one-of-a-kind Eloise Suite, to their ultra-luxurious Penthouse Suites, The Plaza’s unparalleled accommodations are as unique as they are elegant. Their spacious guest rooms offer classic appointments and furnishings as can only be expected from New York’s most legendary address. Their contemporary Legacy Suites offer beauty in every detail, some suites with striking partial views of Central Park, outdoor terraces, and connecting rooms. Pareto charts and flowcharts monitor processes and facilitate the management in spotting problematic areas graphically. The philosophy that customers come first is taught to all the employees at the very first day of their orientation. The guards at the gates or the waiters in the hallways will never be heard commenting on each other’s personal lives or discussing confidential issues. This quality culture at the Plaza hotel makes the hotel visit a warmer and more comforting experience for the guests.

a. What TQM concepts and tools have been employed by the Plaza Hotel? Identify and briefly explain them.

b. What tools would you recommend them that they can use in future and how can they use them?

please solve it in a word doc and be brief

Question no.2 (10)

Read the details regarding “The Plaza Hotel” and answer the questions below:

The Plaza Hotel is a 20-story luxury hotel and condominium apartment building in Midtown Manhattan in New York City. It opened in 1907 and is now owned by Katara Hospitality. The Plaza Hotel has many services including a butler on every floor, baby-sitting and concierges, a shopping mall, the Palm Court under the restored stained glass ceiling, the Champagne Bar located in the hotel lobby with views of Grand Army Plaza, the Edwardian Room, the Terrace Room, the Rose Club, the Grand BallRoom, The Plaza Food Hall and The Todd English Food Hall Restaurant and Marketplace, as well as meeting rooms and conference rooms. Guests not only come from the 50 states but from all over the world. The hotel scores in the top 5% of the national benchmark studies in terms of customer satisfaction. The hotel managers analyze the data received through customer questionnaires on a daily basis. Corrective measures are taken without any delay in case of any problems. The Plaza believes that quality improvement is a never ending process and the staff and management are continuously striving to come up with strategies to improve customer satisfaction. When the staff observes some kind of problem, they take care of it themselves; delay in room service is followed by small gifts to the guests, delay in food service is followed by a complimentary dessert and so on. Katara Hospitality keeps a check and balance on the hotel’s performance. Different areas are monitored, compared to a selected standard and the feedback report is shared on a monthly basis with the hotel. Automated inventory system is used for inventory management. Whenever an item is removed from the inventory for customer use, the item is automatically billed to that account, and usage is noted at the main supply area. Supplies are delivered on a Just-in-time basis to keep the costs low and to avoid any quality related problems. From their one-of-a-kind Eloise Suite, to their ultra-luxurious Penthouse Suites, The Plaza’s unparalleled accommodations are as unique as they are elegant. Their spacious guest rooms offer classic appointments and furnishings as can only be expected from New York’s most legendary address. Their contemporary Legacy Suites offer beauty in every detail, some suites with striking partial views of Central Park, outdoor terraces, and connecting rooms. Pareto charts and flowcharts monitor processes and facilitate the management in spotting problematic areas graphically. The philosophy that customers come first is taught to all the employees at the very first day of their orientation. The guards at the gates or the waiters in the hallways will never be heard commenting on each other’s personal lives or discussing confidential issues. This quality culture at the Plaza hotel makes the hotel visit a warmer and more comforting experience for the guests.

a. What TQM concepts and tools have been employed by the Plaza Hotel? Identify and briefly explain them.

b. What tools would you recommend them that they can use in future and how can they use them?

The accompanying table provides data for​ tar, nicotine, and carbon monoxide​ (CO) contents in a certain brand of cigarette. Find the best regression equation for predicting the amount of nicotine in a cigarette. Why is it​ best? Is the best regression equation a good regression equation for predicting the nicotine​ content? Why or why​ not?

Tar   Nicotine   CO
5   0.5   5
17   1.0   19
16   1.1   18
13   0.7   19
13   0.8   18
15   1.1   13
15   1.0   17
16   1.2   16
15   1.1   15
9   0.7   11
13   0.8   17
12   0.8   17
14   0.7   17
16   1.1   16
3   0.3   3
14   1.0   18
15   1.1   16
13   0.7   19
15   1.0   16
15   1.0   17
16   1.2   15
15   1.1   16
7   0.7   7
17   1.3   15
15   1.0   14

Find the best regression equation for predicting the amount of nicotine in a cigarette. Use predictor variables of tar and/or carbon monoxide​ (CO). Select the correct choice and fill in the answer boxes to complete your choice.

A. Nicotine = __ + (__) CO

B. Nicotine = __ + (__) Tar

C. Nicotine = __ + (__) Tar + (__) CO

A family on vacation in San Francisco drives from Golden Gate Park due south on 19th Avenue for 2.2 miles and then turns west on Sloat Boulevard and drives an additional 1.1 mile to go to the zoo. The driving time for this trip is 18 minutes. What is the family’s net displacement for this trip? What is the average speed for the trip? What is the average velocity? (Remember to specify the direction of the net displacement and the velocity vectors. This requires giving a reference, like “of the north”, and a direction the angle is measured, like “east” in the direction “20.0° east of north”.)

This problem requires you to prompt the user for some information, and apply simple arithmetic operation to generate an output.

We all know that driving is expensive. So let's write a program to observe this.

• Your job is to prompt the driver for
  • miles per gallon and
  • gas price (in dollars) per gallon

You should prompt the user with the words: Enter miles per gallon: at which time the users enters a number, and then Enter the gas price:at which time the user enters the second number. The prompts must be EXACTLY as written, including the colon (:) character, or your test cases will fail. Since you are prompting the user for input, you should not enter anything into the (optional) input box below, but input your numbers after your prompts.

Both inputs should be read as  float data type , and your program will output the gas cost for 10 miles, 50 miles, and 400 miles. Due to the way floating point numbers are internally stored, there can be some discrepancies with the precision of calculations depending on the order things are done. To prevent this from causing your submission to be marked incorrect, please calculate the cost in the following order:  The miles increment (10, 50, or 400) multiplied by 1.0/miles per gallon multiplied by the gas price.

Example: If the input is:

Enter miles per gallon:20.0
Enter the gas price:3.1599

Then the output is:

1.57995 7.89975 63.198

Note: Real per-mile cost would also include maintenance and depreciation.

Someone please help! Can't get it right! (This is python)

A study to determine haemoglobin due to the strength of medication categorised into 5 groups were conducted on 27 women aged 18-40 years. The table below displays the data and the relevant descriptive quantities.

Medication strength
A B C D E
0.8 0.7 1.2 1.0 0.6
0.6 0.8 1.0 0.9 0.4
0.6 0.5 0.9 0.9 0.4
0.5 0.5 1.2 1.1 0.7

0.6 1.3 0.7 0.3

0.9 0.8
0.7   

a) Normality assumption was checked, and it was not normally distributed. Hence, determine if the five groups of medication strength have the same median haemoglobin level? 

b) Write a brief summary of what the result show.  

(a) The price elasticity of demand for smoke grinders in response to changes in the price of purpletts is -2. What formula and concept will we use to study the change in quantity demanded of smoke grinders to a change in price of purpletts? What the -2 elasticity of demand tells us about the goods purpletts and smoke grinders? (b) Given the table below, answer the following question. The quantity demanded of which good decreases the most during a recession (when incomes decrease)?

Given the table below ( income elasticity of demand), answer the following question.

Total brand cereal = 0.3, eclipse galsses = -1.5, office chairs = 0, theater tickets = 4, heart shaped pillows = 2

The quantity demanded of which good decreases the most during a recession (when incomes decrease)?

the company sells a brand of low-fat shakes that appeal to people of all age groups and both genders. The company advertises this shake in a variety of 30-second television ads, and these ads can be placed in a variety of television shows. The ads in different shows vary by cost – some 30-second slots are much more expensive than others – and by the types of viewers they are likely to reach.

The company has segmented the potential viewers into six mutually exclusive categories: males age 18 to 35, males age 36 to 55, males over 55, females age 18 to 35, females age 36 to 55, and females over 55. A rating service can supply data on the numbers of viewers in each of these categories who will watch a 30-second ad on any particular television show. Each such viewer is called an exposure. The company has determined the required number of exposures it wants to obtain for each group. It wants to know how many ads to place on each of several television shows to obtain these required exposures at minimum cost.

The data on costs per ad, numbers of exposures per ad, and minimal required exposures are listed below, where numbers of exposures are expressed in millions, and costs are in thousands of dollars.

What should the company do?

How would you address the fact that multiple ads per show do not translate to multiple exposures for the show?

The Super-Pop Popcorn Company requires a new popcorn plant in Asia. Management collects data related to each site as follows in the table below. Where the plant should be built?

1. Calculate the weighted factor scores for each site.

2. Choose the best site and explain why.