Q1. An LMN sugar mill company, department stores wish to purchase 10,000 handbags of which 2,000 are of style A, 2,000 are of style B, 3,000 of style C and 3,000 are of style D. Four manufacturers P, Q, R and S bid to supply not more than the following quantities, all styles combined. P= 1,500, Q = 2,600, R = 3,500 and S = 3,000. The following table gives the cost per handbag of each style of the bidders in RO. per handbag: Manufacturers Style P R A 12 10 8 10 11 9. 7 8 10 7 10 10 8 (a) Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? (b) Compare transportation cost by both models(NWCR and LCM)

Q1. An LMN sugar mill company, department stores wish to purchase 10,000 handbags of which 2,000 are of style A, 2,000 are of style B, 3,000 of style C and 3,000 are of style D. Four manufacturers P, Q, R and S bid to supply not more than the following quantities, all styles combined. P= 1,500, Q = 2,600, R = 3,500 and S = 3,000. The following table gives the cost per handbag of each style of the bidders in RO. per handbag: Manufacturers Style P R A 12 10 8 10 11 9. 7 8 10 7 10 10 8 (a) Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? (b) Compare transportation cost by both models(NWCR and LCM)

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

5. __________________refers to the benefits of holding some inventory rather than completely depending on the futures market for supply a. Contract yield b. Convenience yield c. Storage benefit d. Holding benefit
Question 16 Refer to the table given below. As a price of $45, a Price (in dollars) of units occurs. Quantity Demanded Quantity Supplied 75 400 900 450 850 800 70 65 500 60 550 750 55 600 700 50 650 650 45 700 600 40 750 550 a) surplus; 100 b) shortage; 700 Oc) surplus; 700 O d) shortage; 100
Estes Bal. 200 200 150 Truong Bal. 0 100 100 Gehrke Bal. 100 100 150 Weiser Bal. 100 100 100 100 Determine the correct amount of the end-of-month posting from the sales journal to the Accounts Receivable control accoun Amount of the end-of-month posting from the sales journal to the Accounts Receivable control
Q7. of price cwts always leads to higher sales yolumes ?
56 Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every five weeks to take orders. Because the orders are shipped directly from Italy, they take four weeks to arrive. Charlie's Pizza uses an average of 250 pounds of pepperoni each week, with a standard deviation of 10 pounds. Charlie's prides itself on offering only the best-quality ingredients and a high level of service, so it wants to ensure a 99 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 490 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would vou order? Note: Use Excel's NORM.S.INV( function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.
Identify what documents you would find in the above transactions of Chocolate company in the month of October and evaluate them. please help me...
Please no written by hand solutions QUESTION 10 10. "Enter our competition and you could win your share of R500 online shopping voucher for yourself AND a R10 000 voucher towards a Women's empowerment NGO of your choice!" Mrs Jacobs entered the competition above at Mr Price and won a R500 voucher. With R500, she can either buy a handbag, a pair of shoes, a pair of jeans or jacket. She already has a jacket, and she does not want new shoes. She would like a pair of jeans but decides to buy a handbag. What is her opportunity cost? a)R500 voucher. b) Handbag C)Pair of shoes. d)Pair of jeans.
As the new owner of a supermarket, you have inherited a large inventory of unsold imported Limburger cheese, and you would like to set the price so that your revenue from selling it is as large as possible. Previous sales figures of the cheese are shown in the following table. Price per Pound, p $3.00 $4.00 $5.00 Monthly Sales, q (pounds) 404 286 224 (a) Use the sales figures for the prices $4 and $5 per pound to construct a demand function of the form q = Ae-bP, where A and b are constants you must determine. (Round A and b to two significant digits.) q = 760.04e 0.34p x (b) Use your demand function to find the price elasticity of demand at each of the prices listed. (Round your answers to two decimal places.) p = $3 E = -0.65 p = $4 E = -0.98 p = $5 E = -1.23 (c) At what price should you sell the cheese to maximize monthly revenue? (Round your answer to the nearest cent.) $ 4.17 (d) If your total inventory of cheese amounts to only 200 pounds and it will spoil one month from now, how…
Q1/ One of the dairy canning companies wants to set up a special program for the production of cheese, as it decided to produce two types of cheese, each of which consists of a mixture of ingredients that are manufactured in special machines to become ready for use. The cost of the first type of cheese is 41 dinars, and the cost of the second type is 35 dinars. Each of the two types of cheese contains four components. The manufacture of cheese of the first type requires a mixture of (2, 1, 5, 0.6) and the second type (3, 1, 3, 0.25) units of the components (D, C, B, A). on the sequence. The weekly needs of foodstuffs (D, C, B, A) that are supposed to be provided for the cheese industry are (1250, 250, 900, 232.5) kg, respectively. Required: 1- Formulate a mathematical model for this problem. 2- The quantity of cheese production of the first and second types to obtain .the highest return using the graph method
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
what is PARQ
5. An insurer charges a loading of 30% on its policies with limit $500,000, anda loading of 33% on its policies with limit $1,000,000. It purchases stoploss reinsurance of $500,000 over $500,000. The cost of this reinsurance is22% of total premiums. What is the reinsurer’s loading on the reinsurancepolicy?