Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[20 pts] Question 19: Design an Entity Relationship diagram that represents the following information. Identify the attributes. A customer places an order that contains many

image text in transcribed

[20 pts] Question 19: Design an Entity Relationship diagram that represents the following information. Identify the attributes. A customer places an order that contains many products which are produced by many manufacturing companies. 1. Customers are identified by their unique number. They have an email ID and physical address. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. 2. Manufacturing companies have a name, which we may assume is unique, an address, and a phone number. 3. Products have product ID, product name, a model number, a type (e.g., gaming device)and quantity on hand. Each product is made by one manufacturer and different manufacturers may have different products with the same model number. However, you may assume that no manufacturer would have two products with the same model 4. An order has a unique order number and a date. An order is placed by one customer. 5. For each order, there are one or more products ordered, and there is a quantity for each product on the order. [20 pts) Question 20: Calculate the estimated product completion time and provide a realistic conclusion for the case provided below. Please use today's date and show ALL the steps to derive your answer. Compute the following: 1. BAC 2. BCWP 3. BCWS 4. Earned Value (EV) 5. Schedule Performance Index (SPI) 6. Schedule Variance (SV) 7. ACWP 8. Cost Variance (CV) 9. CPI 10. Is the project on schedule? Explain your answer to provide a conclusion. Work Task Estimated Effort (Prog. Days) Actual Effort so far (Prog. Days) Estimated Completion Date Actual Completion Date 1 5 5 9/28/2021 9/27/2021 2 10 40 10/10/2021 3 20 14 11/2/2021 11/22/2021 4 10 6 12/8/2021 Reference: Progress Indicators EV - Budgeted Cost of Work Performed / Budget at Completion SPI = Budgeted Cost of Work Performed / Budget Cost of Work Scheduled SV - Budgeted Cost of Work Performed - Budget Cost of Work Scheduled . CPI - Budgeted Cost of Work Performed / Actual Cost of Work Performed . CV - Budgeted Cost of Work Performed - Actual Cost of Work Performed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing A Practical Approach

Authors: Robyn Moroney

1st Canadian Edition

978-1118472972, 1118472977, 978-1742165943

More Books

Students also viewed these Accounting questions

Question

Jim Riley is (incompetent) for that kind of promotion.

Answered: 1 week ago