Question: Show excel formulas please Problem 1: (100 points) Hardgrave can manufacture four different products (A, B, C, D) in any combination. Each product requires time

Show excel formulas please

Show excel formulas please Problem 1: (100

Problem 1: (100 points) Hardgrave can manufacture four different products (A, B, C, D) in any combination. Each product requires time on each of four machines in minutes per pound of products, as shown in the Table 1: Table 1 PRODUCT B C MACHINE . D 3 4 4 tel:1%205344%202%2010652%203%206431%204 1 2 3 4- MAXIMUM DEMAND 5 10 6 3 400 4 8 100 3 3 150 1 2 500 Each machine is available 40 hours per week. Products A, B, C, and D may be sold at prices of $9, $7, $6, and $5 per pound respectively. Material cost for each pound of product A is $4 and for each pound of products B, C, and D is $1. Given the maximum demand in the above table, formulate and solve a spreadsheet model to find the optimal production amount for each of the four products to maximize profit for Hardgrave

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!