Fundamentals of Cost Accounting 2nd Edition by William Lanen, Carolyn Wells, Michael Maher

Exercise 14

Cost Data for Managerial Purposes-Finding Unknowns
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 blank cells.