BIS 155 Dreams Come True /uophelp.com BIS 155 Dreams Come True /uophelp.com | Page 10

BIS 155 iLab 1 Upper Saddle River Marching Band ( New )
For more course tutorials visit www . uophelp . com
As an alternative to steps 3-5 above , use 3-D referencing to summarize the data . Add row and column summary totals on the Quest 5-Organizing Data Worksheet . Summarize your results using an appropriate chart type and place it below the summarized data . Spell check the worksheet . Save your work ( CTRL + s ). Analysis , Summary and Recommendation ( TCO ‘ s 8 , and 9 ; 30 Points ). Analyze the results from Quest 5-Organizing Data worksheet and create a report / memo with the following : Identify the top two selling items and the two lowest selling items . Add a Chart / Table ( s ) to reflect your results – or use the chart created in step 5 Offer management a recommendation to improve the business based upon your analysis . List at least two Lessons Learned from your course experience . Save and close your Excel file . ==================================================

BIS 155 iLab 1 Upper Saddle River Marching Band ( New )

For more course tutorials visit www . uophelp . com

Scenario / Summary You are the assistant to the band director for the Upper Saddle River Marching Band , and you must prepare a report showing the status of the marching band fundraising event for presentation to the board of trustees . The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal . You will open the partially completed workbook , create formulas , format for presentation to the board , and add charts to graphically depict the sales over time and by product . Deliverables