Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Using excel solver to maximize profits

05/05/2021 Client: muhammad11 Deadline: 2 Day

BUS 310 Homework 9 and 10 Please download the Homework 9 and 10 Excel file. This file contains all the data required to complete the assignment. Please follow the optimization steps developed in class as well as discussed in the textbook. Complete the problems as indicated in this document. Please set up your model format as seen in class, by using the required model templated located on Blackboard. Problem 1: Use MS Excel and the Solver add-in to solve this problem. Karen’s Konfectionary makes many types of candy bars, however the company’s highest revenue producing bars are Chocolate Crunch and Berry Bars. Chocolate Crunch has a net profit of $0.13 per bar and Berry Bars has a net profit of $0.15 per bar. Marketing says that during the holiday month of December, no more than 1000 Chocolate Crunch bars must be produced and no more than 1200 Berry Bars must be produced. The company has a December supply of 8,000 oz. of chocolate. A Chocolate Crunch requires 3.5 oz. of chocolate for each bar and Berry Bars requires 6 oz. of chocolate for each bar. How many of each candy bars need to be produced? Problem 2: Use MS Excel and the Solver add-in to solve this problem. Steve’s Sporting Goods Supply manufactures numerous popular sporting good products. Marketing has indicated, that during the holiday season, baseballs and software balls are the most popular sellers. The company would like to make as many baseballs and softballs subject to the manufacturing constraints of labor hours, machine time. The company has a limited supply of cork, leather, and nylon; the ball components. The company has 3600 hours of labor, and 2000 minutes of machine time. Each ball type takes 1 minute of machine time. Softballs required 3 hours of labor and baseballs required 2 minutes of labor. The company has 6000 units of leather, 5000 units of nylon, and 5000 units of cork. Each softball requires 6 units of leather, 8 units of nylon, and 10 units of cork. Baseballs require requires 4 units of leather, 3 units of nylon, and 2 units of cork. Software make a net profit per unit of $20 and baseballs make a net profit per unit of $10. How of each ball should the company make? Problem 3: Use MS Excel and the Solver add-in to solve this problem. Mike’s Mazda is a large automotive dealer in Fairfax, Virginia. The dealership sells many Mazda models; however, the Mid-Size SUV and the Compact-Size SUV are the most profitable for Mike’s Mazda. The Mid-Size has a net profit of $480 and the Compact-Size has a net profit of $420. Ford Mazda sets very strict monthly sales quotas on dealerships. Mike’s Mazda is required to sale at least 10 of each model. Mike’s Mazda can sell no more than 50 Mid-Sized and 60 Compact-Size models. The Mid-Size takes out 8 square feet of inventory space and the CompactSize requires 7 square feet. The company has 720 square feet to allocate to these two models. To maximize profit how many of model should the dealership sell? Problem 4: Use MS Excel and the Solver add-in to solve this problem. FredX must deliver many packages during the month of December. The company delivers to three distinct regions, Region I, Region II, and Region III. The cost to deliver a package to Region I is $0.1, to Region II is $0.12, and to Region III is $0.15. The company has a required delivery capacity of 15,000 packages for December. FredX can deliver between 1,000 and 4,000 packages to Region I. FredX can deliver between 2,000 and 8,000 packages to Region II. FredX can delivery between 3,000 and 12,000 packages to Region III.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Guru
George M.
Math Specialist
Engineering Mentor
Quality Assignments
Homework Guru
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

I have read and understood all your initial requirements, and I am very professional in this task.

$40 Chat With Writer
George M.

ONLINE

George M.

I have read your project details. I can do this within your deadline.

$36 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$49 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

Give me a chance, i will do this with my best efforts

$36 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

I will cover all the points which you have mentioned in your project details.

$48 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I will cover all the points which you have mentioned in your project details.

$28 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Silica gel packets officeworks - Carbide ion lewis structure - The other wes moore discussion questions answers - Expert key management pk - An outward shift of the production possibilities frontier represents - The boy in the striped pajamas chapter 8 - There will come soft rains answer key - Westpac capital notes 8 - Iso 13849 performance levels - Telstra mobile accelerate casual plan $30 - How to work consistently - Budj bim cultural landscape map - BUS 660 WEEK 1 DISCUSIONS 1 &2 - 1200 employees of a company were surveyed - Security systems ultimately depend on the behavior of its - Bluebeam insert page numbers - Maths made easy biology gcse - Tina jones mental health assessment - 13.2 sine and cosine ratios evaluate homework and practice - The zero exponent rule - Company case 5 goldieblox swimming upstream against consumer perceptions - 5 step bowling approach - Lam vam ram yam linga bhairavi - 4 essays ×2 1200 ×2 1000 words - Binocular esterman visual field - Simmons case study - Vcaa 2020 chemistry exam - Going after cacciato character analysis - How to critique a presentation - History essay - Visual spatial skills occupational therapy - Vision learning com library module - Discussion board - Dependency diagram database example - No knock warrant pros and cons - Week 4 6640 - First year of College Seminar - Servant leadership and followership similarities army - OPERATIONS MANAGENENT 5 ASSIGNMENTS - In 1 peter believers are identified as - HQ LANAn IP address plan for the HQ LAN - Metallica never cared for what they do - Discussion part 6 - Themis university of melbourne - Oj simpson crime scene photos - Renew jib ecs card - If poem by rudyard kipling analysis - The house of the scorpion chapter summary - Eleanor dunn scholarship in engineering - Essay for English - Ibm v3700 storage configuration guide - Ehr implementation gantt chart - Lord wensleydale golden rule - El tomate se introdujo a europa como planta ornamental. cierto falso - Business driven technology 5th edition mcgraw hill - The following transactions took place for smart solutions inc - 50 ml of water and 50 ml of alcohol - Hyperbolic functions identities proofs - Nhtv breda university of applied sciences - If you were to be sent to the moon, which of your physical properties would be altered noticeably? - Calculate equivalent annual cost - Killings andre dubus pdf - Pro engineer wildfire 5.0 windows 10 - The prentice hall reader 12th edition pdf free - Legal and ethical responsibilities of a medical assistant - 3 spheres of project management - Research Paper - Zappos differentiation strategy - Whats wrong with rfk jr voice - Team powers xps pro v2 - Irresponsible pursuit of paradise 2nd - Current Event Article Critique - Loctite products list pdf - Weekly Post #2 - Why is allusion effective - Security policies and implementation issues 2nd edition - How to write a rational - Tall ship productions pasadena - Afi strategy framework - How to calculate minimum unit price - Discussion about investors measure the risk of individual common stocks - Ka and base strength - Nightfall the ordeal torch in the night destiny 2 - Discussion - Caravan storage brierley hill - Ceiling joists span table - Discussion / Read Chapter 5 and 12 / Answer and Comment / need it within 8 hours - Islamic environmental ethics law and society - Rear window essay prompts - Spirogyra mode of locomotion - Preliminary physics moving aboutpreliminary physics moving aboutpreliminary physics moving aboutpreliminary physics moving about - Thomastown recreation & aquatic centre - Human resources esl activities - Fragmentation of benzyl alcohol - Pschology paper - Stonefields reserve cabernet sauvignon 2017 - History ask questions get answers - Teams - Resume Assigment - Alka seltzer tablet in water chemical reaction