21. Amanułacturer of prefabricated homes has decided to subcontract four components of the homes. Several companies are interested in receiving this business, but none can handle more than one subcontract. The bids made by the companies for the various subcontracts are summarized in the following table. Bids by Companies (in $1,000s) for Various Subcontracts Company Component D 1 185 225 193 207 200 190 175 225 3 330 320 315 300 375 389 425 445 ssuming all the companies can perform each subcontract equally well, to which mpany should each subcontract be assigned if the home manufacturer wants to nimize payments to the subcontractors? Formulate an LP model for this problem. Create a spreadsheet model for this problem and solve it using Solver. Vhat is the optimal solution?

21. Amanułacturer of prefabricated homes has decided to subcontract four components of the homes. Several companies are interested in receiving this business, but none can handle more than one subcontract. The bids made by the companies for the various subcontracts are summarized in the following table. Bids by Companies (in $1,000s) for Various Subcontracts Company Component D 1 185 225 193 207 200 190 175 225 3 330 320 315 300 375 389 425 445 ssuming all the companies can perform each subcontract equally well, to which mpany should each subcontract be assigned if the home manufacturer wants to nimize payments to the subcontractors? Formulate an LP model for this problem. Create a spreadsheet model for this problem and solve it using Solver. Vhat is the optimal solution?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

ngaged couple Marina and Mark were the winners of a reality TV show involving racing other couples around Australia. They decided to use some of the winnings on their wedding. They checked out a number of venues and finally decided on the Grand Ballroom at the Hotel Grand Inquisitor. Marina and Mark signed a ‘wedding package’ contract with the hotel, which provided for the following: Hire of ballroom - $15,000 Catering (excluding cake) - $9,000 Wedding cake (two-tier) - $500 Honeymoon suite (one night) - $400 Total - $24,900 The wedding reception was a happy event. However, when it came to the time to reveal and cut the cake, Marina and Mark were shocked to learn that earlier in the day a hotel waitress had clumsily dropped the specially baked wedding cake, and because there was no time to prepare another, the two-tier cake provided by the hotel was in fact two sponge cakes…
10. Dantey Development Corporation is considering bidding on a contract for a new office building complex. Dantey's Company must decide whether to bid on the contract or not. The cost of preparing the bid is $200,000. Based on past experience the company has a 0.80 probability of winning the contract if it submits a bid. If the company wins the bid, it will have to pay $2,000,000 to become a partner in the project. Dantey Company will consider doing a market research study to forecast demand for the office units prior to beginning construction if the company wins the contract. The cost of this study is $150,000. The possible outcomes of the market research study can either be high or moderate forecasts. The likelihood of high forecast is 0.60. Dantey CEO must decide either to build the office complex or sell the rights in the project to another developer upon wining the contract whether the market research study was conducted or not. The decision to build the complex will result in an…
Question 25 A buyer is entitled to the remedy of specific performance when: the contract requires delivery in installments. the contract is for goods where the price is $500 or more. the contract is for unique goods. the contract is between merchants.
Under what circumstances would a construction change directive (CCD) be used? When the owner selects one of the alternates included in the initial bid When the designer assumes control of the means and methods used for construction When the source of the change is differing site conditions When a change is minor and has no impact on cost or schedule When the owner wants the contractor to perform a change but cost has not yet been determined
Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period: Merchandise Freight Paid by Seller Customer Returns and Allowances a. $13,900 FOB destination, n/30 $700 b. 11,000 $400 FOB shipping point, 1/10, n/30 1,300 c. 8,500 FOB shipping point, 2/10, n/30 800 d. 2,800 100 FOB shipping point, 1/10, n/30 400 e. 3,700 - FOB destination, 2/10, n/30 -
On January 2, 2019, Epson Company signed an 8-year non-cancellable lease for a new machine, requiring P120,000 annual payments at the beginning of each year. The machine has an estimated life of 12 years, with no salvage value. Title passes to Epson at the lease expiration date. Epson uses straight-line method of depreciation for all of its plant asses. Aggregate lease payments have a present value on January 2, 2017, of P864,000 based on an appropriate rate of interest. For 2018, how much should Epson record as depreciation expense for the leased machine?
2
Define resolution, what is (are) the type(s) of resolution?
Pls help ASAP on both
problem number 2/a,b,and c No handwritten solution plz
waldo needs to decide how many copies of a new hardcover release to purchase for its shelves. The store has assumed that demand will be 50, 100, 150, or 200 copies next month and they need to decide whether to order 50, 100, 150 or 200 books for this period. Each book costs Waldo PhP50 and can be sold for PhP85. Waldo can sell any unsold books back to their supplier for PhP15. a. Formulate the payoff table. b. Determine the best decision and payoff is maximin and equally likely criteria are used. Answers in figure only without comma or units. If there are more than 2 answers, put an NA to excess brackets. Maximin: Decision: Order Blank 17 Payoff = Blank 18 Equally Likely: Decision: Order Blank 19, Blank 20, Blank 21 Payoff = Blank 22 c. If the coefficient of pessimism is 0.4, determine the best decision and payoff using Hurwicz criterion. Answers in figure only without comma or units. Hurwicz: Decision: Order Blank 23 Payoff= Blank 24
1.What is the point at which an owner can begin to occupy a building or use it for its intended purpose? At the end of the warranty period After final completion When the payment bond is terminated After substantial completion 2.What is used to determine periodic payment amounts on unit price contracts? Submitted invoices, receipts, and timesheets plus the contractor's fee. A fixed, monthly installment negotiated at the start of the project. Schedule of Values and percentage completion on each pay item Unit prices originally bid and quantities measured.