Create Excel Worksheet to complete problem present

User Generated

QPnvaln

Description

Problem: Using Excel To Calculate Estimates

A window blind company owner never knew how exactly how much material he needed for any single project. He would estimate the amount and put that figure into Excel. When he estimated too much, it cost him money for materials he didn't use. When he estimated too little, it delayed the project's completion because he had to get more material from his supplier. Plus, he used Excel as if it was just a paper chart.

Solution: Worksheet Creation

Use Excel to create a worksheet for each order as part of a workbook for orders to his suppliers. After all the individual orders are entered in the workbook as worksheets, the new Excel workbook calculates how much material was needed for was needed for the entire group of orders. The worksheet will save the company time and money because the owner could order the right amount of material from his suppliers and allocate it correctly to the customers' jobs.

Unformatted Attachment Preview

CPT 321 – VBA, The Internet and Microsoft Office Applications – Mastery Group Assignment As a group, you will be tasked with using the solution below to solve the problem for the fictional business. As a team, you will be responsible for creating a VBA solution that solves the problem, and a PowerPoint Presentation that you will present through a web recording (Zoom, Screencast-o-matic, etc.) as if you were presenting this solution to the president of the company. Each of you will be responsible for participating in the project and participating in the recorded presentation, but only one learner will need to submit both the VBA script (Excel Document) and the You Tube link for the group presentation for the Unit 6 Mastery Assignment. This assignment will be due in Unit 6. There will be a Discussion Board progress check in Unit 5. The instructor will create the groups at the beginning of Unit 1. Problem: Using Excel To Calculate Estimates A window blind company owner never knew how exactly how much material he needed for any single project. He would estimate the amount and put that figure into Excel. When he estimated too much, it cost him money for materials he didn't use. When he estimated too little, it delayed the project's completion because he had to get more material from his supplier. Plus, he used Excel as if it was just a paper chart. Solution: Worksheet Creation Use Excel to create a worksheet for each order as part of a workbook for orders to his suppliers. After all the individual orders are entered in the workbook as worksheets, the new Excel workbook calculates how much material was needed for was needed for the entire group of orders. The worksheet will save the company time and money because the owner could order the right amount of material from his suppliers and allocate it correctly to the customers' jobs. **Instructions for setting up a Zoom account and a user’s guide for Zoom can be found in the Faculty and Course Info section of Blackboard. Instructions for how to upload an .mp4 to You Tube can be also found in the Faculty and Course Info section of Blackboard.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Order number
Customer
Telephone contact

20181101
Peter Smith
5th Avenue 253, New York City
15412576457

Date
Product
Horizontal blinds
Outdoor venetian blinds
Wooden venetian blinds
Pleated blinds
Polyester blinds
Faux wood blinds
PVC blinds
Bamboo venetian blinds
Window blinds
Roller blinds
Interior venetian blinds
Screws

11/23/2018
Size (squared feet)

Quantity
3
1
5
6
2
4
5
5
5
8
8
5

N/A

3
1
5
6
2
4
5
5
5
8
8
5
456

Unit price
\$
1.50
\$
1.40
\$
1.50
\$
1.55
\$
1.35
\$
1.60...

Review

Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4