Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started