Logan Manufacturing is a cabinetry company that makes two differentfiling cabinets.We have cabinet modelXwhich costs$10 per cabinet,
Question:
Logan Manufacturing is a cabinetry company that makes two different filing cabinets. We have cabinet model X which costs $10 per cabinet, space required is 6 square feet and a file storage volume of 8 cubic feet of files. Cabinet model Y costs $20 per cabinet, space required is 8 square feet and a file storage volume of 12 cubic feet of files. You work for Space Design Inc. and your boss has given you a budget of $140 to purchase cabinets for your company. Given that your office has room for no more than 72 square feet of cabinets, you need to determine how many cabinets of each model to buy in order to maximize storage volume.
(Hint: The objective function is not cost/profit related)
Part(a): What are your decision variables? (1 point)
Part(b): Write out a mathematical expression for the objective function for storage volume. (1 point)
Part(c): Write out the mathematical expressions for the constraints. (1 point)
Part(d): Using excel solver, identify the solution that maximizes storage volume. (1 point)
Part (e): Do you have a bounded or unbounded feasible region of optimal solution? (1 point)
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw