Floyd’s Bumpers has distribution centers in Lafayette, Indiana; Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania. Each distribution center carries all products sold. Floyd’s customers are auto repair shops and larger auto parts retail stores. You are asked to perform an analysis of the customer assignments to determine which of Floyd’s customers should be assigned to each distribution center. The rule for assigning customers to distribution centers is simple: A customer should be assigned to the closest center. The worksheet Floyds in the provided datafile contains the distance from each of Floyd’s 1,029 customers to each of the five distribution centers. Your task is to build a list that tells which distribution center should serve each customer. The following functions will be helpful:

=MIN(array).

The MIN function returns the smallest value in a set of numbers. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MIN(A1:A3) returns the number 6, because it is the smallest of the three numbers:

=MATCH(lookup_value, lookup_array, match type).

The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range. The lookup_value is the value to match, the lookup_array is the range of search, and match type indicates the type of match (use 0 for an exact match).

For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

=INDEX(array, column_num).

The INDEX function returns the value of an element in a position of an array. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =INDEX(A1:A3, 2) 5 25, because 25 is the value in the second position of the array A1:A3. (Hint: Create three new columns. In the first column, use the MIN function to calculate the minimum distance for the customer in that row. In the second column use the MATCH function to find the position of the minimum distance. In the third column, use the position in the previous column with the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.)

(Hint: The INDEX function may be used with a two-dimensional array: =INDEX(array, row_num, column_num), where array is a matrix, row_num is the row numbers and column_num is the column position of the desired element of the matrix.)

Floyd's Bumpers pays a transportation company to ship its product to its customers. Floyd's Bumpers ships full truckloads to its customers. Therefore, the cost for shipping is a function of the distance traveled and a fuel surcharge (also on a per mile basis). The cost per mile is $2.64 and the fuel surcharge is $.56 per mile. The worksheet May in the provided datafile contains data for shipments for the month of May (each record is simply the customer zip code for a given truckload shipment), as well as the distance table from the distribution centers to each customer. Use the VLOOKUP function to retrieve the distance traveled for each shipment from the exercise completed above, and calculate the charge for each shipment. What is the total amount that Floyd's Bumpers spends on these May shipments?

If required, round your answers to two decimal places.

$

Here is the link to the data file

https://1drv.ms/x/s!ApMP2LeBUrTssVvBH4KCoBWINZcw

You are evaluating two magazines in which to advertise and reach the 18-34 year-old female audience. These two magazines are Field & Stream (a hunting and fishing enthusiasts’ magazine whose readership is 75% male) and Cosmopolitan (a fashion/lifestyle magazine targeting young women in their 20s and 30s). One page in Field & Stream costs $50,000 with a circulation of 1,500,000 readers. One page in Cosmopolitan costs $150,000 with a circulation of 2,500,000 readers, 90% female under the age of 40. What is the CPM of both magazines ( Field & Stream and Cosmopolitan) and briefly discuss the efficiency and effectiveness of each media vehicle, given the target audience of 18-34 females.

Field & Stream CPM =


Cosmopolitan CPM =


Efficiency:


Effectiveness:

One hundred and fourteen people are eligible to participate in a clinical trial. The trial will have two arms (‘treatment’ and ‘control’), and we want an equal number of people in each arm. Gender and activity status (both of which may be related to the outcome measured in the trial) are recorded for the 114 people; the results are in the table below.

Explain how you would decide who gets what treatment. You do not have to go into intricate detail but hit on the important topic(s) of the assignment of treatments to individuals. Note that each person can be in only one of the two arms.

Write a program that implements the FIFO, LRU, and Optimal page replacement algorithms presented in chapter 8 of your text. First generate a random page-reference string (this should be 20 entries long) where page numbers range from 0 to 9. Apply the random page-reference string to each algorithm, and record the number of page faults incurred by each algorithm. Implement the replacement algorithms so that the number of page frames goes from 1 to 7 and you must compute the page fault for each of these frame numbers. Record the number of page faults with each of these different page frames numbers and each of the different algorithms. Assume that demand paging is used. Remember to count the first time a page comes in, as this is a page fault in demand paging. Then do the same procedure, except use the following page-reference string instead of the random one: 0,7,0,1,2,0,8,9,0,3,0,4,5,6,7,0,8,9,1,2 and then lastly do it with the page-reference string: 7,0,1,2,0,3,0,4,2,3,0,3,2,1,2,0,1,7,0,1 The sample output has the correct solutions for LRU and FIFO but nothing for Optimal. Have separate clearly marked classes, functions, or methods for LRU, FIFO, and Optimal replacement algorithms. Also have comments within your code. Make certain to have your name, date, assignment number, and a brief description of the program at the top of your main method. Your output should be in the following format (repeated seven times, one for each number of page frames, and the set of seven repeated three times, one for each of the three page-reference strings): For x page frames, and using string page reference string nnnnnnnnnnnnnn: FIFO had ### page faults. LRU had ### page faults. Optimal had ### page faults. Where ### is the number of page faults, x is the number of page frames, and nnnnnn is the page-reference string.

A sample of size 34 will be drawn from a population with mean 44 and standard deviation 9.

(a) Is it appropriate to use the normal distribution to find probabilities for x?
(b) If appropriate find the probability that x will be between 45 and 46. Round the answer to at least four decimal places.
(c) If appropriate find the 38th percentile of mean=x Round the answer to at least two decimal places.

Directions:      

1. The Table of Data below contains the blood pressure (BP) readings for ten college students.   All systolic and diastolic       readings are in units of mmHg.

2. Enter these data into a table in an Excel spread sheet with the following columns: Subject

Systolic P (mmHg)

Diastolic P (mmHg)

Pulse P (mmHg)

    Clearly label the table with a title and the column headings, including units.

3. Using Excel, provide a histogram for each of the following data:

            a. Systolic BP

            b. Diastolic BP

            c. Pulse Pressure (PP)   Note: PP = (Systolic Pressure) – (Diastolic Pressure)

4. Using Excel, for the Systolic BP and the Diastolic BP and the Pulse Pressure, calculate the following:

            a. range

            b. mean

            c. standard deviation

            d. variance

            e. maximum

            f. minimum

Table of Data

Subject             Blood Pressure (BP)

1                    120/60

2                    126/60

3                    120/70

4                    110/70

5                    116/72

6                    110/68

7                    130/90

8                    128/86

9                    126/80

10                    130/82

7. Suppose the government pays everyone who lost his/her job during the current

crisis 5000$. How does the graph below change? How does the GDP change?

Explain.

Currently, Forever Flowers Inc. has a capital structure consisting of 30% debt and 70% equity. Forever's debt currently has an 8% yield to maturity. The risk-free rate (r_RF) is 3%, and the market risk premium (r_M - r_RF) is 4%. Using the CAPM, Forever estimates that its cost of equity is currently 14.5%. The company has a 40% tax rate. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations.

1. What is Forever's current WACC? Round your answer to two decimal places.

   %

2. What is the current beta on Forever's common stock? Round your answer to two decimal places

3. What would Forever's beta be if the company had no debt in its capital structure? (That is, what is Forever's unlevered beta, b_U?) Round your answer to two decimal places.

   Forever's financial staff is considering changing its capital structure to 40% debt and 60% equity. If the company went ahead with the proposed change, the yield to maturity on the company's bonds would rise to 10%. The proposed change will have no effect on the company's tax rate.

4. What would be the company's new cost of equity if it adopted the proposed change in capital structure? Round your answer to two decimal places.

   %

5. What would be the company's new WACC if it adopted the proposed change in capital structure? Round your answer to two decimal places.

An article suggested that yield strength (ksi) for A36 grade steel is normally distributed with μ = 44 and σ = 5.0.

(a) What is the probability that yield strength is at most 40? Greater than 64? (Round your answers to four decimal places.)

(b) What yield strength value separates the strongest 75% from the others? (Round your answer to three decimal places.)
____________ ksi

If exogenous investment falls by USD 40 billion and the MPC is 8/11 and there is a multiplier effect, then:

a. short-run equilibrium output falls by 11/8 x USD40 billion.

b. None of the other 4 choices.

c. short-run equilibrium output falls by 11/3 x USD40 billion.

d. short-run equilibrium output by 3 x USD40 billion.

e. short-run equilibrium output by 8/3 x USD40 billion.