GENERATE THE DECISION VARIABLE SOLUTION ANDGENERATE AN ANSWER REPORT2. During the winter WeeMow Lawn Service contracts with customers for cutting lawns starting in thespring. WeeMow provides service to residential and commercial customers. The service hasidentified 50 possible residential customers and 15 potential commercial customers it hascontacted. WeeMow services a customer once every 2 weeks during the growing season. Aresidential lawn on average takes 1.2 hours to cut, and a commercial property requires 5 hours tocut; the service's available work time is 8 hours, 6 days per week. The profit for a residential lawn is$23, and the profit for a commercial property is $61. The service has established a weekly budget of$350 for management, gas, and other materials, plus equipment repair. A residential lawn averages$12 in management, gas, material, and repair costs, and a commercial property averages $20 incosts. WeeMow wants to know how many residential and commercial jobs it should contract forfrom among its potential customers in order to maximize profits.Required:a. Which resources constrain how many jobs the service can contract for?b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9hours, which would be more profitable?c.The solution to this problem should logically be integer, that is, whole jobs; however, theoptimal solution is not integer. How would you suggest that WeeMow address thisdiscrepancy? Do you think there is a way to handle this problem with the computer programyou are using to solve this problem?

Let, R = Number of residential jobs C = Number of commercial jobs Objective function: Maximize Z =…

Required: a. Which resources constrain how many jobs the service can contract for? b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9 hours, which would be more profitable? c. The solution to this problem should logically be integer, that is, whole jobs; however, the optimal solution is not integer. How would you suggest that WeeMow address this discrepancy? Do you think there is a way to handle this problem with the computer program you are using to solve this problem?

Required: a. Which resources constrain how many jobs the service can contract for? b. If WeeMow could increase its weekly budget by $50 per week, or increase its workday to 9 hours, which would be more profitable? c. The solution to this problem should logically be integer, that is, whole jobs; however, the optimal solution is not integer. How would you suggest that WeeMow address this discrepancy? Do you think there is a way to handle this problem with the computer program you are using to solve this problem?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Ridgley Custom Metal Products (RCMP) must purchase a new tube bender. RCMP's MARR is 12 percent. RCMP can forecast demand for its products for only 4 years in advance. The salvage value after 4 years is $50,000 for model T, $85,000 for model A and $75,000 for model X. Using the study period method, which of the three alternatives is best? Salvage Value $50.000 Yearly Net Savings $55.000 $50.000 $65.000 Model First Cost Economic Life $100,000 $140,000 $190,000 4 years 4 years A $85,000 $75,000 4 years Click the icon to view the table of compound interest factors for discrete compounding periods when i= 12%. The present worth of Model T is $. The present worth of Model A is $ The present worth of Model X is $. Model V is the better choice to buy. (Round to the nearest cent as needed.)
Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 2 projects. Projects 5 and 3 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project 1 Cost Net Present Value $230,000 $300, 000 $260,000 $230,000 $255,000 $660,000 $740,000 $450,000 $450,000 $560,000 3 5. Which projects should be selected? Project 1 will Project 2 will Project 3 will Project 4 will Project 5 will What is the total net present value of these projects? Total net present value
Portfolio manager Max Gaines needs to develop an investment portfolio for his clients who are willing to accept a moderate amount of risk. His task is to determine the proportion of the portfolio to invest in each of the five mutual funds listed below so that the portfolio maximizes the expected return but provides an annual return of no less than 3%. for each of the following scenarios. Annual Returns (Planning Scenarios): mutual fund yr 1 yr 2 yr 3 yr 4 international stock 22.37 26.73 6.46 -3.19 low-cap blend 14.88 18.61 10.52 5.25 mid-cap blend 19.45 18.04 5.91 -1.94 small-cap blend 13.79 11.33 -2.07 6.85 intermediate bond 7.29 8.05 9.18 3.92 Formulate the appropriate linear program for this situation. (state the objective function, the decision variables, and the constraints)
A company owns the same asset in a ASIAN plant and in a UK plant . It has B $2,000,000 and a salvage value of 20% of B . For tax depreciation purposes, ASIA allows a straight line write-off over 5 years, while the UK allows SL write-off over 8 years. The general managers of the two plants want to know the difference in the depreciation amount for year 5.
2. Given a worksheet that stores the top 5 students' marks. The Final marks are calculated as 25% of Term1 marks + 30% of Term2 marks and 45% of Terms3 marks. The Term3 marks entered in the worksheet are estimated marks. In order to avail the scholarship, the student must obtain final % as > 80%. 15 16 Name 17 Tarun 18 Tabassum 19 Krishanan 20 Abraham 21 Simran 22 B Term1 360 377 410 390 380 D Max Marks : 500 Term2 Term3 389 355 390 360 368 410 430 460 450 410 Final =B18*0.25 +C18*0.3+D18*0.45 391.2 394.25 426.5 408 389.9 Final % 78.24 78.85 85.3 81.6 77.98 =E17 / 500 % Estimate how much Term3 marks would be required by each student to meet this condition. For this : (i) Either use Goal Seek by taking target cell from Final % column and variable cell from Term3 column. (ii) Or use Scenario for Term3 values to get desired result in Final %.
For the following problem, what would be the objective function that aims at maximizing the total revenue considering that X1, X2, X3, and X4 are the number of units produced and sold of Products 1, 2, 3, and 4, respectively? Manufacturing time (hr) per unit Machine Cost per hr ($) Product 1 Product 2 Product 3 Product 4 Capacity (hr) 1 10 3 4 2 500 3 2 1 2 380 3 2 1 450 70 55 2 5 3 4 Unit selling price (S) O a. 12X1+8X2+7X3+5X4 O b. None of the answers OC. 20X1+30X2+40X3+20X4 d. 75X1+70X2+55X3+45X4 7 75 45
A new Company plans to allocate some or all of its monthly advertising budget of GH¢82,000 in the Mankato area. It can purchase local radio spots at GH¢120 per spot, local TV spots at GH¢600 per spot, and local newspaper advertising at GH¢220 per insertion. The company's policy requirements specify that the company must spend at least GH¢40,000 on TV and allow monthly newspaper expenditures up to GH¢60,000. The payoff from each advertising medium is a function of the size of its audience. The general experience of the firm is that the values of insertions and spots in terms of "audience points" (arbitrary unit), are as given below: ----------------------------------------------------------------- Radio 40 audience points per spot TV 180 audience points per spot Newspapers 320 audience points per insertion -----------------------------------------------------------------…
Explain to me how the following should be done in the Excel solver:Formulation: Decision variables: x (path 1), y (path 2) Objective function: Maximize Z is equal to 50 x plus 65 y Restrictions: Simplex method: Optimal solution: x = 40 point y = 40 Maximum benefit: $4600
Answer the following questions using the output below please be brief. If there are two possibleanswers one will suffice. Where necessary a range analysis must be shown.convert to minutes) a) What is the optimal solution (in words? b) An additional 4 hours of shaper time became available. Evaluate the effect? Explain c) Two hours of Grinder time was lost. Evaluate the effect?
he pulp and paper factory is one of the longest industrial sectors in the world. Thus, international paper company wants to increase their output. Based on its product, the thickness of 500 sheet of papers is 2.027558055 inch. Without decreasing its quality according to scientific experiments they had done, they decided to use rounding off formula from 9 decimal places to 6 decimal places based on thickness of the paper. Discuss the above study in view of absolute and relative errors. If you are quality control manager of the factory, what is your BEST action towards production line with above decision. Justify your answer
If you have a column of cash flows from years 0 to n and you wish to calculate the present worth of the cash flows. You could use the following EXCEL function(s) for solving the problem with an excel spread sheet: None of the above Maximize EUAB Maximize NPW Maximize (EUAB - EUAC) Maximize PW of Benefits