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.

Maximum of $35,000 on 25 items

Work five, 10 hour days

Order no less than 5 and no more than 20 units of each item

Minimum truck order of 6,000 pounds

yes, excel is needed

A B F G H 1 D Total Available Hours Total Available Minutes E 200 12000 4 5 10 35000 6000 QTY Cost Weight Assemly Time 1 Inventory Clerks 2 Work Days 3 Work Hours 4 Maximum Cost 5 Minimum Truck Order Pounds 6 Order no less than 5 but no more than 20 7 8 9 10 Item 11 Oak Cabinet 12 Oak Low Chair 13 Oak Gateleg Table 14 Oak Buffet with Top Cabinet 15 Oak Buffet 16 Oak Chair 17 Black Cherry Sideboard 18 Black Cherry Wall Cabinet 19 Black Cherry Dining Table 20 Black Cherry Chair 21 Black Cherry Coffee Table 22 Black Cherry Coffee Table Oval 23 Maple Round Coffee Table 24 Maple Oval Coffee Table 25 Maple Visitor Chair 26 Mahogany Chair 27 Mahogany Low Chair 28 Resewood Chair 29 Rosewood Wardrobe 30 Rosewood Linen Cupboard 31 Rosewood Chest with 3 Drawers 32 Rosewood Chest with 7 Drawers 33 Rosewood Wardrobe with 3 Doors 34 Rosewood Wardrobe with Sliding Doors 35 Rosewood Bed with Storage 36 3971.00 Wholesale Price 209.00 49.00 249.00 179.00 159.00 59.00 209.00 129.00 209.00 59.00 119.00 99.00 99.00 89.00 89.00 69.00 59.00 55.00 209.00 139.00 139.00 499.00 289.00 329.00 179.00 7325.00 Retail Price 369.00 99.00 449.00 339.00 299.00 109.00 399.00 239.00 399.00 109.00 229.00 189.00 189.00 179.00 179.00 149.00 119.00 109.00 379.00 269.00 269.00 879.00 499.00 559.00 319.00 700 Weight 35 12 39 30 28 13 35 23 35 13 22 19 17 18 20 15 14 13 35 25 28 82 46 51 32 Minutes of Assembly 80 25 90 90 65 20 90 45 90 20 50 45 45 45 45 45 20 20 70 65 70 90 75 75 65 A B F G H 1 D Total Available Hours Total Available Minutes E 200 12000 4 5 10 35000 6000 QTY Cost Weight Assemly Time 1 Inventory Clerks 2 Work Days 3 Work Hours 4 Maximum Cost 5 Minimum Truck Order Pounds 6 Order no less than 5 but no more than 20 7 8 9 10 Item 11 Oak Cabinet 12 Oak Low Chair 13 Oak Gateleg Table 14 Oak Buffet with Top Cabinet 15 Oak Buffet 16 Oak Chair 17 Black Cherry Sideboard 18 Black Cherry Wall Cabinet 19 Black Cherry Dining Table 20 Black Cherry Chair 21 Black Cherry Coffee Table 22 Black Cherry Coffee Table Oval 23 Maple Round Coffee Table 24 Maple Oval Coffee Table 25 Maple Visitor Chair 26 Mahogany Chair 27 Mahogany Low Chair 28 Resewood Chair 29 Rosewood Wardrobe 30 Rosewood Linen Cupboard 31 Rosewood Chest with 3 Drawers 32 Rosewood Chest with 7 Drawers 33 Rosewood Wardrobe with 3 Doors 34 Rosewood Wardrobe with Sliding Doors 35 Rosewood Bed with Storage 36 3971.00 Wholesale Price 209.00 49.00 249.00 179.00 159.00 59.00 209.00 129.00 209.00 59.00 119.00 99.00 99.00 89.00 89.00 69.00 59.00 55.00 209.00 139.00 139.00 499.00 289.00 329.00 179.00 7325.00 Retail Price 369.00 99.00 449.00 339.00 299.00 109.00 399.00 239.00 399.00 109.00 229.00 189.00 189.00 179.00 179.00 149.00 119.00 109.00 379.00 269.00 269.00 879.00 499.00 559.00 319.00 700 Weight 35 12 39 30 28 13 35 23 35 13 22 19 17 18 20 15 14 13 35 25 28 82 46 51 32 Minutes of Assembly 80 25 90 90 65 20 90 45 90 20 50 45 45 45 45 45 20 20 70 65 70 90 75 75 65