Question: Problem 2 : Complete on excel. A small retail store, The Nifty Nook, is planning a limited - time showcase. Due to space constraints (

Problem 2:
Complete on excel.
A small retail store, "The Nifty Nook," is planning a limited-time showcase. Due to space constraints (20 pounds) and a $700 budget, they must carefully select products to maximize profit. The table below lists each product's weight, cost, and potential profit.
Product Name Weight [lb] Cost [$] Profit Cozy Knit Blanket 250100 Vintage Vinyl Record Player 375150 Sleek Smartwatch 14080 Retro Gaming Console 4100200 Stylish Tote Bag 260120 Gourmet Coffee Maker 390180 Portable Bluetooth Speaker 255110 High-End Camera Lens 5125250 Essential Oil Diffuser 13570 Modern Desk Lamp 4110220 Handmade Ceramic Mug 380160 Eco-Friendly Reusable 24590 Bottle 6150300 Luxurious Throw Pillow 495190 Solar-Powered Light 252.5105 Minimalist Jewelry Organizer
Determine the optimal product selection for the showcase that maximizes profit while adhering to the weight and budget limitations.
What is the optimal combination of products for the showcase? What is the total weight of the selected products? What is the total cost of the selected products?
What is the total profit from the showcase?
 Problem 2: Complete on excel. A small retail store, "The Nifty

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!