Question
Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division. Frozen Foods Division: Year 1 Year 2 Sales
Allard, Inc., presented two years of data for its Frozen Foods Division and its Canned Foods Division.
Frozen Foods Division: | ||
Year 1 | Year 2 | |
Sales | $35,000,000 | $38,200,000 |
Operating income | 1,420,000 | 1,500,000 |
Average operating assets | 4,690,000 | 4,690,000 |
Canned Foods Division: | ||
Year 1 | Year 2 | |
Sales | $11,600,000 | $12,800,000 |
Operating income | 690,000 | 600,000 |
Average operating assets | 5,550,000 | 5,550,000 |
At the end of Year 2, the manager of the Canned Foods Division is concerned about the division's performance. As a result, he is considering the opportunity to invest in two independent projects. The first is juice boxes for elementary school children. The second is fruit and veggie pouches for kids on the go. Without the investments, the division expects that Year 2 data will remain unchanged. The expected operating incomes and the outlay required for each investment are as follows:
Juice Box | Fruit Pouch | |
Operating income | $28,000 | $15,000 |
Outlay | 220,000 | 170,000 |
Allard's corporate headquarters has made available up to $500,000 of capital for this division. Any funds not invested by the division will be retained by headquarters and invested to earn the company's minimum required rate of return, 9 percent.
Required:
Round your answers to four decimal places before converting to a percentage. For example, .06349 would be rounded to .0635 and entered as "6.35" percent.
1. Compute the ROI for each investment.
Juice Box ROI | fill in the blank 1 % |
Fruit Pouch ROI | fill in the blank 2 % |
2. Compute the divisional ROI for each of the following four alternatives:
a. The juice box is added. fill in the blank 3 %
b. The fruit pouch is added. fill in the blank 4 %
c. Both investments are added. fill in the blank 5 %
d. Neither investment is made; the status quo is maintained. fill in the blank 6 %
Assuming that divisional managers are evaluated and rewarded on the basis of ROI performance, which alternative do you think the divisional manager will choose?
Juice BoxFruit PouchBoth ProjectsStatus Quo
3. Which of the data analytic typesdescriptive, diagnostic, predictive or prescriptiveis used in determining which, if any, new investment to make?
DescriptiveDiagnosticPredictivePrescriptive
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started