Project Description: In this project, you will use a database to answer questions about student publications at a college. You will import an Excel spreadsheet as a new table in the database, create a relationship between two tables, and create queries using numeric, compound, and wildcard criteria using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query.   Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded file named go_a02_grader_h2_Student_Publications.accdb. 0 2 Import the records from the downloaded Excel file named go_a02_grader_h2_Student_Papers.xlsx as a new table named…

Project Description: In this project, you will create database objects to track the inventory of new computer parts used by the Computer Club. You will create a table and import data from Excel to create a second table. You will create a simple query, a form, and a report. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded file named a01_grader_a1_Computer_Club.accdb, enable the content, and then open the Inventory table. 0 2 Beginning in the second column of the Inventory table and using the specified data types, create the following fields (in this order): Part (Short Text), Room (Short Text), Cabinet Location (Short Text),…

Background Info The tvseries.xlsx workbook contains eight (8) worksheets (Sheet1 to Sheet7 and Original Data worksheets). Sheet1 worksheet contains excerpts of TV series information with the advertisement cost (values in dollar) for each 30 seconds time slot during the show in 2018 and 2019. You are tasked to complete this worksheet with the necessary formula and charts, as well as make it presentable. Sheet2 to Sheet7 worksheets serve different purposes, you will need to prepare them for each of those intended purposes as listed. Original Data worksheet contains the copy of the original data used in worksheets Sheet2 to Sheet7. If you need a fresh copy, you can duplicate this worksheet and rename it accordingly. Do not make any changes to…

Wombat company has identified the following overhead activities, costs and cost drivers for the coming year:   Activity  Expected costs Cost driver  Activity capacity Setup costs           $60,000 No. of setups              300 Ordering costs           45,000 No. of orders           4,500 Machine costs           90,000 Machine hours        18,000 Receiving           25,000 No. of parts        50,000   The following two jobs were completed during the year:   Job 600 Job 700 Direct material  $       750  $       850 Direct labour (50 hours per job)  $       600  $       600 Units completed 100 50 Number of setups 1 1 Number of orders 4 2 Machine hours 20 30 Parts used 20 40   The company's normal activity is 4000 direct labour hours…

On 1 July 2019 Ethan Ltd acquired 90% the issued shares of Davis Ltd for $ 3,832,000. The equity of Davis Ltd at this date consisted of: Share capital: $ 1,341,000 Retained earnings: $ 575,000 General reserve: $ 460,000 All the identifiable assets and liabilities of Davis Ltd were recorded at amounts equal to their fair values at acquisition date except for the following: Account Cost Carrying Amount Fair Value Future life-in Year Inventories   575,000 1,035,000   Land   1,150,000 2,070,000   Vehicle 1,609,000 1,341,000 2,414,000 5 Fittings 60,425 56,950 63,900 5 Liabilities (Contingent)   0 50,000     All inventories on hand at 1 July 2019 are sold by 30 June 2020. Further life of the assets are listed…

Sanshain Construction Company has entered into a contract beginning January 1, 2019, to build a parking complex. It has been estimated that the complex will cost $600,000 and will take 3 years to construct. The complex will be billed to the purchasing company at $900,000. The following data pertain to the construction period. Items 2019 2020 2021 Costs incurred to date $270,000 $450,000 $610,000 Estimated costs to complete 330,000 150,000 –0– Billings to date 270,000 550,000 900,000 Collections to date 240,000 500,000 900,000 Instructions Using the percentage-of-completion method, compute the estimated gross profit that would be recognized during each year of the construction period. Record the necessary journal entry each year. Prepare the partial income statement and statement of financial position…

Question 1 Retail operations and retail inventory ‘Kites Galore’ began business on 1 October 2019.  The business is owned and operated by Harry Smith as a sole-trader.  The business will sell kites via an online store.  The business is registered for GST.  The following transactions occurred during October 2019: Date: Details: 1 Oct Harry Smith deposited $20,000 into the business bank account. 5 Oct Kites Galore purchased of 50 kites on account for $2,750 ($55 per kite, including GST) from the kite manufacturer, Super Kites Ltd, on terms of 2/10, n/30. 7 Oct Kites Galore received an invoice from Star Track Freight Ltd relating to delivery costs for the kites purchased on 5 October.  The amount due is $110 (including GST),…

Sweden Ltd manufactures cabinets.  You work in the accounting department and have been tasked with preparing the Budget for the next month.   Sweden makes two products: Premium cabinets - large cabinets with mirrors De Luxe cabinets - medium sized cabinets with an innovative shelving solution and mirrors   Direct manufacturing labour is 3 hours for the Premium cabinet and 5 hours for the De Luxe.   The budgeted direct material usage for each product in 2020 is: Square metres     Premium        De Luxe Mirrors                               2                      3 Softwood                           1                      5   Opening direct materials inventory for January 2020 is: Square metres                 Premium        De Luxe Mirrors                              …

Question 1 a.      Your twin daughters will be starting high school next year and they have indicated they wish to attend university when they finish school in six (6) years time. You have no current savings and anticipate that it will cost approximately $90,000 in total for both children. Your financial institution has offered you a 6% p.a. (compounded quarterly). How much to you need to deposit to your bank account each quarter in order to save the total amount required before your children commence university? b.  Due to the recent decrease in overseas demand for used plastics for recycling, your company has decided to invest into recycling technologies. The used plastics will be recycled into pellets to sell…