2021 Homework Assignment PDF

Preview

Summary

homework assignmnet Answer Sheet for Association...

Description

CB2011 Solving Business Problems with Spreadsheet Modeling Homework Assignment (10% weight) Question 1 One gram of food X, which costs $7, gives 8mg of Vitamin A, 10mg of Vitamin B and 9 mg of cholesterol. One gram of food Y, which costs $9, gives 12mg of Vitamin A, 6mg of Vitamin B and 10mg of cholesterol. An adult needs at least 32mg of Vitamin A, 22mg of Vitamin B and not more than 50mg of cholesterol every day. The problem is to determine the amount of X and Y to be taken each day in order to minimize total cost. We are given the following linear program:

Minimize

7X + 9Y (total cost)

Subject to

8X + 12Y >= 32 (Vitamin A) 10X + 6Y >= 22 (Vitamin B) 9X + 10Y...