Cunningham Products is evaluating five possible locations to build a distribution center. Data estimated from the accounting department are provided below. The annualproduction is estimated to be 35,000 units.CP Location Analysis DataFixed costsDirect material cost/unitDirect labor cost/unitLocation 2$115,000.00Location 3$100,000.00Location 4$145,000.00Location 5$115,000.00Location 1$75,000.00$4.08$4.60$5.15$4.30$12.65$14.00$12.00$15.50Overhead/unit$2.50$2.20$2.90$2.50$0.55Transportation cost/unit$0.60$0.20$0.89a. Use the Location Analysis Excel template to determine the location that provides the least cost. Calculate the total cost for each location. Round your answers to the nearestdollar.$4.30$13.55$2.10$0.61 Total costsLocation 1CP LocationLocation 1Location 2Location 3Location 4Location 5$Which location provides the least cost?-Select- provides the least cost.b. For what range of demand would each location be best?Range of demand$-Select--Select--Select--Select--Select-Location 2✓✓✓V$Location 3$Location 4$Location 5

For each location, I am given the fixed costs and the variable costs per unit, I will determine the…

Answered: CP Location Location 1 Location 2…

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

don't use ai answer,i will 5 upvotes
RM1.
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Q4/ Consider building a new manufacturing plant, is to be located in London. For the three potential sites (location factor, weights, and scores 1 = poor, 7 = excellent') shown in table below. What is the weighted score for these sites? Which is the best location? SI. No. Location factor Weight Scores Location 1 Location 2 Location 3 Facility utilization Total patient km per month Average time per emergency trip Land and construction costs 1. 30 3 6. 7 2. 33 5 3. 27 3 1 9 4. 13 7 6. 5. Employee preferences 10 3
Retailers have to think the way customer would think. When a retailer opens a store he has to think will the place beconvenient for the customers. Considering the geographical, peoples are spread out at every possible location, retailers knows opening a store in every neighborhood would be impossible.Theretailer has to think of a Central location which would be accessible by most of the neighborhood within a particular diameter of the circle. 1. What are the major retailing decisions are to be considered? 2.Pretend that you are one of the aspiring retailer how will you plan your retail store to corner the market and be the best retailing decisions any retailer made? 3 All possible decisions have been presented,. Present your Plans and Programs in retail store.
Subject: Channel management Q): list down the selection criteria for choosing the following for a dairy products company (cheese, margarine, butter etc) a) distributors b) dealers
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
3. Suppose that a logistics company is designing its offering for a manufacturer of frozen foods to deliver their products to various retailers. Assume that the logistics company follows differentiation strategy to gain competitive advantage. How would this logistics company design the following aspects of the offering in order to create value for the frozen food manufacturer? (a) Product (b) Service (c) Delivery (d) Advice
What are the major factors that firms consider when choos-ing a country in which to locate?
Fruit Centre Ice Cream Parlor is deciding where to locate a new facility. The annual fixed costs, initial fixed costs and variable costs for each site have been estimated as follows; Location Annual Fixed Costs (shs) Initial Fixed costs selling price (shs) Variable costs(shs) Namugongo 35,000 400,000 200/unit 200/unit Kireka 19,000 250,000 400/unit 45/unit Banda 15,000 200,000 600/unit 2500/unit Ntinda 95,000 170,000 100/unit 360/unit If demand is expected to be 2000 units, which location is best? and Forecasting is a key component in operations management. Identify and describe any three methods of forecasting that you would recommend to a service industry.
Please assist
Write all constrains equations Draw the constrain region Check if the following pints are valid solution and find their profit - (1,1) - (0.5,2.5) - (3,1) - (3,3) Find the corner points solution table chair Constrain Const 1 Const 30 Const 2 4 8 PRICE 10 PRICE 10 2. 20

SEE MORE QUESTIONS

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