Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I solve this on EXCEL? The production editor of Rayburn Publishing Company has 1800 page count of manuscript that must be copy-edited. Because

How do I solve this on EXCEL?

The production editor of Rayburn Publishing Company has 1800 page count of manuscript that must be copy-edited. Because of the short time frame involved, only two copyeditors are available: Erhan Mergen and Sue Smith. Erhan has 10 days available, and Sue has 12 days available. Erhan can process 100 page count of manuscript per day and Sue can process 150 page count of manuscript per day. Rayburn Publishing has developed an index used to measure the overall quality of a copyeditor on a scale from 1 (worst) to 10 (best). Erhan's quality rating is 9, and Sue's quality rating is 6. In addition, Erhan charges $3 per page and Sue charges $2 per page. A budget of $4800 has been allocated for copyediting.

Formulate a mathematical model that can be used to determine how many pages should be assigned to each copy editor to complete the project with the highest possible quality.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Processes and Supply Chains

Authors: Lee J. Krajewski, Larry P. Ritzman, Manoj K. Malhotra

10th edition

978-013280747, 132807394, 9780132951814, 132807475, 132951819, 978-0132807395

More Books

Students also viewed these General Management questions

Question

What are three disadvantages of using the direct write-off method?

Answered: 1 week ago