Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Asian Import Company (AIC) has 600 cubic feet of excess cargo space on its ships and has decided to import two new items: jade

The Asian Import Company (AIC) has 600 cubic feet of excess cargo space on its ships and has decided to import two new items: jade figurines and linen placemats.

Each container of jade figurines is 4 cu. ft. and will net a profit of $80 per container. Each container of lien placemats is 2 cu. ft. and will realize a profit of $60 per container. AIC expects no more than 140 jade containers of jade figurines available on any trip.

Additionally, AIC wishes to use no more than 480 man hours for loading, storing, and processing the items through customs. The normal estimate is that a container requires 2 man-hours. However, because of special agricultural restrictions, an extra 2 man-hours can be expected for the linen products. Use the EXCEL output and determine the number of containers of jade figurines should be shipped.

Sensitivity Report

Adjustable Cells

Final

Reduced

Objective

Allowable

Allowable

Cell

Name

Value

Cost

Coefficient

Increase

Decrease

$C$4

J=Jade Figurines

120

0

80

40

50

$C$5

L=Linen Placemats

60

0

60

100

20

Constraints

Final

Shadow

Constraint

Allowable

Allowable

Cell

Name

Value

Price

R.H. Side

Increase

Decrease

$C$7

Cubic feet of Cargo Space

600

16.67

600

60

360

$C$8

Man-hour

480

6.67

480

720

120

$C$9

Jade Container

120

0

140

1E+30

20

$C$11

Non-negativity for Linen Placemats

60

0

0

60

1E+30

$C$10

Non-negativity for Jade Figurines

120

0

0

120

1E+30

Use the EXCEL output and determine the number of containers of jade figurines should be shipped.?

Use the EXCEL output and calculate the optimal value of the objective function. Keep 2 decimal places. Do not use $ sign.?

Use the EXCEL output to determine the value of an extra man-hour. Keep 2 decimal places. Do not use dollar sign.?

Use the EXCEL output to determine the value of an extra cubic foot of cargo space. Keep 2 decimal places. Do not use dollar sign.?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Financial Planning

Authors: Lawrence J. Gitman, Michael D. Joehnk

11th Edition

0324422865, 978-0324422863

More Books

Students also viewed these Finance questions

Question

When is the deadline?

Answered: 1 week ago

Question

7 Describe the role of an HR business partner

Answered: 1 week ago

Question

5 Explain the concept of the psychological contract.

Answered: 1 week ago