Make a pro forma Income statement for next two quarters (Quarter 1 & 2) by forecasting sales, costs to achieve the target profit.

Office elegance Office elegance is a privately-owned specialty manufacturer of high-end office furniture for computer users who care about elegant office space. Their customers are in all levels of business that can afford very high quality office furniture, plus a growing portion of high-end home offices. It offers a bundle of very high quality office furniture designed to effectively incorporate computer machinery into the executive office or home office. The key to the line is an ergonomically effective desk that still looks like an executive desk, looks very good in a high-end home office, but is intended to accommodate the personal computer. Direct cost of sales will be around BDT 96 Lac in the first year. The two critical elements of ergonomics keyboard height and angle and monitor height and angle are completely adjustable. Cable runs and shelving add to the utility of the executive computer, without sacrificing elegance. It also make complementary pieces to fill out the office suite, including file cabinets, printer stands, and bookcases. The competition, by the way, is not niche, they compete against generalized furniture manufacturers, cheaper computer-related furniture, and the mainstream merchandise. Price (BDT) 250000-300000 Products Full ergonomic office bundle (Executive desk+chair+ File cabinets+ printer stand + Bookcase "Office Elegance" has following targets in upcoming months Target (Orders) Orders 1st Quarter 10 2nd Quarter 20 General targets: Establish brand with minimal effort in marketing. Identify the key operation costs and keep the cost within 40-50% of the revenue in 1st three months. Office elegance Office elegance is a privately-owned specialty manufacturer of high-end office furniture for computer users who care about elegant office space. Their customers are in all levels of business that can afford very high quality office furniture, plus a growing portion of high-end home offices. It offers a bundle of very high quality office furniture designed to effectively incorporate computer machinery into the executive office or home office. The key to the line is an ergonomically effective desk that still looks like an executive desk, looks very good in a high-end home office, but is intended to accommodate the personal computer. Direct cost of sales will be around BDT 96 Lac in the first year. The two critical elements of ergonomics keyboard height and angle and monitor height and angle are completely adjustable. Cable runs and shelving add to the utility of the executive computer, without sacrificing elegance. It also make complementary pieces to fill out the office suite, including file cabinets, printer stands, and bookcases. The competition, by the way, is not niche, they compete against generalized furniture manufacturers, cheaper computer-related furniture, and the mainstream merchandise. Price (BDT) 250000-300000 Products Full ergonomic office bundle (Executive desk+chair+ File cabinets+ printer stand + Bookcase "Office Elegance" has following targets in upcoming months Target (Orders) Orders 1st Quarter 10 2nd Quarter 20 General targets: Establish brand with minimal effort in marketing. Identify the key operation costs and keep the cost within 40-50% of the revenue in 1st three months