Develop a network representation of the problem

Assignment Help Business Management

Reference no: EM131803844

Quality Consulting has two consultants, Alfred and Barbara that can be scheduled to work for clients up to a maximum of 170 hours each over the next four weeks.

A third consultant, Charlie, has some administrative assignments already planned and is available for clients up to a maximum of 150 hours over the next four weeks.

The company has four clients with projects in process. The estimated hourly requirements for each of the clients over the four- week period are:

Client	Hours
A	180
B	75
C	100
D	85

Hourly rates vary for the consultant-client combination and are based on several factors, including project type and the consultant's experience. The rates (dollars per hour) for each consultant-client combination are as follows:

	Client
Consultant	A	B	C	D
Alfred	100	125	115	100
Barbara	120	135	115	120
Charlie	155	150	140	130

1) Develop a network representation of the problem. You may reference the Network Diagram Template .

2) Formulate the problem as a linear program, with the optimal solution providing the hours each consultant should be scheduled for each client to maximize the consulting firm's billings. What is the schedule and what is the total billing?

Would like to see each step using formula to this problem on excel setup.

Reference no: EM131803844

Questions Cloud

Describe the seven types of business goods and services : Describe the seven types of business goods and services. Major equipment includes capital goods, such as heavy machinery.

Draw diagrams of the john and sally systems : Draw diagrams of the John’s and Sally’ systems. Who has the higher overall probability (reliability) of getting the homework done?

Discuss the unique aspects of business buying behavior : Discuss the unique aspects of business buying behavior. Business buying behavior is distinguished by five fundamental characteristics.

Prepare a job order cost sheet : Prepare a job order cost sheet showing the estimate given to the customer. Use the format shown on the next page

Develop a network representation of the problem : Hourly rates vary for the consultant-client combination and are based on several factors, including project type and the consultant's experience.

Review problem of the Cameron Stock : Cameron Stock, purchasing manager for a sports equipment manufacturer, is responsible for buying $5 million of supplies every year.

Differences between the terms diversity-global diversity : Compare and contrast the differences between the terms “diversity” and “global diversity,”

Calculating the preferred stock valuation : You are considering an investment in one of two preferred? stocks, TCF Capital or TAYC Capital Trust. TCF Capital pays an annual dividend.

What are some practices where computerized findings enhance : What are some practices where computerized findings enhance workflow processes? Your response should be at least 75 words in length.

User Account

All Pages