The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company would like to minimize the transportation costs while meeting the demand at each destination and not exceeding the supply at each source. In formulating this as a linear program, there are three supply constraints (one for each source) and three demand constraints (one for each destination). The decisions to be made are the number of units to ship on each route, so there is one decision variable for each arc (arrow) in the network. Let: the network. Let: Supply 100 300 300 Source Des Moines (Source 1) Evansville (Source 2) Fort Lauderdale (Source 3) $3 $8 8 $9 $5 $4 $4 $7 $5 E Destination Albuquerque (Destination 1) D Boston (Destination 2) Cleveland (Destination 3) Demand 300 200 200 ****PLEASE SOLVE ON EXCEL ONLY WITH CLEAR AND EASY FORMULATION AND EASY TO UNDERSTAND STEP BY STEP** NOTE** ONLY SOLVE USING EXCEL SOLVER WITH EASY METHOD** The Executive Furniture Corporation is faced with the transportation problem shown in Figure 9.1. The company would like to minimize the transportation costs while meeting the demand at each destination and not exceeding the supply at each source. In formulating this as a linear program, there are three supply constraints (one for each source) and three demand constraints (one for each destination). The decisions to be made are the number of units to ship on each route, so there is one decision variable for each arc (arrow) in the network. Let: the network. Let: Supply 100 300 300 Source Des Moines (Source 1) Evansville (Source 2) Fort Lauderdale (Source 3) $3 $8 8 $9 $5 $4 $4 $7 $5 E Destination Albuquerque (Destination 1) D Boston (Destination 2) Cleveland (Destination 3) Demand 300 200 200 ****PLEASE SOLVE ON EXCEL ONLY WITH CLEAR AND EASY FORMULATION AND EASY TO UNDERSTAND STEP BY STEP** NOTE** ONLY SOLVE USING EXCEL SOLVER WITH EASY METHOD**
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Chewy Candy Company would like to determine an aggregate production plan for the next six months. The company makes many different types of candy but feels it can plan its total production in...
-
The controller of Yazoo Electronic Company would like to know how closely the incurrence of factory overhead in the company's Semiconductor Manufacturing Department correlates with machine hours....
-
A fishing company would like to predict how much fish are caught based on the amount of baits used. You are brought in as a consultant. You believe a linear regression model may be appropriate. Using...
-
(a) Decide whether each of the following expressions are true or not. Answer yes or no. In any case where it is not true, provide the actual O-complexity. (i) log n = O(n!) (ii) 10! = O(log n) (iii)...
-
Distinguish between the general audit objectives and management assertions. Why are the general audit objectives more useful to auditors?
-
Jiminys Cricket Farm issued a 30-year, 6 percent semiannual bond three years ago. The bond currently sells for 93 percent of its face value. The companys tax rate is 22 percent. a. What is the pretax...
-
When is it appropriate to seek a writ of possession as a provisional remedy?
-
This problem continues the Draper Consulting, Inc., situation from Problem 13-37 of Chapter 13. Refer to the comparative balance sheet for Draper Consulting. Requirement 1. Prepare the statement of...
-
If the provision for bad is $0 will the extraordinary item cost equal zero as well for this year and the following? OPERATING EXPENSES Salaries and Wages Employee Benefits Professional Fees Supplies...
-
The Accounts Receivable Confirmation Statistics working paper shown on the next page was prepared by an audit assistant for the 2013 audit of Lewis County Water Company, Inc., a continuing audit...
-
A firm's return on equity is 6.55%, its plowback ratio is 70%, and next year's expected earnings per share is $4.30. What is the expected price of the stock in 6 years if investors require a 10.70%...
-
Effective cost drivers, and the resulting allocation system, must have what two important attributes?
-
Which of the following is not a condition of an ideal currency regime? A. Fully convertible currencies B. Fully independent monetary policy C. Independently floating exchange rates
-
What is the impact of a discount contract on fixed costs, total variable costs, and the breakeven point?
-
For complex buying situations, longer selling cycles and incremental commitments may be the best strategies to adopt. Explain why.
-
Which of the following counterparties is most likely to be considered a sell-side foreign exchange market participant? A. A large corporation that borrows in foreign currencies B. A sovereign wealth...
-
10. What happens to the quantity of money demanded when the interest rate changes? 11. What happens to the quantity of loans as the interest rate changes? Explain
-
Identify the Critical Infrastructure Physical Protection System Plan.
-
The Miramar Company in Problem 18 is considering contracting with a market research firm to do a survey to determine future market conditions. The results of the survey will indicate either positive...
-
Maria Eagle is a Native American artisan. She works part time making bowls and mugs by hand from special pottery clay and then sells her items to the Beaver Creek Pottery Company, a Native American...
-
Blue Ridge Power and Light is an electric utility company with a large fleet of vehicles, including automobiles, light trucks, and construction equipment. The company is evaluating four alternative...
-
In a recent year Kennedy Ltd had profit after tax of \($150\) 000, interest expense of \($30\) 000, and tax expense of \($20\) 000. What was Kennedy Ltds times interest earned for the year? (a) 5.00....
-
An obligation for long service leave payable 6 years from now is recognised as: (a) a contingent liability. (b) a non-current provision. (c) a current provision. (d) none of the above; it is not...
-
Gester Ltd redeems its \($100\) 000 face value debentures at 105 on 31 January, following the payment of half-yearly interest. The carrying amount of the debentures at the redemption date is \($100\)...
Study smarter with the SolutionInn App