![]() ![]() Layout: (I marked in x's where I need to solve. Eve asked you to help her determine how many tables and chairs she should purchase in order to make the most profit. All you should do is to click the resolve button to re-calculate it. Enter Shipments for the Changing Variable Cells. On the worksheet, choose the latitude of cells holding the saved model and click on Load: in the Load mannequin dialog, click the substitute button: this can open the main Excel Solver window with the parameters of the in the past saved model. You have the choice of typing the range names or clicking on the cells in the spreadsheet. Eve cannot sell more than 40 chairs but the demand for tables is unlimited. The result should be consistent with the picture below. The maximum amount allocated for purchasing the tables and chairs for the sale is $280. You must order at least one chair and one table and, of course, they must be whole units. Each chair costs $4, retails for $9 and takes up one square foot of space. During the sale each folding table costs $5, retails for $11 and takes up two square feet of space. ![]() The store has only 75 square feet of space available to display and stock this merchandise. I was wondering if someone could guide me through on how to use the solver feature.Įve Blue is the manager of Southland Furniture store and she is planning a New Years Day sale. Hey, I am having problems with this excercise on my worksheet in my business computing class. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |