Problem 4-04

Calculate a Dow Jones Industrial Average for days 1 through 5. Do not round intermediate calculations. Round your answers to three decimal places.

Day 1:

Day 2:

Day 3:

Day 4:

Day 5:

Edit question

Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables:

OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)

OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID)

GG_SERVICE (ServiceID, ServiceDescription, CostPerHour);

EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)

PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked)

The referential integrity constraints are:

OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER

PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY

ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE

EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in PROPERTY, and EmployeeID in EMPLOYEE are surrogate keys with values as follows:

OwnerID Start at 1 Increment by 1

PropertyID Start at 1 Increment by 1

ServiceID Start at 1 Increment by 1

EmployeeID Start at 1 Increment by 1

PropertyServiceID Start at 1 Increment by 1

Sample data are shown in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42. OwnerType is either Individual or Corporation. PropertyType is one of Office, Apartments, or Private Residence. ExperienceLevel is one of Unknown, Junior, Senior, Master or SuperMaster. These tables, referential integrity constraints, and data are used

Sample Data for Garden Glory OWNER Table OwnerID OwnerName OwnerEmailAddress OwnerType

1 Mary Jones [email protected] Individual

2 DT Enterprises [email protected] Corporation

3 Sam Douglas [email protected] Individual

4 UNY Enterprises [email protected] Corporation

5 Doug Samuels [email protected] Individual

Sample Data for Garden Glory OWNED_PROPERTY Table PropertyID PropertyName PropertyType Street City State ZIP OwnerID

1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2

2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 1

3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2

4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3

5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 98052 4

6 Jones House Private Residence 1456 48th St Bellevue WA 98007 1

7 Douglas House Private Residence 1567 51st St Bellevue WA 98007 3

8 Samuels House Private Residence 567 151st St Redmond WA 98052 5

as the basis for the SQL statements you will create in the exercises that follow. If possible, run these statements in an actual DBMS, as appropriate, to obtain your results. Name your database GARDEN_GLORY. Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows:

Will you please explain and write the instructions how to write on mySQL and thank you

FIGURE 3-40

Sample Data for Garden Glory EMPLOYEE Table EmployeeID LastName FirstName CellPhone ExperienceLevel

1 Smith Sam 206-254-1234 Master

2 Evanston John 206-254-2345 Senior

3 Murray Dale 206-254-3456 Junior

4 Murphy Jerry 585-545-8765 Master

5 Fontaine Joan 206-254-4567 Senior

FIGURE 3-41

Sample Data for Garden Glory GG_SERVICE Table ServiceID ServiceDescription CostPerHour

1 Mow Lawn 25.00

2 Plant Annuals 25.00

3 Weed Garden 30.00

4 Trim Hedge 45.00

5 Prune Small Tree 60.00

6 Trim Medium Tree 100.00

7 Trim Large Tree 125.00

FIGURE 3-42

Sample Data for Garden Glory PROPERTY_SERVICE Table PropertyServiceID PropertyID ServiceID ServiceDate EmployeeID HoursWorked

1 1 2 2019-05-05 1 4.50

2 3 2 2019-05-08 3 4.50

3 2 1 2019-05-08 2 2.75

4 6 1 2019-05-10 5 2.50

5 5 4 2019-05-12 4 7.50

6 8 1 2019-05-15 4 2.75

7 4 4 2019-05-19 1 1.00

8 7 1 2019-05-21 2 2.50

9 6 3 2019-06-03 5 2.50

10 5 7 2019-06-08 4 10.50

11 8 3 2019-06-12 4 2.75

12 4 5 2019-06-15 1 5.00

13 7 3 2019-06-19 2 4.00

D. Write SQL statements to list all columns for all tables.

E. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master.

will you please explain thank you

Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables:

OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)

OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID)

GG_SERVICE (ServiceID, ServiceDescription, CostPerHour);

EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)

PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked)

The referential integrity constraints are:

OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER

PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY

ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE

EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in PROPERTY, and EmployeeID in EMPLOYEE are surrogate keys with values as follows:

OwnerID Start at 1 Increment by 1

PropertyID Start at 1 Increment by 1

ServiceID Start at 1 Increment by 1

EmployeeID Start at 1 Increment by 1

PropertyServiceID Start at 1 Increment by 1

Sample data are shown in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42. OwnerType is either Individual or Corporation. PropertyType is one of Office, Apartments, or Private Residence. ExperienceLevel is one of Unknown, Junior, Senior, Master or SuperMaster. These tables, referential integrity constraints, and data are used

Sample Data for Garden Glory OWNER Table OwnerID OwnerName OwnerEmailAddress OwnerType

1 Mary Jones [email protected] Individual

2 DT Enterprises [email protected] Corporation

3 Sam Douglas [email protected] Individual

4 UNY Enterprises [email protected] Corporation

5 Doug Samuels [email protected] Individual

Sample Data for Garden Glory OWNED_PROPERTY Table PropertyID PropertyName PropertyType Street City State ZIP OwnerID

1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2

2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 1

3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2

4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3

5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 98052 4

6 Jones House Private Residence 1456 48th St Bellevue WA 98007 1

7 Douglas House Private Residence 1567 51st St Bellevue WA 98007 3

8 Samuels House Private Residence 567 151st St Redmond WA 98052 5

as the basis for the SQL statements you will create in the exercises that follow. If possible, run these statements in an actual DBMS, as appropriate, to obtain your results. Name your database GARDEN_GLORY. Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows:

FIGURE 3-40

Sample Data for Garden Glory EMPLOYEE Table EmployeeID LastName FirstName CellPhone ExperienceLevel

1 Smith Sam 206-254-1234 Master

2 Evanston John 206-254-2345 Senior

3 Murray Dale 206-254-3456 Junior

4 Murphy Jerry 585-545-8765 Master

5 Fontaine Joan 206-254-4567 Senior

FIGURE 3-41

Sample Data for Garden Glory GG_SERVICE Table ServiceID ServiceDescription CostPerHour

1 Mow Lawn 25.00

2 Plant Annuals 25.00

3 Weed Garden 30.00

4 Trim Hedge 45.00

5 Prune Small Tree 60.00

6 Trim Medium Tree 100.00

7 Trim Large Tree 125.00

FIGURE 3-42

Sample Data for Garden Glory PROPERTY_SERVICE Table PropertyServiceID PropertyID ServiceID ServiceDate EmployeeID HoursWorked

1 1 2 2019-05-05 1 4.50

2 3 2 2019-05-08 3 4.50

3 2 1 2019-05-08 2 2.75

4 6 1 2019-05-10 5 2.50

5 5 4 2019-05-12 4 7.50

6 8 1 2019-05-15 4 2.75

7 4 4 2019-05-19 1 1.00

8 7 1 2019-05-21 2 2.50

9 6 3 2019-06-03 5 2.50

10 5 7 2019-06-08 4 10.50

11 8 3 2019-06-12 4 2.75

12 4 5 2019-06-15 1 5.00

13 7 3 2019-06-19 2 4.00

G. Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked on a property in Seattle. Use a subquery.

H. Answer question G but use a join using JOIN ON syntax. What are the consequences of using (or not using) the DISTINCT keyword in this version of the query?

I. Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked on a property owned by a corporation. Use a subquery.

will you please explain thank you!

Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables:

OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)

OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID)

GG_SERVICE (ServiceID, ServiceDescription, CostPerHour);

EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel)

PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked)

The referential integrity constraints are:

OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER

PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY

ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE

EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in PROPERTY, and EmployeeID in EMPLOYEE are surrogate keys with values as follows:

OwnerID Start at 1 Increment by 1

PropertyID Start at 1 Increment by 1

ServiceID Start at 1 Increment by 1

EmployeeID Start at 1 Increment by 1

PropertyServiceID Start at 1 Increment by 1

Sample data are shown in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42. OwnerType is either Individual or Corporation. PropertyType is one of Office, Apartments, or Private Residence. ExperienceLevel is one of Unknown, Junior, Senior, Master or SuperMaster. These tables, referential integrity constraints, and data are used

Sample Data for Garden Glory OWNER Table OwnerID OwnerName OwnerEmailAddress OwnerType

1 Mary Jones [email protected] Individual

2 DT Enterprises [email protected] Corporation

3 Sam Douglas [email protected] Individual

4 UNY Enterprises [email protected] Corporation

5 Doug Samuels [email protected] Individual

Sample Data for Garden Glory OWNED_PROPERTY Table PropertyID PropertyName PropertyType Street City State ZIP OwnerID

1 Eastlake Building Office 123 Eastlake Seattle WA 98119 2

2 Elm St Apts Apartments 4 East Elm Lynwood WA 98223 1

3 Jefferson Hill Office 42 West 7th St Bellevue WA 98007 2

4 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 98052 3

5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 98052 4

6 Jones House Private Residence 1456 48th St Bellevue WA 98007 1

7 Douglas House Private Residence 1567 51st St Bellevue WA 98007 3

8 Samuels House Private Residence 567 151st St Redmond WA 98052 5

as the basis for the SQL statements you will create in the exercises that follow. If possible, run these statements in an actual DBMS, as appropriate, to obtain your results. Name your database GARDEN_GLORY. Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5. For each SQL statement you write, show the results based on your data. Write SQL statements and answer questions for this database as follows:

Will you please explain and write the instructions how to write on mySQL and thank you

FIGURE 3-40

Sample Data for Garden Glory EMPLOYEE Table EmployeeID LastName FirstName CellPhone ExperienceLevel

1 Smith Sam 206-254-1234 Master

2 Evanston John 206-254-2345 Senior

3 Murray Dale 206-254-3456 Junior

4 Murphy Jerry 585-545-8765 Master

5 Fontaine Joan 206-254-4567 Senior

FIGURE 3-41

Sample Data for Garden Glory GG_SERVICE Table ServiceID ServiceDescription CostPerHour

1 Mow Lawn 25.00

2 Plant Annuals 25.00

3 Weed Garden 30.00

4 Trim Hedge 45.00

5 Prune Small Tree 60.00

6 Trim Medium Tree 100.00

7 Trim Large Tree 125.00

FIGURE 3-42

Sample Data for Garden Glory PROPERTY_SERVICE Table PropertyServiceID PropertyID ServiceID ServiceDate EmployeeID HoursWorked

1 1 2 2019-05-05 1 4.50

2 3 2 2019-05-08 3 4.50

3 2 1 2019-05-08 2 2.75

4 6 1 2019-05-10 5 2.50

5 5 4 2019-05-12 4 7.50

6 8 1 2019-05-15 4 2.75

7 4 4 2019-05-19 1 1.00

8 7 1 2019-05-21 2 2.50

9 6 3 2019-06-03 5 2.50

10 5 7 2019-06-08 4 10.50

11 8 3 2019-06-12 4 2.75

12 4 5 2019-06-15 1 5.00

13 7 3 2019-06-19 2 4.00

B. Write foreign key constraints for the relationships in each of these tables. Make your own assumptions regarding cascading updates and deletions and justify those assumptions. (Hint: You can combine the SQL for your answers to parts A and B.)

C. Write SQL statements to insert the data into each of the five Garden Glory database tables. Assume that any surrogate key value will be supplied by the DBMS. Use the data in Figure 3-38, Figure 3-39, Figure 3-40, Figure 3-41, and Figure 3-42.

will you please explain thank you

Problem 4-15 Comprehensive Problem-Weighted-Average Method [LO4-2, LO4-3, LO4-4, LO4-5]

Sunspot Beverages, Ltd., of Fiji uses the weighted-average method in its process costing system. It makes blended tropical fruit drinks in two stages. Fruit juices are extracted from fresh fruits and then blended in the Blending Department. The blended juices are then bottled and packed for shipping in the Bottling Department. The following information pertains to the operations of the Blending Department for June.

Required:

1. Calculate the Blending Department's equivalent units of production for materials and conversion in June.

2. Calculate the Blending Department's cost per equivalent unit for materials and conversion in June.

3. Calculate the Blending Department's cost of ending work in process inventory for materials, conversion, and in total for June.

4. Calculate the Blending Department's cost of units transferred out to the Bottling Department for materials, conversion, and in total for June.

5. Prepare a cost reconciliation report for the Blending Department for June.

consider the subspace W=span[(4,-2,1)^T,(2,0,3)^T,(2,-4,-7)^T]

Find

A) basis of W

B) Dimension of W

C) is vector v=[0,-2,-5]^T contained in W? if yes espress as linear combantion

Exercise 4-8 Equivalent Units; Cost per Equivalent Unit; Assigning Costs to Units-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

Helix Corporation uses the weighted-average method in its process costing system. It produces prefabricated flooring in a series of steps carried out in production departments. All of the material that is used in the first production department is added at the beginning of processing in that department. Data for May for the first production department follow:

Required:

1. Calculate the first production department's equivalent units of production for materials and conversion for May.

2. Compute the first production department's cost per equivalent unit for materials and conversion for May.

3. Compute the first production department's cost of ending work in process inventory for materials, conversion, and in total for May.

4. Compute the first production department's cost of the units transferred to the next production department for materials, conversion, and in total for May.

Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

"I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it."

*Consists of cost transferred in, $4,286; materials cost, $2,025; and conversion cost, $2,250.

"He's struggling to learn our system," replied Frank Harrop, the operations manager. "The problem is that he's been away from process costing for a long time, and it's coming back slowly."

"It's not just the format of his report that I'm concerned about. Look at that $24.340 unit cost that he's come up with for April. Doesn't that seem high to you?" said Ms. Scarpino.

"Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation," replied Mr. Harrop. "I’ll get someone else to redo this report and then we can see what’s going on."

Provost Industries manufactures a ceramic product that goes through two processing departments—Molding and Finishing. The company uses the weighted-average method in its process costing.

Required:

1-a. Calculate the equivalent units of production.

1-b. Calculate the cost per equivalent unit. (Round your answers to 2 decimal places.)

1-c. How much cost should have been assigned to the ending work in process inventory? (Round your intermediate calculations to 2 decimal places.)

1-d. How much cost should have been assigned to the units completed and transferred to finished goods? (Round your intermediate calculations to 2 decimal places.)

Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

"I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it."

*Consists of cost transferred in, $4,304; materials cost, $2,070; and conversion cost, $2,340.

"He's struggling to learn our system," replied Frank Harrop, the operations manager. "The problem is that he's been away from process costing for a long time, and it's coming back slowly."

"It's not just the format of his report that I'm concerned about. Look at that $23.450 unit cost that he's come up with for April. Doesn't that seem high to you?" said Ms. Scarpino.

"Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation," replied Mr. Harrop. "I’ll get someone else to redo this report and then we can see what’s going on."

Provost Industries manufactures a ceramic product that goes through two processing departments—Molding and Finishing. The company uses the weighted-average method in its process costing.

Required:

1-a. Calculate the equivalent units of production.

1-b. Calculate the cost per equivalent unit. (Round your answers to 2 decimal places.)

1-c. How much cost should have been assigned to the ending work in process inventory? (Round your intermediate calculations to 2 decimal places.)

1-d. How much cost should have been assigned to the units completed and transferred to finished goods? (Round your intermediate calculations to 2 decimal places.)

Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

"I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it."

*Consists of cost transferred in, $4,304; materials cost, $2,070; and conversion cost, $2,340.

"He's struggling to learn our system," replied Frank Harrop, the operations manager. "The problem is that he's been away from process costing for a long time, and it's coming back slowly."

"It's not just the format of his report that I'm concerned about. Look at that $23.450 unit cost that he's come up with for April. Doesn't that seem high to you?" said Ms. Scarpino.

"Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation," replied Mr. Harrop. "I’ll get someone else to redo this report and then we can see what’s going on."

Provost Industries manufactures a ceramic product that goes through two processing departments—Molding and Finishing. The company uses the weighted-average method in its process costing.

Required:

1-a. Calculate the equivalent units of production.

1-b. Calculate the cost per equivalent unit. (Round your answers to 2 decimal places.)

1-c. How much cost should have been assigned to the ending work in process inventory? (Round your intermediate calculations to 2 decimal places.)

1-d. How much cost should have been assigned to the units completed and transferred to finished goods? (Round your intermediate calculations to 2 decimal places.)

Case 4-19 Second Department-Weighted-Average Method [LO4-2, LO4-3, LO4-4]

"I think we goofed when we hired that new assistant controller," said Ruth Scarpino, president of Provost Industries. "Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it."

*Consists of cost transferred in, $4,302; materials cost, $2,065; and conversion cost, $2,330.

"He's struggling to learn our system," replied Frank Harrop, the operations manager. "The problem is that he's been away from process costing for a long time, and it's coming back slowly."

"It's not just the format of his report that I'm concerned about. Look at that $23.270 unit cost that he's come up with for April. Doesn't that seem high to you?" said Ms. Scarpino.

"Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation," replied Mr. Harrop. "I’ll get someone else to redo this report and then we can see what’s going on."

Provost Industries manufactures a ceramic product that goes through two processing departments—Molding and Finishing. The company uses the weighted-average method in its process costing.

Required:

1-a. Calculate the equivalent units of production.

1-b. Calculate the cost per equivalent unit. (Round your answers to 2 decimal places.)

1-c. How much cost should have been assigned to the ending work in process inventory? (Round your intermediate calculations to 2 decimal places.)

1-d. How much cost should have been assigned to the units completed and transferred to finished goods? (Round your intermediate calculations to 2 decimal places.)