Using solver: Please list out what my steps in excel would be Many young people moving into apartments and new homes look forward to the excitement of furniture shopping. These young shoppers are usually interested in cheaper, build-yourself furniture, however, many of them are not too handy and the excitement quickly dissipates as they start putting their furniture together. The instructions, even if they are in English, are difficult to understand and the consumer soon realizes that the savings may not be worth the hassle. Built-4-U is an online furniture company that caters to those customers. Built-4-U buys build yourself furniture directly from manufacturers at a discount price, assembles each piece at their warehouse, and then ships directly to their customers. Each customer can order their furniture online without ever having to leave their home or search for the right tool to assemble. Joe Builder, the owner and CEO of Built-4-U, plans to establish their beginning inventory by investing a maximum of $35,000 on 25 popular items. The website for Built-4-U is scheduled to go live shortly and all 4 inventory clerks were advised they might have to work five, 10 hour days prior to the grand opening to assemble this startup inventory. Joe believes he should order no less than 5 and no more than 20 units of each item. In addition, the manufacturer has a minimum truck order of 6,000 pounds. Given the following information, help Joe decide how many units of each item to order.
Using solver:
Please list out what my steps in excel would be
Many young people moving into apartments and new homes look forward to the excitement of furniture shopping. These young shoppers are usually interested in cheaper, build-yourself furniture, however, many of them are not too handy and the excitement quickly dissipates as they start putting their furniture together. The instructions, even if they are in English, are difficult to understand and the consumer soon realizes that the savings may not be worth the hassle. Built-4-U is an online furniture company that caters to those customers. Built-4-U buys build yourself furniture directly from manufacturers at a discount price, assembles each piece at their warehouse, and then ships directly to their customers.
Each customer can order their furniture online without ever having to leave their home or search for the right tool to assemble. Joe Builder, the owner and CEO of Built-4-U, plans to establish their beginning inventory by investing a maximum of $35,000 on 25 popular items. The website for Built-4-U is scheduled to go live shortly and all 4 inventory clerks were advised they might have to work five, 10 hour days prior to the grand opening to assemble this startup inventory. Joe believes he should order no less than 5 and no more than 20 units of each item. In addition, the manufacturer has a minimum truck order of 6,000 pounds. Given the following information, help Joe decide how many units of each item to order.
| Item | Wholesale Price | Retail Price | Weight | Minutes of Assembly |
| Oak Cabinet | 209.00 | 369.00 | 35 | 80 |
| Oak Low Chair | 49.00 | 99.00 | 12 | 25 |
| Oak Gateleg Table | 249.00 | 449.00 | 39 | 90 |
| Oak Buffet with Top Cabinet | 179.00 | 339.00 | 30 | 90 |
| Oak Buffet | 159.00 | 299.00 | 28 | 65 |
| Oak Chair | 59.00 | 109.00 | 13 | 20 |
| Black Cherry Sideboard | 209.00 | 399.00 | 35 | 90 |
| Black Cherry Wall Cabinet | 129.00 | 239.00 | 23 | 45 |
| Black Cherry Dining Table | 209.00 | 399.00 | 35 | 90 |
| Black Cherry Chair | 59.00 | 109.00 | 13 | 20 |
| Black Cherry Coffee Table | 119.00 | 229.00 | 22 | 50 |
| Black Cherry Coffee Table Oval | 99.00 | 189.00 | 19 | 45 |
| Maple Round Coffee Table | 99.00 | 189.00 | 17 | 45 |
| Maple Oval Coffee Table | 89.00 | 179.00 | 18 | 45 |
| Maple Visitor Chair | 89.00 | 179.00 | 20 | 45 |
| Mahogany Chair | 69.00 | 149.00 | 15 | 45 |
| Mahogany Low Chair | 59.00 | 119.00 | 14 | 20 |
| Resewood Chair | 55.00 | 109.00 | 13 | 20 |
| Rosewood Wardrobe | 209.00 | 379.00 | 35 | 70 |
| Rosewood Linen Cupboard | 139.00 | 269.00 | 25 | 65 |
| Rosewood Chest with 3 Drawers | 139.00 | 269.00 | 28 | 70 |
| Rosewood Chest with 7 Drawers | 499.00 | 879.00 | 82 | 90 |
| Rosewood Wardrobe with 3 Doors | 289.00 | 499.00 | 46 | 75 |
| Rosewood Wardrobe with Sliding Doors | 329.00 | 559.00 | 51 | 75 |
| Rosewood Bed with Storage | 179.00 | 319.00 | 32 | 65 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
