There is an excell spreadsheet that is suppose to accompany the questions but it

Question

There is an excell spreadsheet that is suppose to accompany the questions but it wont let me upload them, is there another way to upload? I only need questions #3 and #4 answered

M5 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign5.xls (where XX is your Group Name), and upload and submit to the instructor through Folio Dropbox. Do not enter anything in the spreadsheet cells that are black. You must complete this assignment without the assistance of persons other than the members of your Group. You may use any other resources you deem necessary. Answer the questions below by placing the appropriate graph and/or answers in the designated cells of the spreadsheet. DO NOT CHANGE THE APPEARANCE OR FUNCTIONALITY OF THE SPREADSHEET UNLESS INSTRUCTED TO DO SO. Use one simulation run of 500 iterations for this assignment. Fix Initial Seed at one for all runs. QUESTION 1 (20 points): The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distribution for the purchase cost, the labor cost, and the transportation cost are given in worksheet Brinkley. a. 3 Points: Compute profit per unit for the base case, worst case, and best case. Note that the base case is calculated, in the case of Procurement Cost, as 10*0.25+11*0.45+12*0.3. b. 8 Points: Construct a simulation model to estimate the mean, the maximum, and the minimum profit per unit. c. 3 Points: Provide a distribution of profit per unit and comment on the distribution. d. 3 Points: Management believes the project may not be sustainable if the profit per unit is less than $5. Use your simulation model to estimate the probability the profit per unit will be less than $5. e. 3 Points: Use your simulation model to estimate the probability the profit per unit will be between $5 and $7. QUESTION 2 (30 points): What will your retirement portfolio be worth in 10 or 20 years? Can you retire as planned? The Human Resources Department at Corner Stone Corporation wants to develop a financial planning model that would help employee address these questions. Your team was asked to lead this effort. Using Tom as an example, he is 40 years old and making $85,000 per year. Through contributions to his company’s retirement program, Tom has accumulated a portfolio valued at $50,000. The worksheet CornerStone provides a financial projection for the next year assuming 5% annual salary growth rate, new investment contribution at 6% of his salary, and 10% annual portfolio growth rate. Note that investment contribution would occur evenly throughout the year, and thus half of the new investment could be included in the computation of the portfolio earnings for the year. a. 4 Points: Tom plans to work for another 20 years and hopes to accumulate a portfolio valued at $1,000,000. Can he do it? Based on your calculation, what is Tom’s portfolio value if he works for another 20 years? Place your answer in Cell J2. 2 b. 15 Point: Annual salary growth rate and portfolio growth rate are subject to fluctuations. Assume salary growth rate would vary from 0 to 5% following a uniform distribution and annual portfolio growth rate could be approximated by a normal distribution with a mean of 10% and a standard deviation of 5%, construct your worksheet simulate Tom’s portfolio value in 20 years. Place your model in worksheet CornerStoneSimulation. c. 4 Points: Provide a distribution of Tom’s portfolio value in 20 years and comment on the distribution. d. 3 points: What is the probability that Tom will achieve his $1,000,000 retirement goal using the outcome distribution from part c? e. 4 points: If Tom is willing to work for another 27 years, what is the probability that Tom will achieve his $1,000,000 retirement goal? QUESTION 3 (30 points): An entrepreneur who operates a cellular phone store orders inventory of cell phones based on four internal memory specifications – 8 GB, 16 GB, 32 GB, and 64 GB. She wants to evaluate her inventory ordering policy for the phones with four different amounts of internal memory. Any phone unsold at the end of a period is kept in inventory for the next sales period and incurs a holding cost expressed as 10% of the cost per unit per period. If demand during a period exceeds supply for a phone, then sale is lost. The data on the cost and selling prices of the cell phones categorized by these memory specifications are known, and representative data on the past sales are provided in worksheet CellPhone. a. 3 Points: To model the respective cell phone demands, fit a realistic distribution to the sales data for each type of the cell phone. Provide the distributions and comment on them. b. 8 Points: Construct a spreadsheet simulation model to estimate the total profit the entrepreneur earns in a period when ordering 300 units of each cell phone. c. 3 Points: What is the estimated likelihood that the entrepreneur makes less than $10,000 next period? d. 3 Points: Compute the correlations between the demands for the cells phones based on the four memory specifications. Comment on the correlation matrix. Use worksheet CellPhoneCorrelation. e. 7 Points: Incorporate the correlation matrix to captures the interrelationships between the demands for each cell phone type and construct a new model to estimate the total profit the entrepreneur earns in a period when ordering 300 units of each cell phone. f. 3 Points: Based on the model from part e, what is the estimated likelihood that the entrepreneur makes less than $10,000 next period? g. 3 Points: Provide the total profit distributions from parts b and e. Does the correlated demand affect the model's output? QUESTION 4 (20 points): A tourist bus can accommodate 80 people and currently books up to 80 reservations. Past data shows that the tourist bus always accommodates all 80 reservations but that, on average, two people do not show up. To capture additional profit, the travel agent is considering an overbooking strategy in which he would accept 82 reservations even though the tourist bus can accommodate only 80 people. The travel agent believes that he will be able to always book all 82 reservations. The probability distribution for the number of people showing up when 82 reservations are accepted is estimated in worksheet Overbooking. 3 The travel agent receives a marginal profit of $110 for each passenger who books a reservation (regardless whether they show up). The travel agent will also incur a cost for any passenger denied seating on the bus. This cost covers added expenses of rescheduling the passenger as well as loss of goodwill, estimated to be $160 per passenger. a. 10 Points: Develop a spreadsheet simulation model for this overbooking system. b. 3 Points: What is the average net profit for each tourist bus with the overbooking strategy? c. 2 Points: What is the probability that the net profit with the overbooking strategy will be less than the net profit without overbooking (80*$110 = $8,800)? d. 5 Points: Evaluate other overbooking levels of 81, 83, and 84 and recommend a best overbooking level. In each case, the travel agent needs to estimate the distribution of the number of passengers showing up and rerun the simulation model.

Explanation / Answer

Answer:

HR Recruiting

At the point when an organization is recruiting, they have to guarantee that they enlist the correct workers. There are a few unique advances associated with the employing procedure. This lesson clarifies these means that incorporate application shapes, testing, talking with, reference checks and wellbeing exams. The enlisting procedure is the way toward exploring applications, choosing the correct possibility to talk with, testing applicants, picking between contender to settle on the recruiting choice and performing different pre-business tests and checks. Amid the contracting procedure, a HR supervisor will utilize the accompanying strides to decide the most ideal fit for the activity:

Analyse Job applications

Test the interviewers/ Candidates

Interviewing selected candidates

Choosing the right candidates in line with the roles and responsibilities & the match

Performing the background check for the selected candidates

Arranging health checks for the candidates who gets finally selected

Bark's Dog Bone Company expected to enlist another dough puncher. Mr. Parsley, human asset chief, got more than 200 applications. He knew he needed to utilize a procedure to choose the most ideal applicant. In any case, what would it be advisable for him to do next? Testing hopefuls will be the subsequent stage and for the most part includes testing contender for work aptitudes or information to decide if the applicant is fit the bill for the position. Tests may incorporate identity tests, aptitudes tests and physical tests. Mr. Parsley picked a few applicants and sent them for testing. When he gets the aftereffects of the testing, he will limit the choice to less hopefuls.

Meetings are booked next. A meeting is a meeting between the activity searcher and the business to assess whether the applicant has the correct capabilities for the activity. In spite of the fact that testing gave Mr. Parsley with a smart thought of whether the competitors would be ideal for the activity, the eye to eye meeting will disclose to him more about the applicant, similar to individual cleanliness, auspiciousness and conduct. Once the meetings have been finished, applicants will be chosen on the premise of the consequences of the testing and the meeting. This progression will limit the pool of applicants down much more. An arrangement of pre-decided criteria is produced and may incorporate abilities, learning, background and instruction. The exact opposite thing which is taint one of the urgent once in the HR enrollment process in choosing an applicant. The determination procedure is totally in view of the every past round on the meeting the applicants experienced at this point. On the off chance that the competitor clears every one of the criteria of being enlisted he gets chose if not he gets rejected.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.