Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This project is based on segment data. The name of the company is Snow White and it has seven business segments (Doc, Sleepy, Grumpy, Sneezy,

image text in transcribed
This project is based on segment data. The name of the company is Snow White and it has seven business segments (Doc, Sleepy, Grumpy, Sneezy, Happy, Bashful, Dopey). Data on segment sales, assets and prot for ten years on each of these seven segments is given in an Excel le that is posted on iCollege in the same folder as this document. Reguired: 1. Prepare 3 pie charts (one each for segment revenue, prots and assets), showing the average percentage (over the 10 years) that each segment contributes to total company revenue, prots and the allocation of assets. The pie chart should be properly labeled and the use of colors to indicate the segments is encouraged. The formulas for calculation of the contribution by each segment to segment revenue, prots and assets should be in the spreadsheet. 2. The management of Snow White wants to evaluate the performance of each segment and make a decision as to which segments to keep and which ones to dispose of. It wants to use Return on Assets (ROA) as the criterion to make this business decision. ROA is dened as Prot/Assets. Calculate the average ROA for each of the segments over the ten years and present the information in the form of a bar graph. The formula for calculating the average ROA for each segment should be in the spreadsheet. 3. Snow White management wants to get rid of any segment that did not have an average ROA of at least 10.5% over the last 10 years. Based on the RCA you calculated in (2) above, identify which segment(s) are candidates for being disposed off. 4. For m segment that has been identied by the top management of Snow White in (3) above as one to be disposed off, imagine you are the manager of that segment. As the manager of that segment make a case as to why your segment should not be disposed off. You need to make your case solely based on the performance of your segment (Hint: Use other performance measures). You need to be creative in doing this section of the assignment. All calculations should be shown in the spreadsheet and the narrative for making your case should also be in the spreadsheet. The entire assignment should be submitted as one Excel spreadsheet. All calculations, charts, graphs, narratives should be in the spreadsheet itself. You can use as many tabs in the spreadsheet as you wish. Please make sure all tabs are properly labeled

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Accounting

Authors: Donna Kay

14th Edition

007762453X, 9780077624538

More Books

Students also viewed these Accounting questions

Question

How is the swap rate calculated?

Answered: 1 week ago

Question

Subjective norms, i.e. the norms of the target group

Answered: 1 week ago