Sales Forecast and Flexible Budget Olympus, Inc. manufactures three models of mattresses: the Sleepeze the Plushette, and the u tima. Forecast sales 4,590 for the Ultima. Gene Dixon, vice president of sales, has provided the following information or next year are 15 for the Sleepeze. r e u hette and a. Salaries for his office (including himself at $65,500, a marketing research assistant at $39,200, and an administrative assistant at $25,200) are budgeted for $129,900 next year. b. Depreciation on the offices and equipment is $19,100 per year. c. Office supplies and other expenses total $21,350 per year. d. Advertising has been steady at $20,350 per year. However, the Ultima is a new product and will require extensive advertising to educate consumers on the unique features of this high-end mattress. Gene believes the company should spend 20 percent of first-year Ultima sales for a print and television campaign. e. Commissions on the Sleepeze and Plushette lines are 4 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores. f. Last year, shipping for the Sleepeze and Plushette lines averaged $55 per unit sold. Gene expects the Ultima line to ship for $80 per unit sold since this model features a larger mattress. Required: 1. Suppose that Gene is considering three sales scenarios as follows: Pessimistic Expected Optimistic Price Quantity Price Quantity Price Quantity Sleepeze $188 12,100 $206 15,120 $206 18,350 Plushette 297 9,920349 12,620 35714,070 Ultima 940 1,880 1,020 4,590 1,240 4,590 Prepare a revenue budget for the Sales Division for the coming year for each scenario