I am not sure how to input the following data into the solver parameter? Could anyone explain how it goes? I am not sure how to find the QTY section.

DATA CAN BE FOUND IN THE SCREENSHOT PROVIDED.

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

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