Data Mining for Business Decisions (BSAN 54000-001) Summer 2022 Midterm Exam Note: Please submit your excel...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66463c4122bae_97666463c40d5307.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66463c41b7e54_97766463c417fcca.jpg)
Transcribed Image Text:
Data Mining for Business Decisions (BSAN 54000-001) Summer 2022 Midterm Exam Note: Please submit your excel sheets along with word documents of your answers. Also, on problem 2 please submit your decision tree. 1) Chipper Payroll Services knows the demand for its services during the current year is around 50,000 worker hours and with current operations covers all customer demand (i.e., Chipper's capacity currently is 50,000 worker-hours). Chipper is planning on a 5% growth rate each year. Chipper's current office space and staff will eventually outgrow demand. Expanding the office space and staff depends mostly on the hours that will be worked total in the facility. If we let x = total worker-hours, Chipper will incur a one-time cost of $15x to expand [i.e., if Chipper goes from 50,000 worker-hour capacity to 70,000 worker-hour capacity, it will incur a cost of $15 x (70,000 - 50,000) = $300,000]. Chipper needs to expand its current space and staff, since any new business will be lost to its competitors if it cannot accommodate the new customers. Each customer serviced incurs a variable cost of $3.00 per worker-hour. It also costs Chipper $6.00 per worker-hour of capacity per year (i.e., if Chipper has 70,000 worker hours total then Chipper incurs $6 x 70,0000 = $420,000 per year in costs). Chipper garners $25 per worker hour from its customers. 2) Construct an Excel spreadsheet model to determine what the projected revenue, costs, and potential profits would be over the next 10 years based on the current capacity, 50,000 worker-hours, an expansion to 70,000 worker-hours, and an expansion to 90,000 worker- hours. 15points James Bernard, head of leasing at New Braunfels Inc., has to decide whether to build a new state-of the-art processing facility. If the new facility works, the company could realize a profit of $200,000. If it fails, New Braunfels could lose $150,000. At this time, he estimates a 60% chance that the new process will fail. The other option is to build a pilot plant and then decide whether to build a company-wide facility. The pilot plant would cost $10,000 to build. James estimates a 50-50 chance that the pilot plant will work. If the pilot plant works, there is a 90% probability that the complete plant, if it is built, will also work. If the pilot plant does not work, there is only a 20% chance that the complete project (if it is constructed) will work. James faces a dilemma. Should he build the plant? Should he build the pilot project and then make a decision? Help James by analyzing this problem: Create a decision tree and please submit. What recommendation, based on expected value, would you give James? 15 Points PAGE 1 OF 2 Data Mining for Business Decisions (BSAN 54000-001) Summer 2022 Midterm Exam 3) Historical data indicate that a student's income for any month of school from work, parents, scholarships, and loans is consistent with the following probability distribution INCOME PROBABILITY $750 0.20 $950 0.36 $1150 0.30 $1350 0.14 Expenses for the same student are believed to be consistent with the following probability distribution: EXPENSE PROBABILITY $900 0.40 $1000 0.25 $1100 0.20 $1200 0.15 Assuming the student begins the school year with a balance of $1200, use Excel to simulate 12 months of activity and to predict the position of the student at the end of the year. Please explain your results. 20 Points Data Mining for Business Decisions (BSAN 54000-001) Summer 2022 Midterm Exam Note: Please submit your excel sheets along with word documents of your answers. Also, on problem 2 please submit your decision tree. 1) Chipper Payroll Services knows the demand for its services during the current year is around 50,000 worker hours and with current operations covers all customer demand (i.e., Chipper's capacity currently is 50,000 worker-hours). Chipper is planning on a 5% growth rate each year. Chipper's current office space and staff will eventually outgrow demand. Expanding the office space and staff depends mostly on the hours that will be worked total in the facility. If we let x = total worker-hours, Chipper will incur a one-time cost of $15x to expand [i.e., if Chipper goes from 50,000 worker-hour capacity to 70,000 worker-hour capacity, it will incur a cost of $15 x (70,000 - 50,000) = $300,000]. Chipper needs to expand its current space and staff, since any new business will be lost to its competitors if it cannot accommodate the new customers. Each customer serviced incurs a variable cost of $3.00 per worker-hour. It also costs Chipper $6.00 per worker-hour of capacity per year (i.e., if Chipper has 70,000 worker hours total then Chipper incurs $6 x 70,0000 = $420,000 per year in costs). Chipper garners $25 per worker hour from its customers. 2) Construct an Excel spreadsheet model to determine what the projected revenue, costs, and potential profits would be over the next 10 years based on the current capacity, 50,000 worker-hours, an expansion to 70,000 worker-hours, and an expansion to 90,000 worker- hours. 15points James Bernard, head of leasing at New Braunfels Inc., has to decide whether to build a new state-of the-art processing facility. If the new facility works, the company could realize a profit of $200,000. If it fails, New Braunfels could lose $150,000. At this time, he estimates a 60% chance that the new process will fail. The other option is to build a pilot plant and then decide whether to build a company-wide facility. The pilot plant would cost $10,000 to build. James estimates a 50-50 chance that the pilot plant will work. If the pilot plant works, there is a 90% probability that the complete plant, if it is built, will also work. If the pilot plant does not work, there is only a 20% chance that the complete project (if it is constructed) will work. James faces a dilemma. Should he build the plant? Should he build the pilot project and then make a decision? Help James by analyzing this problem: Create a decision tree and please submit. What recommendation, based on expected value, would you give James? 15 Points PAGE 1 OF 2 Data Mining for Business Decisions (BSAN 54000-001) Summer 2022 Midterm Exam 3) Historical data indicate that a student's income for any month of school from work, parents, scholarships, and loans is consistent with the following probability distribution INCOME PROBABILITY $750 0.20 $950 0.36 $1150 0.30 $1350 0.14 Expenses for the same student are believed to be consistent with the following probability distribution: EXPENSE PROBABILITY $900 0.40 $1000 0.25 $1100 0.20 $1200 0.15 Assuming the student begins the school year with a balance of $1200, use Excel to simulate 12 months of activity and to predict the position of the student at the end of the year. Please explain your results. 20 Points
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
1 . WACC calculation You are analyzing a Corporation s capital structure. It has the following issues of capital. The company can NOT use the tax shelter. Determine the WACC and its parts. Common...
-
Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What is the payback period? Name and discuss three possible reasons that the payback period is used to help make capital investment decisions.
-
The following information was drawn from the 2016 balance sheets of the Augusta and Reno Companies: Required a. Compute the current ratio for each company. b. Which company has the greater likelihood...
-
Prior to liquidating their partnership, Kim and Cheyenne had capital accounts of $304,000 and $190,000, respectively. Prior to liquidation, the partnership had no cash assets other than what was...
-
Watch Bettina Warburg's TED Talk titled "How the Blockchain Will Radically Transform the Economy," dated June 2016 at https://www.ted.com/talks/bettina_warburg_...
-
Great Eastern Inns has a total of 2,000 rooms in its chain of motels located in eastern Canada. On average, 70% of the rooms are occupied each day. The companys operating costs are $42 per occupied...
-
finance 1. You have just won another secret lottery that will provide you ten payments of $10,000 with the first payment being made six months from today and subsequent payments occurring...
-
A concave spherical mirror has a focal length of 6.00 cm. If an object is placed at a distance of 24.0 cm from the mirror, calculate the image distance and characteristics of the image including...
-
) The matrix below is in echelon form. x y z 0 1 0 6 0 0 1 6 0 0 0 0 Write the corresponding linear system. equation 1 x+ y+ z= equation 2 x + y + z= equation 3 x+ y + z= Solve the linear system....
-
Determine the force T that will produce impending motion upward of the 300-lb weight in Figure 8. (Assume a coefficient of friction of 0.25.) Also, find the minimum force T required to hold the...
-
Kayla wants to have $100,000 saved when she graduates. She plans to graduate in 6 years and believes that she can earn 12% per year. Caroline believes Kayla is overly optimistic about her earning...
-
For an island where the demand for housing is increasing and supply is decreasing home-sharing is one option to solve the problem. what are the benefits of sharing a home and the negative impacts?...
-
Show that the Bolzano-Weierstrass theorem does not hold in infinite-dimensional spaces by giving an explicit counterexample in the space C([0, 1], K) with the || || norm.
-
Sage Hill Inc. issued $852,000 of 20-year, 10% bonds on January 1, 2020, at 103. Interest is payable semi-annually on July 1 and January 1. The company follows ASPE and uses the straight-line method...
-
In Exercises 1-2, rewrite each verbal statement as an equation. Then decide whether the statement is true or false. Justify your answer. 1. The logarithm of the difference of two numbers is equal to...
-
Figure 1-2 shows that organizational culture and the design of an AIS influence one another. What does this imply about the degree to which an innovative system I developed by one company can be...
-
One interesting property of digital assets is that they can be reproduced and dis tributed via the Internet at very little cost. What are some of the implications of having a product with a marginal...
-
Figure 1-2 shows that developments in IT affect both an organizations strategy and the design of its AIS. How can a company determine whether it is spending too much, too little, or just enough on...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App