Revised BMS 12/29/19 Integrated Capstone Project Mr ✓ Solved

Revised BMS 12/29/19 INTEGRATED CAPSTONE PROJECT Mr.

Mr. Carlyle would like you to complete the report, workbook and presentation for his upcoming yearly meeting. Review your Capstone Projects from each software to review your key concepts. The goal is to have a business professional report, workbook and presentation. You are to integrate your skills using Microsoft Word, Excel, PowerPoint and Outlook.

Workbook

The Apple Valley Paper Year-End workbook needs to be completed. Apply a theme, use styles, number formats, and complete the workbook with consistent formatting and use of formulas and functions. Use a minimum 12-point font. At a minimum include the following:

  • Complete the Safety Worksheet by calculating our total safety incidents.
  • Create a chart using the Safety Worksheet.
  • Update all monthly worksheets with consistent formatting and formulas.
  • Complete the Year-End Net Income worksheet by calculating the total Net Income for the year.
  • Apply conditional formatting on the Year-End Net Income worksheet to indicate the top three divisions’ Net Income.
  • Create a chart on the Year-End Net Income worksheet using the Percent of Total.
  • On the Employees Worksheet, use a function to determine what bonus amount each employee will receive.
  • Apply consistent formatting to all worksheets.
  • Safety and Year-End Net Income worksheets: Change orientation to Landscape and Scale to Fit one page width and height.
  • Employees worksheet: Change orientation to Landscape and Scale to Fit one page width.
  • Arrange monthly worksheets in order.

Business Report

Based on the data created in your workbook, Mr. Carlyle would like you to create a Business Report using Word. Start a new document, apply a consistent theme and formatting to match your workbook. Use the Apple Valley Paper website to complete the report along with your Year-End workbook.

At a minimum include the following:

  • Apply a theme and styles of your choice.
  • Your report needs to be a minimum of four pages of content and a cover page.
  • About: Include general information about Apple Valley Paper from their website.
  • People: Include all members of Apple Valley Paper from their website.
  • Financial: Include year-end information from your Excel Workbook.
  • Products: Include information about Apple Valley Paper Products from their website.
  • Use the Apple Valley Paper logo provided in AVP Information button in Blackboard.
  • Business Professional Images, some are provided in AVP Information button in Blackboard.
  • Include additional professional images as you need.
  • Include Charts from the AVP Year-End Excel Workbook.
  • Must include a table, tabbed list, and a SmartArt of your choice with appropriate formatting and enhancements.
  • Feel free to use information from your other capstone projects to add content.
  • Review your document to ensure your information fully fills the pages.

Business Presentation

Mr. Carlyle would like to take the contents of the Business Report and Year-End workbook and use it at an upcoming investor meeting for future expansion. Create a minimum of 8 slides. At a minimum include the following:

  • Apply a theme and styles of your choice.
  • Create a minimum of 8 slides but include the following:
  • Title Slide
  • Agenda Slide
  • About Slide
  • People Slide
  • Financial Slide
  • Products Slide
  • Thank You Slide
  • Include charts, SmartArt, Business Professional Images, video, and Icons of your choice.
  • Minimum of 60-point font size on titles and 24-point font size on text.

Email to Mr. Carlyle

Mr. Carlyle would like your project to be emailed to him for review. At a minimum include the following:

  • Professionally formatted email includes salutation, body and complimentary closing.
  • Include signature.
  • Include the Business Report, Workbook, and Presentation as attachments.

Paper For Above Instructions

The Integrated Capstone Project for Apple Valley Paper serves as a comprehensive effort to consolidate various business-oriented tasks utilizing Microsoft Office tools. This project requires careful planning and organization to ensure all components are not only completed but also presented professionally, catering to Mr. Carlyle’s expectations for his upcoming yearly meeting.

Creating the Workbook

The workbook holds vital data concerning the company's safety incidents, total net income, and employee bonuses. Each worksheet requires careful attention to detail, including consistent formatting, appropriate use of formulas, and visual representations through charts. For instance, the Safety Worksheet must calculate total incidents accurately, while the Year-End Net Income Worksheet must highlight the performance of divisions through conditional formatting. These aspects should showcase Apple Valley Paper's dedication to maintaining a safe workplace and improving financial performance.

Developing the Business Report

The business report will generate essential insights for stakeholders regarding Apple Valley Paper's operations. Drawing information from various sources such as company data, financial results, and product information will ensure a well-rounded report. The report should not only meet but also exceed the four-page requirement, utilizing professional images, charts from the workbook, and enhanced formatting to engage the reader. This will involve detailing each aspect, including company history and product lines, to provide a comprehensive overview of Apple Valley Paper.

Preparing the Business Presentation

The accompanying presentation for Mr. Carlyle must distill the essence of the report into bite-sized, visually appealing segments. Utilizing themes, SmartArt, and images will help convey critical information succinctly. Each slide needs to emphasize clarity and professionalism, with the inclusion of charts to illustrate key metrics. A well-structured agenda slide will guide viewers through the content, while a thank-you slide will close the presentation on an appreciative note.

Professional Email Communication

Finally, the email to Mr. Carlyle must be perfectly formatted and professional. The salutation should address him appropriately, followed by a concise body summarizing the attached documents: the workbook, the business report, and the presentation. A clear signature at the end will enhance the communication's professionalism. Additionally, sending the documents as attachments will facilitate Mr. Carlyle's review process, demonstrating organizational skills and respect for his time.

Conclusion

Completing the Integrated Capstone Project is a multifaceted task that reflects on both individual skill and the synthesis of various business concepts. By integrating Microsoft Word, Excel, PowerPoint, and Outlook seamlessly, not only will the requirements be met, but they will also deliver a professional representation of the Apple Valley Paper's achievements and future potential. Continuous attention to detail and adherence to professional standards will ensure that the final products resonate well with Mr. Carlyle and any other stakeholders involved.

References

  • Apple Valley Paper. (2021). Company Overview. Retrieved from [website link]
  • Microsoft. (2021). Excel Functions. Retrieved from [website link]
  • Microsoft. (2021). Word Templates. Retrieved from [website link]
  • Powell, A. (2021). Professional Business Emails. Retrieved from [website link]
  • Charting in Excel. (2021). To create Charts. Retrieved from [website link]
  • Styles and Formatting in Word. (2021). Retrieved from [website link]
  • Using SmartArt in Presentations. (2021). Retrieved from [website link]
  • Professional Communication Standards. (2021). Retrieved from [website link]
  • Microsoft PowerPoint Guidelines. (2021). Retrieved from [website link]
  • Continuous Improvement: Apple Valley Paper Case Study. (2021). Retrieved from [website link]

Related Assignments