Quince Products is a small company in southern California that makes jams and preserves. Recently, a sales rep from one of the company's suppliers suggested that Quince could increase its profitability by 50 percent if it introduced a second line of products, packaged fruit. She offered to do the analysis and show the company her assumptions. When Quince's management opened the spreadsheet sent by the sales rep, they noticed that there were several blank cells. In the meantime, the sales rep had taken a job with a competitor and told the managers at Quince that she could no longer advise them. Although they were not sure they should rely on the analysis, they asked you to see if you could reconstruct the sales rep's analysis. They had been considering this new business already and wanted to see if their analysis was close to that of an outside observer. The incomplete spreadsheet is shown below.

Required
Fill in the blankcells.

Transcribed Image Text:

QUINCE PRODUCTS Pro Income Statement For One Month Status Quo | % Increase Single Product (Decreas) Two Products Difference 5 Sales 30% 7 Costs 8 Material 9 Labor 10 Rent 2,000 2,800 40% 20% 0% 25% 25% 800 P) 400 200 700 500 100 12 Utilities 13 Other 14 Total coats 15 Operating profit 16 1.050 350