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
- A recurring maintenance job in a factory is being done by a three-man crew. Due to the nature of the job and space limitations, it was observed that two of the men were idle 37% of the time; one of the men was also idle an additional of the time, and at any given time only one man was required. The men were each paid P24.00 per hour. Each time the job was performed a set of tools and equipment with a value equivalent to P36.00 per hour was used. If the three-men crew could complete the work in 5 hours, which crew size would be the most economicalA company plans to produce 25,000 units in a 3-month period. The months have 22, 21, and 20 working days, respectively. What should the average daily production be?In order to produce 1000 units of X in a week units X is scheduled weekly for Operation B (due to 5% scrap ratio) units X is scheduled weekly for Operation A (due to 2% scrap ratio) Based on your answer in part a, find the number of machines required to produce 1000 units of X per week. The total time required to perform Operation B = minutes per week The total time required to perform Operation A = minutes per week H= Available Time in a week = minutes /week Thus FA = . FB = . Since both of the operations A and B are performed on the same machine machines are required
- LBC Corporation makes and sells a product called Product WZ. Each unit of Product WZ requires 3.0 hours of direct labor at the rate of $26.00 per direct labor-hour. Management would like you to prepare a Direct Labor Budget for June. The budgeted direct labor cost per unit of Product WZ would be: $78.00 $7.00 $26.00 $46.00Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. In design capacity it is assume that the company will produce in best and ideal condition to produce goods and services while in Effective capacity it is assume that company will produce in current operating conditions. In design capacity it is assume that the company have unlimited resource's. It means these resource's include:- Men,…You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________
- A machine shop manufactures two types of bolts. The bolts require time on each of the three groups of machines, but the time required on each group differs, as shown in the table below. Type I Type IIMachine 1 0.2 min 0.2 minMachine 2 0.6 min 0.2 minMachine 3 0.04 min. 0.08 min Production schedules are made up one day at a time. In a day, 300, 720, and 100 minutes are available, respectively, on these machines. Type I bolts sell for 15¢ and type II bolts for 20¢. (a) How many of each type of bolt should be manufactured per day to maximize revenue?(b) What is the maximum revenue?(c) Suppose the selling price of type I bolts began to increase. Beyond what amount would this price have to increase before a different number of each type of bolts should be produced to maximize revenue?. A group of students organizes a bake sale in which they sell hundreds of cookies at $1per piece. They set up a table on campus and wait for students to come and purchasetheir cookies. Consider the following variables in this bake sale operation:1. Size of the cookies2. Weather conditions on campus3. Organization of the table4. Number of cookies sold5. Competition from other fund-raisers coinciding on campus6. Amount of advertising and shouting of the students at the bake sale table7. Number of students on campus that dayWhich of these variables is an output variable?a. 3b. 4c. 5d. None of the aboveThe senior management at Davis Watercraft would like to determine if it is possible to improve firm profitability by changing their existing product mix. Currently, the product mix is delermined by giving resource priority to the highest contribution margin watercrafts. Davis Watercraft always has a contingent of 10 workers on hand; each worker is paid $25 per hour. Overhead costs are $38,000 per week. The plant operates 18 hours per day and 6 days per week. Labor is considered a fixed expense because workers are paid for their time regardless of their utilization. The production manager has delermined that workstation 1 is the bottleneck. Delailed production information is provided below. Model A B Price $495 $345 $525 Material costs $45 $35 $115 Weekly demand Processing Time Station 1 Processing Time Station 2 Processing Time Station 3 Processing Time Station 4 100 75 40 60 30 60 10 60 20 30 40 a. Using the traditional method, which bases decisions solely on a product's contribution…
- 1.) Because most equipment is not used on a project for an entire year, the costs must be converted to an hourly, weekly, or monthly cost. true or false 2.) Operation costs include tires and other wear items, fuel, lubricants and filters, and repair reserves. true or false 3.) Operating costs are those costs that are most closely related to how long a piece of equipment is owned rather than how much a piece of equipment is used. true or false Note: please help us in this sample problem and also please explain even a little bit so that we can understand it thank youThe textile company “Designs Sports” is dedicated to the production of sports clothing. In its line has shorts, pants and t-shirts. From management they requested to manufacture the quantity of each product to maximize profits. To manufacture each type of garment It goes through two areas, sewing and finishing. Furthermore, all three garments require the same type of fabric. Two people work in the sewing area, while in the production area finished only one. In the company we work 8 hours a day, 5 days a week. The Weekly fabric availability is 375 square meters. Lastly, each shirt contributes $100 US to profits, each short with $80 US; and each pair of pants with $150 US. Solve this operations research problem.P1 P4 P2 P3 P5 P5 P5 P6 ... P1 has a production rate of 15 units/hour, P2 = 30 units/hour, P3 = 10 units per hour, P4 = 4 units/hour, P5 = 1 unit(s) per hour for each P5 and P6 = 6 units per hour. Operation P4 occurs seperately from and simultaneously with operations P1-P3. Operation P5 has three parallel and identical lines; therefore, each part only needs to go through one of the three lines. Consider the following two independent improvements: Improvement 1: Change station P4 into two connected stations (P4-1 and P4-2, connected in series) that have process times of 4 min/unit and 6 min/unit respectively. Improvement 2: Add two additional P5 stations to give you 5 parallel and identical lines. Improvement 2 increases capacity because it improves the bottleneck. The new bottleneck is station P4 since the original bottleneck has a process time of The new yearly capacity would be units per year. a) Which of the two improvements will provide the largest increase in capacity? What is the…