Đã Đóng

Spreadsheet

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.

For the final part of your report, in your capacity as an IT Adviser, you should present a memorandum to your client. Describe your main conclusions in simple, non-technical English; i.e. do not use technical terms like variable, objective function or dual price. Don’t worry about repeating some or all of the points that you have already made in answer to earlier questions. The aim is to communicate your conclusions clearly to someone who knows nothing about the subject of linear programming. You may use tables and charts if you wish.

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

Xem thêm: writing conclusions, writing objective, writing news report, writing memorandum, technical writing advice, tc results, tc programming, state newspaper, solver excel expert, shadow writing, shadow price linear programming, report writing non profits, programming excel 2013, problem graph, part graph, objective function linear programming, non linear programming, newspaper writing, newspaper report writing, newspaper delivery, model report writing, main points report writing, linear programming word problem, linear programming solver excel, linear programming problem

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 work.You 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 job.You 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
askoranalyst2

I am an operations research analyst working on linear programming, mip and large scale optimization projects using CPLEX, Excel Solver etc. from last three years. Will provide a POC and show the work i have done earlie Thêm

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