Formulate and solve a spreadsheet model for this problem. Then use Solver's sensitivity report to find the allowable range for the unit profit of each activity. a. Determine the number of units of each activity to undertake. Note: If an allowable increase/decrease is 10,000 or larger, simply enter 10,000. Round "Allowable Increase - Solution Activity 1" answer to 1 decimal place. Round "Allowable Decrease - Solution Activity 1" answer to 2 decimal places. Name Solution activity 1 Solution activity 2 Name Resource 1 used Resource 2 used b. Determine the total profit. Final Value Final Value Reduced Cost Shadow Price 0 0 1 Objective Coefficient 2 5 Constraint Right- Hand Side 10 12 Allowable Increase Allowable Increase Allowable Decrease Allowable Decrease
Q: Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit…
A: Workforce level remains same during the entire forecast periodInventory usedBacklogs can…
Q: Statistical infographics. Informational infographics. Process infographics. Timeline infographics.…
A: An infographic is the aspect of the information system of an organization that includes all the…
Q: A company wants to minimize the cost of shipping a product from 3 different factories to 6 different…
A:
Q: Why have unions become more accepting of alternative reward systems over the past few years?…
A: The objective of the question is to understand the reasons why unions have become more accepting of…
Q: situate an on-line product delivery strategy
A: A robust online product delivery strategy goes beyond the mere act of shipping goods. It involves a…
Q: Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the…
A: An optimization problem in the real world is represented mathematically by a linear programming (LP)…
Q: In maritime law, in some cases happened for conflicts in the ships. The justification is based on…
A: The objective of the question is to understand the significance of a ship's flag and nationality in…
Q: Q1/Aircraft has 150 passengers, passengers arrange with 5 seat in one row. Fuselage width is 3.5 m,…
A: Capacity management is the aspect of management that deals with maximizing the capacity of the…
Q: What really motivates you to work hard beyond the compensation? what would you like your manager do…
A: As we know people still can work hard beyond the compensation, Here, people need enough motivation…
Q: 41.The ______ are (is) used to determine the amount of money that an organization would save if it…
A: Organizations utilize employment tests to assess job applicants, and the design, selection, and…
Q: Find an example of a corporate negotiating mistake. Describe.
A: One notable example of a corporate negotiating mistake is the failed acquisition of Hewlett-Packard…
Q: Highlighting the importance of Human Resources Management (HRM) in quality management, QM experts…
A: Human resource management is an integral part of an organization. There are several functions which…
Q: How many nurses should be working each month to most closely match payient forecast? b). Suppose…
A: Patient ForecastPatient Type: # of nurses Jan Feb March…
Q: The manufacturer of children’s toys designed a special toy truck that can be assembled in 8 basic…
A: Line balancing helps to find the optimal allotment of tasks to each workstation so that efficiency…
Q: Graph the feasible region
A: Manufacturing time (hrs)Assembly (hrs)FrameProfit ($)EZ-Rider (x)6202400Lady-Sport…
Q: 1. Waiting time, transportation, processing, and product defects are all part of the ____________…
A: 1. elimination of waste2. reduced cost3. waste5. reduce setup times7. both Lean and Six Sigma…
Q: For your next 10k race of the athletics season, you consider competing in either Sheffield, Cardiff,…
A: · A weight is proposed for each state of nature. · sums of weighted…
Q: Explain forecasting in a business
A: Business management entails planning, organizing, directing, and controlling resources as well as…
Q: Identify and describe the stakeholders and their interests in autonomous vehicles. Describe any…
A: Autonomous vehicles are the sort of vehicles that operate or work on remote-sensing technology and…
Q: Capacity utilization of the teller. Average number of cars in the waiting line Average number in the…
A: Arrival rateA15.00Service rateS20.00
Q: what is the market size and growth rate of Subway fast food restaurant?
A: Subway is a global fast-food conglomerate known for its diverse sandwich offerings and expansive…
Q: The annual requirement of a part is 360,000 units. The order cost is $120 per order, the holding…
A: Annual requirements (D) = 360,000 unitsOrder cost (S) = $120 per orderUnit cost (C) = $2,500 per…
Q: QUESTION FOUR Solve the problems below: a) Minimize Z = X1 - 2X2-3X3 s.t -2X1 + X2 + 3X3 2X1 +3X2 +…
A: I have solved the problem using Excel and Here are the Excel formulas:Now go to DATA TAB in Excel…
Q: Typically _____ of shareholders who vote in the shareholder meeting approve of executive pay plans…
A: The question is asking about the typical percentage of shareholders who vote in favor of executive…
Q: Job Flow Time (min) 1 2 3 4 5 6 minutes Makespan: Average flow time: minutes In what order would the…
A: JOBPROCESSING TIME1702903110413051606220
Q: A work team is looking at a current product in the LUML catalog --- the L555X fixture. The L555X…
A: The scenario presented revolves around a strategic initiative within a company, LUML, to enhance the…
Q: BSOP 588 Managing QualityAll Assignments Course Projects, Midterm and Final ExamWeek 2 Course…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: Write a 350- to 700-word review of the article. Your review should discuss how the SOX Act may…
A: The Sarbanes-Oxley Act (SOX) is an aspect related to the law that was enacted in 2002 This act came…
Q: Questions 1. In what ways were the project's planning and scope management appropriate? When did the…
A: The Tacoma Narrows Suspension Bridge collapsed four months after it opened in 1940, exposing design…
Q: A veterinarian has been asked to prepare a diet for a group of dogs to be used in a nutrition study…
A: The information provided is stated below:Minimum Nutrient I = 29 unitsMinimum Nutrient II = 20…
Q: Suppose in the Dorian production model that no -minimum production limits are placed on the…
A: For the condition that Dorian should create in any event 1500 vehicles in entirety, think about the…
Q: Under gate-usage agreements, aircraft schedule use of gates is coordinated with airport management…
A: The objective of the question is to identify the type of agreement that is being described, where…
Q: An automotive supply store sells a product that has a demand of 400 units per month. Its supplier…
A: The cost of maintaining or storing inventory over the course of a year is represented by the annual…
Q: Solve the following optimization model using Excel Solver and generate a sensitivity report. Upload…
A: The given problem is with linear programming. It is required to use Excel Solver to solve the…
Q: Company A has been selling 200 units per month of a product at a price of $12 per unit. The two…
A: Company A sells 200 units per month at a price of $12 per unit. The two competitors of Company A…
Q: What is the optimal number of housing for HAL Ltd. to produce in each production run? b) Find the…
A:
Q: 8. The Timken Company applied Six Sigma tools to minimize process variation to address the…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: What is the manufacturing flow process of Chick-Fil-A?
A: Chick-Fil-A is a renowned fast-food chain specializing in chicken sandwiches and other chicken-based…
Q: Figure 12-7 Selected Countries on the Uncertainty- Avoidance and Masculinity Scales Uncertainty…
A: Corkley & Finn, a successful regional investment brokerage, intends to go global, beginning with…
Q: Which of the following alternative reward systems involves aligning workers and management in…
A: The question is asking to identify the type of reward system that involves aligning the interests of…
Q: Required information [The following information applies to the questions displayed below] Camp…
A: WeekNo. of campers Cost to run…
Q: Wellplace Insurance Company processes insurance policy applications in batches of 100. One day, they…
A: The objective of the question is to calculate the proportion of nonconforming policies in each batch…
Q: How is quality defined from a customer perspective?
A: Quality, from a customer's perspective, is often defined by how well a product or service meets or…
Q: calculate the intercept for the regression line
A: Store Sales (X)Advertising…
Q: How often should the LIS be backed up? Hourly Daily Weekly Monthly
A: The objective of the question is to determine the frequency of backing up the Laboratory Information…
Q: Jim's Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demands and selling…
A: Businesses need to be mindful of the association between revenue, demand, and selling price as they…
Q: Select an item at Shoprite and assess the various types of ‘wastes’ in lean thinking with reference…
A: Lean thinking is a methodology that focuses on minimizing waste within a system while simultaneously…
Q: Number of production units: Unit Next year If you know that the average number of annual working…
A: Workload analysis is a comprehensive examination and assessment of the tasks, responsibilities, and…
Q: Animus Ltd is a mining company. Which of the following is an example of a decision relating to…
A: “Since you have posted multiple questions, we will provide the solution only to the first question…
Q: In the following MRP planning schedule for Item J, indicate the correct net requirements, planned…
A: Material Requirement Planning (MRP) is a production planning and inventory control system that helps…
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 11 images
- This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?
- Chapter 6. Solve the following Linear Program using the Solver method and answer the questions given below (round to two decimal places): Maximize 12A + 15B s.t. 3A + 7B <= 250 5A + 2B <= 200 B <= 25 A, B >= 0 a. The optimal value of A is 31.03 and the optimal value of B is 22.41. b. The maximized function yields a solution of 708.62. Chapter 7. For the problem you solved in Q1, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions: The range for Variable A is from ????? to ????? The range for Variable B is from ????? to ????? The range for Constraint 1 is from ????? to ????? The range for Constraint 2 is from ????? to ????? The range for Constraint 3 is from ????? to ?????An Insurance Company is introducing two new product lines: special risk insuranceand mortgages. The expected profit is $5 per unit on special risk insurance and $2 per unit onmortgages. Management wishes to establish sales quotas for the new product lines tomaximize total expected profit. Please see figure for work requirements. The sensitivity report for this optimization problem is given in the following figure 1 - Can you determine the optimal value (maximum expected profit) based on the sensitivityreport? 2 - Identify the non-binding constraint(s).The board of directors of General Wheels Company is considering seven large capital investments. Each investment can be made only once. These investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table. Investment Opportunity 1 2 3 4 5 6 7 Estimated Profit ($million) 17 10 15 19 7 13 9 Capital Required for Investment Opportunity ($million) Capital Available ($million) 1 2 3 4 5 6 7 Capital 43 28 34 48 17 32 23 100 The total amount of capital available for these investments is $100 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 3 and 4. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. There are no such restrictions on investment opportunities 5, 6, and 7. The objective is to select the combination of capital investments that will maximize the total estimated long-run…
- Given the linear program Max 3x+4y S.T. -x+2y</=8 x+2y</=12 2x+y</= 16 x,y>/=0 A. Write the problem in standard form. Identify slack/surplus variables. B. Find all the extreme points. List the value for x and y at each extreme point. C. What is the optimal solution? D. What are the values of the slack/surplus variables at the optimal solution?A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.Consider the following linear programming model with 4 regular constraints:Maximize 3X + 5Y (a) Draw your graph in the space below:subject to: 4X + 4Y ≤ 48 (constraint #1) 4X + 3Y ≤ 50 (constraint #2) 2X + 1Y ≤ 20 (constraint #3) X ≥ 2 (constraint #4) X, Y ≥ 0 (non-negativity constraints)(a) Which of the constraints is redundant? Constraint #______.Justify by drawing a graph similar to Figure 7.14 on p.263.(b) Is point (9,3) a feasible solution? _____. Explain your answer (by analyzing each of the constraints).Constraint #1: _______________________________________________________________Constraint #2: _______________________________________________________________Constraint #3: _______________________________________________________________Constraint #4: ______________________________________________________________
- Company Z is contemplating a product development program encompassing 6 major projects. The company is constrained from embarking on all of the projects at once by the number of available (budgeted) developers (60) and the budget allocated for project expenses (£200,000). The following table shows the resource requirements and the estimated profit for each project. Use EXCEL’s Solver to answer question 1. 1. Suppose that CEO of company Z decides that project 2 and project 5 are mutually exclusive when all other projects remain independent. What is the revised project portfolio and the revised maximum profit?I NEED HELP WITH QUESTION D AND E. Adirondack Savings Bank (ASB) has $1,000,000 in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 7% for home loans, 12% for personal loans, and 9% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. a. Formulate a linear programming model that can be used to determine the amount of funds ASB should allocate to each type of loan in order to maximize the total annual return for the new funds. b. How much should be allocated to each type of loan? What is the total annual return? What is the annual percentage return? c. If the interest rate on home loans increased to 9%, would the amount allocated to each type of loan…Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a) What will happen to the optimal solution if the unit profit on x increase by 300? b) what will happen happen to the optimal solution if the unit profit on y decreases by 230? c) What will happen to the optimal solution if the unit profit on both x and y change to 700? d) Complete the sensitivity report with upper and lower limit. 1. The JAV Company manufactures two types of lamps; Special lamp and regular lamp. Each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machine, The company's machine are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from…