I need someone that knows solver for excel with parameters

Someone please contact me

 

For this assignment, please complete problem number 8, in the shared document provided.

Use Excel “Solver” to set up and answer all three parts. Save all parts in three separate worksheets (e.g., part a, part b and part c) in a single spreadsheet file.

 

Solver must be used, and please check the video on the shared document as well.

  

 Also a reminder that I need this in 24 hours.

  

https://docs.google.com/document/d/1nasAa_EVhnCdLS8F1fvCWLqtOFjcraXVvUwFGILfCPM/edit?usp=drive_web

  

I have also included an example as well.

Part a

00

0

5,000 5,000 5,000 5,000 5,000 5,000

,600

0

200

-600 0 0 0

1,000

600 0 0

1,000 1,200 600 0 0 0

0

300 0 0

0 0 0 0 0 0 0

Regular 10 10 10 10 10 10

00

Overtime

16 16 16 16 16

Inventry 1 1 1 1 1 1 2800
Total

																										Problem 8(Part a)
		Month			May			Jun			July			August			September			October						Total
		Forecast	4,																																																		0			4,800	5,		600	7,								20		6,		400																					5,000			33,000
		Output
					Regular			30,000
					Overtime																			1	1,400		300
		Output- forcast						1,000		-600
					Inventry
Begning		1,200
		Ending
		Average									500	1																								10	900		2800
	Backlog
		Cost
		3000
																	16		48000
350800

Part b

Month May Jun July August September October Total
Forecast

4,800

5,000 33,000
Output
Regular 5,000 5,000 5,000 5,000 5,000 5,000 30,000

Overtime 500 500 500 500 500 0

0 0 0 0 500 0 500

Output- forcast

0 0

Inventry

1,500

400 0

Ending 1,500 2,200 2,100 400 0 0
Average

200 0

Backlog 0 0 0 0 0 0 0
Cost
Regular 10 10 10 10 10 10

Overtime 16 16 16 16 16 16

20 20 20 20 20 20

Inventry 1 1 1 1 1 1 6200

0 0 0 0 0 0 0

Total

Problem 8 (Part b)
	4,000		5,600		7,200	6,400
2500
Suncontract
		1,500	700	-100	-1,700	-400
	Beginning		2,200				2,100
				750	1850	2	150	1250		6200
	300000
40000
Subcontract	10000
	Back Orders
356200

Part c

Month May Jun July August September October Total
Forecast 4,000 4,800 5,600 7,200 6,400 5,000 33,000
Output
Regular 5,000 5,000 5,000 5,000 5,000 5,000 30,000

Overtime 750 750 750 750 0 3000
Output- forcast 1,000

150

0 0

Inventry

Beginning 1,000

2,100 950 0

Ending 1,000 1,950 2,100 950 0 0
Average 500

0

Cost
Regular 10 10 10 10 10 10 300000
Overtime 16 16 16 16 16 16 48000

Inventry 1 1 1 1 1 1 5700
Back Orders 10 10 10 10 10 10 300000
Total

Problem 8 (Part c)
		950	-1,450	-650
	1,950
1475	2025	1375	325		5700
653700

Sheet1

2

>

Toledo

0

209.9999999998

2

0 0 140 140

Toledo 0

0 160 160

220 220 220

A B C
1

$ 10.00

2

3

$ 11.00 $ 12.00

Toledo

																																																			Optimal Shipping Strategy
			A				B				C		Shipped		Supply
			1												0		209.9999999998				2	10
			140
			3	79.9999999994	60	10.0000000003	149.9999999997		150
			160
	Received		219.9999999994								220	220.0000000001
	Demand
	Shipping Cost Per Unit
			$ 10.00		$ 14.00
			$ 12.00			$ 17.00		$ 20.00
			$ 11.00
$ 18.00	$ 8.00		$ 13.00
	Minimal Cost:	$ 6,720.00
	Note: Since total supply = total demand
	all supply and demand constraints
	have the equality sign.

This is the area reserved for the decision variables.

Demand Constraints

Supply Constraints

Don’t forget to click on the “Assume Linear Model” and “Assume Non-Negative” check boxes from

If you are using Excel 2010, please note the minor changes as shown below.

Cincinnati

Optimal Shipping Strategy
A B C Shipped Supply

1 0 0 210 210 210
2

0

140

3 0

0 149.9999999994 150

Cincinnati

0 10

160

Received 219.9999999994

220

Demand 220 220 220
Shipping Cost Per Unit
A B C
1 $ 10.00 $ 14.00 $ 10.00
2 $ 12.00 $ 17.00 $ 20.00
3 $ 11.00 $ 11.00 $ 12.00

Cincinnati

$ 17.00 $ 13.00

Minimal Cost:

Note: Since total supply = total demand
all supply and demand constraints
have the equality sign.

70.0000000003	69.9999999995	139.9999999997
	149.9999999994
149.9999999992	159.9999999991
219.9999999989
$ 7.00
$ 6,960.00

This is the area reserved for the decision variables.
Demand Constraints
Supply Constraints
Don’t forget to click on the “Assume Linear Model” and “Assume Non-Negative” check boxes from

If you are using Excekl 2010, please note the minor changes as shown below.

Sheet2

Sheet3