plants, respectively. Formulate it as an LP to find the number of days that the company should run each plant during the month so that the production cost is minimized while meeting the market demand.
Q: - Identify and describe the decision variables for this LP problem. - Mathematically state and…
A: This question is related to the topic of linear programming and this topic falls under the…
Q: Noah Yobs, who has $75,400 of AGI (solely from wages) before considering rental activities, has…
A: Given data, AGI = $75400Rental activities = $67,860Real estate rental activity income =…
Q: Departments A, B, C, and D need to be assigned to four rooms 1, 2, 3, and 4. These rooms are…
A: Answer: In a plant layout different departments or plant services are located in such an order that…
Q: Formulate a mixed-integer programming model that could be used to help Mtartin-Beck determine which…
A: From the given data: Objective function: Zmin=…
Q: Mercury Electronics must develop a plan to allocate capacity to fulfilling forecasted demand of 400…
A: Production Capacity refers to the maximum possible output with the use of economic resources. It is…
Q: Each robot takes up a square area of 10 feet aside. To the left and to the right of each robot along…
A: The detailed solution is to the given question is given is step 2.
Q: Wine Accessories Inc. (WAI) produces two models of corkscrews, the standard model and a deluxe…
A: The master production schedule (MPS) is a schedule that details the number of end items that will be…
Q: Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an…
A: Month 1 2 3 4 5 6 Total Demand (Unit) 160 150 160 180 170 140 960…
Q: Scheduling Bank Tellers Note: Setup example below in excel and Minimize total daily manpower cost in…
A: Time Period No. of Teller Required 9 to 10 10 10 to 11 12 10 to 12 14 12 to 1 16 1 to 2 18…
Q: 8-1 (Production problem) Winkler Furniture manufactures two different types of china cabinets: a…
A: Let the number of French Provincial cabinets produced be F and Danish Modern cabinets be D. The Net…
Q: 2. Solve this resource scheduling problem with the series method. The resource limits are as…
A: Firstly we will be computing the values as: EF = ES+duration ES = Latest Ef of immediate preceding…
Q: An electronic gadgets store requires the following minimum number of employees, each of whom is…
A: Day Mon Tues Wed Thurs Fri Sat Sun Min. Employee required 9 2 7 6 9 1 9
Q: Tim runs a softball league consisting of 16 teams. Each team plays approximately 20 games each…
A: Using the linear programming concept, the optimal workforce scheduling can be determined. Decision…
Q: You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have…
A: wheat warehouse capacity = 20,000 bushels Inventory beginning of month 1= 6,000 bushels bought and…
Q: Formulate the linear programming model to determine how much of each ingredient the manager should…
A: Below is the solution:-
Q: Many business schools are increasing their offerings of internship and study abroad programs. In…
A: 1.) Internships are important that they are short-term workplace practical experiences that provide…
Q: Lee Beedo, a hip bachelor in Edmond, has a date for Saturday night and finds himself without a thing…
A: Sequencing of finite workload on the finite number of machines is called sequencing problem. It is…
Q: The chairperson of the department of management at Tech wants to forecast the number of students who…
A: Given data: Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7…
Q: laid out below: A B C D E F Use rectilinear travel costs for the cost of going from one department…
A: The following numbers of trips are made between departments per week: A-B (10), A-C (20), B-E (10),…
Q: Assuming that the company is interested in maximizing the total profit contribution , answer t…
A: Note: "Since you have posted a question with multiple sub-parts, we will solve the first three…
Q: Please help solve the solution below. I need to have this done in 45 minutes and I am struggling to…
A: Given Information:
Q: Barker Company produces and sells a single product with budgeted or standard costs as follows:…
A:
Q: The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers…
A: Day Mon Tue Wed Thu Fri Sat Sun Requirements 6 4 4 4 6 3 3
Q: SOLVE USING EXCEL A hospital emergency room needs the following numbers of nurses: Day Monday…
A: Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Min. no. of nurses 2 3 4 4 8 7 5
Q: Qnl. Maximize the objective function Z= 4X, +3x, +5X, using Two- Phase method. Given below a…
A: Following Tableau: Cj 0 0 0 0 0 -1 -1 Cbi Basic Variable X1 X2 X3 S1 S2 A1 A2 Solution…
Q: What is computerized short-term scheduling that overcomes the disadvantage of rule-based systems by…
A: Short-term scheduling includes selecting one of the processes from the ready queue and scheduling…
Q: Prepare a disaggregation schedule for the following situation. The forecast for each period is 700…
A: Gross requirement for every period is maximum of customer orders and forecast. Project onhand…
Q: The objectives of scheduling include all of the following except: A. Increased inventories in order…
A: Scheduling refers to arranging and balancing the resources of an organisation in an effective means…
Q: You are a scheduling manager for a small group of government contractors working in the Sudan.…
A: Legend: The cell with respective colors show the legend.
Q: he optimal schedule using Johnson method and makespan for the jobs is
A: Schedule of jobs should be done as per the lowest processing time as per the Johnson rule.
Q: Minimize Z = 2x1 - 2x2 + 3x3, subject to - x1 + x2 + x3 ≤ 4 (resource 1) 2x1 - x2 + x3 ≤ 2…
A:
Q: The University Research Center wants to forecast the number of students who will enroll in the SABH…
A: In this question, I have to prepare the forecast for the available data, here, we could find the…
Q: throughout the country. These are job shops that handle a variety of outpatient surgical procedures.…
A: For the sequence, B-C-D-A-E the job completion time is as follows: 1
Q: Cheen Corporation makes two products that are processed in two machines. The objective function and…
A: THE ANSWER IS AS BELOW:
Q: The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers…
A: The Monroe Logistics Company would like to schedule its drivers to minimize the number of drivers…
Q: A toy car is composed of a body assembly and four wheels. The body assembly includes a hood, a top,…
A: Following is the product BOM:
Q: . David’s Sport Supplies is a store that sells sports equipmentand gear for teenagers and young…
A: Introduction about Warehouse Warehousing is the process of holding items for eventual sale or…
Q: Four products are processed sequentially on three machines. The following table gives the data of…
A: Linear programming is a method that is used to determine an optimal solution with the given…
Q: ow much should Tyler plan on ordering the flour for his bakery? When should Tyler order the flour…
A: EOQ or Economic ordering quantity indicating a model of ordering an item based on the consideration…
Q: The company has pre-order for 6 heavy and 4 light balls that must be completed. (i) Calculate the…
A: The answer is as below:
Q: in Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales…
A: Open all the three workbooks it is given In cell A5, enter a formula without using a function that…
Q: The Hickory Company manufactures wooden desks. Management schedules overtime every weekend to reduce…
A: First Come First Served (FCFS) and Earliest Due Date (EDD) are the two ways to determine work flow…
Q: Planners for a company that makes several models of skateboards are about to prepare theaggregate…
A:
Q: 1. A travelling salesman has to visit five cities. He wishes to start from a particular city, visit…
A: I am solving the given problem using the nearest neighbor method. A B C D E A M 2…
Q: The director of a large public library must schedule employees to reshelf books and periodicals…
A:
Q: A company is preparing an aggregate production plan for its product for the next four months. The…
A: In a Chase plan for an aggregate production system, We attempt to chase the demand and production as…
Create an LP Model.
Step by step
Solved in 2 steps
- 12.4. The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past eight semesters: Students Enrolled Semester in OM 1 270 2 310 250 4 290 370 6. 410 7 400 8. 450 a. Compute a three-semester moving average forecast for semesters 4 through 9. b. Compute the exponentially smoothed forecast (a = .20) for the enrollment data. c. Compare the two forecasts using MAD and indicate the most accurate. 3.Explain how is the moving avarages l approach equivalent to exponential smoothing ?The Northville Post Office experiences a seasonal pattern of daily mail volume every week. The followingdata for two representative weeks are expressed in thousands of pieces of mail:Day Week 1 Week 2Sunday 5 8Monday 20 15Tuesday 30 32Wednesday 35 30Thursday 49 45Friday 70 70Saturday 15 10Total 224 210 a. Calculate a seasonal factor for each day of the week.b. If the postmaster estimates 230,000 pieces of mail to be sorted next week, forecast the volume foreach day of the week.
- The Yeasty Brewing Company Produces a popular local beer known as Iron Stomach. Beer sales are somewhat seasonal, and Yeasty is planning its production and workforce levels on March 31 for the next six months. The demand forecasts are as follows: Month April May June July August September Production Days 14 20 24 26 20 18 Forecasted Demand (in hundreds of cases) 75 100 200 140 100 50 As of March 31, Yeasty had 70 workers on the payroll. Over a period of 20 working days when there are 100 workers on the pay roll, Yeasty produced 10,000 cases of beer. The cost to hire each worker is $200 and the cost of laying off each worker is $400. Holding costs amount to 1 dollar per case per month. As of March 31, Yeasty expects to have 3,000 cases of beer in stock. It plans to start October with 3,500 cases on hand. a) Formulate the problem of planning Yeasty's production levels as a linear program. b) Use Excel solver to solve the problem and give the solution (decision variables and objective…12.2 The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past 8 months. Month 1 2 3 4 5 6 7 8 Demand for Soft Shag Carpet (1000 yd) 5 10 6 8 14 10 9 12 a. Compute a three-month moving average forecast for months 4 through 9.12.2. The manager of the I-85 Carpet Outlet needs to be able to forecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlet’s many competitors. The manager has collected the following demand data for the past eight months: Month Demand for Soft Shag Carpet (1000 yd)1 52 103 64 85 146 107 98 12 a. Compute a three-month moving average forecast for months 4 through 9. b. Compute a weighted three-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months in sequence, starting with…
- Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past 15 semesters: Using 2 Semester Weighted moving average compute the forecasted number of student for semester 16 the weight are 4 for the most recent semester and 2 for the older one. Semester Students Enrolled in OM 1 270 2 310 3 250 4 290 5 370 6 410 7 400 8 450 9 440 10 470 11 520 12 515 13 525 14 542 15 503The historical data for 4 perlods demand are 65, 60, B0, ond 70respectively Calculate the weighted moving verae (WMA) forecast of perlod 5 with welghts (0,4, 0,6)
- In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, what is the demand for summer going to be (enter your responses as whole numbers): 468 250 330 153Tropical Leisure Limited Tropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-fiveyears, in old rented premises located in the heart of the Barbadian capital of Bridgetown. Thecompany has a flexible labour force of about twenty employees and three directors, only one ofwhom, namely Mr. Grant, the managing director, is fully active in the business.The company specializes in leisure and swim wear garments. Their current range consists of teeshirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women andchildren. The company capacity is 400-500 garments per week, depending on style and continuityof the production run, but additional floor space and machines could be brought in quickly to raiseproduction levels to a maximum of 1000 garments weekly if required.Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but sincethen inflation and recession has deflated the market,…Data collected on the yearly demand for 50- pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Estimate demand for vear 12 with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other two years are each given a weight of 1. Year Demand (Bags) 4 6. 3 4. 4. 10 6 8. 8. 8. 12 10 14 11 15 O A. 13.67 O B. 14.00 OC. 14.87 O D. 11.79 Click to select your answer. Us MacBook Air 888 * ES F2 F4 F6 F7 4) F9 F10 %23 2$ & * 4 6. 7 8 9. Q W R T Y F C V В alt command command option %#3