You are planning the production schedule for a small factory making simple stationary items. Storage space for
Fantastic news! We've Found the answer you've been seeking!
Question:
You are planning the production schedule for a small factory making simple stationary items. Storage space for items awaiting shipping is a problem, as space is limited.
Your task: Use Solver to decide how many of each item to make (Column C) so that all constraints are satisfied, and the storage space is completely full (20,000 items in total). Assume that all items are the same size.
Constraints:
- Pencils and Sharpeners are only sold in pairs, so we should have equal numbers of both.
- We require a minimum of 6,000 of Pencils in the warehouse after the production run to satisfy existing orders.
- We must not have more than 4,000 of Crayons after the production run, as we don’t usually sell more than this.
Hint: Be aware of any constraints which are not listed here, but are required for Solver to work.
Your task:
- An image for the Solver Parameters is shown below with the necessary four parts for completion (A, B, C, D). What values should we enter in the fields (A, B, C, D) as highlighted in the figure below?
- For your answer, you must write the details of what you would enter into these four parts of the Solver window. You must ensure that you make clear what data goes into what part of the Solver Parameter window (for example “A contains $B$4” or “D contains $A$6 >=5” etc.).
Related Book For
Auditing a business risk appraoch
ISBN: 978-0324375589
6th Edition
Authors: larry e. rittenberg, bradley j. schwieger, karla m. johnston
Posted Date: