Chapter 12, Problem 25QP

Please help

Andy’s Bicycle Company (ABC) has the hottest new  product on the upscale toy market—boys’ and girls’ bikes in  bright fashion colors, with oversize hubs and axles; shell design  safety tires; strong padded frames; chrome-plated chains, brackets, and valves; and non-slip handlebars. Due to the seller’s market for high-quality toys for the newest baby boomers, ABC can  sell all the bicycles it manufactures at the following prices: boys’  bikes, $220; girls’ bikes, $175. This is the price payable to ABC at  its Orlando plant.  The firm’s accountant, V. R. Dondeti, has determined that  direct labor costs will be 45% of the price that ABC receives for  the boys’ model and 40% of the price received for the girls’ model.  Production costs, other than labor but excluding painting and  packaging, are $44 per boys’ bicycle and $30 per girls’ bicycle.  Painting and packaging are $20 per bike, regardless of model.  The Orlando plant’s overall production capacity is 390 bicycles per day. Each boys’…

Tom is a habitual shopper at garage sales. Last Saturday he stopped at one where there were several types of used building materials for sale. At the low prices being asked, Tom knew that he could resell the items in another town for a substantial gain. Four things stood in his way: he could only make one round trip to resell the goods; his pickup truck bed would hold only 1200 pounds; the pickup truck bed could hold at most 80 cubic feet of merchandise; and he had only $190 cash with him. He wants to load his truck with the mix of materials that will yield the greatest profit when he resells them. Formulate (define objective function and constraints) and solve this problem (using excel solver) as a linear program.