Problem $1-52($Algo$)$ Cost Data for Managerial Purposes$-$Finding Unknowns $($LO $1-3)$

Whitcomb Foods is a small company in Oregon that packages and sells organic juices. Recently, a sales rep from one of the company's

suppliers suggested that Whitcomb could increase its profitability by $50$ percent if it introduced a second line of products, packaged

dried fruit for snacks. The rep offered to do the analysis and show the company the assumptions made.

When Whitcomb'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 Whitcomb that "I can no longer advise you."

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.

Required:

Complete the below table by filling in the blank cells.

Note: Enter all amounts as positlve values.