Back Savers is a company that produces backpacks primarily for students. They are considering offering some combination

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Back Savers is a company that produces backpacks primarily for students. They are considering offering some combination

Post by answerhappygod »

Back Savers is a company that produces backpacks primarily for
students. They are considering offering some combination of two
different models—the Collegiate and the Mini. Both are made out of
the same rip-resistant nylon fabric. Back Savers has a long-term
contract with a supplier of the nylon and receives a
5,000-square-foot shipment of the material each week. Each
Collegiate requires 3 square feet while each Mini requires 2 square
feet.
Each Collegiate requires 45 minutes of labor to produce and
generates a unit profit of $32. Each Mini requires 40 minutes of
labor and generates a unit profit of $24. Back Savers has 35
laborers that each provides 40 hours of labor per week.
What is the total maximized profit?
Please solve using the Solver function in Excel. Anything
not in excel will receive a thumbs down. Thank you!
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply