Thjis question is for [email protected]

Sensitivity Report 1

Adjustable Cells
			Final	Reduced	Objective	Allowable	Allowable
	Cell	Name	Value	Cost	Coefficient	Increase	Decrease
	$B$12	Pizza=	1250	0	0.75	1	1.00
	$B$13	Hot Dogs=	1250	0	1.05	1E+30	0.27
	$B$14	Barbecue=	0	-0	1.35	0.3750000114	1E+30
Constraints
			Final	Shadow	Constraint	Allowable	Allowable
	Cell	Name	Value	Price	R.H. Side	Increase	Decrease
	$G$9	Demand Usage	1,250.00	- 0	0	1250	1E+30
	$G$7	Oven space (sq. in.) Usage	50,000.00	- 0	55296	1E+30	5296
	$G$6	Budget ($) Usage	1,500.00	1.50	1500	158.8800000001	1500.0000000009
	$G$8	Demand Usage	- 0	(0.38)	0	2000.0000000012	3333.33

Sheet1

Case 3 - Julia's Food Booth
Food items:		Pizza	Hot Dogs	Barbecue
Profit per item:		0.75	1.05	1.35
Constraints:					Available	Usage	Left over
Budget ($)		0.75	0.45	0.90	1,500	1,500.00	0
Oven space (sq. in.)		24	16	25	55,296	50,000.00	5296
Demand		1	-1	-1	0	- 0	0
Demand		0	1	-2	0	1,250.00	-1250
Stock
Pizza=	1250	slices
Hot Dogs=	1250	hot dogs
Barbecue=	0	sandwiches
Profit=	2,250.00

Sheet2

Sheet3

Sheet4

Sheet5

Sheet6

Sheet7

Sheet8

Sheet9

Sheet10

Sheet11

Sheet12

Sheet13

Sheet14

Sheet15

Sheet16

1

2

3

4

5

6

7

8

9

10

11

A

B

C

D

Case 3 - Julia's Food Booth

Food items:

Pizza

Hot Dogs

Profit per item:

0.75

1.05

Constraints:

0.75

0.45

24

16

1

-1

0

1

Stock

Budget ($)

Oven space (sq. in.)

Demand

Demand