A building contractor has a contract which will expire in 30 days. He has 80 men on the job and can finish the job in 50 days. The wage per day of 40 men is P6.00 each and that of the other men is P4.00 each for 8 hours work per day. The fine or liquidated damages for delay in the work is P100.00 per day. How many more men should the contractor add in order to complete the work on time? Assuming that the additional men to be added will be paid P6.00 per day, will the contractor save money by employing enough men for him to complete the work on time or by not adding more men and paying the fine? How much is the savings, if any? No overtime work is permitted

A building contractor has a contract which will expire in 30 days. He has 80 men on the job and can finish the job in 50 days. The wage per day of 40 men is P6.00 each and that of the other men is P4.00 each for 8 hours work per day. The fine or liquidated damages for delay in the work is P100.00 per day. How many more men should the contractor add in order to complete the work on time? Assuming that the additional men to be added will be paid P6.00 per day, will the contractor save money by employing enough men for him to complete the work on time or by not adding more men and paying the fine? How much is the savings, if any? No overtime work is permitted

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Similar questions

A building contractor has a contract that will expire in 40 days. He has 80 men on the job and can finish the job in 50days. The wage per day of 40 men is P500 each and the other 40 men is P300, each for 8 hours work per day. The fine for the delay in the work is P10,000 per day. a.How many more men should the contractor add in order to complete the work on time? b.Assuming that the additional men to be added will be paid P400 per day, will the contractor save money by employing enough men to complete the work on time or by not adding more men and paying the fine? How much is the savings, if any? Note: No overtime work is permitted
An engineer failed to finish its building construction contract on time. With this, a penalty of P10,000 will be paid for each day that passes beyond the date of contract. According to the engineers estimate, if the construction will continue with the same number of workers, the project will be finished 30 days after the contract date. But the engineer also has an option of hiring more workers to hasten the construction process. Every additional worker, the engineer has to pay P3,000 per day and every 3 additional workers the construction period will be lowered down by 1 day. But, the engineer can only hire 21 workers. If you are the engineer, what method are you going to follow so as to incur a lesser amount of extra construction cost? Just pay P10,000 per day for 30 days? Or just hire additional workers to lower down the construction time?
Given problem: A contractor has a job which should be completed in 120 days. At present, he has 80 men on the job and it is estimated that they will finish the work in 150 days. Of the 80 men, 50 are each paid ¥ 150.00 a day, 25 at ¥ 210.00, and 5 at ¥ 280.00. For each day beyond the original 120 days, the contractor has to pay ¥ 1,500.00 liquidated damages. If of the additional men, 5 are paid ¥ 150.00, and the rest at ¥ 210.00, how much more is the savings of the contractor by hiring more men and not paying the fine? *Do show solution. Round off final answer in 2 decimal places. Thank you.
Haya International are considering a project that is susceptible to risk. An initial investment of OMR90,000 will be followed by four years each with the following ‘most likely’ cash flows (there is no inflation or tax): OMR OMR Annual Sales 400,000 (volume of 100,000 units multiplied by estimated sales price of OMR 4) Annual Costs Labour 200,000 Materials 40,000 Other 10,000 250,000 (250,000) 150,000 The initial investment consists of OMR80,000 in machines, which have a zero scrap value at the end of the four-year life of the project and OMR10,000 in additional working capital which is recoverable at the end. The discount rate is 10 per cent. Required : Calculate the NPV and show the sensitivity of NPV to changes in the following: Increase in sales price by 10%; Decrease in discount rate by 10%
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Cliente A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Now consider that each employee can carry out at most three jobs during the day. State and solve the problem thorugh excel solver.
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 Solve it through excel solver.
You are the owner of a business and must perform the work of ten clients during the day. It has four collaborators who are capable of carrying out the different jobs with the same level of quality. Depending on the skills of the different collaborators and the complexity of the jobs, the execution times are different and are presented in the following table: Client A B C D Arkitex 3 3 2 1 Bravia 3 3 4 3 Cúbika 4 5 6 4 Doratta 8 6 5 7 Evergreen 3 4 2 2 Fenix 5 6 3 4 Golden 3 3 1 4 Horizon 6 8 6 5 Icónika 5 5 5 5 Luxus 4 4 1 2 b) Now consider that each employee must carry out at least one job during the day. State and solve the problem throught excel solver
A small publishing company is planning to publish a new book. The production costs will include one-time fixed costs (such as editing) and variable costs (such as printing). There are two production methods it could use. With one method, the one-time fixed costs will total $49,465, and the variable costs will be $11.25 per book. With the other method, the one-time fixed costs will total $19,240, and the variable costs will be $19 per book. For how many books produced will the costs from the two methods be the same?
Tom Adams has received a job offer from a large investmentbank as a clerk to an associate banker. His base salary will be $55,000. He willreceive his first annual salary payment one year from the day he begins to work.In addition, he will get an immediate $10,000 bonus for joining the company. Hissalary will grow at 3.5 percent each year. Each year he will receive a bonus equal to10 percent of his salary. Mr. Adams is expected to work for 25 years. What is thepresent value of the offer if the discount rate is 9 percent?
Given problem: A contractor has a job which should be completed in 120 days. At present, he has 80 men on the job and it is estimated that they will finish the work in 150 days. Of the 80 men, 50 are each paid Php 150.00 a day, 25 at Php 210.00, and 5 at Php 280.00. For each day beyond the original 120 days, the contractor has to pay Php 1,500.00 liquidated damages. How many more men should the contractor add so that he can complete the work on time? *Do show solution. Round off final answer in 2 decimal places. Thank you.
A contractor has a job which should be completed in 120 days. At present, he has 80 men on the job and it is estimated that they will finish the work in 150 days. Of the 80 men, 50 are each paid Php 150.00 a day, 25 at Php 210.00, and 5 at Php 280.00. For each day beyond the original 120 days, the contractor has to pay Php 1,500.00 liquidated damages. How many more men should the contractor add so that he can complete the work on time? Use continuous computations, round off your final answers to two (2) decimal places.
See the answer A local movie studio wants to determine which of two new scripts they should select for their next major production. The manager feels that script #1 has a 70% chance of earning Php100 million over the long run, but a 30% chance of losing Php20 million. If this movie is successful, then a sequel could also be produced, with an 80% chance of earning Php50 million, but a 20% chance of losing Php10 million. On the other hand, she feels that script #2 has a 60 % chance of earning Php120 million, but a 40% chance of losing Php30 million. If successful, its sequel would have a 50% chance of earning $80 million and a 50% chance of losing Php40 million. As with the first script, if the original movie is a "flop," then no sequel would be produced. What is the expected payoff from selecting script #2?