Susan wants to determine how much to haul from each quarry to each construction so that the total cost of purchasing and hauling the gravel is minimized. Solve using Excel Solver step by step.
Q: 3. Software upgrade times(in seconds) are being evaluated. Samples of five observations have been…
A: X-double bar = Average of all mean valueR-bar = Average of all range value Control limit of the X…
Q: To support National Heart Week, the Heart Association plans to install a free blood pressure testing…
A: Queuing theory is a mathematical discipline that deals with the study of waiting lines, or queues,…
Q: Design a brief research proposal with a topic of your choice derived from your area of study.…
A: Business research is the systematic as well as objective investigation of business-related topics,…
Q: The three blood banks in Franklin County are coordinated through a central office that facilitates…
A: We reproduce the given table in Excel as shown below: The above tables in the form of Excel…
Q: What is a Strategic Environmental Assessment and what does it involve?
A: A Strategic Environmental Assessment (SEA) is a methodical and thorough procedure used to evaluate…
Q: A company wants to locate a new warehouse to minimize the longest distance traveled by any of its…
A: Non-linear programming deals with the optimization of an objective function subject to constraints…
Q: Part 2 a) Find the expected completion time for this project. The expected completion time for…
A: The Critical Path Method (CPM) is a project management technique used to determine the shortest…
Q: Can a process stop? Give reasons.
A: A process is a series of activities that have to be performed to transform the input into output. A…
Q: Write the Linear Programming Model 2.Using Excel Solver to find the optimal solution and the weekly…
A: For this question, I would formulate the LP, The LP model is shown below, Decision…
Q: (a) Many airlines were badly affected by the volatility in fuel prices during the Global Financial…
A: Fuel expenses are essential in determining airline profitability in the dynamic airline sector. This…
Q: Calculate early start, early finish, late start, late finish, activity float and activity duration…
A: Activity Immediate Predecessors Duration A - 0 B A 15 C B 15 D C 15 E D 30 F E 30 G F…
Q: What is the duration of the critical path for the project? A. 14 weeks B. 7 Weeks C. 5 Weeks D. 8…
A: 30) Here, I have been given the network diagram, this network diagram presents a "finish to start"…
Q: Lean development's benefits in five lines. Second, apply the lean principle from class to two…
A: Lean development is a development methodology that focuses on maximising value while minimising…
Q: L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An…
A: ABC classification, also known as ABC analysis or ABC categorization, is a technique used in…
Q: 12. A restaurant uses an average of 8 jars of a special sauce every day. When they place an order,…
A: Daily demand (d) = 8 jarsLead Time (L) = 1 dayStandard Deviation of daily demand (σd) = 3 jars Stock…
Q: What should Al achieve? Give two instances for each major point.
A: Introduction: Artificial intelligence, abbreviated as Al, has the power to improve humanity and…
Q: Piping Hot Pizza Limited (a company) is a client of your firm. They regularly ask your firm to…
A: To effectively assist Piping Hot Pizza Limited, our firm must have a thorough understanding of the…
Q: Innovative Service Pricing Explore one highly successful business model based on innovation service…
A: Innovative service pricing and revenue management methods are critical in today's competitive…
Q: Discuss What strategies can organizations use to ensure effective collaboration between different…
A: Effective collaboration between different departments involved in product or service development is…
Q: What is the total cost of crashing the project from its current duration down to 11 weeks? Number…
A: Project crashing is a process which reduces the total duration of the project using additional costs…
Q: Briefly describe what is meant by gaining an understanding of a business problem within the…
A: In field of operational management, gaining understanding of business problem within framework of…
Q: Analyse the rationale behind creating a social policy that is reflected in NASA's mission and vision…
A: Social policy refers to set the guidelines, rules, principles, and actions implemented by…
Q: this question is procurement and logistic management related but you don,t have the subject in your…
A: Procurement management involves the process of sourcing, acquiring, and managing goods,…
Q: Lynette is interested in finding a sedan car for work. Below is the summary of her criteria and the…
A: Here, each criterion is given with a specific weight, I would convert this weight value in…
Q: How does coordination contribute to effective project management and timely completion of tasks?
A: Projects are unique endeavors with a specific goal, timeline, and set of deliverables. They may vary…
Q: Willow Brook National Bank operates a drive-up teller window that allows customers to complete bank…
A: Find the calculation methods below: Single server: Multi-server: Total cost: Total cost = Cw*L +…
Q: The Svenson Furniture Company sells a popular coffee table that comes unassembled and includes three…
A: Find the Given details below: Given details: Percentage of Good quality table 80% Cost $…
Q: Potentially negative results include broadening the problem's scope and adding unnecessary features.…
A: Here, I would discuss each concept like broadening the problem's scope and adding unnecessary…
Q: A Cell Phone Manufacturer is developing a new cell phone and currently has two models under…
A: Answer) The problem given is that a cell phone manufacturer is developing a new cell phone and has…
Q: What role does the procurement function play in the organizational buying process
A: The procurement department is critical to the purchase process of the firm. It is the company's job…
Q: Why are functional unit and system boundary choices important when comparing disposable and reusable…
A: Functional unit and system boundary choices are essential elements in conducting a life cycle…
Q: MARKOV CHAINS
A: We begin by arranging the probabilities in columns and obtain a transition matrix…
Q: Explain the concept of contingent workforce and discuss the benefits and challenges of utilizing…
A: The utilization of a contingent workforce, comprising temporary, contract, and freelance workers,…
Q: Conducting business strategy analysis is important in understanding drivers of industries’ and…
A: Identifying the factors that influence an industry's and a firm's profitability requires doing a…
Q: provide undestanding of inventory in supply chain
A: Supply chain management is the coordination and integration of all the activities that are involved…
Q: The University Procurement Manager has approached you to design a specification document for supply…
A: Supply chain management (SCM) is the coordination and oversight of all activities involved in the…
Q: Describe the adoption of a safety model and methodological framework/model.
A: Adopting security models and methodological frameworks/models refers to the implementation and use…
Q: Consider a product with a daily demand of 500 units, a setup cost per production run of $100, a…
A: Here, the daily demand is 500 units The annual demand =500×365The annual demand=182500 Annual…
Q: Subj: Business/ Operations Management Scenario: John used the AirBnB platform to book a condo for…
A: When it comes to assisting visitors who face unforeseen circumstances, Airbnb's existing refund…
Q: discuss importance of project resource planning and its impact on project success
A: Project resource planning which requires efficiently identifying, procuring and utilizing the…
Q: Period Season Trend 1 1 2 2 3 3 4 4 5 1 6 2 7 3 8 4 9 1 10 11 12 2 3 4 ? ? ? ? ? Index Forecast ? ?…
A: Here, given data, Intercept=85Slope=7.5The total number of seasons=4 Here, the linear regression…
Q: The Denver International Airport baggage system debacle may have been influenced by ineffective…
A: The automated baggage system at Denver International Airport was designed to completely eliminate…
Q: The total budget for the program is $6,000,000.00 and the maximum space available is 290 square…
A: First, The LP formulation is stated below, Decision variables: The number of machines A=X1 The…
Q: a. Draw a project network. b. What are the critical path activities? c. What is the expected project…
A: Given the information from the immediate predecessors for each action, I would estimate how long…
Q: Bangs Leisure Chairs produces three types of hand-crafted outdoor chairs: sling chairs, Adirondack…
A: We formulate the given programming problem in Excel as shown below: The above formulation in the…
Q: find the solution of the following LP problems using simplex and graphical method
A: I have utilized the Solver tool to identify the Simplex technique's best answer in this case, but I…
Q: Given the data table below develop the precedence network and perform the CPM calculations. Then,…
A: Find the Given details below: Activity Predecessor Normal Time (NT) (Days) Normal cost (NC) Crash…
Q: Briefly enumerate how the literature review contributes in achieving the overall purpose of…
A: A literature review is an important component of research that is critical to reaching the overall…
Q: Accounting 2b. An analysis of Terbolt Corporation's operating income changes between 2021 and…
A: The cost leadership strategy is reflected in the increase in Terbolt's operating income. Because,it…
Q: Please do not give solution in image format thanku Stephen's manager notices that he slammed his…
A: A manager is an individual who is responsible for overseeing the activities of their team members so…
Step by step
Solved in 4 steps with 7 images
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources-rubber and leather. The resource requirements for each product and the total resources available are as follows: Product Resource Requirement per Unit Rubber (lb.) Basketball 4 Football 5 Total Resources available 500 lb. 800 ft.2 * Each basketball produced results in a profit of $12, and each football earns $16 in profit. b. Transform this model into standard form Leather (ft.2) 3 2 a. Formulate a linear programming model to determine the number of basketballs and footballs to produce in order to maximize profit.Karen owns a roof repair service and drives a van to local client sites. During the week she drives the following distances: · From her home to her business headquarters: 8 miles · From her headquarters to a client site: 15 miles · From client site back to her headquarters: 15 miles · Trip from her headquarters back home: 8 miles How many miles does she count for business purposes? Group of answer choices 8 miles. 15 miles. 30 miles. 46 miles.
- A department is preparing a trip for 80 volunteers to an area affected by the typhoon. The transportation company to transit the volunteers has 8 vans of 15 seats each and 5 vans of 10 seats, but only has 15 drivers available. The rental cost for a large van is $150 and $100 for a small van. Calculate how many vans of each type should be used for the trip for the least possible cost. Question 1: What objective function will be used to evaluate the minimum cost? Question 2: Given the feasible region, how many corner points does the LP model generate? Question 3: Given the graph of the LP model, which of the following is not a corner point? (0,0), (0,8), (0,15) (15,0) Question 4: How many constraints, excluding the non-negative constraints, will be considered for the determination of the optimal solution? Question 5: What is the minimum cost referred to in the problem?A recruiter for a job placement agency is considering whether to pay $50,000 per year to lease a new recruiting facility in a prime location in Washington D. C. He estimates it will cost $50 per recruit to process the paperwork at this new location. He receives a $75 commission for each new recruit he processes. Part A - If the office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and 6,000 recruits will be processed per year, what will be the utilization of the office space?Part B - If his office space at this new location has design and effective capacities of 10,000 and 8,000 recruits processed annually, respectively, and he plans to be 90% efficient in his use of this space, how many recruits does he plan to process per year?Suppose an Excel spreadsheet model has been partially created as shown below. 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E
- The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Department A B C 1.00 0.30 0.20 Profit contribution/unit $30.00 Production Labor-Hours Required (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. If required, round your answer to two decimal places. Product 1 Product 2 (hours/unit) Product 1 Product 2 Hours Available OT hours: (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? - Select your answer - What is the upper limit of what you would be willing to pay…Josh Randall, a sales representative for WAI, has convincedhis customer (order #2 in Problem 9) to reschedule. Order #2 hasagreed to accept delivery of 25 units in week 2 as long as WAIcan also guarantee delivery of an additional 25 units in week 5.If WAI cannot meet both delivery requirements, the customerhas threatened to withdraw its entire order. You have alreadypromised orders 1, 3, and 4. Can you assure Josh that WAI willdeliver on time? Show your calculations.GRAPHICAL METHOD: A store wants to liquidate 200 of its shirts and 100 pairs of pants from last season. They have decided to put together two offers, A and B. Offer A is a package of one shirt and a pair of pants which will sell for $30. Offer B is a package of three shirts and a pair of pants, which will sell for $50. The store does not want to sell less than 20 packages of Offer A and less than 10 of Offer B. How many packages of each do they have to sell to maximize the money generated from the promotion? Attach the PDF or JPEG file of the solution made. *
- 2. A company has plants at locations A, B and C with the daily capacity to produce chemicals to a maximum of 3000 kg, 1000 kg and 2000 kg respectively. The cost of production (per kg) are P800, P900 and P750 respectively. Customer's requirement of chemicals per day is as follows: Customer Chemical Required Price offered 2000 200 2 1000 215 3 2500 225 1000 200 Transportation cost per kg from plant locations to customer's place is given in table. Customer 2 3 A 5 7 10 12 Plant B 3 4 2 с 3 Find the transportation schedule that minimizes the total transportation cost.Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. i Demand Forecast Component A B C Time Standard Processing (hr/unit) 0.04 0.20 0.05 Setup (hr/lot) 1.0 4.4 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected 16,000 17,000 10,000 12,000 18,000 24,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best. D Demand Forecast Component A B C Time Standard Processing Setup (hr/unit) (hr/lot) 0.04 1.0 0.20 4.4 0.05 8.5 Lot Size (units/lot) 50 75 100 Demand Forecast Pessimistic Expected Optimistic Pessimistic 16,000 10,000 18,000 a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up to the next…