Project Week 2 For these project assignments throughout the course you will need to reference the data in the ROI Excel spreadheet. Using the ROI data set: For each of the 2 majors calculate the mean, median, minimum, maximum, range, and standard deviation for the columns ‘Cost’ and ’30-Year ROI’. By hand or with Excel, for each of the 2 majors calculate the probability that a college picked from the column for ‘School Type’ is ‘Private’.By hand or with Excel, for each of the 2 majors find the probability that a college with the ‘School Type’ ‘Private’ has a ’30-Year ROI’ between $1,500,000 and $1,800,000.Excell Sheet Attached with ROI Data

Calculating Sell Thru allows businesses and managers to determine the percentage of units sold compared to the total amount originally on hand.Calculating Penetration of product styles, product types, vendors, etc., allows managers to identify and reorder best sellers, and to take action to address slow-selling, less-profitable products. What ultimately influences results are the actions that businesses take, based on analysis of the information gathered from the data and the thought processes used to make decisions.Scenario A:The buyer ordered 1,200 units of seasonal garden items and planned for a 35% sell thru in the first month.All 1,200 units were received in the stores 4 weeks ago.Of the 1,200 units, the sell thru on garden hoses was the highest and the stores in warmer climates sold more garden hoses during the first four weeks.The current inventory report shows 400 units of the seasonal garden items on hand.Scenario B: The buyer ordered the garden hoses from several different vendors.Vendor A - $90,500 in salesVendor B - $80,000 in salesVendor C - $40,000 in salesThe total garden hose category had $400,000 in sales for the quarter.Instructions:Use the information in the scenarios provided above to answer the following questions: Scenario A: Calculate the sell thru of seasonal garden items in the scenario and include your calculations in your answer.Scenario A: Analyze the scenario in order to provide justification when answering the following questions:Is sell thru "good" or "bad", as compared to the buyer's plan?What can the sell thru data tell the buyer?How should the buyer respond to the sell thru data?Why is it important to know which stores are trending up/down in seasonal garden item sales?Scenario B: Calculate the penetration in dollars for each of the vendors and include your calculations in your answer.Scenario B: Analyze the scenario in order to provide justification when answering the following questions:What is each vendor's dollar penetration rate (percentage) and what can the penetration rate for each vendor tell the buyer?Considering the available information, what recommendations would you make regarding reorders for each of the vendors?What other information would you need about the garden hoses and/or vendors to allow you to make wise decisions on reorders?Summarize the results of your analysis of the two scenarios to explain the importance of using sell thru and penetration calculations to aid in managerial decision-making. Justify your explanation.Compose your answers with a minimum of one paragraph per question (a - e), for a minimum of 5 paragraphs total.Research and use at least one additional outside source to support your recommendations