In the Excel lessons in TechnoConsultant, high school students generate several scenarios for increasing revenue. By setting a sales target product lines are manipulated to illustrate the effect on the bottom line.
Using the Solver feature of Microsoft Excel in combination with the Scenario Manager how much money each category of furnishings including bedroom, office, kitchen, living room, and accents must increase are determined. Moreover, the sales that each product line would need to earn to meet these targets are also established. This provides the information the consultants need to help the TechnoFurniture Company set some financial goals.