I saw this problem and solution on Course Hero, but the tutor does not explain what formula he/she uses for the "quantity" volume.

Can you please explain what formula to use? also can you please help me solve using SOLVER

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.

Please solve the problem using the Solver function in Microsoft excel and make sure to identify and include all contraints. Use the excel spreadsheet provided for answer.

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
	3971.00	7325.00	700.00	1440.00