Attachment from text

From the attached document, 1. Draw an E-R Diagram 2. State any assumptions that you made. Thank you.

Pert Chart

I got confused on the PERT chart. Please help draw what the pert chart will look like. Thanks

Product Mix Model

Instruction: - Review the attached document. Problem: - Recreate the spreadsheet shown in the attached document. - Change the X2 lower constraint value (cell F12) from 200 units to 100 units. - Use the Excel add-in Solver to determine the optimal production of products to maximize total profit. - Return the spreadsheet showing the optimal solution.

Product Mix Model II

Instruction: - Review the attached document. - Recreate the spreadsheet shown in the attached document. - Marketing now believes that demand for the CC-7 model (X1 decision variable) will not exceed 200 units per month. Problem: - Add a new constraint to the model to restrict production of that product to a maximum of 200 units per month. - Use the Excel add-in Solver to determine the optimal production of products to maximize total profit. - Return the spreadsheet showing the optimal solution.

Product Mix Model III

Introduction: A canning company is about to receive 60,000 pounds of ripe tomatoes from which it can produce canned tomato juice or tomato paste. Each case of tomato juice requires 24 pounds of tomatoes to produce whereas each case of tomato paste only requires 8 pounds of tomatoes. At most, the company can sell a maximum of 2,000 cases of tomato juice. At most, the company can sell a maximum of 6,000 cases of tomato paste. The company can sell a case of juice for $18 and a case of paste for $9. Instruction: - Review the attached document. Problem: - Create a spreadsheet in Excel to represent this situation and then use the Excel add-in Solver to determine the optimal numb... click for more