Answered step by step
Verified Expert Solution
Question
1 Approved Answer
6. Create a constraints list in the worksheet that identifies the constraints in this problem. 7. Format all monetary fields as Accounting with two decimal
6. Create a constraints list in the worksheet that identifies the constraints in this problem. 7. Format all monetary fields as Accounting with two decimal places. 8. Use Solver to determine the best way to purchase the Mighty Toys sets and kits and maximize the profit. 9. Produce an answer report of your final solution. Use the answer report to recommend additional changes that might maximize the total profit. Place your recommendations in a cell on the answer report worksheet.Number Gross Storage Cost Purchased Retail Price Revenue Unit Cost Total Unit Cost per Unit Total Storage Cost Total Cost Profit Blue Raider Urban Adventure Set 3644 $ 19.95 $ 72,697.80 15.36 $ 55,971.84 $ 0. 15 $ 546.60 $ 56,518.44 $ 16,179.36 Super Action Kit 250 $ 14.95 $ 3,737.50 14.21 $ 3,552.50 $ 0.10 $ 25.00 $ 3,577.50 $ 160.00 Blue Raider Outdoor Set 1822 $ 16.95 $ 30,882.90 13.77 $ 25,088.94 $ 0.25 $ 455.50 |$ 25,544.44 $ 5,338.46 Hiking Kit 1534 $ 11.95 $ 18,331.30 10.03 $ 15,386.02 $ 0.15 $ 230.10 $ 15,616.12 $ 2,715.18 7250 Total $ 101,256.50 $ 24,393.00 Constraints: Total Cost (18) Blue Raider Urban Adventure Set (B4) Super Action Kit (B5) Blue Raider Outdoor Set (B6) Hiking Kit (B7) Number Purchased (B4:B7) Total Number Purchased Super Action Kit (B5) Hiking Kit (B7) Blue Raider Outdoor Set (B6)
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