View the step-by-step solution to:

Power Blocks Purchasing Plan Number Purchased Power Blocks Urban Adventure Set Turbo Action Kit Power Blocks Outdoor Set Camping Kit 1 1 1 0 Retail...

Need assistance with the excel spreadsheet assignment attached Power Blocks Purchasing Plan

Power Blocks Purchasing Plan Number Purchased Retail Price Gross Revenue Unit Cost Total Unit Cost Total Storage Cost Total Cost Profit Power Blocks Urban Adventure Set 1 \$18.95 \$15.26 \$0.15 Turbo Action Kit 1 \$15.95 \$14.20 \$0.10 Power Blocks Outdoor Set 1 \$15.95 \$13.50 \$0.25 Camping Kit 0 \$12.95 \$10.05 \$0.15 Total Constraints Microsoft Excel 11.0 Answer Report Worksheet: [Power Blocks.xls]Purchase Plan Target Cell (Max) Cell Name Original Value Final Value \$J\$8 28,725.00 \$19,877.00 Adjustable Cells Cell Name Original Value Final Value \$B\$4 Power Blocks Urban Adventure Set Number Purchased 5000 2200 \$B\$5 Turbo Action Kit Number Purchased 0 1100 \$B\$6 Power Blocks Outdoor Set Number Purchased 5000 2200 \$B\$7 Camping Kit Number Purchased 0 1973 Constraints Cell Name Cell Value Formula Status Slack \$I\$8 Total Total Cost \$99,998.35 \$I\$8<=\$C\$11 Not Binding 1.65 \$B\$4 Power Blocks Urban Adventure Set Number PPower Blocks Urban Adventure Set Number Purchased 2200 \$B\$4=integer Binding 0 \$B\$5 1100 \$B\$5=integer Binding 0 \$B\$6 \$B\$6 Power Blocks Outdoor Set Number Purchased 2200 \$B\$6=integer Binding 0 \$B\$7 \$B\$7 Camping Kit Number Purchased 1973 \$B\$7=integer Binding 0 \$B\$4 \$B\$4 Power Blocks Urban Adventure Set Number 2200 \$B\$4>=\$C\$12 Binding 0 \$B\$6 \$B\$6 Power Blocks Outdoor Set Number Purchased 2200 \$B\$6>=\$C\$13 Binding 0 \$B\$5 \$B\$5 Turbo Action Kit Number Purchased 1100 \$B\$5>=\$C\$14 Binding 0 \$B\$5 \$B\$5 Turbo Action Kit Number Purchased 1100 \$B\$5>=\$C\$16 Not Binding 1100 \$B\$7 \$B\$7 Camping Kit Number Purchased 1973 \$B\$7>=\$C\$17 Not Binding 1973 \$B\$7 \$B\$7 Camping Kit Number Purchased 1973 \$B\$7>=\$C\$15 Not Binding 873 Storage Cost per Unit

Dear Student, I have reviewed your assignment thoroughly, based on your assignment details and current... View the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
• -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents