Predictive Modeling and Business Analytics

Predictive Modeling and Business Analytics Guidelines
Creating spreadsheet models is an art that requires practice.

Below there are various great examples of things that can be done with spreadsheet. Some numbers and details have been changed so please use the information provided within this file and the files posted in Sakai.
Provide the final answer in Word and the Excel spreadsheet.

Predictive Modeling and Business Analytics Problems

Excerpts from Business Analytics by J. Evans 2nd Edition. While creating the models for each of the problems, make sure to follow the guidelines for spreadsheet quality.
Linear Optimization
1. Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are given in the table.
Components Required/Unit
A
B
Profit/Unit
LaserStop
18
6
$24
SpeedBuster
12
10
$40
a) Identify the decision variables, objective function, and constraints in simple verbal statements.
b) Mathematically formulate a linear optimization model.
c) Implement the linear optimization model that you developed in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constrains.
2. Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more-expensive hardware and require additional time for finishing and polishing. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 15 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $225, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot.
a) Identify the decision variables, objective function, and constraints in simple verbal statements.
b) Mathematically formulate a linear optimization model.
c) Implement the linear optimization model that you developed in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constrains.
3. Using the Banking Data file, do the following:
a. Use XLMiner to generate a simple random sample of 10 records from the Excel file Banking Data.
b. Construct a boxplot for the Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What observations can you make about these data?
c. Construct a parallel coordinates chart for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What conclusions can you reach?
d. Construct a scatterplot matrix for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What conclusions can you reach?
e. Construct a variable plot for all the variables.
Data Mining
4. Apply cluster analysis to the numerical data in the Excel file Credit Approval Decisions. Analyze the clusters and determine if cluster analysis would be a useful classification method for approving or rejecting loan applications.
OPRE 605: Business Analytics
Predictive Modeling and Analytics

Predictive Modeling and Business Analytics Guidelines

Creating spreadsheet models is an art that requires practice. Below there are various great examples of things that can be done with spreadsheet. Some numbers and details have been changed so please use the information provided within this file and the files posted in Sakai.
Provide the final answer in Word and the Excel spreadsheet.
Problems
Excerpts from Business Analytics by J. Evans 2nd Edition. While creating the models for each of the problems, make sure to follow the guidelines for spreadsheet quality.
Linear Optimization
1. Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are given in the table.
Components Required/Unit
A
B
Profit/Unit
LaserStop
18
6
$24
SpeedBuster
12
10
$40
a) Identify the decision variables, objective function, and constraints in simple verbal statements.
b) Mathematically formulate a linear optimization model.
c) Implement the linear optimization model that you developed in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constrains.
2. Burger Office Equipment produces two types of desks, standard and deluxe. Deluxe desks have oak tops and more-expensive hardware and require additional time for finishing and polishing. Standard desks require 70 board feet of pine and 10 hours of labor, whereas deluxe desks require 60 board feet of pine, 18 square feet of oak, and 15 hours of labor. For the next week, the company has 5,000 board feet of pine, 750 square feet of oak, and 400 hours of labor available. Standard desks net a profit of $225, and deluxe desks net a profit of $320. All desks can be sold to national chains such as Staples or Office Depot.
a) Identify the decision variables, objective function, and constraints in simple verbal statements.
b) Mathematically formulate a linear optimization model.
c) Implement the linear optimization model that you developed in Excel and use Solver to find an optimal solution. Interpret the Solver Answer report and identify the binding constraints and verify the values of the slack variables by substituting the optimal solution into the model constrains.

Predictive Modeling and Business Analytics and Banking Data Usage

3. Using the Banking Data file, do the following:
a. Use XLMiner to generate a simple random sample of 10 records from the Excel file Banking Data.
b. Construct a boxplot for the Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What observations can you make about these data?
c. Construct a parallel coordinates chart for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What conclusions can you reach?
d. Construct a scatterplot matrix for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance. What conclusions can you reach?
e. Construct a variable plot for all the variables.
Data Mining
4. Apply cluster analysis to the numerical data in the Excel file Credit Approval Decisions. Analyze the clusters and determine if cluster analysis would be a useful classification method for approving or rejecting loan applications.

International Trade Article Summary

International Trade

Please briefly describe or summary the article. What are benefits and consequences of Trade Gap between US and China. Give opinion about the expectancy of president Trump at G20.

Article link: https://www.bloomberg.com/news/articles/2018-11-29/trump-says-he-is-very-close-to-doing-something-on-china-trade

The U.S. trade deficit with China was $375 billion in 2017. The trade deficit exists because U.S. exports to China were only $130 billion while imports from China were $506 billion.

The United States imported from China $77 billion in computers and accessories, $70 billion in cell phones, and $54 billion in apparel and footwear. A lot of these imports are from U.S. manufacturers that send raw materials to China for low-cost assembly. Once shipped back to the United States, they are considered imports.

In 2017, China imported from America $16 billion in commercial aircraft, $12 billion in soybeans, and $10 billion in autos. In 2018, China canceled its soybean imports after President Trump started a trade war. He imposed tariffs on Chinese steel exports and other goods.

We can write this or a similar paper for you! Simply fill the order form!

Efficiency and effectiveness Essay Paper

Efficiency and effectiveness

Efficiency and effectiveness is essential to control costs and quality in healthcare organizations. Research global and national accreditation bodies working to accredit facilities in Saudi Arabia. Write a 6-7-page paper evaluating the agency and its effect on healthcare organizations using the readings and research.

Your paper should address the following substantive requirements:

description of the agency and the facilities it accredits,
assess the agencies impact on efficiency and effectiveness of organizations in Saudi Arabia,
evaluate accreditation from the aspect of involved stakeholders,
and compare and contrast facilities with and without the accreditation.

Provide support for your statements with in-text citations from a minimum of six scholarly articles(avoid Wikipedia and similar encyclopedias or blogs. Two of these sources may be from the class readings, textbook, or lectures, but four must be external.
Utilize headings to organize the content in your work.

We can write this or a similar paper for you! Simply fill the order form!

Organization Behaviour Research Paper

Organization Behaviour

The book is “Behavior in Organizations” by Jerald Greenberg.

Those are the topic of the book from chapter 1 to chapter 14, You can talk about work environment, Trust, decision making, power, individual differences, communication, and team work. 500-word essay outlining the concepts from the course which you have found most meaningful and describing how you anticipate incorporating these new concepts into your professional, academic or personal life. Explanation of how you’ll incorporate course concepts in the future, citing specific examples. Evidence of understanding of general Organization Behavior course topics

We can write this or a similar paper for you! Simply fill the order form!

CAPSIM INDIVIDUAL ASSIGNMENT

CAPSIM Individual Assignment

CAPSIM Individual Assignment-5 pages long
Learning Outcome: Using the appropriate data from a business simulation, determine the firm’s performance on key indicators and communicate this assessment and recommendations for management actions.
Please Note: This assignment is an individual assignment on team portion of the Capsim
Develop a written paper, addressing the following:
The Situation Analysis has five areas: Perceptual Map, Demand Analysis, Capacity Analysis, Margin Analysis and Consumer Report. Overall, the Situation Analysis will give you an idea of where the market currently stands and where it will go.

1. On the Perceptual Map, all segments drift to the lower right. Which segment drifts at the fastest rate? Which drifts at the slowest?

2. Each Segment’s Ideal Spot shows the buyer’s preferred coordinates within the circle. Why is the High End Ideal Spot to the lower right of the segment center? Why is the Low End Ideal Spot to the upper left of the Low End segment center?

3. On a unit demand basis, the Performance Segment is growing at the fastest rate, 19.8% each year. In which round will demand for Performance products exceed the demand for Size products?

4. Explain how increasing First Shift Capacity can reduce per unit labor costs.

5. Automation reduces per unit labor costs but it has two disadvantages. What are these?

6. A product’s margin is determined by subtracting its manufacturing costs (labor and material) from its price. Logically, higher prices and lower labor and material costs result in higher margins. Keeping in mind the Customer Buying Criteria, how would you increase margins for a Low End product? How would you increase margins for a High End product? Hint: The criteria can be found in the Capstone Courier Market Segment Analyses.

7. The Consumer Report indicates how customers perceive your product offerings. For example, Reliability (MTBF) is very important to Performance customers. What is the current MTBF for your Performance product? Given the desired range for Performance customers (found in the Buying Criteria) how many hours would it need to be raised to receive an “A” on the Consumer Report?

Your paper is to be written in 6th edition APA formatting, and should be no less than 5 pages in length (excluding cover and reference page). Also you should use at least 2 academic references to support your analysis and critical thinking.

We can write this or a similar paper for you! Simply fill the order form!

Opportunity Analysis Plan Assignment

Opportunity Analysis Plan

In Task 5-3, you will submit a draft Opportunity Analysis Plan. The format should match the requirements. However, only the first three sections of the outline described above are due for this milestone. Section 4, Business Phasing, is not required to be turned in as part of this milestone.

It is used to find and solve weaknesses and risks, first on your own and later in discussions with people whose expertise you value.

The Opportunity Analysis has four sections;

Part One: Describe the Business Idea and the Competition
Part Two: Describe the Market
Part Three: Describe Your Team’s Skills, Experience, and Resources
Part Four: Describe the Timeline for Launching the Venture

We can write this or a similar paper for you! Simply fill the order form!

New World Wine Regions Research Paper

New World Wine Regions Research Paper Select one of the New World wine regions covered in class and your book (see Classes 2, 6, and the Australia, New Zealand, South Africa, Chile, and Argentina sections of Wines of the World).

Based on your textbook reading and additional research, write a 2- to 3-page paper about your selected region (typed in standard Times or Times New Roman font, double-spaced with single inch margins and MLA citations where appropriate), including the following:
1. Its star grape varieties and why they grow well;
2. Viticulture and/or winemaking styles;
3. What makes wine from that region special?
4. And, an opportunity or challenge you think these wine producers face in today’s market, particularly among younger wine consumers.

International Business Implementation

International Business Implementation For the company Tesla Corporation, based on the textbook, cases, and lectures, develop a strategy for this company to enter, compete, and grow in a foreign country (The Company must not already be in the country you choose.).

Clearly explain you’re recommended: a) strategy; b) organizational architecture; c) control systems; and d) processes for building capabilities, innovating, and motivating people Write a report of no more than 1,500 words.
Along with a maximum 1500 words, in the report, include as many charts/ graphs and other data tables that support your business plan to take Tesla motors to an international country. (Remember don’t pick a country where Tesla already has their business)
Prove in the report with analysis and data/factual figures why Tesla must go to this international country, and explain how and why it will be a profitable venture there in the long run.

Consumer and Organizational Buying Processes

Consumer and Organizational Buying Processes Select any one of the following starter bullet point sections. Review the important themes within the sub questions of each bullet point.

The sub questions are designed to get you thinking about some of the important issues. Your response should provide a succinct synthesis of the key themes in a way that articulates a clear point, position, or conclusion supported by research. Select a different bullet point section than what your classmates have already posted so that we can engage several discussions on relevant topics. If all of the bullet points have been addressed, then you may begin to reuse the bullet points with the expectation that varied responses continue.

Consumer and Organizational Buying Processes Essay Description

You work for a firm that produces packaged potato chips. Your firm is interested in exporting its product to a different country. You need to select a country other than the one you live in and describe the culture of that country along with the key elements of its marketing system.
Describe the different tastes, needs, and customs of your intended customers.
Would these differences be consistent or different among multiple countries in a geographic region? Explain why.

Consumer and Organizational Buying Processes References

Explain how culture influences the way consumers view the different attributes of a product. Also, explain how the culture in which individuals are raised has an impact on the products they buy. How can a seller use culture to sell a product successfully? Provide two examples showing how culture influences the purchasing process.
Include references, APA format

Disaster Recovery Plan for Small Business

Disaster Recovery Plan for Small Business 1. You have been asked to test the recovery plan for small business in your area.

The company has a backup plan that is well documented.
2. Describe the steps would use to test the plan to ensure that the backup plan would functions in case of an actual emergency. If you already feel there aren’t enough hours in the day to run your small business, preparing a disaster recovery plan may seem pretty low down in your priorities.That’s understandable, as most of the day-to-day running of your operation falls on your shoulders.