The director of a large public library must schedule employees to reshelf books and periodicals checked out of the library. The number of items checked out will determine the labor requirements. The following data reflect the number of items checked out of the library for the past three years: Year 1 1.804 2.711 2,509 2.432 2,468 2,378 2,175 2.445 1.908 1.922 2,417 2274 Year 2 2.056 2,321 2,442 2.088 2.694 2,122 2,206 1,869 2,489 2.291 2.352 2.189 Year 3 1,976 2,564 2,616 2,150 2,195 2,663 2,011 1,678 1,778 2,065 2,158 2.440 Month January February March April May June July August September October November December The director needs a time-series method for forecasting the number of items to be checked out during the next month. Suppose that the director considers the best forecast to be the one that minimizes the absolute value of mean bias (E). Find the best simple moving average forecast you can using the director's criteria Using the director's criteria, the best forecast for the next month is tems to be checked out (Enter your response as a whole number.)
Q: The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost…
A:
Q: The Carver Family did choose Warehouse Space A. The warehouse includes 8000 sq. ft. of showroom and…
A: In the question data, we have got square foot size of the warehouse, height of the warehouse.…
Q: Four automobiles have entered Bubba’s Repair Shop for various types of work, ranging from a…
A: Consider the provided question, According to the given question, let assume for work as J1, J2, J3,…
Q: What is true about the assignment problem if the solution has reached the table below? Project A…
A: a. The minimum number of vertical and horizontal lines needed to cross out 0s is not three, its…
Q: XYZ Corporation operates two plants, each of which has a capacity of 110 units per day. Each day,…
A: [A] Units should ship Customer A Customer B Customer C Customer D Plant1 20 0 0 90 Plant 2…
Q: A manufacturing company processes 6 different jobs on two mahcines A and B. Number of units of each…
A: 1. The smallest processing time is 3 hours for job 4 on Machine-1. So job 4 will be processed…
Q: XYZ Corporation operates two plants, each of which has a capacity of 100 units per day. Each day,…
A: The given problem is solved us MS Excel Solver. Excel input and formulas:
Q: A university computer center is open from 8 AM until midnight. The numbers of computer consultants…
A: Find the Given details below:
Q: The Funny Toys Company has four men available for work on four separate jobs. Only one man can work…
A: The assignment problems help to assign the available resources to the available jobs so that the…
Q: (A) A product line has two models: X and Y. Model X consists of 4 components: a, b, c, and d. The…
A: Product variety, P=2 (X&Y) Product quantity, Q1=1000 units Q2=1500 units Number of…
Q: The Pyrotec Company produces three electrical productsclocks, radios, and toasters. These products…
A: Given Data Profit of clock =Selling cost -Cost /unit price = 15-7…
Q: A manufacturing company has an aggregate planning of selling its beds in the following sizes (the…
A: Given Information: Total Production Bed Sizes Production Proportion Colors Proportion…
Q: Using the provided template, show the steps to get the solution. During each four-hour period, the…
A: Find the Given details below: Given details: Starting 4 hours of 8-hour shift Midnight -…
Q: Note: This problem requires the use of a linear programming application such as Solver or Analytic…
A: Given data is
Q: Dr. Maureen Becker, the head administrator at Jefferson County Regional Hospital, must determine a…
A: Shift Timing Minimum requirement 12-2 PM 30 2-4 AM 20 4-6 AM 40 6-8 AM 50 8-10 AM 60…
Q: A soap manufacturing company is planning to advertise in various channel to enhance its brand recall…
A: The goal programming model is formulated as below: Let X1 the number of ads to place in Sports…
Q: XYZ Corporation operates two plants, each of which has a capacity of 100 units per day. Each day,…
A: given data: Customer A Customer B Customer C Customer D Plant 1 24 21 19 18 Plant 2 18 16…
Q: Barb’s Beach Bar operates seven days per week. Barb usesonly full-time employees and wants each…
A: Given data is Working days = 7 Demand(Monday to Thursday and Sunday) = 3 Demand(Friday and Sunday) =…
Q: The Northside Bank is working to develop an efficient work schedule for full-time and part-time…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A furniture manufacturer produces two types of tables – country and contemporary – using three types…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Raw Material Requirement Amount For Unit Product Сарacity Raw Materials P1 P2 P3 H1 2 3 5 4000 H2 4…
A: In order to create the LP model, these are the following steps: Determine the decision variables…
Q: Amy Zeng, owner ofZeng's Restaurant Distributions,supplies nonperishable goods to restaurants around…
A: Given-
Q: 3.4-11. Larry Edison is the director of the Computer Center for Buckly College. He now needs to…
A: Find the Given details below: Time Periods covered by shifts - Full Time Time of day…
Q: Given this linear programming model, solve the model and then answer the questions that follow.…
A: Note: Since you have posted a question with multiple subparts, we will solve the first three…
Q: A company is developing its weekly production plan. The company produces two products, A and B,…
A: Given data is Fixed cost of A and B = $60 and $80 Unit profit of A and B = $17 and $21
Q: Find the minimum cost.
A: Linear programming is a technique used to maximize or minimize the set of given variables. These…
Q: c) Jay Calahi is to supply gravel for projects located in three different sites. He has three…
A: Given data is
Q: XYZ Corporation operates two plants, each of which has a capacity of 170 units per day. Each day,…
A: [A] Customer A Customer B Customer C Customer D Plant 1 12 12 12 134…
Q: A garden store prepares various grades of pine bark for mulch: nuggets (x1), mini-nuggets (x2), and…
A:
Q: Merlin Park Hospital has 4 scan machines and 4 patients to scan. Each machine must be assigned to…
A: Find the Network representation below:
Q: The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in…
A: Given data is
Q: Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line…
A: This concept is from labor and working machine hours in operations management, where we calculate…
Q: Merlin Park Hospital has 4 scan machines and 4 patients to scan. Each machine must be assigned to…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Weenies and Buns is a food processing plant which manufactures hot dogs and hot dog buns. They grind…
A: a) Let assume number of hot dogs 'x' and number of hot dog buns be 'y' Each hot dog bun required 0.1…
Q: XYZ Corporation operates two plants, each of which has a capacity of 140 units per day. Each day,…
A: Customer A Customer B Customer C Customer D Capacity Plant A 12 18 21 10 140 Plant B 16 14 18…
Q: The Carver Family did choose Warehouse Space A. The warehouse includes 8000 sq. ft. of showroom and…
A: here, in the question, I have following information, these are size of the warehouse, size of the…
Q: Note: This problem requires the use of a linear programming application such as Solver or Analytic…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Hoosier Power needs to determine a capacity expansion plan to meet Bloomington’s power needs for the…
A: Formulate Excel model as follows:
Q: Which of the following linear programming model has bounded feasible region? O max z= 3x + 2y…
A: The question is related to Linear Programming.
Q: Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the…
A: Decision Variable:Suppose-f1 = No. of full-time consultants working the morning shift (8 a.m.-4…
Q: A one-day vaccination clinic has forecast the number of workers needed according to the table shown…
A: A worker in 10 hour shift can start from either 8 am or 10 am because after 10 am shift, the 10 hour…
Q: Carefully examine the following ASSIGNMENT problem. Which of the following constraints is not true?…
A: In assignment problem we assign one job to machine to get all the job done with a minimum cost…
Q: Fashion Fun makes 2 types of high end sneakers for toddlers, "Run-It-Out" brand and Jump-It-Out"…
A: Decision Variable: Suppose -X be the no. of 'Run-In-Out' brand sneaker to manufactureY be the no. of…
Q: A furniture manufaci using three types of machines. The time required to produce the tables on each…
A:
Q: XYZ Corporation operates two plants, each of which has a capacity of 140 units per day. Each day,…
A: [A] Customer A Customer B Customer C Customer D Plant 1 19 19 0 102…
Q: A plant has four operators to be assigned to four machines. The time (minutes) required by each…
A: When workers are assigned to certain duties based on cost, the Hungarian algorithm is beneficial for…
Q: A manufacturing company makes two types of water skis, a trick ski and a slalom ski. The relevant…
A:
Q: A. The Butterfield Company makes a variety of hunting knives. Each knife is processed on four…
A: The simplex method is a deliberate technique for testing the vertices as potential arrangements.…
Q: Jack is the quality manager of Shearwater Systems. Shearwater and maintenance services to homeowners…
A: The various options to give access to the technicians are as follows: Advantages - Smartphones…
Q: Assembly Line Consider the following tasks that must be assigned to four workers on a conveyor-paced…
A: The throughput pace of a bunch of assets will rely upon the limit of the bottleneck asset. A…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?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?
- At modern woodworks, president and producer of apple crates sold to growers, has been able, with his current equipment, to produce 240 crates per 100 logs. He currently purchases 100 logs per day, and each log requires 3 labor hours to process. He believes that he can hire a profesional buyer who can buy a better quality log at the same cost. if this is the case, he can increase hos production to 260 crates per 100 logs. His labour-hours will increase by 8 hours per day. What will be the impact on productivity (measured in crates per labor-hour) if the buyer is hired?The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process. Min 270 x1 + 230x2 + 240x3+ 220x4 + 190x5 + 270x6 + 230x7 + 220x8 st. x1 + x2 + x5 + x7 ≥ 1 (Building A constraint] x1 + x2 + x3 ≥ 1 (Building B constraint} x6 + x8 ≥ 1 (Building C constraint} x1 + x4 + x7 ≥ 1 (Building D constraint} x2 + x7 ≥ 1 (Building E constraint] x3 + x8 ≥ 1 (Building F constraint) x2 + x5 + x7 ≥ 1 (Building G constraint} X1 + x4 + x6 ≥ 1 (Building H constraint] x1 + x4 + x8 ≥ 1 (Building I constraint} x1 + x2 + x7 ≥ 1 (Building J constraint} xj= {1, if crew j is selected {0, otherwise Set up the problem in Excel and find the optimal solution. a. What…The university is scheduling cleaning crews for its ten buildings. Each crew has a different cost and is qualified to clean only certain buildings. There are eight possible crews to choose from in this case. The goal is to minimize costs while making sure that each building is cleaned. The management science department formulated the following linear programming model to help with the selection process. Min 270x1 + 290x2 + 250x3+ 270x4 + 230x5 + 180x6 + 180x7 + 280x8s.t. x1 + x2 + x5 + x7 ≥ 1 {Building A constraint}x1 + x2 + x3 ≥ 1 {Building B constraint}x6 + x8 ≥ 1 {Building C constraint}x1 + x4 + x7 ≥ 1 {Building D constraint}x2 + x7 ≥ 1 {Building E constraint}x3 + x8 ≥ 1 {Building F constraint}x2 + x5 + x7 ≥ 1 {Building G constraint}x1 + x4 + x6 ≥ 1 {Building H constraint}x1 + x4 + x8 ≥ 1 {Building I constraint}x1 + x2 + x7 ≥ 1 {Building J constraint}xj = {1, if crew j is selected0, otherwisexj = 1, if crew j is selected0, otherwise Set up the problem in Excel and find…
- According to the XYZ Apartment Rental Company ER diagram, which of the following is true? Each building must have more than one builder Each building must have multiple apartments Each building must have at least 8 apartments Each building must have more than 2 apartments Answer: ____A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His political consultants have provided him with the following estimates of additional votes as a result of the advertising effort: -for every small sign placed by the roadside, he will garner 20 additional votes. -for every large sign placed by the roadside, he will garner 30 additional votes. -for every thousand bumper stickers placed on cars, he will garner 15 additional votes. -for every hundred personal mailings to voters, he will garner 40 additional votes. -for every radio ad heard, he will garner 485 additional votes. The costs for each of the advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the following table. How should the candidate plan to spend his campaign money? Advertising Medium Cost Minimum Maximum Bumper stickers (thousands) $30…Consider the linear program max 4y_{1} + 5y_{2} s.t. - y_{1} + y_{2} <= 4 y_{1} - y_{2} <= 10 y_{1}, y_{2} >= 0 (a) Show graphically that the model is unbounded.
- KrazySockzThe KrazySockz Company is known for their colorful yetcomfortable socks. They have forecasted their demand for the nextsix months as follows: Month 1 demand is 30,000, month 2demand is 50,000, month 3 demand is 20,000, month 4 demand is10,000, month 5 demand is 15,000 and month 6 demand is 20,000.At the beginning of month 1 they have 15,000 pairs of socks onhand. KrazySockz currently has 40 production employees. Each productionemployee costs the company the company $4,000 per month ($3,200 salary and $800in other costs) per month. Production employees can work up to 160 hours permonth before they must be paid overtime. Overtime is paid at a rate of $30 per hourand production employees can not work more than 30 hours per month overtime. Ittakes 15 minutes of labor and $0.75 of raw material to produce a pair of socks.KrazySockz can hire or fire employees each month. Hiring a production employeeincurs a cost of $3,500 and firing a production employee costs $4,500. At the end…You are the district manager for the NCDNR aka the Game Wardens. You staff your law enforcement officers such that they have a 10 hour work day in a single shift. This means that they work 4 days in a row and have 3 consecutive days off. For your district, you need to make sure that you have at least: 10 working on Saturday, 0 on Sunday, 3 on Monday, 3 on Tuesday, 5 on Wednesday, 4 on Thursday, and 8 on Friday. Your current compensation plan approved by the state is: Days off M,T,W T,W,Th W,Th,F Th,F,Sa F,Sa,Su Sa,Su,M Su,M,T Wage 3000 2900 2820 2750 2600 2700 2720 Questions: What is the objective function value? How many employees do you have? How many people show up for work on Sunday, despite this not being necessary according to the scheduling requirements?The state firefighters’ association has a membership of 15,000. The purpose of the organization is to provide some financial support to the families of deceased member firefighters and to organize a conference each year bringing together firefighters from all over the state. Annually, members are billed dues and calls. “Calls” are additional funds required to take care of payments made to the families of deceased members. The bookkeeping work for the association is handled by the elected treasurer, Bob Smith, although it is widely known that his wife, Laura, does all of the work. Bob runs unopposed each year at the election, since no one wants to take over the tedious and time consuming job of tracking memberships. Bob is paid a stipend of $8000 per year, but his wife spends well over 20 hours per week on the job. The organization, however, is not happy with their performance. A computer system is used to track the billing and receipt of funds. This system was developed in 1984 by a…