Purchase Solution

Payback, ROAI, NPV & Flexible Budget Variances

Not what you're looking for?

Ask Custom Question

I.C. Icecream is considering 2 possible expansion plans. Proposal A involves opening 8 stores in northern Alaska at a total cost of $ 4,000,000/-Under another strategy,proposal B I.C. Icecream would focus on Southern Alaska and opening 5 stores at a total cost od $ 3,000,000/-. Selected data regarding the two proposals are as under

Proposal A Proposal B
Required Investment $4,000,000 $3,000,000
Estimated Life of store locations 8 years 8 years
Estimated Salvage Value - 200,000.00
Estimated annual net cash flows 800,000.00 700,000.00
Depreciation on equipment ( straight line method) 500,000.00 350,000.00
Estimated annual Income ? ?

Evaluate each proposal using
Pay back period
Return on average investment
NPV @ 12 %

State which proposal you would recommend and explain the reasoning behind your choice.

XL industries uses flexible budgets and performance reports in planning and controlling its manufacturing operations. The following annual performance report for the widget production department was presented to the president of the company:-

Costs "Budgeted Cost
for 4000 units" "Actual Cost
for 5000 units"
Per unit Total
Variable manufacturing costs
Direct Material $25 $100,000 $120,000
Direct Labour $50 $200,000 $210,000
Indirect Labour $12 $48,000 $50,000
Indirect material and supplies $10 $40,000 $43,000
Total variable manufacturing costs $97.00 $388,000.00 $423,000.00

Fixed manufacturing Costs $53.00 $212,000.00 $219,000

Prepare a flexible budget for the actual level of sales achieved, analyse the variance between budgeted and actual cost and give your comments

Read the attached file for complete details.

Attachments
Purchase this Solution

Solution Summary

The solution provides answers to 2 questions - one on capital budgeting and the other on flexible budget variances.

Solution Preview

Please see attached file for complete solution.

I.C. Icecream is considering 2 possible expansion plans. Proposal A involves opening 8 stores in northern Alaska at a total cost of $ 4,000,000/-Under another strategy,proposal B I.C. Icecream would focus on Southern Alaska and opening 5 stores at a total cost od $ 3,000,000/-. Selected data regarding the two proposals are as under

Proposal A Proposal B
Required Investment $4,000,000 $3,000,000
Estimated Life of store locations 8 years 8 years
Estimated Salvage Value - 200,000.00
Estimated annual net cash flows 800,000.00 700,000.00
Depreciation on equipment ( straight line method) 500,000.00 350,000.00
Estimated annual Income ? ?

Evaluate each proposal using
Pay back period
Return on average investment
NPV @ 12 %

State which proposal you would recommend and explain the reasoning behind your choice.

Cash flow
Year Proposal A Proposal B
0 ($4,000,000) ($3,000,000)
1 $800,000 $700,000 Estimated annual net cash flow
2 $800,000 $700,000 "
3 $800,000 $700,000 "
4 $800,000 $700,000 "
5 $800,000 $700,000 "
6 $800,000 $700,000 "
7 $800,000 $700,000 "
8 $800,000 $900,000 (Estimated annual net cash flow + Estimated Salvage value)

Payback Period

Payback period is the number of years in which the initial investment is recouped
Payback = Year before full recovery + (unrecovered cost at start of yr/CF during yr)

Proposal A

Year Cash flow Cumulative cash ...

Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.