# Analytics Question

Complete the following problems in a single excel file

Chapter 1 Problem 2

Gobblecakes is a bakery that specializes in cupcakes. The annual fixed cost to make cupcakes is \$18,000. The variable cost including ingredients and labor to make a cupcake is \$0.90. The bakery sells cupcakes for \$3.20 apiece.

a. If the bakery sells 12,000 cupcakes annually, determine the total cost, total revenue, and profit.

b. How many cupcakes will the bakery need to sell to break even?

Chapter 1 Problem 4

Evergreen Fertilizer Company produces fertilizer. The company’s fixed monthly cost is \$25,000, and its variable cost per pound of fertilizer is \$0.15. Evergreen sells the fertilizer for \$0.40 per pound. Determine the monthly break-even volume for the company.

Chapter 11

Problem 10

A large research hospital has accumulated statistical data on its patients for an extended period. Researchers have determined that patients who are smokers have an 18% chance of contracting a serious illness such as heart disease, cancer, or emphysema, whereas there is only a .06 probability that a nonsmoker will contract a serious illness. From hospital records, the researchers know that 23% of all hospital patients are smokers, whereas 77% are nonsmokers. For planning purposes, the hospital physician staff would like to know the probability that a given patient is a smoker if the patient has a serious illness.

Problem 12

The Senate consists of 100 senators, of whom 34 are Republicans and 66 are Democrats. A bill to increase defense appropriations is before the Senate. Thirty-five percent of the Democrats and 70% of the Republicans favor the bill. The bill needs a simple majority to pass. Using a probability tree, determine the probability that the bill will pass.

Problem 14

A metropolitan school system consists of three districts—north, south, and central. The north district contains 25% of all students, the south district contains 40%, and the central district contains 35%. A minimum-competency test was given to all students; 10% of the north district students failed, 15% of the south district students failed, and 5% of the central district students failed.

a. Develop a probability tree showing all marginal, conditional, and joint probabilities.

b. Develop a joint probability table.

c. What is the probability that a student selected at random failed the test?

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.