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 1 week 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 )...

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...

Subjects