Flore Company manufactures office equipment for sale in retail stores. Rajiv Goyal, vice

president of marketing, has proposed that Flore Company to introduce two new products,

an electric stapler and an electric pencil sharpener. Goyal has requested Flore's Accounting

Department to develop preliminary selling prices for the two new products for his review.

The Accounting Department followed the company's standard policy for developing

potential selling prices using as much data as available for each product. The data

accumulated for the two new products were as follows:

Flore planned to employ an average of Rs$.24($Twenty Four$)$ lakhs of assets to support its

operations in the current year. The following budgeted profit and loss account represents

Flore Company's planned goals with respect to cost relationships and return on investment

for the entire company across all of its products.

Calculate a potential selling price for the electric stapler using cost$-$plus pricing to achieve a

target return on investment equal to Fiore Company's current projected ROI as below. Do the calculations in excel, attach screenshots of excel table and explain the steps and formulas to calculate the problem.