PowerO ExponentialLogarithmicO PolynomialQUESTION 9If you try different startinng values for the changing cells and obtain different solutions:you can be confident there is no solutionyou can keep the best solution you have found and hope that it is indeed optimalO there must be a mistake in your objective functionO there must be a mistake in one of your constraintsQUESTION 10In pricing models (i.e., Example 7.1), elasticity of demand is an input with specifies the:sensitivity of price to changes in demandO sensitivity of demand to changes in pricerange of demandlovol

Critical success factors are a management term which states the factors that are important for…

QUESTION 9 If you try different starting values for the changing cells and obtain different solutions: you can be confident there is no solution Oyou can keep the best solution you have found and hope that it is indeed optimal there must be a mistake in your objective function O there must be a mistake in one of your constraints

QUESTION 9 If you try different starting values for the changing cells and obtain different solutions: you can be confident there is no solution Oyou can keep the best solution you have found and hope that it is indeed optimal there must be a mistake in your objective function O there must be a mistake in one of your constraints

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 38P: Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly...

See similar textbooks

Similar questions

Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly payments should equal 556.11. The key relationships are that for any month t (Ending month t balance) = (Ending month t 1 balance) ((Monthly payment) (Month t interest)) (Month t interest) = (Beginning month t balance) (Monthly interest rate) Of course, the ending month 60 balance must equal 0.
I need help with everything, please. hint: you will need to define one variable for total funds needed; one variable for each for 2 securities. and five variables for investment in savings at the beginning of each year. The 6th year will be 1.04 times the 5th-year saving variable. Formulate the problem and submit the formulation - no need to solve 1. As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year Payment 1 190 2 215 3 240 4 285 5 315 6 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street…
Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution please
The shadow price is calculated to be P4.00 for a less than or equal to constraint in a maximization LP problem with the optimal objective function value of z = 25, this means that a.if the coefficient of the objective function is increase by 1 then the RHS for that constraint must be increased by 4. b. if the RHS for that constraint is increased by 4 units then the optimal objective function value will become 26 c.if the coefficient of the objective function is increase by 4 then the RHS for that constraint must be increased by 1. d.if the RHS for that constraint is increased by one unit then the optimal objective function value will become 29
A farmer uses K units of machinery and L hours of labor to produce C tons of corn, with the production function, C= 2L0.5 K. The farmer currently uses L = 20 and K = 10. Suppose the input price ratio is w/r = 1. What would you tell the farmer to do in order to minimize his cost of production given the current level of output? a. You should use more machinery and more labor. b. You should use more machinery and less labor. c. You should use less machinery and more labor. d. You should use less machinery and less labor. Suppose that a latte can only be produced by using exactly 1 ounce of espresso (E) and 3 ounces of milk (M). What is the firm's cost function if the price of espresso is 0.50 per ounce and the price of milk is 0.10 per ounce? a. C = 4q b. C = 0.8q c. C = 0.4q d. C = 160q e. C = 80q
The general manager of XXX Factoring is about to decide whether to enterinto the small and medium enterprise (SME) market. XX Company's customers so far have been mostly big-size companies. The decision to provide factoring to SMEs would mean entering into a new market. Turkey's economy increasingly rely on SMEs, and XX Company doesn't want to jeopardize Company’s position in the market. However, the company also wants to grow fast. Conduct an industry analysis using Porter’s 5 Forces.
Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?
(1) When chef Paolo prices his speciality ‘pizza-n-all’ meal at £25, he sells 20 meals a day. When he prices his pizza meal at £22, he sells 21 meals a day. Suppose Paolo reduces his price from £25 to £22. Explain the impact of the price reduction on the revenue he receives from the first 20 meals he sells. Total Revenue – Price X Quantity. Revenue @ £25 = £25 X 20 = £500. Revenue @ £22 = £25 X 20 = £440 The impact of the price reduction is a reduction in total revenue of £60 (-12%) over the first 20 meals that he sells. Calculate the additional revenue generated from the additional meals he sells when he lowers his price to £22. Total Revenue = Price X Quantity. Total Revenue @ £22 = £22 X 21 = £462. Additional Revenue = Revenue @ £25 – revenue @ £22 = £500 - £462 = -£38. Calculate the marginal revenue Paolo receives from the 21st meal. How does that amount relate to the amounts you calculated in (a) and (b)? (3%) Suppose Paolo reduces his price from £25 to £22. Explain…
Suppose it costs $10,000 to purchase a new car. Theannual operating cost and resale value of a used car areshown in Table 4. Assuming that one now has a new car,determine a replacement policy that minimizes the net costsof owning and operating a car for the next six years.
McDonald wants to increase its total revenue. One strategy is to offer a 10% discount on every customer that they sell. MacDonald knows that their customers can be divided into two distinct groups according to their likely responses to the discount. The table shows how the two groups respond to the discount. Discount Group A: family (sales per week) Group B: school children (sales per week) Volume of sales before the 10% discount 1.55 million 1.50 million Volume of sales after the 10% discount 1.65 million 1.70 million If McDonald wants to increase its total revenue, should discounts be offered to group A or to group B? Explain
4. A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are $500 per print run, with each copy printed costing an additional $0.40. If C(q) is the cost function (in $) of the price of the print run as a function of copies printed, what is the formula for C(q)? Select one: a. C(q) = 500 + 0.4q b. C(q) = 500q + 0.4 c. C(q) = (500 + 0.4)q d. C(q) = 500 - 0.4q e. C(q) = 500q - 0.4 5. A hot dog vendor sells an average of 50 hot dogs during a Little League baseball game. If the sales are Normally distributed with a standard deviation of 7 hot dogs, what is the probability the vendor will sell between 45 and 65 hot dogs? Select one: a. 74.50% b. 92.36% c. 99.78% d. 174.50% e. 2.14 f. -0.71 g. 0.71
Despite of the price increase A Diesel engine uses the following: Type A filter and high-grade lubricating oil costing P10.50 per liter. With this filter, the oil and the filter must be changed every 200 hours of operation, and 5 liters of oil must be added every 50 hours. This filter costs P150 a piece. Eighty liters of oil fill the the engine. Another type, filter B, costing P110 may be used with a lower grade of oil costing P5.50 per liter. However, if this filter is used, the oil and filter must be changed every 250 hours, and 10 liters are added after each 100 hours the engine is used. Which type of filter and oil would you recommend?