商业分析作业代做 Business Analytics代写 商业分析代写
369Business Analytics 商业分析作业代做 5.There are 500 client records in the worksheet “Q5” of the Excel file (provided for this assignment) who have shopped many special products from 5. ...
View detailsSearch the whole station
商业分析期中代考 QUESTION 1: Graphical Method (25 points) The RBC (Royal Bank of Canada) uses online banking to market two new banking products.
Time: 2.5 hours or 150 minutes
The RBC (Royal Bank of Canada) uses online banking to market two new banking products. The first product is a home risk insurance that allows buyers to default for up to 6 months on their mortgage payments. The second is a guaranteed mortgage fund that buyers may purchase to leverage their funds without increasing their debt loads. The RBC expects to make profit contributions of $20 per unit on the home risk insurance instrument, and $8 per unit on the guaranteed mortgage fund. The bank has a policy that at least 50% of total sales of the two products are home risk insurance instruments. The bank is now determining sales quotas for its online offerings to maximize total expected contribution to profits based on the product resource requirements, as follows:
Resource Requirements per Product Offering (Hours per Unit)
BankDepartment | Home Risk Insurance (HRI) | Guaranteed Mortgage (GM) | Resource Availability (Hours) |
Legal | 6 | 4 | 4,800 |
Data Management | 1 | 2 | 2,000 |
Policy Claims | 3 | 0 | 1,800 |
A correct formulation for this problem is provided below:
Let HRI and GM denote the number of units of Home Risk Insurance instruments and Guaranteed Mortgage units to sell online, respectively.
MAX Z = 20 HRI + 8 GM ($)
subject to,
1) Legal Hours 6 HRI + 4 GM ≤ 4,800 hrs
2) Data Mgt Hours 1 HRI + 2 GM ≤ 2,000 hrs
3) Policy Claims 3 HRI ≤ 1,800 hrs
4) Ratio Policy Limits 0.5 HRI – 0.5 GM ≥ 0
5) Non-negativity HRI, GM ≥ 0
a）Graph the constraint lines and mark them clearly with the numbers (1), (2), (3) and (4) to indicate which line corresponds to which constraint. Darken the feasible region. (12 points)
(b) Determine the optimal solution that will maximize the total expected contribution to profits. Report the solution in a managerial statement (i.e. describe verbally the optimal solution and its profit). Provide all necessary calculations to justify your answers. (7 points).
(c) Which constraint(s) is (are) redundant? (3 points)
(d) Will there be excess capacity in the Data Management resource? Justify. (3 points).
A salad dressing supplier to Ottawa area restaurants has been using Linear Programming (LP) for years to determine how much dressing they should produce for every season. In particular, they specialize in producing three kinds of dressing: Dijon, Classic Vinaigrette, and Roasted Garlic. All these dressings require some use of olive oil to produce. Taking this into account, the management team has formulated the following LP model that determines the optimal amount they should produce for each dressing.
Answer all the questions below ACCORDING TO the above sensitivity report.
(a) What is the optimal profit? (2 points)
(b) Two numbers have been removed from the resource sensitivity table by your professor (the letters A and B appear instead of the numbers). What are the correct values of A and B? Justify. (4 points)
(c) The supplier learned recently that the price of Olive oil has been dropping significantly, and is wondering if they should take this opportunity to purchase more oils. Provide your answer and JUSTIFY it. (3 points)
(d) The profit of Dijon dressing has been found overly estimated. The company however has difficulty determining how much lower the real profit should be. Does this impact the LP optimal solutions? Justify your answer. (3 points)
(e) Some workers are not happy with their salaries and ask for a raise; otherwise, they will quit and this would reduce the available labour minutes from 280 to 240. Should the company consider the raise? If so, what will be a reasonable amount to pay (in total) to these workers in addition to their original salaries? Justify your answer. (5 points)
(f) What if the profit of ALL three dressings (i.e. Dijon, Classic Vinaigrette, and Roasted Garlic) is now $1.5/unit. Do the optimal values of the decision variables change? What will be the impact on the profit? Justify. (5 points)
Acme sells two sprocket assemblies for escalators and elevators. Each type of sprocket must first be machined and then assembled. Unit machining and assembly times, capacity limitations, demand restrictions and revenue-cost data are as follows:
Required | Hrs/unit | Max | Unit | |
Machining | Assembly | Sales | Price ($) | |
Sprocket 1 | 2 | 2 | 15 | 50 |
Sprocket 2 | 4 | 1 | 20 | 60 |
Capacity (hrs/wk) | 90 | 50 | ||
Cost | $ 5/hr | $ 4/hr |
Let x1 and x2 represent the number of units of sprockets 1 and 2 to produce, respectively.
MAX Z = 32x_{1} + 36x_{2}
Subject to
Max Sales Sp. 1: x_{1} ≤ 15
Max Sales Sp. 2: x_{2} ≤ 20
Machine Time: 2x_{1} + 4x_{2} ≤ 90
Assembly Time: 2x_{1} + x_{2} ≤ 50
Non-negativity: x_{1}, x_{2} ≥ 0
a）In November, Acme introduces a third type of sprocket (Sprocket 3). To produce one sprocket 3 requires 3 hours of machining and three hours of assembly. The maximum sales of sprocket 3 is 10 units. The selling price of a sprocket 3 is $61. The above formulation can be modified to take account of the new product. The new formulation is:
Let x_{1}, x_{2} and x_{3} represent the number of units of sprockets 1, 2 and 3 to produce, respectively. 商业分析期中代考
MAX Z = 32x_{1} + 36x_{2} _____________
Subject to
Max Sales Sp. 1: x_{1} ≤ 15
Max Sales Sp. 2: x_{2} ≤ 20
Max Sales Sp. 3: x_{3} ≤ _________
Machine Time: 2x_{1} + 4x_{2} ________ ≤ 90
Assembly Time: 2x_{1} + x_{2} ________ ≤ 50
Non-negativity: x_{1}, x_{2}, x_{3} ≥ 0
Complete the formulation above by filling in the four blanks (8 points).
In December, the problem turns out to be the same as the November problem given in part (a), except that a new packaging process has resulted in an additional requirement that at least 2 sprocket 1’s must be produced for every sprocket 2 that is produced. Either include below the LP formulation of this new problem, or clearly state how the formulation in part (a) could be changed to deal with the December situation. (2 points)
In January, the problem turns out to be the same as the November problem given in part (a), except that the selling price per unit for sprockets 1 and 2 have each decreased by 10%. Either included below the LP formulation of this new problem, or clearly state how the formulation in part (a) could be changed to deal with the January situation. (3 points)
In February, the problem turns out to be the same as the November problem given in part (a), except that it is now (in February) possible to purchase up to 10 additional hours of machine time at a price of $6 per hour. The $6 per hour cost applies to only the additional 10 hours. Either include below the LP formulation of this new problem, or clearly state how the formulation in part (a) could be changed to deal with the February situation. (6 points)
Hint: Add a new decision variable (Y: the number of extra machine hours to produce).
Formulate the original linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding “Excel Spreadsheet” and the “Sensitivity Report”). Include “managerial statements” that communicate the results of the analysis. (i.e. describe verbally the results). (8 points) 商业分析期中代考
Let x1 and x2 represent the number of units of sprockets 1 and 2 to produce, respectively.
MAX Z = 32x_{1} + 36x_{2}
Subject to
Max Sales Sp. 1: x_{1} ≤ 15
Max Sales Sp. 2: x_{2} ≤ 20
Machine Time: 2x_{1} + 4x_{2} ≤ 90
Assembly Time: 2x_{1} + x_{2} ≤ 50
Non-negativity: x_{1}, x_{2} ≥ 0
Would it be worthwhile to increase the maximum sales level on Sprocket 2 OR to increase the maximum Machine capacity? Justify. (2 points).
ACME is offered $7 per hour for use of their assembly time by an outside contractor. How much assembly time is it worthwhile to sell? (2 points).
If a machine breakdown reduced machining capacity by 20 hours, how would profits be affected? (2 points)
Niteton Power and Light Company (NPLC) wants to develop an efficient work schedule for its full- and part-time customer service clerks. The number of clerks needed to provide adequate service during each hour the office is open on a weekday is given below:
Hour 8-9AM 9-10 10-11 11-12PM 12-1 1-2 2-3 3-4
Clerks 5 4 6 8 10 9 7 4
A full time clerk works 3 hours, has a 1-hour break, and then works another 3 hours. Part-time clerks work for 4 consecutive hours. Full-timers get paid for their break. All clerks start work on the hour.
NPLC’s office manager insists that at least one full time clerk be on duty during all open hours and that at least 40% of the clerks should be full-time clerks on payroll.
A full-time clerk costs NPLC $20 per hour, and a part-timer costs $15 per hour.
Formulate a linear programming model that will provide a schedule that will meet NPLC’s customer service needs at a minimum labor cost. (Define the decision variables, objective function, and constraints). DO NOT SOLVE.
Hint on the decision variables: there are 2 different full-time shifts and 5 different part-time shifts.
更多代写：Cs代写 托福家庭版保分 英国硕士毕业论文写作技巧 英文论文writing mistakes 英文邮件结构 英国论文抄袭
合作平台：essay代写 论文代写 写手招聘 英国留学生代写
Business Analytics 商业分析作业代做 5.There are 500 client records in the worksheet “Q5” of the Excel file (provided for this assignment) who have shopped many special products from 5. ...
View detailsMGT 226 ONLINE BUSINESS ANALYTICS 线上商业分析代写 Question 1 (2 points) Descriptive analytics encompasses summarization and visualization of historical data using tables, charts, Qu...
View detailsADM 2302 SAMPLE FINAL EXAM 商业分析考试代写 QUESTION 1: (20 points) Electronics Play Group (EPG) of Packenham, Ontario is considering how to distribute a new portable MP3 player they QU...
View detailsADM 2302 Midterm Exam (sample 2) 商业分析样题代写 Please answer all the questions in the space provided (If you require more space you may use the back of the page). Only answers in this...
View details