The data presented in worksheet 4 is the results of a 4-year study conducted to assess how age, weight, and gender influence the risk of diabetes. Risk is interpreted as the probability (times 100) that the patient will have diabetes over the next 4-year period.
a) What predictive model you suggest to relate risk of diabetes to the person’s age, weight and the gender. Why? b)Develop an estimated multiple regression model that relates risk of diabetes to the person’s age, weight, gender and life style. Present the regression formula as a mathematical equation. Interpret the coefficients of the regression and comment on the strength of the regression.
c) What is the risk percentage of diabetes over the next 4 years for a 52-year-old woman living in a small town with 80 kg weight?
| Age | Weight (Kg) | Gender | Life style | Risk (%) |
| 56 | 80 | Female | Small town | 38 |
| 27 | 79 | Male | Big city | 23 |
| 80 | 85 | Female | Country | 67 |
| 91 | 91 | Female | Small town | 71 |
| 59 | 67 | Male | Big city | 45 |
| 74 | 84 | Female | Country | 54 |
| 56 | 81 | Female | Small town | 48 |
| 73 | 68 | Male | Small town | 49 |
| 83 | 82 | Female | Big city | 65 |
| 81 | 69 | Male | Big city | 59 |
| 74 | 71 | Male | Big city | 56 |
| 73 | 80 | Female | Small town | 59 |
| 70 | 77 | Male | Country | 46 |
| 80 | 90 | Female | Big city | 64 |
| 63 | 59 | Male | Country | 39 |
| 85 | 102 | Female | Big city | 73 |
| 69 | 87 | Male | Small town | 63 |
| 83 | 98 | Male | Big city | 87 |
| 65 | 85 | Female | Country | 52 |
| 62 | 95 | Male | Big city | 61 |
| 79 | 69 | Male | Big city | 59 |
| 57 | 77 | Female | Small town | 46 |
| 81 | 51 | Male | Big city | 64 |
| 72 | 60 | Male | Country | 64 |
In: Statistics and Probability
1. Han Industries Inc. constructed a building and acquired five assets during the current year.
Construction of Building: Han constructed a building on land that it purchased last year at a cost of $240,000. Construction began on March 1 and was completed on October 1. The payments to the contractor were as follows.
Date Payment
March 1 $360,000
July 1 275,000
October 1 325,000
Han obtained a $700,000, 8% construction loan on March 1. Han repaid the loan on October 1. Han had $400,000 of other outstanding debt during the year at a borrowing rate of 9%.
Asset 1: Han acquired office furniture by making a $7,500 down payment and issuing a $10,000, 2-year, zero-interest-bearing note. The note is to be paid off in two $5,000 installments made at the end of the first and second years. It was estimated that the asset could have been purchased outright for $16,200.
Asset 2: Han acquired manufacturing equipment by trading in used manufacturing equipment. (The exchange lacks commercial substance.) Facts concerning the trade-in are as follows.
Cost of equipment traded in $52,000
Accumulated depreciation on equipment
|
traded in - to date of sale |
34,000 |
|
Fair value of equipment traded |
25,000 |
|
Cash received |
2,500 |
|
Fair value of equipment acquired |
22,500 |
Asset 3: Four computers were acquired by issuing 500 shares of $1 par value common stock. The stock had a market price of $12 per share.
Assets 4 and 5: Han purchased these assets together for a lump sum of $230,000 cash. The following information was gathered.
Initial Cost onDepreciation to Date onBook Value on
DescriptionSeller's Books Seller's Books Seller's BooksAppraised Value
|
Forklifts |
$75,000 |
$20,000 |
$55,000 |
$50,000 |
|
Equipment |
180,000 |
40,000 |
140,000 |
165,000 |
|
Trucks |
65,000 |
15,000 |
50,000 |
35,000 |
Instructions
Record the acquisition of each of these assets.
In: Accounting
Joan’s Golf Shop Ltd. had the following transactions involving
current liabilities in its first year of operations:
| 1. | The company ordered golf equipment from suppliers for $545,000, on credit. It paid $500,000 to suppliers during the year. | |
| 2. | The shop has seven employees, who earn gross wages of $231,000 for the year. From this, the company deducted 20% for income taxes, $11,400 in CPP premiums, and $3,770 in EI premiums before distributing the cheques to the staff. As an employer, Joan was also required to match the employees’ CPP premiums and pay $5,278 in EI premiums. Eleven-twelfths of the amounts due to the government (all except the last month) were paid before the end of the year. | |
| 3. | The company gives customers a one-year warranty against defects on golf clubs. Management estimated that warranty costs would total 2% of sales. Sales of golf clubs for the year were $1,100,000. During the year, the company spent $13,800 on refunds under the warranty. | |
| 4. | Some customers order very expensive, custom-made golf clubs. In these cases, the company requires them to pay a deposit of 50% of the selling price when the order is placed. During the year, deposits totalling $22,000 were received for custom orders. None of these orders have been delivered yet. |
A) Prepare journal entries to record the transactions.
1a. To record purchase of inventory on account
1b. To record payment to supplier
2a. To record payment to staff
2b. To record employer's liabilities
2c. To record payment to government
3a. To record warranty expense
3b. To record warranty payments
4.
B) Prepare the current liabilities section of the statement of financial position as it would appear at the end of the year.
In: Accounting
You collect the following information on a sample of 100 adults:
The data set can be found in Mod9-1Data. Run the multiple regression in Minitab. Assume a level of significance of 5%.
| Lottery | Educ | Age | Children | Inc1000 |
| 5 | 15 | 50 | 2 | 41 |
| 7 | 10 | 26 | 0 | 22 |
| 0 | 13 | 40 | 3 | 24 |
| 10 | 9 | 46 | 2 | 20 |
| 5 | 14 | 40 | 3 | 32 |
| 5 | 15 | 39 | 2 | 42 |
| 3 | 8 | 36 | 3 | 18 |
| 0 | 16 | 44 | 1 | 47 |
| 0 | 20 | 47 | 4 | 85 |
| 6 | 10 | 52 | 1 | 23 |
| 0 | 18 | 51 | 2 | 61 |
| 0 | 17 | 41 | 2 | 70 |
| 12 | 9 | 42 | 2 | 22 |
| 7 | 12 | 53 | 1 | 27 |
| 11 | 9 | 72 | 1 | 25 |
| 2 | 16 | 38 | 2 | 43 |
| 11 | 12 | 41 | 5 | 34 |
| 2 | 14 | 50 | 3 | 53 |
| 7 | 9 | 41 | 3 | 20 |
| 0 | 16 | 52 | 0 | 71 |
| 10 | 9 | 41 | 2 | 16 |
| 8 | 10 | 45 | 3 | 19 |
| 1 | 16 | 58 | 0 | 64 |
| 11 | 11 | 53 | 0 | 25 |
| 7 | 14 | 61 | 2 | 31 |
| 3 | 17 | 30 | 1 | 42 |
| 5 | 17 | 40 | 0 | 50 |
| 9 | 11 | 73 | 3 | 31 |
| 5 | 15 | 43 | 4 | 35 |
| 10 | 9 | 49 | 3 | 18 |
| 7 | 10 | 50 | 0 | 26 |
| 10 | 10 | 27 | 1 | 23 |
| 1 | 17 | 46 | 3 | 39 |
| 4 | 14 | 47 | 1 | 22 |
| 7 | 14 | 47 | 3 | 31 |
| 8 | 12 | 28 | 1 | 29 |
| 8 | 14 | 26 | 1 | 29 |
| 3 | 17 | 32 | 2 | 30 |
| 5 | 16 | 42 | 5 | 21 |
| 3 | 11 | 53 | 1 | 26 |
| 0 | 17 | 46 | 1 | 66 |
| 8 | 14 | 33 | 3 | 29 |
| 3 | 16 | 52 | 0 | 48 |
| 8 | 11 | 58 | 3 | 20 |
| 0 | 18 | 28 | 3 | 80 |
| 7 | 10 | 53 | 2 | 31 |
| 7 | 14 | 43 | 1 | 26 |
| 0 | 16 | 49 | 2 | 36 |
| 7 | 9 | 38 | 1 | 26 |
| 9 | 10 | 44 | 0 | 21 |
| 8 | 9 | 32 | 1 | 24 |
| 0 | 12 | 44 | 3 | 18 |
| 7 | 10 | 52 | 0 | 28 |
| 0 | 16 | 40 | 2 | 42 |
| 8 | 11 | 53 | 6 | 21 |
| 7 | 8 | 43 | 2 | 28 |
| 8 | 17 | 23 | 0 | 27 |
| 8 | 12 | 21 | 0 | 34 |
| 7 | 9 | 50 | 3 | 28 |
| 9 | 12 | 46 | 1 | 30 |
| 5 | 7 | 82 | 0 | 23 |
| 0 | 20 | 45 | 3 | 95 |
| 0 | 11 | 23 | 0 | 22 |
| 11 | 9 | 40 | 3 | 27 |
| 8 | 12 | 36 | 3 | 23 |
| 0 | 10 | 42 | 1 | 29 |
| 9 | 7 | 36 | 0 | 25 |
| 7 | 14 | 58 | 3 | 25 |
| 0 | 16 | 36 | 0 | 28 |
| 8 | 9 | 37 | 2 | 25 |
| 6 | 10 | 53 | 2 | 27 |
| 7 | 17 | 42 | 2 | 39 |
| 0 | 19 | 50 | 4 | 63 |
| 8 | 11 | 33 | 0 | 28 |
| 8 | 11 | 27 | 3 | 29 |
| 0 | 16 | 30 | 2 | 34 |
| 7 | 11 | 40 | 2 | 19 |
| 6 | 13 | 32 | 2 | 22 |
| 8 | 11 | 69 | 2 | 17 |
| 0 | 17 | 24 | 0 | 34 |
| 1 | 17 | 32 | 2 | 44 |
| 6 | 8 | 21 | 0 | 28 |
| 0 | 19 | 31 | 2 | 53 |
| 10 | 11 | 53 | 1 | 16 |
| 9 | 14 | 43 | 1 | 22 |
| 5 | 14 | 39 | 1 | 27 |
| 0 | 7 | 37 | 2 | 22 |
| 10 | 8 | 57 | 1 | 23 |
| 10 | 10 | 31 | 1 | 24 |
| 13 | 8 | 71 | 0 | 11 |
| 6 | 15 | 59 | 3 | 50 |
| 7 | 15 | 33 | 3 | 37 |
| 3 | 11 | 33 | 3 | 24 |
| 0 | 11 | 41 | 3 | 30 |
| 5 | 12 | 53 | 3 | 21 |
| 0 | 16 | 35 | 1 | 53 |
| 0 | 17 | 54 | 0 | 31 |
| 10 | 9 | 55 | 2 | 29 |
| 6 | 16 | 24 | 0 | 36 |
| 11 | 12 | 56 | 3 | 27 |
null hypothesis for the test on the slope/coefficient on AGE-
alternative hypothesis=
computed test statistic=
table test statistic=
p-value=
statistical conclusion=
Predicted percentage of income spent of lottery tickets for a person with 12 years of education; 20 years old; 0 children; and an income of $25,000.=
null hypothesis for valid regression test=
alternative hypothesis for valid regression=
computed test statistic for the useful regression test=
table test statistic for the valid regression test=
p-value for the valid regression test=
statistical conclusion for the valid regression test=
In: Statistics and Probability
S & Y are partners with profit sharing ratio as 2:1. The position of the firm 31st December 2004 when they decided to dissolve the business was as follows:
| Liabilities | Rs. | Assets | Rs. | |
|---|---|---|---|---|
| Sundry Creditor | 1,50,000 | Plant & Machinery | 2,50,000 | |
| General Reserve | 1,00,000 | Furniture | 40,000 | |
| Capital Accounts: | Stock | 1,00,000 | ||
| S quad2,20,000 | Debtors | 2,00,000 | ||
| Y quad2,20,000 | 4,40,000 | Cash at bank | 1,00,000 | |
| Total | 6,90,000 | Total | 6,90,000 |
The details or realization was as follows:
1. S took over plant & machinery and furniture at book value less 10%
2. Y took over the stock at Rs. 1,75,000
3. Debtors realized Rs. 1,85,000
4. Sundry creditors were settled at a discount of 5%
Required: Prepare necessary journal entries and ledger accounts to close the books of the firm.
In: Other
Recall from Activities 16-1 and 16-3 that the Kaiser Family Foundation commissioned an extensive survey in 2004 that investigated the degree to which American youths aged 8–18 have access to various forms of media. Of the 1036 girls in the sample, 64% had a television in their bedrooms, compared to 72% of the 996 boys in the sample.
a. Suppose you want to use these sample results to produce a 95% confidence interval for πg - πb. Describe in words what πg - πb represents.
b. Calculate this interval, and interpret what it reveals. Be sure to mention whether the interval contains all negative values, all positive values, or some of each.
c. Calculate a 99% confidence interval for πg - πb. Comment on how its midpoint and width compare to the 95% interval
note: TT= pi
In: Statistics and Probability
On January 4, 2016, Spandella Company purchased 168,000 shares of Filington Company directly from one of the founders for a price of $27 per share. Filington has 560,000 shares outstanding, including the shares acquired by Spandella Company. On July 2, 2016, Filington paid $717,000 in total dividends to its shareholders. On December 31, 2016, Filington reported a net income of $963,000 for the year. Spandella uses the equity method in accounting for its investment in Filington.
Required:
| A. | Provide the Spandella Company journal entries for the transactions involving its investment in Filington Company during 2016. Refer to the Chart of Accounts for exact wording of account titles. |
| B. | Determine the December 31, 2016, balance of the Investment in Filington Company Stock account. |
In: Accounting
In: Operations Management
Multiple Choice 1
Data differ from information in which way?
a. Data are facts about a sale
b. Information is data organized to provide meaning
c. Data are meaningful bits of information
d. There is no difference
Multiple Choice 2
Which of the following is not a characteristic that makes information useful?
a. It is reliable
b. It is timely
c. It is inexpensive
d. It is relevant
Multiple Choice 3
What information needs are generally associated with the acquire inventory business process?
a. Market Analysis
b. Vendor Performance
c. Inventory status reports
d. All of the above
Multiple Choice 4
Which transaction cycle includes interactions between an organization and its suppliers?
a. Revenue cycle
b. Expenditure cycle
c. Human resources/payroll cycle
d. General ledger and reporting system
Multiple Choice 5
In which cycle does a company ship goods to customers?
a. Production cycle
b. Financing cycle
c. Revenue cycle
d. Expenditure cycle
Multiple Choice 6
Which of the following is a function of an AIS?
a. Reducing the need to identify a strategy and strategic position.
b. Transforming data into useful information.
c. Allocating organizational resources.
d. Automating all decision making.
Multiple Choice 7
An AIS provides value by:
a. improving products or services through information that increases quality and reduces costs
b. providing timely and reliable information to decision makers
c. creating new products
d. both A and B
Multiple Choice 8
The value chain concept is composed of the following two types of activities:
Primary and secondary
Primary and support
Support and value
Technology and support
Multiple Choice 9
Which of the following is a primary activity in the value chain?
a. Purchasing
b. Accounting
c. Post-sales service
d. Human resource management
Multiple Choice 10
Which of the following is a support activity in the value chain?
a. Purchasing
b. Manufacturing
c. Post-sales service
d. Receiving materials
In: Accounting
Prepare a Bank Reconciliation Statement from the information provided and prepare adjusting Journal Entries.
The information below relates to the Cash account in the ledger of Bramble Company.
| Balance September 1—$17,010; | Cash deposited—$64,500. | |
| Balance September 30—$17,664; | Checks written—$63,846. |
The September bank statement shows a balance of $16,682 on September 30 and the following memoranda.
Credits | Debits | |||||
|---|---|---|---|---|---|---|
Collection of $1,621 note plus interest $39 | $1,660 | NSF check: Richard Nance | $555 | |||
Interest earned on checking account | $54 | Safety deposit box rent | $74 |
At September 30, deposits in transit were $4,580, and outstanding checks totaled $2,513

In: Accounting