Use the tab labeled Solver Part 4 to complete the following: a) Create and program a spreadsheet with data based on the following scenario: Scenario Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck's costs per mile are as follows: Fuel/additives: 54¢ Truck payments: 24¢ Driver: 36¢ • Repairs: 12¢ Miscellaneous: 1¢ The old truck's costs are as follows: Fuel/additives: 60¢ Truck payments: Oc Rookie driver: 32¢ Repairs: 24¢ • • Miscellaneous: 1¢ The company knows that truck breakdowns lose customers, so they have capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks). After you set up and program your table, be sure to provide a rationale statement. b) Use Solver to determine the number of miles each truck should be driven.
Q: Plan production for a four-month period: February through May. For February and March, you should…
A: Aggregate plans show output rates, workforce levels, and inventory in accordance with demand and…
Q: How does an understanding of management and organizational behavior lead to organizational…
A: An understanding of management and organizational behavior is crucial for achieving organizational…
Q: O C. 1 B Loser (0.70) Win $5 (0.09) Win $25 (0.21) Loser (0.70) Second Chance (0.30) 0 Loser (0.6) 0…
A: A decision tree is a flowchart-like design where each inward node addresses a decision or test on a…
Q: Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Weight East #1 8 100 60…
A: Find the given details below: Given details:FactorWeightFactor ScoreEast #1East #2WestInitial…
Q: Avis Company is a car rental company that is located three miles from the Los Angeles airport (LAX).…
A:
Q: What is the standard times for Molding tasks? OA. 35.5 minutes per batch B. 32.5 minutes per batch…
A: For each task, I have taken four observations, The given data is shown below, Observed…
Q: a. Formulate an integer programming model that can be used to develop a schedule that will satisfy…
A: (a) Formulation of the integer programming model is shown below:As per the given assumption,xi =…
Q: The desired daily output for an assembly line is 360 units. This assembly line will operate 390…
A: Network diagram is a graphical representation of a project which helps to identify the project…
Q: What is the minimum cost of crashing the following project that Roger Solano manages at Slippery…
A: The project crashing is a process that helps to reduce the project duration using additional costs…
Q: A Activity Immediate Precedence Duration -- B D E F A,B,C A,B,C D 4 3 2 5 6 7 (i) Draw the network…
A: The critical path method assists in optimizing resource allocation, budget management, and risk…
Q: The constraint for cold storage location B should be:
A: The transshipment problem is a pivotal concept within the realm of transportation and logistics. It…
Q: Assuming that the company is interested in maximizing the total profit contribution, answer the…
A: Here, we have regular and catcher's models, The constraints are cutting and sewing, finishing and…
Q: manager of Roth Corporation, wants to determine whether or not the type of work schedule for her…
A: Work Schedule (Treatments)Schedule 1 Schedule 2Schedule 3506075606575706555405840455755
Q: o move their products through the distribution channel from the point of manufacture to the point of…
A: The product life cycle starts from its inception through manufacturing to the point of consumption,…
Q: A telephone call center uses five customer service representatives (CSRs) during the 8:30 a.m. to…
A: Number of CSRs = 5Standard service rate =5 min per call = 30/5=6 callsUtilization rate = 80% = 0.80
Q: 14.) A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure…
A: It shows the items required in manufacturing with their1. levels in which they appear and 2. the…
Q: The section of the audit report is often technical in nature and focuses on solutions to problems…
A: Organizations take various measures to maintain their financial statements, ensure that there is…
Q: Which of the following is a plot of the distribution function of a normal distribution? (See…
A: Another name for a normal distribution plot is a bell curve. Here, we will present a graph to show…
Q: Jose Martinez of El Paso has developed a polished stainless steel tortilla machine that makes it a…
A: Production is the process of manufacturing the finished products using the raw materials and…
Q: yield C1 C2 C3 Does it indicate presence of interaction?
A: Step 1: Identify the variablesThe two variables in the image are the yield and the concentration of…
Q: You have just been hired as the director of operations for Reid Chocolates, a purveyor of…
A:
Q: Mary Parker Follett anticipated some of today's workplace trends, such as
A: American social worker, philosopher, and pioneer in the disciplines of organizational theory and…
Q: Ecommerce or electronic commerce is the trading of goods and services on the internet. All aspects…
A: E-commerce has become immensely popular with the advancements in technology. There has been an…
Q: Prepare a bill of material for a wooden pencil, complete with eraser. Bill of Material for a Wooden…
A: Here is a list of the components for a hardwood pencil that includes an eraser:Wood half: 1Graphite…
Q: The operations of stores functions and controls of stock involves the capturing, storing information…
A: Maintaining an inventory record is a way to make sure that an organisation has the appropriate…
Q: 1) Work specialization is the degree to which task in the organization are into separate jobs with…
A: Work specialization would consider individuals with their specialized skills and experiences for a…
Q: In the basic EOQ model, a monthly demand of 50 units, an ordering cost of $100, and a holding cost…
A: Monthly demand = 50 units Ordering cost = $ 100Holding cost = $ 3/unit per year
Q: Consider the following decision tree. Which decision, A or B, is best? What is the expected value of…
A: First, I would determine the expected payoff for each node, Here, there are two alternatives, For…
Q: With reference to the relevant theory and the information ion the attached, provide an analysis of…
A: The Mayo Clinic's reputation as a preeminent healthcare facility is founded on its unwavering…
Q: In an M/M/1 queueing system, the arrival rate is 5 customers per hour and the service rate is 7…
A: Arrival rate of calls λ=5 customers per hourService rate μ=7 customers per hour
Q: Use the process flow diagram to determine which of these events has the greatest net benefit.…
A: Theory of Constraints is a process improvement method is based on the principle that every system…
Q: Given 5000 minutes of resources at each Workcenter, how many units of A could be produced assuming…
A: A requires 3 units of B and 2 units of C. Where 1 unit of C requires 2 units of B.For Part A:Lot…
Q: need to be recognized. ng ethical behavior. ting ethics and g programs ems below. Rewarding ethical…
A: *5Strategy: Screening prospective employeesScenario: Employees at Riverview go through an extensive…
Q: Use the Naive method to make a forecast for month 3, and then use that information to make a…
A: Forecasting helps in knowing about future events by making estimates mainly based on historical…
Q: Critical Path Scheduling Construct a Pert diagram for each of the two problems below (see scheduling…
A: A PERT diagram showing the sequence and dependencies of tasks, as well as the estimated durations…
Q: A tax advisor is able to serve 4 customers per hour on a walk-in basis. An average of 3 customers…
A: For this question, first I would determine the utilization, From this Ref data, I could answer the…
Q: The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects.…
A: Project management includes those processes that are important for quality planning and control. It…
Q: Develop a Work Breakdown Structure (WBS), in text or graphical format for the project (with a…
A: The Work Breakdown Structure (WBS) is a pivotal tool utilized in project management to disintegrate…
Q: Solve the following assignment problem I 11 9 13 21 1 2 3 4 5 сл 14 II 17 7 16 III 8 12 15 12 24 17…
A: An assignment problem is a technique to find the combinations of the optimal solution to the…
Q: The project will take The critical activities are The late start on Activity C is The slack on…
A: Here, each activity ID is given with description data, predecessor data, and time data. Using the…
Q: The activities described by the following table are given for the J.C. Howard Corporation in Kansas:…
A: ActivityTimeImmediate PredessorA9-B7AC3AD6BE9BF4CG6E,FH5DI3G,H
Q: Consider a partial output from a cost minimization problem that has been solved to optimality. Name…
A: Shadow price relates to the change in the objective function value resulting from a unit increase in…
Q: QUESTION 34 butie y & Google 4 Sample size Number defective 100 3 100 100 100 5 100 The central line…
A: Quality control involves analyzing the process of production to identify areas for improvement. This…
Q: A nutritional plan requires at least 200 units of protein and 180 units of fat. From chemical…
A: Linear programming (LP) is a mathematical optimization technique that helps solve problems where an…
Q: In line balancing, the relationships between among tasks in a process is are shown in a: Multiple…
A: In the field of process optimization and production management, one of key considerations is…
Q: hile not all Police Departments may have the resources to implement a program for LGBTQ+ community…
A: Training and Sensitivity Workshops: Provide training to officers and staff on LGBTQ+ issues,…
Q: The lean operations system strategy has been in operation for 3 months at Your Furniture Company.…
A: From the given case, we can tell that the lean operations strategy has a lot of importance, Here, we…
Q: oger Ginde is developing a program in supply chain management certification for managers. Ginde has…
A: A)NETWORK DIAGRAM B)PATHS DURATIONS AEG=…
Q: Output from a process contains 0.02 defective unit. Defective units that go undetected into final…
A: Inspection helps the organization in identifying the potential risks as well as hazards associated…
Q: (b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each…
A: For this question, first, I would formulate the LP, and after formulating the LP, I would solve this…
Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows: 54₵ (fuel/additives), 24₵ (truck payments), 36₵ (driver), 12₵ (repairs), and 1₵ (misc.). The old truck’s costs are 60₵ (fuel/additives), 0₵ (truck payments), 32₵ (rookie driver), 24₵ (repairs), and 1₵ (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.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?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.
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?