Class welcome to module 5,Milestone 2 is due at the end of this module. Milestone 2 drills down into cost factors. Make sure you have corrected any issues from Milestone 1, otherwise these errors can cause problems in Milestone 2. Also, you need to take care in organizing your Milestone 2 reports in a logical manner and properly labeling the charts and tables.In Part A you will be producing three costs for each BIN. Those will be:Transport Cost (what did each shipment in each BIN actually cost to ship) Cost per pallet (if you take the transport cost and divide by number of pallets shipped you will get cost per pallet)Cost of shipping (what did it cost the company to make all the shipments in this BIN)In this part you do need to examine where the break-even point is between shipping individual pallets and when it is cheaper to simply use a whole truck. For example, if it costs $210 to ship pallets individually to Omaha and it costs $1000 to send a whole truck (full or not) you would realize that for any shipment above four pallets (4 x $210 = $840) it would be cheaper to use a whole truck (5 x $210 = $1050). So, for shipments in BINs less than 5, the Transport Costs would equal the cost per pallet and for shipments in BINs 5 to a BIN 24 the Transport Cost would be equal to the cost of a full truck. In Part B-C, COGs is the Cost of Goods Sold and it equals the cost of producing the wine shipped. Be very careful with Parts A-D because the parts build on each other, so a mistake made earlier can foul up the rest of your work.This week you are also being introduced to ‘Solver’. Make sure that it is part of your Excel program or that you have downloaded it as an Add-In. If you are wondering if you have Solver, just look at your ribbon bar and it should appear (for example on this screen shot it is under Data Analysis on the left side. If you click on Solver, a box (see below) will appear. If you have not used Solver before, it will take some time to master and you will experience some trial and error. Start early! What Solver basically figures out is what is possible when you are working with multiple constraints. An example if you were building boxes and you knew that each box required 1 sheet of plywood, 20 linear feet of framing material, and 30 nails, and you had a supply of 20 sheets of plywood, 260 linear feet of framing material, and 900 nails how many boxes could you make? In this simple case the amount of supplies you have would be your constraints. You could look at each constraint individually:Plywood, you have 20 sheets and each box requires 1 sheet per box- so you have enough for 20 boxesFraming material, you have 260 liner feet and each box requires 20 feet- so you have enough for 13 boxesNails, you have 900 and each box requires 30- so you have enough for 30 boxesIn this case the binding constraint is the framing material, it will limit total production to 13 boxes.However, as the formulas become more complex and there are more variables, the time need to solve the problem would become increasing time consuming. Therefore, we use Solver. When you take the Quiz and the following question appears “What three things do you need to specify before running Solver?” on your quiz do not worry if you get it wrong. There is a problem with the question and I will issue you credit for the question. You need to master the use of Solver because in Milestone 3 it accounts for a large percentage of the grade. Keep up the good work!Steve O’Malley

its an excel statistics projectgain a better understanding of the use of excel to make HW problems easierTask: Follow the directions below in the order given. There are 21 questions consisting of graphs and figures as well as answers to simple questions about the data or graphs. There are two parts to the project. Part 1 is this set of instructions. Part 2 is an Excel file with 6 worksheets provided for all your answers. At the end, you will print off the Excel worksheets used in the exercise and turn them in for a grade. When a question appears, answer it with its related computer output at that point; do not wait until the end of the paper to enter answers to all the questions. Please label your answers.

The Morningstar mutual-fund rating system ranks mutual funds, using one to five stars. The stars divide the mutual-fund performances into quintiles: that is, a mutual fund with a one-star rating is in the bottom 20% of mutual funds in its category, a mutual fund with two-stars is in between the 21st and 40th percentile, and so on. These data can be found at www.morningstar.com (Links to an external site.) or screen.yahoo.com/funds.html (Links to an external site.)Obtain a random sample of at least 15 mutual funds from each investment category. Determine the 3 years rate of return for each fund.Obtain a 95% confidence interval for the difference between the mean rates of return. Interpret the interval.You are going to write a report detailing which investment category seems superior.The report contains 4-5 paragraphs in Microsoft Word (.doc or .docx) format with supporting data supporting your conclusion.Attach the Excel sheet used for the primary data source. You’ll submit both the Word document and the Excel file.SubmissionThis assignment requires a file upload submission (Links to an external site.). After you have reviewed the assignment instructions and rubric, as applicable, complete your submission by selecting the Submit Assignment button next to the assignment title.RubricProject RubricProject RubricCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContent30.0 to >26.0 ptsExemplaryAll required elements are fully addressed, easily identified, and integrated into the assignment at the highest level. All key facts are clearly identified and completely addressed.26.0 to >17.0 ptsMeets ExpectationsAll required elements are addressed and identified. Several key facts are identified and completely addressed.17.0 to >9.0 ptsDevelopingRequired elements are addressed, but further elaboration is needed. A few key facts are identified and addressed.9.0 to >0.0 ptsNoviceFew of the required elements are addressed. Little or no elaboration present.0.0 ptsNot AcceptableAssignment not submitted, submitted late OR contains plagiarized content.30.0 ptsThis criterion is linked to a Learning OutcomeData Source30.0 to >26.0 ptsExemplaryOriginal data provided and summarized in appropriate tabular form and is presented in a neat and accurate way graphically or numerically26.0 to >17.0 ptsMeets ExpectationsOriginal data provided and summarized in tabular form, but with a minor error in tabulation or computation or presentation.17.0 to >9.0 ptsDevelopingOriginal data is provided, with quite a few errors when summarizing data either graphically or numerically or data is not appropriately tabulated.9.0 to >0.0 ptsNoviceOriginal data is provided, tabulated and summarized but with some major errors.0.0 ptsNot AcceptableOriginal data is not provided.30.0 ptsThis criterion is linked to a Learning OutcomeTechnical40.0 to >34.0 ptsExemplaryDemonstrates excellent problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, well organized, and flows well.34.0 to >27.0 ptsMeets ExpectationsDemonstrates good problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. All relevant statistics reported and correctly interpreted. Composition is structured logically, focused, organized, yet minor errors in format exist.27.0 to >17.0 ptsDevelopingDemonstrates inadequate problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported and correctly interpreted. Composition is, generally, structured logically, focused, organized, and flows well with but a few errors in format exist.17.0 to >4.0 ptsNoviceDemonstrates poor problem solving competency using mathematics, quantitative reasoning and statistical analysis and methods.. Most of relevant statistics reported yet incorrectly interpreted. Composition is, generally, structured logically, focused, organized, but major errors in format exist.4.0 to >0 ptsNot AcceptableConfusing explanation of statistical concepts.40.0 ptsThis criterion is linked to a Learning OutcomeData Interpretation30.0 to >26.0 ptsExemplaryThorough and accurate interpretation of the data26.0 to >17.0 ptsMeets ExpectationsCorrect and good interpretation of the data.17.0 to >9.0 ptsDevelopingCorrect and good interpretation of the data, except for minor errors or omissions.9.0 to >0.0 ptsNoviceInterpretation of the meaning of the data is provided, but with some major errors.0.0 ptsNot AcceptableNo data interpretation provided30.0 ptsThis criterion is linked to a Learning OutcomeReport Writing30.0 to >26.0 ptsExemplaryFollows APA writing style and basic rules of formal English grammar and written essay style. Communicates in a cohesive, logical style.26.0 to >19.0 ptsMeets ExpectationsMostly follows APA writing style and basic rules of formal English grammar and written essay style. Mostly communicates in a cohesive, logical style.19.0 to >12.0 ptsDevelopingAPA writing style and basic rules of formal English grammar and written essay style are followed, but with minor errors. Mostly communicates in a cohesive, logical style though at times ideas are unclear and confusing.12.0 to >5.0 ptsNoviceAPA writing style and basic rules of formal English grammar and written essay style are followed, but with major errors. Report is not communicated in a cohesive, logical style. Ideas are unclear and confusing.5.0 to >0 ptsNot AcceptableDoes not follow APA writing style and basic rules of formal English grammar and written essay style.30.0 ptsTotal Points: 160.0