Business, 25.02.2020 19:54 autumnsumrall

A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sent to regional distributors in Jacksonville, Boise, and Charlotte. The shipping costs vary, and the company would like to find the least-cost way to meet the demands at each of the distribution centers Jacksonville needs to receive 800 printers per month, Boise needs 600, and Charlotte needs 200 New Orleans has 750 printers available each month, Albuquerque has 550, and Nashville has 300 The shipping cost per unit from New Orleans to Jacksonville is $8, to Boise is $12, and to Charlotte is $10. Due to truck capacity limits, no more than 50 printers can be shipped between New Orleans and Charlotte each month. The cost per unit from Albuquerque to Jacksonville is $10, and to Charlotte is $9. Printers from Albuquerque are never ship The cost per unit from Nashville to Jacksonville is $11, to Boise is $8, and to Charlotte is $12. ped to Boise

(a) Formulate a linear optimization model to determine how many units should be shipped from each plant to each regional distribution center
(b) Is the capacity of the plants equal to the demand at the distribution centers?
(c) Enter your model in Excel and use Solver to find the optimal distribution plan. Include your spreadsheet in vour homework submission.
(d) What is the optimal distribution plan?
(e) What is the cost of the optimal distribution plan?

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 12:30

M. cotteleer electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. one of the components has an annual demand of 235 units, and this is constant throughout the year. carrying cost is estimated to be $1.25 per unit per year, and the ordering (setup) cost is $21 per order. a) to minimize cost, how many units should be ordered each time an order is placed? b) how many orders per year are needed with the optimal policy? c) what is the average inventory if costs are minimized? d) suppose that the ordering cost is not $21, and cotteleer has been ordering 125 units each time an order is placed. for this order policy (of q = 125) to be optimal, determine what the ordering cost would have to be.

Answers: 1

Answer

Business, 22.06.2019 13:30

Over the past year, three of the star salesmen at family resorts international's corporate office have been lured away to competitors. on top of that, karina, the general manager of the sales department, has noticed that most employees come in, do their jobs, and leave. family resorts offers a good salary, benefits, and tuition reimbursement, as well as a number of development and training programs. most employees seem contented enough, but karina would like to do something to increase the level of engagement among her staff. what do you think karina should do?

Answers: 1

Answer

Business, 22.06.2019 21:10

Acompany has two products: standard and deluxe. the company expects to produce 36,375 standard units and 62,240 deluxe units. it uses activity-based costing and has prepared the following analysis showing budgeted cost and cost driver activity for each of its three activity cost pools.budgeted activity of cost driver activity cost pool budgeted cost standard deluxe activity 1 $ 93,000 2,500 5,250 activity 2 $ 92,000 4,500 5,500 activity 3 $ 87,000 3,000 2,800 what is the overhead cost per unit for the standard units? what is the overhead cost per unit for the deluxe units? (round activity rate and cost per unit answers to 2 decimal places.)activity expected costs expected activity driver activity rate1 93,000 2 92,000 3 87,000 standard activity activity driver activity rate allocated costs1 2 3

Answers: 2

Answer

Business, 23.06.2019 00:30

Dr. hughes enjoys offering to employees who perform over and above the call of duty

Answers: 1

Answer

You know the right answer?

A manufacturer produces printers at plants in New Orleans, Albuquerque, and Nashville. These are sen...

Questions