unit 5,6.docx - BUSINESS DECISION ANALYSIS BUSI 2013 \u2013 ASSIGNMENT FOR UNITS 6&7 SPRING 2020 STUDENT ID UNIT NUMBER DATE OF EXAMINATION UNIT D D M M Y

unit 5,6.docx - BUSINESS DECISION ANALYSIS BUSI 2013 u2013...

• 12
• 100% (2) 2 out of 2 people found this document helpful

This preview shows page 1 - 5 out of 12 pages.

BUSINESS DECISION ANALYSIS BUSI 2013 – ASSIGNMENT FOR UNITS # 6 &7 SPRING - 2020 STUDENT ID UNIT NUMBER UNIT 6 & 7 DATE OF EXAMINATION D D M M Y Y Name (in Full) ______________________________________________________________ You may NOT use a dictionary or internet source. INSTRUCTIONS: 1. Solve all the questions using MS WORD. 2. Make use to use Math equation Editor where applicable 3. Submit completed assignment through Moodle. No email submissions allowed 4. Make sure to submit on time. No late submissions allowed
Evaluation Sheet for Professor Use Only PART 1 (Individual Problem 5) 56 POINTS Question 1 TOTAL Marks 16 Your Score Question 2 20 Marks Your Score Question 3 20 Marks Your Score PART 2 (Individual Problem 6 56 Points Question 1 Marks 16 Your Score Question 2 20 Marks Your Score Question 3 20 Marks Your Score Total
PART 1 Total Value: 56 points Instructions These problems focus on finding solutions to numerical problems. With that in mind, most problem sets will include a number of problems. For each problem, you will need to provide more than a simple numerical response. Your solutions should thoroughly address the issue and present your findings in a meaningful format, similar to those developed within the chapters and as part of the review exercises solutions. Any Excel spreadsheet models developed to solve the problems should be included with your submission. Part value may be assigned for incorrect responses. Question 1: The NEC Company produces two cheese spreads by blending mild cheddar cheese with extra sharp cheddar cheese. The cheese spreads are packaged in 12-ounce containers, which are then sold to distributors throughout the Northeast. The Regular blend contains 80% mild cheddar and 20% extra sharp, and the Zesty blend contains 60% mild cheddar and 40% extra sharp. This year,a local dairy cooperative offered to provide up to 8100 pounds of mild cheddar cheese for \$1.20 per pound and up to 3000 pounds of extra sharp cheddar cheese for \$1.40 per pound. The cost to blend and package the cheese spreads, excluding the cost of the cheese, is \$0.20 per container. If each container of Regular is sold for \$1.95 and each container of Zesty is sold for \$2.20, how many containers of Regular and Zesty should NEC produce?