You are an Independent IT Adviser providing expert advice to individuals on request. A client of a small newspaper, Daily News, produces two editions, morning and evening, and must publish at least 100 total copies for each day’s delivery. The morning edition requires 1hourof preparation and sells for20 pence. The evening edition requires 2.5 hours of preparation and sells for 30 pence. The client’s objective is to maximise his total revenue of publishing, given that he has 200 preparation hours available each day and at least 40 copies of the evening edition must be printed each day.

Questions

You should answer the following questions and incorporate your answers into a word-processed report. The sections of your report should correspond to the individual questions below.

Formulate the client’s problem as a linear programming model, clearly defining the variables, the objective function and the constraints.

Solve the problem graphically by hand (use graph paper).

Solve the problem using the Excel Solver and interpret the results.

Find the value of the slack-variable relating to the hours available and discuss its economic interpretation.

Find the shadow price of hours available and discuss its economic interpretation.

Problem 2

A company manufactures a product. The total cost function is given by TC= 400 +10q and the total revenue function is given by TR= (60 - q) q, where q is the quantity sold.

Questions

You should answer the following questions and incorporate your answers into a word-processed report. The sections of your report should correspond to the individual questions below.

Plot on the same axes the revenue function and the total cost function and shade the region where profits are made.

Using the graph or otherwise, obtain the output levels where total revenue equals total costs. State these breakeven costs and revenues.

Calculate the profit-maximising level of output and the profit at this output level.

Good presentation of the documentation

Kĩ năng: Excel, Viết báo cáo

Về Bên Thuê:
( 0 nhận xét ) United Kingdom

ID dự án: #4542058

## 14 freelancer đang chào giá trung bình £183 cho công việc này

oFAZo

I have considerable amount of experience with LP and Excel Solver, with few projects at my workplace. I also am an expert with Excel. I can complete this within 2 days guaranteed. Thanks!

£83 GBP trong 2 ngày
(11 Nhận xét)
3.7
LisaCornellBrown

Native English Speaker.

£145 GBP trong 5 ngày
(2 Nhận xét)
3.4
vickkey7

I am ready to start this project.. thanks

£200 GBP trong 2 ngày
(10 Nhận xét)
3.9
Xulfi1102

hire me n lets c...

£277 GBP trong 3 ngày
(0 Nhận xét)
0.0
smsnobin77

Dear Sir I can complete this [login to view URL] can test me.

£277 GBP trong 30 ngày
(0 Nhận xét)
0.0
iphoris

"Solve the problem graphically by hand (use graph paper)." <-- Is it part of our job?

£250 GBP trong 10 ngày
(1 Nhận xét)
0.0
shagor99

Hello By reading this job's description I hope I'll able to deliver this project to you. SO You can contact with me.

£277 GBP trong 30 ngày
(0 Nhận xét)
0.0
smshossain77

Hi I'm able to to finish this [login to view URL] can hire me.

£222 GBP trong 25 ngày
(0 Nhận xét)
0.0
alinastan03

I'm interested for this project. Thank you in advance.

£177 GBP trong 10 ngày
(1 Nhận xét)
0.0
ExcelRate

Check my private message.

£100 GBP trong 3 ngày
(0 Nhận xét)
0.0
hedonistu

Hello! Writing this kind of reports is my daily job.

£90 GBP trong 3 ngày
(0 Nhận xét)
0.0
tupuconstantin

Ready to start and can assure you that I can complete in time and with better quality according to your requirements. Thank you! Constantin

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
fengwan2008

this seems a college question link to linear programming. I am confident to finish them well

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0