Using linear regression, model the following data. The table contains world internet users in millions (Source: International Telecommunication Union; ICT database). Model the data as a linear function. Note the x and y are tabulated. Your answer needs to be an equation in the form y = mx + b

1

The Nowra Company has assembled the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Nowra Company has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation.

How is the cost function stated?

2

The Yeppoon Company uses the high-low method to estimate its cost function. The information for 2018 is provided below:

What is the constant for the estimating cost equation?

3

The cost components of an air conditioner include $35 for the compressor; $11.50 for the sheet moulded compound frame; and $80 per unit for assembly. The factory machines and tools cost is $55 000. The company expects to produce 1500 air conditioners in the coming year. What cost function best represents these costs?

4

V8 Engineering Pty used the following data to evaluate their current operating system. The company sells items for $14.50 each and had used a budgeted selling price of $15 per unit.

                                                                   Actual             Budgeted
        Units sold                                   206 000 units      200 000 units
        Variable costs                            $965 000               $950 000
        Fixed costs                                    $53 000                 $50 000

What is the static-budget variance of variable costs?

You are a partner in a medium-size CPA firm and want to convince your partners that your firm should update the way it conducts audits in order to become more competitive. Specifically, you believe the company should make use of up-to-date data analytics technology. Write a memo to your partners to explain what data analytics technology is and the advantages to using it. Chapter 10 (From Effective Writing A Handbook for Accountants by May) contains suggestions on memo organization and format. Submit your paper in PDF format and see Syllabus naming convention.

How to code the following function in C? (NOT C++)

int vehicleInsert(HashFile *pHashFile, Vehicle *pVehicle)

This function inserts a vehicle into the specified file.

• Determine the RBN using the driver's hash function.

• Use readRec to read the record at that RBN.

• If that location doesn't exist or the record at that location has a szVehicleId[0] == '\0': o Write this new vehicle record at that location using writeRec.

• If that record exists and that vehicle's szVehicleId matches, return RC_REC_EXISTS. (Do not update it.)

• Otherwise, return RC_SYNONYM. Note that in program #2, we will actually insert synonyms.

Create a C++ program that makes use of both concepts i.e. Array of structure and array within the structure by using the following guidelines:

1. Create an Array of 5 Structures of Student Records

2. Each structure must contain: a. An array of Full Name of Student b. Registration Number in proper Format i.e 18-SE-24 c. An array of Marks of 3 subjects d. Display that information of all students in Ascending order using “Name” e. Search a particular student and update its Marks of any particular subject.

Start by first: Write the code necessary to accept a date in the format (Alice:November,4,2020) and store it in a structure called birthday. (Define the structure, declare the variable, ask the user for input, and store the values in the structure. The month should be a character array, the day and year should be integers.)

Then, Declare a pointer name bdayptr to the type of structure you defined in the previous question. Have the pointer point to the structure you declared, and using the pointer, update the name to the Queen and day to the 31.

C++ Coding Please. Comment in code if you can. thank you!

Problem 21-6

The following facts pertain to a noncancelable lease agreement between Faldo Leasing Company and Bridgeport Company, a lessee.

Inception date January 1, 2017
Annual lease payment due at the beginning of
   each year, beginning with January 1, 2017 $117,768
Residual value of equipment at end of lease term,
   guaranteed by the lessee $50,000
Lease term 6 years
Economic life of leased equipment 6 years
Fair value of asset at January 1, 2017 $556,000
Lessor’s implicit rate 13 %
Lessee’s incremental borrowing rate 13 %

The lessee assumes responsibility for all executory costs, which are expected to amount to $4,800 per year. The asset will revert to the lessor at the end of the lease term. The lessee has guaranteed the lessor a residual value of $50,000. The lessee uses the straight-line depreciation method for all equipment.

Click here to view factor tables

Prepare an amortization schedule that would be suitable for the lessee for the lease term. (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and the final answer to 0 decimal places e.g. 58,971.)

BRIDGEPORT COMPANY (Lessee)
Lease Amortization Schedule
Date
Annual Lease
Payment Plus GRV
Interest on
Liability
Reduction of Lease
Liability
Lease Liability
1/1/17
$
$
$
$
1/1/17
1/1/18
1/1/19
1/1/20
1/1/21
1/1/22
12/31/22
$
$
$

Prepare all of the journal entries for the lessee for 2017 and 2018 to record the lease agreement, the lease payments, and all expenses related to this lease. Assume the lessee’s annual accounting period ends on December 31 and reversing entries are used when appropriate. All executory costs are paid as incurred. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places e.g. 58,971.)

Date
Account Titles and Explanation
Debit
Credit

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018
(To record the lease.)
(To record first lease payment.)

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018
(To record interest.)
(To record depreciation.)

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018
(To reverse the December 31 entry.)
(To record the second lease payment.)

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018

Jan. 1, 2017
During 2017
Dec. 31, 2017
Jan. 1, 2018
During 2018
Dec. 31, 2018
(To record interest.)
(To record depreciation.)

Janet, after years of working as a hairdresser and as a makeup artist, decided to go into business for herself. Over time the business has grown into a spa and beauty retreat and she now employs a few staff. With her growing operation she has identified the need to implement a computerized accounting information system. In order to have a system that meets her needs exactly and also to save cost, she has asked you to create a simple, customized solution for her business. Her immediate need is for a customer sales information system, so that is what you will now create. With customer service being so important to Janet, her customers tend to become regulars and she wants to maintain a record of each customer’s contact information and preferences so that the spa will know what is important to the customer without having to be told each visit. The customer information that Janet considers important to maintain is the full name, cellphone number, favourite treatment, and special considerations (e.g. some customers have allergies or require fragrance-free products). For employees, Janet just needs to record the names and cell phone numbers in the database. The spa also has a standard list of services which each have a standard name, description and price. Janet also wants a database record of each customer visit both for customer billing at the time of service, as well as for future analysis. Janet wants to refer to these sales transactions as “Visits” in the database in order to reflect the spa’s focus on customers’ experiences. For each of these customer visits it is important to record a unique visit identifier, the date, the customer, the main staff member who served the customer, and the service or services experienced (sold). ACCT 3015 Assignment 1 – This is an individual assignment Page 2 of 3 Your Assignment Note: You might find this and other Unit 3 references to be useful while completing this assignment: https://www.datanamic.com/support/lt-dez005-introduction-dbmodeling.html Please submit

Questions 1-3 in either Microsoft Word or PDF format, and Question 4 in Microsoft Access. Submit your files to the Assignment 1 dropbox before the deadline. This is worth 15% of your course grade.

Question 1 (3 points):Based on your analysis of Janet’s requirements, list out the entities and relationships that should be present in the database, indicating the cardinality of each relationship.

Question 2 (3 points): Create the Logical E-R data model

Question 3 (5 points): Create the Physical E-R data model, showing how you went from the Logical to the Physical using best practices.

Question 4 (4 points): Create the resulting accounting information system in LibreOffice Base (which is free) or in Microsoft Access.

Calculate the monthly returns for 08/01/2015 – 08/31/2019 period for

(iii) Chevron:

(iv) Intel:

(v) Tesla:

Baci is a well-known lollipops maker in Western Australia and produces lollipops in two size, i.e., regular and large. The company sells their products to convenience stores, fairs, schools for fundraisers and in bulk on the internet. 2018 summer is approaching and Baci is preparing its budget for the December. All Baci’s lollipops are hand-made, mostly out of sugar, and attached to wooden sticks. Expected sales are based on past experience.

Other information for December 2018 is as follows:

Input prices :

Direct materials:

Sugar $0.50 per kg

Sticks $0.30 each

Direct manufacturing labour $8 per direct manufacturing labour hour (DMLH)

Input quantities per unit of output

Regular Large

Direct materials:

Sugar 0.25 kg 0.5 kg

Sticks 1 1

Direct manufacturing labour hour (DMLH) 0.2 hour 0.25 hour

Set-up hours per batch 0.08 hour 0.09 hour

Inventory data for direct materials1

Sugar Sticks

Beginning inventory 125 kg 350

Target ending inventory 240 kg 480

Cost of beginning inventory $64 $105

1: Baci accounts for direct materials using a FIFO cost flow assumption.

Sales and inventory data for finished goods2

Regular Large

Expected sales in units 3,000 1,800

Selling price $3 $4

Target ending inventory in units 300 180

Beginning inventory in units 200 150

Beginning inventory in dollars $500 $474

2: Baci uses a FIFO cost flow assumption for finished goods inventory.

All the lollipops are made in batches of 10. Baci incurs manufacturing overhead cost, and marketing and general administration costs, but customers pay for shipping. Other 3 than manufacturing labour costs, monthly processing costs are very small. Baci uses activity-based costing (ABC) and has classified all overhead costs for December 2018 as follows:

Cost type Denominator activity Rate

Manufacturing:

Set-up Set-up hours $20 per set-up hour

Processing Direct manufacturing labour hour (DMLH) $1.70 per DMLH

Non-manufacturing:

Marketing & general admin Sales revenue 10%

Required 1. Prepare each of the following for December 2018:

(e) Manufacturing overhead cost budgets for processing and set-up activities

(f) Budgeted unit cost of ending finished goods inventory and ending inventories budget

(g) Cost of goods sold budget

(h) Marketing and general administration costs budget