Question

In: Operations Management

QSO 320 Mgmt Science Thru Spread Sheets Problem 5-13 Shipments: To Flow balance equations From Job...

QSO 320 Mgmt Science Thru Spread Sheets

Problem 5-13
Shipments: To Flow balance equations
From Job 1 Job 2 Job 3 Flow out Location Flow in Flow out Net flow Sign RHS
Central 0.0 Central 0 0 0 >= -3000
Rock 0.0 Rock 0 0 0 >= -4000
Acme 0.0 Acme 0 0 0 >= -6000
Flow in 0.0 0.0 0.0 Job 1 0 0.0 0 = 2500
Job 2 0 0.0 0 = 3750
Unit costs: To Job 3 0 0.0 0 = 4850
From Job 1 Job 2 Job 3
Central $9 $8 $7
Rock $7 $11 $6
Acme $4 $3 $12
Total cost = $0 <--- Minimize total transportation costs. Formula = SUMPRODUCT(B5:D7,B12:D14)
Note:
Once all values are entered in the appropriate shaded areas, go to the DATA tab on the Excel sheet ribbon, click on the Data Analysis Group, and then choose Solver. Click SOLVE to run Excel's Solver add-in to obtain the optimized solution. Note that if Solver is not on the DATA tab, refer to the Help file (Solver) for instructions or pages 569–571 of Balakrishnan (2013) Managerial Decision Modeling With Spreadsheets. For more information on entering information in Solver, refer to pages 44–49 of Balakrishnan (2013). To learn more about how to set up and solve linear programming (LP) problems, refer to pages 40–51 of Balakrishnan (2013).

For the changing variable cells (yellow shaded), the initial entries in the cells can be blank or any value of your choice based on the given constraints.

Solutions

Expert Solution

Solver Solution:

keosha answered 6 months ago
Next > < Previous

Related Solutions

E12-13 Preparing and Evaluating a Statement of Cash Flows (Indirect Method) from Comparative Balance Sheets and...
E12-13 Preparing and Evaluating a Statement of Cash Flows (Indirect Method) from Comparative Balance Sheets and Income Statements [LO 12-1, LO 12-2, LO 12-3, LO 12-4, LO 12-5] Consultex, Inc. was founded in 2012 as a small financial consulting business. The company had done reasonably well in 2012–2014 but started noticing its cash dwindle early in 2015. In January 2015, Consultex had paid $14,500 to purchase land and repaid $3,000 principal on an existing promissory note. In March, the company...
QS 16-13 Computing cash from asset sales LO P3 CRUZ, INC. Comparative Balance Sheets December 31,...
QS 16-13 Computing cash from asset sales LO P3 CRUZ, INC. Comparative Balance Sheets December 31, 2019 2019 2018 Assets Cash $ 64,300 $ 16,100 Accounts receivable, net 27,600 34,100 Inventory 57,700 64,000 Prepaid expenses 3,600 2,900 Total current assets 153,200 117,100 Furniture 72,600 82,200 Accum. depreciation—Furniture (11,200 ) (6,200 ) Total assets $ 214,600 $ 193,100 Liabilities and Equity Accounts payable $ 10,100 $ 14,200 Wages payable 6,000 3,300 Income taxes payable 1,000 1,800 Total current liabilities 17,100 19,300...
Problem 21-5 Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2018 and...
Problem 21-5 Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2018 and 2017 and a statement of income for 2018 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided. METAGROBOLIZE INDUSTRIES Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 400 $ 205 Accounts receivable 390 210 Inventory 540 360 Land 550 515 Building 900 900 Less: Accumulated depreciation (300 )...
Problem 21-5 Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2018 and...
Problem 21-5 Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2018 and 2017 and a statement of income for 2018 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided. METAGROBOLIZE INDUSTRIES Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 530 $ 255 Accounts receivable 650 340 Inventory 800 425 Land 600 555 Building 900 900 Less: Accumulated depreciation (200 )...
This is problem 5-13 from El-Wakil’s Powerplant Technology book -- a 50 percent reaction stage in...
This is problem 5-13 from El-Wakil’s Powerplant Technology book -- a 50 percent reaction stage in a steam turbine undergoes a total of 20 Btu/lbm enthalpy drop. The nozzle efficiency and angle are 88 percent and 25°, respectively. The blades move at 420 ft/s and have Vr1 = 332 ft/s, Vs2 = 386 ft/s, and ? = 22°. The steam flow is 1.08x106 lbm/h. Find (a) the work done by the stage in horsepower and megawatts, (b) the blade efficiency,...
Problem 21-5 (Algo) Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2021...
Problem 21-5 (Algo) Statement of cash flows; direct method [LO21-3, 21-8] Comparative balance sheets for 2021 and 2020 and a statement of income for 2021 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided. METAGROBOLIZE INDUSTRIES Comparative Balance Sheets December 31, 2021 and 2020 ($ in thousands) 2021 2020 Assets Cash $ 440 $ 190 Accounts receivable 470 250 Inventory 620 380 Land 625 575 Building 800 800 Less: Accumulated depreciation (200...
Problem 5-11 Consider a risky portfolio. The end-of-year cash flow derived from the portfolio will be...
Problem 5-11 Consider a risky portfolio. The end-of-year cash flow derived from the portfolio will be either $55,200 or $161,100, with equal probabilities of 0.5. The alternative riskless investment in T-bills pays 4%. Required: (a) If you require a risk premium of 8.5%, how much will you be willing to pay for the portfolio? (Round your answer to the nearest dollar amount. Omit the "$" sign in your response.)   Price $    (b) Suppose the portfolio can be purchased for the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT