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 40 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 positive values. Sales Costs Material Labor Rent Depreciation Utilities Other Total costs Operating profit WHITCOMB FOODS Projected Annual Income Statement Status Quo: Single Product 31,000 6.200 3,200 10,700 S 116,000 $ 38,000 % Increase Alternative: Two (Decrease) Products 30 % $ 40 % 20 % 0% 25 % 25 % 96 200,200 43,400 7,750 14,980 Difference 12,400 1,550 4,280
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 40 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 positive values. Sales Costs Material Labor Rent Depreciation Utilities Other Total costs Operating profit WHITCOMB FOODS Projected Annual Income Statement Status Quo: Single Product 31,000 6.200 3,200 10,700 S 116,000 $ 38,000 % Increase Alternative: Two (Decrease) Products 30 % $ 40 % 20 % 0% 25 % 25 % 96 200,200 43,400 7,750 14,980 Difference 12,400 1,550 4,280
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter6: Statistical Inference
Section: Chapter Questions
Problem 43P: The Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last...
Related questions
Question
Transcribed Image Text: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 40 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 positive values.
Sales
Costs
Material
Labor
Rent
Depreciation
Utilities
Other
Total costs
Operating profit
WHITCOMB FOODS
Projected Annual Income Statement
Status Quo:
Single Product
S
$
31,000
6.200
3,200
10,700
116,000
38,000
% Increase Alternative: Two
(Decrease)
Products
30 % $
40 %
20 9
0%
25 %
25 %
&&*
96
96
200,200
43,400
7,750
14,980
Difference
12,400
1,550
4,280
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning