1. Can we tell Lizzie about the spoilage charges for the entire period? We know the pounds...
Question:
1. Can we tell Lizzie about the spoilage charges for the entire period? We know the pounds of loss, but can we extract the cost from this database? Why or why not?
2. If your answer to 1 is no, how to change the database to solve this problem. Your answer must be specific (an attribute of a class, A new relationship Relationship properties)
3. The database has three volatile attributes. what they are?
4. Select one of the attributes you identified in 3) and tell me that two events will trigger a change in that attribute.
5. Lizzie wants to know which of the three stores has the highest revenue. This model does not give us this information because sometimes employees work in stores where they are not assigned. Tell me why we can't get this information from the database and how you would solve this problem.
Query 1 "total sales by customer" Total Sales by Customer X Customer SumOfDollar. $47,100.00 $37,500.00 $37,600.00 $36,250.00 $34,200.00 $52,000.00 $42,700.00 $4,000.00 Query 2 "total purchases by farmer" C310 C311 C312 C313 C314 C315 C316 C500 Farmer SumOfDollar. F202 F203 F204 F205 F206 F207 F208 F209 $18,100.00 $17,500.00 $18,100.00 $19,500.00 $16,500.00 $13,700.00 $15,700.00 $7,800.00 Query 3 "Q1 total sales" SumOfDollar - $134,300.00 Field: Customer = Table: Sale Total: Group By Sort: Show: Criteria: or: 4 Field: Farmer Table: Purchase Total: Group By Sort: Show: Criteria: or: Field: Dollar amount Table: Sale Total: Sum Sort: Show: Criteria: or: Sale date Sale Where ✓ Dollar amount Sale Sum ✓Dollar amount Purchase Sum KI K Between #1/1/2018# And #3/31/2018 Query 4 "Q1 total purchases" SumOfDollar $56,300.00 Field: Dollar amount Table: Purchase Total: Sum Sort: Show: Criteria: or: Query 5 "Q1 approximate GM" Expr1 $78,000.00 Query 6 "Sale delivery mileage" Engine # SumOfDriver. E456789 E567123 E654987 E659847 E978653 Field: GM: [Total Sales]! [SumOfDollar amount]-[Total Purchases] [SumOfDollar amount] Table: Sort: Show: Criteria: or: 0 45.5 36.3 22 ✔ 25 30.7 S Purchase Date Purchase Where Field: Engine Table: Sale Between #1/1/2018# And #3/31/2018# Total: Group By Sort: Show: Criteria: or: S Driver time Sale Sum S > Query 7 "time spent rinsing" ▬▬▬ Employee So Time Rinsing . 11122333 123456789 234567891 987654321 999884321 99988777 Field: Employee Social Sec Time Rinsing: SumLabor acquisition][Total hours worked]Labor acquisition] [Percentage of time rinsing Table: Employee Total: Group By Expression Sort: Show: Criteria: or: Query 8 "Cost of rinsing" D 123456789 234567891 987654321 999884321 99988777 101.5 116.8 100.3 Employee So Cost Rinsing. 11122333 67.8 57.9 42.7 S $1,522.50 $1,693.60 $1,404.20 $1,017.00 $897.45 $640.50 ISI Field: Employee Social Securit Cost Rinsing: [Employee]![Employee wage rate]"[Time Spent Rinsing][Time Rinsing] Table: Employee Sort: Show: Criteria: or: S Query 9 "total sales by type" Produce ID SumOfQuant. F1 F2 F3 F4 F5 V1 V2 V3 V4 V5 10575 19125 14950 9700 12325 16400 22125 F2 F3 F4 F5 V1 V2 V3 V4 V5 12005 16170 11375 Query 10 "total purchases by type" Produce ID # SumOfQuant. 12200 19400 15650 11650 12400 16700 23700 12700 18500 11600 Field: Produce ID Table: Stockflow 2 Total: Group By Sort: Show: Criteria: or: ✔ Field: Produce ID Table: Stockflow 4 Total Group By Sort: Show: Criteria: or: ✓Quantity sold Stockflow 2 Sum M Quantity purchased Stockflow 4 Sum S Query 11 "total QOH by type" F2 F3 F4 F5 V1 GSSSS V2 V3 V4 V5 WECHASSSSS Produce ID. SumOfTotal ( 1400 200 575 1900 F2 Query 12 "spoilage by produce type" Produce ID. Expr1. Produce descr 225 Tomato 75 Watermelon 125 Strawberry 50 Blueberry 75 Raspberry 300 Boston lettuce 75 Potato F3 F4 FS V1 V2 V3 feldoe Tab Produce type sold Sert ON 0 0 1500 500 2300 0 195 Romaine lettuce 30 Onion 225 Mushroom Field: Produce ID Table: Produce Total: Group By Sort: Show: Criteria: or: S B Total QOH Produce Sum K spolage produce type purchased undantly purchase produce pe soumourity sol produce type on handunofotel que descriptio Query 1 "total sales by customer" Total Sales by Customer X Customer SumOfDollar. $47,100.00 $37,500.00 $37,600.00 $36,250.00 $34,200.00 $52,000.00 $42,700.00 $4,000.00 Query 2 "total purchases by farmer" C310 C311 C312 C313 C314 C315 C316 C500 Farmer SumOfDollar. F202 F203 F204 F205 F206 F207 F208 F209 $18,100.00 $17,500.00 $18,100.00 $19,500.00 $16,500.00 $13,700.00 $15,700.00 $7,800.00 Query 3 "Q1 total sales" SumOfDollar - $134,300.00 Field: Customer = Table: Sale Total: Group By Sort: Show: Criteria: or: 4 Field: Farmer Table: Purchase Total: Group By Sort: Show: Criteria: or: Field: Dollar amount Table: Sale Total: Sum Sort: Show: Criteria: or: Sale date Sale Where ✓ Dollar amount Sale Sum ✓Dollar amount Purchase Sum KI K Between #1/1/2018# And #3/31/2018 Query 4 "Q1 total purchases" SumOfDollar $56,300.00 Field: Dollar amount Table: Purchase Total: Sum Sort: Show: Criteria: or: Query 5 "Q1 approximate GM" Expr1 $78,000.00 Query 6 "Sale delivery mileage" Engine # SumOfDriver. E456789 E567123 E654987 E659847 E978653 Field: GM: [Total Sales]! [SumOfDollar amount]-[Total Purchases] [SumOfDollar amount] Table: Sort: Show: Criteria: or: 0 45.5 36.3 22 ✔ 25 30.7 S Purchase Date Purchase Where Field: Engine Table: Sale Between #1/1/2018# And #3/31/2018# Total: Group By Sort: Show: Criteria: or: S Driver time Sale Sum S > Query 7 "time spent rinsing" ▬▬▬ Employee So Time Rinsing . 11122333 123456789 234567891 987654321 999884321 99988777 Field: Employee Social Sec Time Rinsing: SumLabor acquisition][Total hours worked]Labor acquisition] [Percentage of time rinsing Table: Employee Total: Group By Expression Sort: Show: Criteria: or: Query 8 "Cost of rinsing" D 123456789 234567891 987654321 999884321 99988777 101.5 116.8 100.3 Employee So Cost Rinsing. 11122333 67.8 57.9 42.7 S $1,522.50 $1,693.60 $1,404.20 $1,017.00 $897.45 $640.50 ISI Field: Employee Social Securit Cost Rinsing: [Employee]![Employee wage rate]"[Time Spent Rinsing][Time Rinsing] Table: Employee Sort: Show: Criteria: or: S Query 9 "total sales by type" Produce ID SumOfQuant. F1 F2 F3 F4 F5 V1 V2 V3 V4 V5 10575 19125 14950 9700 12325 16400 22125 F2 F3 F4 F5 V1 V2 V3 V4 V5 12005 16170 11375 Query 10 "total purchases by type" Produce ID # SumOfQuant. 12200 19400 15650 11650 12400 16700 23700 12700 18500 11600 Field: Produce ID Table: Stockflow 2 Total: Group By Sort: Show: Criteria: or: ✔ Field: Produce ID Table: Stockflow 4 Total Group By Sort: Show: Criteria: or: ✓Quantity sold Stockflow 2 Sum M Quantity purchased Stockflow 4 Sum S Query 11 "total QOH by type" F2 F3 F4 F5 V1 GSSSS V2 V3 V4 V5 WECHASSSSS Produce ID. SumOfTotal ( 1400 200 575 1900 F2 Query 12 "spoilage by produce type" Produce ID. Expr1. Produce descr 225 Tomato 75 Watermelon 125 Strawberry 50 Blueberry 75 Raspberry 300 Boston lettuce 75 Potato F3 F4 FS V1 V2 V3 feldoe Tab Produce type sold Sert ON 0 0 1500 500 2300 0 195 Romaine lettuce 30 Onion 225 Mushroom Field: Produce ID Table: Produce Total: Group By Sort: Show: Criteria: or: S B Total QOH Produce Sum K spolage produce type purchased undantly purchase produce pe soumourity sol produce type on handunofotel que descriptio
Expert Answer:
1 Yes In the case of spoilage the supplier will charge the retailer for the entire period of the los... View the full answer
Students also viewed these accounting questions
-
If your answer to #1 above was yes, what do you think would happen to your taxes? What would happen to your private health insurance premiums? Would you come out ahead or not?
-
How would your answer to Problem 1 change if instead we use the long-run model, with shoes and computers produced using labor and capital?
-
What can we tell about a compound when we know the empirical formula? What additional information is conveyed by the molecular formula? By the structural formula? Explain in each case.
-
A mover lifts a 50 lbm box off the ground and places it on a truck (Figure 1-21). If the floor of the truck is 4 feet off the ground, how much work was required to lift the box? 4 ft 50 lbs...
-
Name each molecule. a. b. CI
-
The table contains data on the number of doses of an antihistamine sold per month in a small town. a. To sell 196 doses to customers, what will the price need to be? b. For stores to be willing to...
-
Modify Table 10-1 web site for to indicate whether each control listed there is preventive, detective, or corrective in nature. 10.2Table 10-1 suggests that restricting physical access to inventory...
-
Tom incorporates his sole proprietorship as Total Corporation and transfers its assets to Total in exchange for all 100 shares of Total stock and four $10,000 interest-bearing notes. The stock has a...
-
List three expense accounts related to payroll. Describe when you would expect the account to be cleared to zero. Explain the methods you could use to reconcile these accounts.
-
write a closed-research legal memo using the case cases given, addressing whether Mr. Adler can assert an adverse possession claim to Scrub Lot 40. Please write up your memo using the issue , brief...
-
Create a node class, followed by a queue class and create queue using the node class. void enque (int x) //inserts x at the top of queue int dequeue ( ) // removes top value from queue and returns...
-
9. Tectonic plates are large segments of the Earth's crust that move slowly. Suppose that one such plate has an average speed of 4.0 cm/year. (a) What distance does it move in 1 s at this speed? (b)...
-
Use the add-on method of calculating interest to find the total interest and the monthly payment. Amount of Loan $4400 Length of Loan 2 years The total interest is $ (Round to the nearest cent as...
-
What issues had to be settled between senator sarbanes and representative oxley?
-
In 2010, the criminal code was amended to include income tax evasion as a designated offence; explain the implication from both the criminal and law enforcement perspective.
-
1 at W=b+ PW represents the complex potential for an electricia 4 = x+ determine the sunction &
-
On January 1, Babcock Inc. issued $100,000 of 10-year, 4% bonds to yield an effective interest rate of 5%. Interest is paid semi-annually on January 1 and July 1. Calculate the issue price of the...
-
Why do markets typically lead to an efficient outcome for buyers and sellers?
-
Suppose the EEOC uses a job-scoring system and they determines that the wage rate for a secretary is $50 per hour, while the competitive labor market wage rate is $10 per hour. What is the effect of...
-
Identify two positive and two normative statements given concerning raising the minimum wage. List other minimum wage arguments not discussed in the Economics in Practice, and classify them as either...
-
How does government debt create a socially more inequitable distribution of income- redistribute income away from those with relatively lower incomes to those with relatively high income?
-
Number the following activities from 1 to 3 in the order corresponding to the typical flow of cost in a CPA firm. Record the time worked on a client project by professional staff. Record the...
-
At December 31, 2019, the end of its fiscal year, Kelly Metal Products Corporation collected the following data for 2019: Required Prepare a schedule of cost of goods manufactured and sold for Kelly...
-
Brooklyn Company reported the following amounts for October: Use Excel to prepare a schedule of cost of goods manufactured for October. Beginning raw materials inventory. Beginning work-in-process...
Study smarter with the SolutionInn App