Question: Question 1 Your CEO, Mr Bennet, will be presenting the latest Rainbow Textiles business plan to Mr Ling in Singapore. This business plan will consist

Question 1

Your CEO, Mr Bennet, will be presenting the latest Rainbow Textiles business plan to Mr Ling in Singapore. This business plan will consist of a large amount of data and information that will need to be summarised in graphical or table format for easier analysis and interpretation. Mr Bennet has requested you to present this information for him in an Excel spreadsheet. He has asked that you display each item in a separate sheet within the same workbook.

Sheet 2:

In Sheet 2, first create a simple table displaying the following information. It represents the type and amount of fabric (in metres) sold for the current year by Rainbow Textiles. Make use of formulas and functions in the table to work out the total amount sold in the current year, and the percentage of each fabric sold.

Chiffon: 800,000

Cotton: 650,000

Crinkle de chine: 150,000

Georgette: 500,000

Linen: 725,000

Muslin: 400,000

Silk: 125,000

Then, below this table, create a pie chart displaying these percentages of each specific fabric sold in the current year. Label the sheet Fabrics sold.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Question 1 Your CEO, Mr Bennet, will be presenting the latest Rainbow Textiles business plan to Mr Ling in Singapore. This business plan will consist of a large amount of data and information that...

Question 1 Your Executive, Mr Bennet, has returned from his business trip to Singapore where he visited Mr Ling from Jalan Fabrics. You have asked a junior office clerk to speak to Mr Bennet about...

Complete an Executive Summary Give an explanation what the author intended to do in the study or article. Summarize three or four of the most important findings of the study or article. Summarize any...

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

Among the following situations, which one results in an unambiguous increase in the price of a bond? A simultaneous increase in the demand and supply of bonds. A simultaneous decrease in the demand...

The Four Brothers Lumber Company is considering buying a machine that planes lumber to the correct thickness. The machine is advertised to produce 6-inch lumber having a thickness that is normally...

A Japanese company has a bond that sells for 9 6 . 5 3 2 percent of its 1 0 0 , 0 0 0 par value. The bond has a coupon rate of 5 . 1 percent paid annually and matures in 1 1 years. What is the yield...

Hypothesis Testing of a Single Mean LCTCS Tuition: Louisiana Community And Technical College System consist of 2 community colleges across the state. I think RPCC's tuition and fees is lower than the...

A Is it really possible for Sus doctor to pay attention to all of the cultural factors that play into her health care simultaneously? Is it enough for him to consider her financial constraints but...

A Take a moment to Google yourself. Search not only for your name but also your e-mail address. What comes up?

2 What about students who attended the school but did not graduate or who are not in the alumni rolls? Would leaving them out skew the results of your survey as well?