Reference no: EM133433679
Question 1) Join the Orders and Sales table with the Orders and Sales Items table. Include the following fields in the query: order#, order_date, customer#, order_emp#, sale_date, truck_vin, cash_receipt#, store#, inventory#, qty_ordered, qty_sold, sale_price. Limit sales to the first quarter of 2022 beginning on January 1 and ending on March 31, by entering BETWEEN #1/1/2022# AND #3/31/2022# for the sale_date field in the Criteria row of the query by example grid. How many records are there in your query?
Question 2) Continue with the same query; return to design view. Create a new field called item amount to calculate the sale amount for each item by multiplying quantity sold (qty_sold) times sale price (sale_price). Return to datasheet view, select Home > Records > Totals to add the total row to datasheet view. What is the sum of values in the item amount field? (Round your answer to 2 decimal places.)
Question 3) Join the Purchase Flowers table with the Purchase Flowers Items table. Include the following fields in the query: purchase#, purchase_date, grower#, purch_emp#, truck_vin, store#, check#, inventory#, qty_purch, purchase_price. Limit purchases to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
Question 4) Continue with the same query; return to design view. Create a new field called purchase item amount to calculate the purchase amount for each item by multiplying quantity purchased (qty_purch) times price (purchase_price). Return to datasheet view, select Home > Records > Totals to add the total row to datasheet view. What is the sum of values in the purchase item amount field? (Round your answer to 2 decimal places.)
Question 5) Join the Timecards table with the Payroll table. Include the following fields in this query: timecard#, timecard_date, reg_time_hours, overtime_hours, emp#, supv_emp#, store#, check#, check_date, gross pay, emp_fica, employer_fica, emp_mc, employer_mc, fed_tax_wh, state_tax_wh, net_pay_to_employee. Limit timecard records to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
Question 6) Use the Purchase Misc table. Limit purchases to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?
Question 7) Compute the truck depreciation expense for the quarter (one fourth of the annual depreciation) for each store. Note that this is completed with two queries: 1) calculate the quarterly depreciation for each truck, and 2) sum the quarterly depreciation amount by store. What is the truck depreciation for the first quarter of 2022 for the Miami, FL, store?
Question 8) Compute the quarterly store depreciation for each store. What is the store depreciation expense for the first quarter of 2022 for the Philadelphia, PA, store?
(continues on the next page)
Question 9) Use the query prepared for question 2 and join it with the Stores table. Compute the sum of sales revenue (store revenue) for each store in the first quarter of 2022. What was the revenue for the Pheonix, AZ, store in the first quarter?
Question 10) Use the query prepared for question 4 and join it with the Stores table. Compute the cost of goods sold (COGS) (the sum of flower purchases, since YNF maintains no inventory) for each store in the first quarter of 2022. What was the total COGS/purchases for the Seattle, WA, store in the first quarter?
Question 11) Use the query prepared for question 5. Compute the payroll expense, including employer FICA and MC contributions, for each store in the first quarter of 2022. What was the total payroll expense for the San Diego, CA, store in the first quarter?
Question 12) Use the query prepared for question 6 and join it with the Stores table. What was the total administrative/miscellaneous expense for the Portland, OR, store in the first quarter 2022?
Question 13) Use the queries prepared for questions 9 and 10 to compute revenue and cost of goods sold for each store. Join them with the Stores table by store# and compute gross profit (revenue minus cost of goods sold) dollars and percentage (gross profit divided by revenue) for each store in the first quarter of 2022. What was the gross profit (dollars) for the San Francisco, CA, store for the first quarter?
Question 14) What was the gross profit percentage for the New York, NY, store in the first quarter? (Round your percent to 2 decimal places.)
Question 15) Use the queries prepared for questions 7, 8, 11, 12, and 13 to compute the income before taxes (gross profit minus payroll expense minus admin expense minus truck depreciation expense minus store depreciation expense) and the income percent of sales in the first quarter of 2022. What was the amount of income before taxes for the store that had the highest income before taxes (dollars) in the first quarter?
Question 16) What was the income percent of sales for the Washington, DC, store in the first quarter? (Round your percent to 2 decimal places.)
Question 17) how to Create a new query to present overall income statement information for Y Not Flowers (use the query prepared for question 15). What was the total revenue for YNF in the first quarter of 2022?
Question 18) What was the total income before tax for Y Not Flowers in the first quarter of 2022?
(continues on the next page)
Question 19) What was the overall gross profit percentage (percent of sales) for Y Not Flowers in the first quarter of 2022? (Round your percent to 2 decimal places.)
Question 20) What was the overall net profit percentage (income before taxes as a percent of sales) for Y Not Flowers in the first quarter of 2022? (Round your percent to 2 decimal places.)
Question 21) What was YNF's cash balance (total cash) as of January 1, 2022?
Question 22) What was the total amount YNF disbursed (paid) to growers during the first quarter of 2022?
Question 23) What was the total amount Y Not Flowers disbursed to miscellaneous/admin vendors during the first quarter of 2022?
Question 24) What was the total amount YNF disbursed for payroll expenses during the first quarter of 2022?
Question 25) What was the cash balance (cash on Jan 1 plus cash received minus cash disbursed for growers, administrative expense, and payroll) for Y Not Flowers as of March 31, 2022?
Question 26) What was YNF's accounts receivable balance as of March 31, 2022?
Question 27) What was YNF's current assets value as of March 31, 2022?
Question 28) What was YNF's net store value (net of accumulated depreciation including the depreciation in the first quarter of 2022) as of March 31, 2022?
Question 29) What was YNF's net trucks value (net of accumulated depreciation including the depreciation in the first quarter of 2022) as of March 31, 2022?
Question 30) What was YNF's total assets (including cash, accounts receivable, and fixed assets (stores and trucks) as of March 31, 2022?
Question 31) What was Y Not Flowers' accounts payable to growers as of March 31, 2022?
Question 32) What was Y Not Flowers' accounts payable to miscellaneous vendors as of March 31, 2022?
(continues on the next page)
Question 33) What was Y Not Flowers' accounts payable for payroll as of March 31, 2022?
Question 34) What was YNF's total liabilities as of March 31, 2022?
Question 35) What was YNF's total equity as of March 31, 2022?