Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Finance

Authors: Arthur Keown, John Martin, J. Petty

10th Edition

0136102654, 9780136102656

More Books

Students also viewed these Accounting questions

Question

What is quality function deployment?

Answered: 1 week ago

Question

List three factors that will increase the power of the test.

Answered: 1 week ago

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago

Question

Annoyance about a statement that has been made by somebody

Answered: 1 week ago