B. Use the table below to answer the following questions. b) Determine the minimum profit for Galaxy S3 so that it will attain a positive value in the optimal solution. c) Explain with reasons why reduce cost for galaxy3 is negative. d) If Francophone could raise their budget by GH¢1,500 per week or increase the weekly hours to 150, which should it choose? Advice. With reasons. Table 1: Solver OutputVariable cellsFinalReduced ObjectiveAllowable AllowableCellNameValue CostCoefficient IncreaseDecrease$B$9Galaxy S236001E+30290.91-$B$10Galaxy S3-3204003201E+30$B$11Galaxy S46300900600ConstraintsFinalShadowConstraint Allowable AllowableCellNameValue PriceR.H. SideIncreaseDecrease$F$4budget LHS 9000120001E+303000$F$5labour LHS1203012040120$F$6space LHS9.201E+3011$F$7mix LHS180107.5

Definition: Minimum profit is determined likewise to the exchanging benefit equation in ch6. Ch7…

Answered: Use the table below to answer the…

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Related questions

Question

B. Use the table below to answer the following questions.

b) Determine the minimum profit for Galaxy S3 so that it will attain a positive value in the
optimal solution. c) Explain with reasons why reduce cost for galaxy3 is negative.
d) If Francophone could raise their budget by GH¢1,500 per week or increase the weekly
hours to 150, which should it choose? Advice. With reasons.

Table 1: Solver Output
Variable cells
Final
Reduced Objective
Allowable Allowable
Cell
Name
Value Cost
Coefficient Increase
Decrease
$B$9
Galaxy S2
3
600
1E+30
290.91
-$B$10
Galaxy S3
-320
400
320
1E+30
$B$11
Galaxy S4
6
300
900
600
Constraints
Final
Shadow
Constraint Allowable Allowable
Cell
Name
Value Price
R.H. Side
Increase
Decrease
$F$4
budget LHS 9000
12000
1E+30
3000
$F$5
labour LHS
120
30
120
40
120
$F$6
space LHS
9.
20
1E+30
11
$F$7
mix LHS
180
10
7.5

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.

Similar questions