Question: Part 3 - Aircraft Loading The cargo loading data table (Table 3) provides information about the value of items ($ 1,000) and the item's associated

Part 3 - Aircraft Loading The cargo loading data

Part 3 - Aircraft Loading The cargo loading data table (Table 3) provides information about the value of items ($ 1,000) and the item's associated cubic volume (m). You are to develop a cargo loading model that prioritizes loading items based on value while accounting for cargo volume. In this analysis, the available cargo capacity is 150 m. Questions: Use the example table as a guide for the cargo loading plan. Note, the first two columns, value and Vol are provided in the cargo loading table. In the appendices of your executive summary, include the following: Table for cargo loading plan and value Screen shot of the Excel model 1 Table X. Cargo Loading Plan and Value Item Value ($ 1,000) Vol (m?) % Vol Loaded Vol (m3) Loaded Value ($ 1,000) Example 5 10 0.55 5.5 2.75 Example 2 10 20 1.00 20.0 10.00 Total 25.5 12.75 Table 3. Cargo Loading Data Item Value (in $1,000) Cargo Cubic Vol m^3 Express mail 3 40 Documents 5 10 Medicines 1 16 Amazon packages 1 44 Food 4 21 Electronics 2 22 Legos 2 19 Clothes 5 29 Toys 1 21 Cheetos 3 44

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!