Question: SOS PLEASE HELP ASAP 1. Open a blank Excel file. This should not be a file that you have previously used. When I check when

SOS PLEASE HELP ASAP

SOS PLEASE HELP ASAP 1. Open a blank Excel file.

1. Open a blank Excel file. This should not be a file that you have previously used. When I check when it was created, the timestamp and edit history, it should show that it was created during the exam time. 2. Solve the following problem to find the maximum profit by creating a spreadsheet and using Solver A shoe company is planning on making two new products: sandals and boots The unit profit for a pair of sandals is $25.00 and the unit profit for a pair of boots is $45.00. There are 2 factories available to make the products. Factory 1 cuts the material for each item and requires 3 minutes to make a pair of sandals and 4 minutes to make a pair of boots. It has 450 hours available. Factory 2 puts the pieces together to create the final product and requires 1 minute to make a pair of sandals and 4 minutes to make pair of boots. It has 500 hours available. Factory 1 needs at least 3 employees to produce sandals and 1 employee for boots. The total minimum employees required is 75. Factory 2 needs at least 2 employees to produce sandals and 3 employees for boots. The total minimum employees required is 45. There is strong competition in this industry. The company has decided to create a strong marketing campaign. It is estimated that achieving a production and sales rate of S (shoes) per week will require weekly marketing cost of S2. The corresponding marketing costs for boots are estimated to be 3B3. Thus, the objective function in the model should be: Profit = 255 + 45B-S2-3B3 3. Save your file as lastnameshoes (You must save your file to your computer's desktop rather than to the cloud. If your file begins with a "$", this means that it is a temporary file, and I will not be able to open it, which result in 0 points.) 4. Upload your completed Excel file

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!