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

Mã Dự Án: #4542058

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

Alcatraz87

Hi, I can help you with this. Please check out my profile and previous reviews. Also, please verify your payment method in order to increase the confidence. Thanks.

£100 GBP trong 3 ngày
(10 Đánh Giá)
4.0
vickkey7

I am ready to start this project.. thanks

£200 GBP trong 2 ngày
(9 Đánh Giá)
3.4
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
(10 Đánh Giá)
3.2
LisaCornellBrown

Native English Speaker.

£145 GBP trong 5 ngày
(2 Đánh Giá)
3.0
Xulfi1102

hire me n lets c...

£277 GBP trong 3 ngày
(0 Đánh Giá)
0.0
smsnobin77

Dear Sir I can complete this [url removed, login to view] can test me.

£277 GBP trong 30 ngày
(0 Đánh Giá)
0.0
iphoris

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

£250 GBP trong 10 ngày
(0 Đánh Giá)
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 Giá)
0.0
smshossain77

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

£222 GBP trong 25 ngày
(0 Đánh Giá)
0.0
alinastan03

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

£177 GBP trong 10 ngày
(0 Đánh Giá)
0.0
ExcelRate

Check my private message.

£100 GBP trong 3 ngày
(0 Đánh Giá)
0.0
hedonistu

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

£90 GBP trong 3 ngày
(0 Đánh Giá)
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 Giá)
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 Giá)
0.0