Answered step by step
Verified Expert Solution
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
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
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