Carlton Construction Is Supplying Building Materials for a New MallThe Following Is the LP Model for This Logistics Problem

The Answer of Carlton Construction Is Supplying Building Materials for a New MallThe Following Is the LP Model for This Logistics Problem

Carlton Construction Is Supplying Building Materials for a New MallThe Following Is the LP Model for This Logistics Problem

The Answer of Carlton Construction Is Supplying Building Materials for a New MallThe Following Is the LP Model for This Logistics Problem

Solved

Carlton Construction Is Supplying Building Materials for a New Mall

question 13

Essay

Carlton construction is supplying building materials for a new mall construction project in Kansas.Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period.Carlton's supply depot has access to three modes of transportation: a trucking fleet,railway delivery,and air cargo transport.Their contract calls for 120,000 tons delivered by the end of week one,80% of the total delivered by the end of week two,and the entire amount delivered by the end of week three.Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking,at least 40% of the total delivered be delivered by railway,and up to 15% of the total delivered be delivered by air cargo.Unfortunately,competing demands limit the availability of each mode of transportation each of the three weeks to the following levels all in thousands of tons):
$\begin{array}{cccc}\text { Week } & \text { Trucking Limits } & \text { Railway Limits } & \text { Air Cargo Limits } \\\hline 1 & 45 & 60 & 15 \\2 & 50 & 55 & 10 \\3 & 55 & 45 & 5 \\\hline \text { Costs } \$ \text { per } 1000 \text { tons) } & \$ 20 & \$ 14 & \$ 40\\&0&0&0\end{array}$

The following is the LP model for this logistics problem.
$\text { Let }$

$Carlton construction is supplying building materials for a new mall construction project in Kansas.Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period.Carlton's supply depot has access to three modes of transportation: a trucking fleet,railway delivery,and air cargo transport.Their contract calls for 120,000 tons delivered by the end of week one,80% of the total delivered by the end of week two,and the entire amount delivered by the end of week three.Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking,at least 40% of the total delivered be delivered by railway,and up to 15% of the total delivered be delivered by air cargo.Unfortunately,competing demands limit the availability of each mode of transportation each of the three weeks to the following levels all in thousands of tons): \begin{array}{cccc} \text { Week } & \text { Trucking Limits } & \text { Railway Limits } & \text { Air Cargo Limits } \\ \hline 1 & 45 & 60 & 15 \\ 2 & 50 & 55 & 10 \\ 3 & 55 & 45 & 5 \\ \hline \text { Costs } \$ \text { per } 1000 \text { tons) } & \$ 20 & \$ 14 & \$ 40\\ &0&0&0 \end{array} The following is the LP model for this logistics problem. \text { Let } What values would you enter in the Risk Solver Platform RSP)task pane for the cells in this Excel spreadsheet implementation of this problem? Objective Cell: Variables Cells: Constraints Cells:$
$Carlton construction is supplying building materials for a new mall construction project in Kansas.Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period.Carlton's supply depot has access to three modes of transportation: a trucking fleet,railway delivery,and air cargo transport.Their contract calls for 120,000 tons delivered by the end of week one,80% of the total delivered by the end of week two,and the entire amount delivered by the end of week three.Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking,at least 40% of the total delivered be delivered by railway,and up to 15% of the total delivered be delivered by air cargo.Unfortunately,competing demands limit the availability of each mode of transportation each of the three weeks to the following levels all in thousands of tons): \begin{array}{cccc} \text { Week } & \text { Trucking Limits } & \text { Railway Limits } & \text { Air Cargo Limits } \\ \hline 1 & 45 & 60 & 15 \\ 2 & 50 & 55 & 10 \\ 3 & 55 & 45 & 5 \\ \hline \text { Costs } \$ \text { per } 1000 \text { tons) } & \$ 20 & \$ 14 & \$ 40\\ &0&0&0 \end{array} The following is the LP model for this logistics problem. \text { Let } What values would you enter in the Risk Solver Platform RSP)task pane for the cells in this Excel spreadsheet implementation of this problem? Objective Cell: Variables Cells: Constraints Cells:$
What values would you enter in the Risk Solver Platform RSP)task pane for the cells in this Excel spreadsheet implementation of this problem?
Objective Cell: Variables Cells: Constraints Cells:

Definitions:

Long-range Plans

Strategic plans that encompass a broad vision and long-term goals of an organization, typically extending several years into the future.

Long-term Goals

Objectives or targets a company or individual aims to achieve over an extended period, usually exceeding one year.

Operating Budgets

Detailed projections of income and expenses associated with the day-to-day operations of a business for a specific period.

Financial Budgets

Comprehensive plans that forecast a company's expected revenues, expenditures, and cash flows over a certain period.