Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In addition to determining the above information for each fundraising idea, your manager would also like to see the highest value and lowest value of

image text in transcribed

image text in transcribed

In addition to determining the above information for each fundraising idea, your manager would also like to see the highest value and lowest value of the Cost Per Unit, Mark-Up, Selling Price, Sales per 2000, and Sales per 5000. Lastly, you would like to show the board a comparison of Profit Margin and Profit per 5000 chart types within the same chart with two sets of data. The first set of data will help to compare the Profit per 5000 Sales for each fundraising choice, the second set of data will sit on top of the Profit per 5000 Sales data to compare them at once. Before you submit the chart to the board, you will want to format the chart professionally with all appropriate labels that can be read. Place the chart below the data on the same spreadsheet as the data table. You will need to use the Select Data tool in Chart Tools to change the Series Names to the appropriate labels. Change the Theme of the spreadsheet to Slice, then the Color Theme to Green Yellow, and the Font Theme to Gill Sans MT. Change the chart style to Style 14. This is professional spreadsheet that will be shown to your employer. All of the information should be contained on ONE spreadsheet. Be sure to format it appropriately with the appropriate number formats, borders, text styles, etc. to differentiate and highlight important information. Your spreadsheet should have an identifying title, headings, etc. Name your workbook appropriately according to the guidelines in the syllabus. Upload your completed workbook online through Canvas

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions