1. A company will begin stocking remote control devices. Expected monthly demand is 900 units. The controllers will be purchased from RCD supplieroffering price breaks for quantities. RCD's price list is as follows:Quantity RangeUnit PriceO to 29917.00300 to 39916.60400 to 016.20Given that ordering cost is $45 and annual holding cost is 0.20 of unit price per unit, provide thefollowing results:What is the feasible quantity?What is the total annual ordering cost at this quantity? $What is the total annual holding cost at this quantity? $What is the total annual material cost at this quantity? $What is the total annual cost at this quantity? $What is the most economical quantity to order?What is the savings in total annual cost at this quantity? $FORMAT FOR ENTRIES:All quantities and costs are in two decimals after the dot. (8457.20, for example)DO NOT ENTER $ sign for costsIf no saving in costs is available ENTER 0.00

Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

Answered: A company will begin stocking remote…

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

Q-1)A glass melting furnaces feed auto plumping machines for producing the electric lamp casing (balloon),there are two main kinds can be produced, the original and the big one, they must produce at least 25 million of the original but not accede over 35 million ,and they must produce 3 million of the big one, however the ratio of the original must be at least 5 times to the big one which make a profit double the original, producing million of the big one utilize 5% Of the available materials but the original utilize 2.5% of the available materials ,For this problem ,the objective function is: Max Z =0.5X1+2X2 O MIN Z =2X1+X2 O Max Z =2X1+2X2 O Max Z =2X1+X2
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: Style Manufacturers P Q R S A 9 12 10 8 B 10 11 9 7 C 8 10 7 10 D 10 9 9 8 Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? Compare transportation cost by both models(NWCR and LCM)
Question 10.6 Storage Limited operates a 50-week working year. It produces a product called "GENERAL' for which demand any week in the year is described by the probability distribution below: Demand 2 3 4. 7 8. 9 Probability 0.07 0.10 0.11 0.13 0.15 0.17 0.13 0.08 0.04 0.02 Demand can only be satisfied (if at all) from stocks. The stockholding costs are N4 per item per year. Fixed costs per re-order are N16 and the variable, re-order costs are N30 per unit Lead time is one week. The costs of being out of stock are N12 per unit short. You are required to calculate: (i) The average weekly demand; [i] The Economic Order Quantity; [iv] The number of ordering cycles in the year; and [v] State briefly the main reason for holding inventory, and explain why good inventory management is a very important aspect of overall company management. [ii The average annual demand;
1
A.3 Yellowburn University, a not-for-profit higher education organization, has the following mission statement: ‘We aim to deliver excellent tuition in state-of-the-art facilities to help develop socially responsible students and to contribute to global academic research.’ Which TWO of the following would be appropriate objectives to fit in with this mission? To deliver the best possible lessons. Each member of staff is to write two research papers for publication over the next two years. To increase car parking space at the university by 10% in the next 12 months to improve access. To get 15% of all students to receive first class honors degrees each year. To ensure 100% attendance from all students for every lecture.
am. 105.
Need help, thanksss
Subject Name: Simulation & Modelling Q. Describe the following : • Simulation of a Multi-server queueing system • Simulation of an inventory system
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
#1 handwritten
M:26)
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS