Create a step-by-step excel, using the solver engine to generate the decision variable solution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU
Q: explain in detail what is an operation strategy
A: Strategy:- Managers use strategy to accomplish one or more of the organization's goals. A overall…
Q: Frank’s Contract Bakery measured her 2021 Cost of Goods Sold to be 6516265. Her Average Aggregate…
A: Days of supply = (Average inventory on hand/cost of goods sold)*365 days Average inventory on hand =…
Q: The current values of sales of a product in a company are as follows: November - 22, December -…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: What is total quality management?
A: The term "total quality management" was first used in the 1960s to describe a manufacturing…
Q: Consider the following problem: A company supplies goods to three customers, who each require 30…
A: Find the given details below: Transportation Schedule From/To Customer 1 Customer 2 Customer 3…
Q: Consider the transportation table below. Unit costs for each shipping route are in dollars.…
A: Least cost method is used to find the total cost of transportation of goods from source to…
Q: Add constraints to ensure contracts are whole numbers Add constraints to ensure raw materials never…
A: To make it convenient, the replication of the given excel model is created.
Q: ind out the standard time using the following data: Average time for machine elements = 6 min.…
A: Standard time = Normal time+allowance time Normal time for manual elements = Average element…
Q: Coca-Cola’s British and continental bottling operation has become the latest business to come under…
A: The success of global sourcing depends on the following three factors. 1. Process: 2. Effective…
Q: What is the purpose of supply chain management systems
A: Supply chain management system:- Supply chain management systems are tools to help businesses and…
Q: The difference between a group and a team is that
A: Group is Collection of individuals who coordinate their efforts and have individual gaols. Team is…
Q: Evaluate the ways in which time and quality can affect the cost of a project
A: Time: earlier the time taken for construction of a project better it is because the project can be…
Q: The operations function is made up of many tasks including all of the following except a) Managing…
A: Inventory management is the process of storing and handling the raw resources and finished products…
Q: John Francois Stores Mr. John Francois, a very successful businessman is contemplating his next…
A: Based on the above condition the 3 strategies are: 1) Client assistance improvement 2) Promoting…
Q: Compute the takt time for a system where the total time per shift is 480 minutes, there is one…
A: Takt time is described as the time or the rate at which products are needed to be manufactured in…
Q: 10 5 Raw Material Capacity= units/day Information: The illustration above is an example of a produc…
A: The DBR strategy attempts to beat this issue by utilizing the current framework and methods to…
Q: 4. Amy Zeng, owner of Zeng's Restaurant Distributions, supplies restaurants around the metro area.…
A: Item Category Monthly Trips Area Needed (Blocks) Paper Products 50 2 Dishes, Glasses, and…
Q: Mid-West Publishing Company publishes college textbooks. The company operates an 800 telephone…
A: The question is related to the Probability. The details are given regarding the same.
Q: Given current demand in this period of 103, a forecast for this current period of 99, and an alpha…
A: Exponential smoothing is a forecasting model which helps to identify the forecasting value based on…
Q: A firm uses simple exponential smoothing with trend adjustment to forecast demand, "a = 0.6" and…
A: Given, TAF for first month TAF1 = 434 units Actual demand for first period A1= 488 units Trend T1 =…
Q: Services differ from manufactured products in four ways. Intangibility, Inseparability,…
A: Note- Hi! Thank you for the question As per the honour code, We’ll answer the first question since…
Q: This exercise only contains parts b, c, d, e, and f. b) Given the demand, the cycle time for the…
A:
Q: Q1: An electrical engineer wants to finish his new device production project within 47 days to meet…
A: Project Crashing deal with those situations which will speak of the effect of increase or decrease…
Q: How does this supply chain differ from that in a manufacturing firm?
A: A supply chain is indeed the web of people, businesses, materials, operations, and technology…
Q: The supply chain includes not only distribution channels but also the suppliers who deliver raw…
A: The supply chain is the series of processes that a product goes through from the time it was created…
Q: Examples of Control Systems Models or Representations with explanation.
A: The control systems can be represented with a set of mathematical equations known as mathematical…
Q: International marketing research is vital for companies going global. Explain briefly any TWO (2)…
A: Marketing research is a method that is utilized for researching the market and analyzing the…
Q: 12.1-2* A young couple, Eve and Steven, want to divide their main household chores (marketing,…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: eated. Briefly describe one type
A: A risk assessment is an attempt that is made to discover what dangers may be present in a certain…
Q: 2-1. Use the graphical method to find the solution to the linear programming problems: - Min. Z =…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Formulate the following problems as balanced assignment models: Person A is planning to organize a…
A: An assignment problem is called a balanced assignment problem when the number of persons and the…
Q: Parts List for Electric Golf Cart Electric golf cart Top Supports (4) Cover Base Motor Body Frame…
A: Requirement = 200 golf carts by week 8
Q: Using the following information, create a project network diagram. Calculate, ES, EF, LS and LF for…
A: 1. During forward pass in case of more than two preceding activities the early start will be…
Q: Build an appropriate LP model. Solve the model using the graphical solution method. Develop a…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: he method of identifying many factors is referred to as multifactor identification. How can this…
A: 2FA is implemented to better protect both a user's credentials and the resources the user can…
Q: What is preferred suppliers in furniture company.
A: Preferred suppliers are the suppliers which are preferred by any company as they are assumed to…
Q: Company QAW has two bottling plants in California and Alaska that can produce 10000 and 6000 bottles…
A: Find the Given details below: Given details: Plants Bottle sizes 500 mL 1 L 1.5 L…
Q: Explain how a business case relates to a technological project and why it's important.
A: A business case provides a reason to begin a business project. It estimates the risks, price, and…
Q: ost-Perry Industries (YPI) manufactures a mix of affordable guitars (A, B, C) that are fabricated…
A: Bottleneck station is the one which has least output capacity. time available = 40 hours time…
Q: Scenario: Information technology is a powerful force in shaping service strategies. Customers of an…
A: In service process redesign, the major four objectives are as follows. 1. Reduce service errors 2.…
Q: Q4. Answer the following questions (a-h), based on the provided project Gantt Chart. The red line…
A: Note: Since you have posted a question with multiple sub-parts, we will solve first four sub-parts…
Q: A linear programming computer package is needed. Romans Food Market, located in Saratoga, New York,…
A: Decision Variable: Suppose- BR = Pounds of Brazilian beans purchased to produce Regular BD =…
Q: Identify the strategic issues facing craft brewers in 2021. What effects may these issues have on…
A: There are categories within craft that are growing faster than IPA's where you can see craft beer…
Q: hers in Boston was $13,579 d the entry-level salary have
A: Given: Entry-level salary for teachers in 1981 is $13579 It rises to $45498 in 2017 (a) Based on CPI…
Q: 1. What is Warehouse Operation Management?
A: NOTE: We are allowed to do one question only at a time. Thus the answer to the first question is as…
Q: Given the Actual Demand from January to June of 2021, along with the forecasts based on three (3)…
A: Find the Given details below: Given details: Jan Feb Mar Apr May Jun Actual 960 1230 1520…
Q: Where exactly does Instagram's operational CRM tie into its overall strategy?
A: Instagram is the second most accessed network behind Facebook. The popular visual-first social…
Q: 28 and 35 are two feasible solutions to a primal minimization problem. Which statement is the most…
A: Linear programming can be stated as the technique of amending or optimizing operations with…
Q: GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 1. Southern Sporting Goods…
A: Let, B = Units of basketball to be produced F = Units of Football to be produced Objective…
Q: Aldiscuss Three important Hazard Identification processes are. AND Why non a) Audits conducted by…
A: Occupational Safety and Health Administration often called OSHA can be stated as the main federal…
Create a step-by-step excel, using the solver engine to generate the decision variable
solution. Generate an ANSWER REPORT and a SENSITIVITY REPORT. I WILL UPVOTE. THANK YOU
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 7 images
- Case 2: A marketing research professor is conducting a telephone survey and needs to contact atleast 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 tomake a daytime call and $4 (because of higher labor costs) to make an evening call. The table shownbelow lists the expected results. For example, 10% of all daytime calls are answered by a single male,and 15% of all evening calls are answered by a single female. Because of a limited staff, at most halfof all phone calls can be evening calls. Determine how to minimize the cost of completing thesurvey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following using the Solver application in Excel 4) Obtain a sensitivity report for the reported solution. Which constraints…Case 2: A marketing research professor is conducting a telephone survey and needs to contact atleast 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 tomake a daytime call and $4 (because of higher labor costs) to make an evening call. The table shownbelow lists the expected results. For example, 10% of all daytime calls are answered by a single male,and 15% of all evening calls are answered by a single female. Because of a limited staff, at most halfof all phone calls can be evening calls. Determine how to minimize the cost of completing thesurvey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following using the Solver application on Excel 1) State the decision variables and constraints in this problem. 2) What is…Problem: A farmer is planning to raise wheat and barley. Each acre of wheat yields a profit of $50, and each acre of barley yields a profit of $70. To sow the crop, two machines, a tractor and a tiller are rented. The tractor is available for 150 hours, and the tiller is available for 200 hours. Sowing an acre of wheat requires 4 hours of tractor time and 1 hour of tilling. Sowing an acre of barley requires 3 hours of tractor time and 2 hours of tilling. How many acres of each crop should be planted to maximize the farmer’s profit? (Let W be the number of acres of wheat to be planted, B the number of acres of barley to be planted and P the profit) (a) What is the objective function for the problem? (b) Excluding the non-negative constraint, how many constraints does the problem have? (c) What is the linear programming model of the problem?
- Task 4In this task, you are asked to formulate the linear programming problem below andthen solve it.A carpenter produces Tables (T) and Chairs (C).Each Table unit requires 6kg of wood and 1kg of plastic.Each Chair unit requires 4kg of wood and 4kg of plastic.The carpenter has only 100kg of wood and only 50kg of plastic in stock.On each sale, the carpenter makes a profit of £15 per Table unit sold and a profit of£30 per Chair unit sold.Required:Formulate the Linear Programming problem above by defining the variables,stating the object function and the constraints.You are required to produce the graph for all inequalities (copy image to Word)Find the quantity to make of Tables and Chairs to maximise profit.Problem There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $1000 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $2000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.30 ton. The state wants to reduce the amount of P 1in the river by at least 30 tons and the amount of P2 by at least 40 tons. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Use SolverTable to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what…1. Maribel is selling regular and special juices. To make a bottle of regularjuice, she needs 2 pounds of mango and 3 pounds of pineapple. On theother hand, 4 pounds of mango and 2 pounds of pineapple are needed tomake a bottle of special juice. A profit of P30 is made for a bottle of regularjuice and P40 for a bottle of special juice. Maribel is currently has 800pounds of mango and 480 pounds of pineapple. She wants to make at least180 bottles of special juice. How many bottles of each type of juice mustshe make to maximize her profit? How much will be her maximum profit? 2. A calculator company produces a scientific calculator and a graphingcalculator. Long-term projections indicate an expected demand of atleast 100 scientific and 80 graphing calculators each day. Because oflimitations on production capacity, no more than 200 scientificand 170 graphing calculators can be made daily. To satisfy a shippingcontract, a total of at least 200 calculators much be shipped each day. Ifeach…
- Instruction: Formulate the dual problems for X2 the following linear programming model No need to compute/doing a tableau 1. Maximize Z = 2X1 + X2 Subject to: X2 < 10 2X1 + 5X2 < 60 X1 + X2 <18 3X1 + X2 < 44 2. Maximize Z = 2X1 + X2 +3X3 Subject X1 + X2 + 2X3 < 400 2X1 + X2 + X3 < 500 3. Maximize Z = 80X1 + 60X2 Subject X1 + X2 = 200 X1 < 50 X2 > 80develope a space matrix for macdonalds. Below are the instructions. The steps required to develop a SPACE Matrix are as follows: 1. Select a set of variables to define financial position (FP), competitive position (CP), stability position (SP), and industry position (IP). 2. Assign a numerical value ranging from +1 (worst) to +7 (best) to each of the variables that make up the FP and IP dimensions. Assign a numerical value ranging from -1 (best) to -7 (worst) to each of the variables that make up the SP and CP dimensions. On the FP and CP axes, make comparison to competitors. On the IP and SP axes, make comparison to other industries. 3. Compute an average score for FP, CP, IP, and SP by summing the values given to the variables of each dimension and then by dividing by the number of variables included in the respective dimension. 4. Plot the average scores for FP, IP, SP, and CP on the appropriate axis in the SPACE Matrix. 5. Add the two scores on the x-axis and plot the resultant…1. The Munchies Cereal Company makes a cereal from several ingredients. Two of the ingredients, oats and rice, provide vitamins A and B. The company wants to know how many ounces of oats and rice it should include in each box of cereal to meet the minimum requirements of 48 milligrams of vitamin A and 12 milligrams of vitamin B while minimizing cost. An ounce of oats contributes 8 milligrams of vitamin A and 1 milligram of vitamin B, whereas an ounce of rice contributes 6 milligrams of A and 2 milligrams of B. An ounce of oats costs $0.05, and an ounce of rice costs $0.03. Required: a. Formulate a linear programming model for this problem. b. Solve this model by using graphical analysis. c. What would be the effect on the optimal solution if the cost of rice increased from $0.03 per ounce to $0.06 per ounce?
- 1. The Crumb and Custard Bakery makes coffee cakes and Danish pastries in large pans. The main ingredients are flour and sugar. There are 25 pounds of flour and 16 pounds of sugar available, and the demand for coffee cakes is 5. Five pounds of flour and 2 pounds of sugar are required to make a pan of coffee cakes, and 5 pounds of flour and 4 pounds of sugar are required to make a pan of Danish. A pan of coffee cakes has a profit of $1, and a pan of Danish has a profit of $5. Determine the number of pans of cakes and Danish to produce each day so that profit will be maximized. REQUIRED: A. Formulate a linear programming model for this problem. B. Solve this model by using graphical analysis. C. How much flour and sugar will be left unused if the optimal numbers of cakes and Danish are baked?21. A linear programming problem has two constraints 2X + 4Y ≤ 100 and 1X + 8Y ≤ 100, plus nonnegativity constraints on X and Y. Which of the following statements about its feasible region is TRUE? Part 2 A. The graphical origin (0, 0) is not in the feasible region. B. The feasible region includes all points that satisfy one constraint, the other, or both. C. The feasible region cannot be determined without knowing whether the problem is to be minimized or maximized. D. The two corner points are (0, 0) and (50, 12.5). E. There are four corner points including (50, 0) and (0, 12.5)1. A city is reviewing the location of its fire stations. The city is made up of a number of neighborhoods, as illustrated in the figure below. A fire station can be placed in any neighborhood. It is able to handle the fires for both its neighborhood and any adjacent neighborhood (any neighborhood with a non-zero border with its home neighborhood). The objective is to minimize the number of fire stations used. Solve this problem. Which neighborhoods will be hosting the firestations?