|
Janus Products, Inc. is a merchandising company that sells binders, paper, and other school supplies. The company is planning its cash needs for the third quarter. In the past, Janus Products has had to borrow money during the third quarter to support peak sales of back-to-school materials, which occur during August. The following information has been assembled to assist in preparing a cash budget for the quarter: |
| a. | Budgeted monthly absorption costing income statements for July to October are as follows: |
| July | August | September | October | |||||
| Sales | $ | 45,000 | $ | 75,000 | $ | 55,000 | $ | 50,000 |
| Cost of goods sold | 26,000 | 44,000 | 32,000 | 29,000 | ||||
| Gross margin | 19,000 | 31,000 | 23,000 | 21,000 | ||||
| Selling and administrative expenses: | ||||||||
| Selling expense | 8,700 | 12,700 | 9,000 | 7,800 | ||||
| Administrative expense* | 5,900 | 7,700 | 6,600 | 6,400 | ||||
| Total selling and administrative expenses | 14,600 | 20,400 | 15,600 | 14,200 | ||||
| Net operating income | $ | 4,400 | $ | 10,600 | $ | 7,400 | $ | 6,800 |
| *Includes $2,250 depreciation each month. |
| b. | Sales are 20% for cash and 80% on credit. |
| c. |
Credit sales are collected over a three-month period, with 10% collected in the month of sale, 70% in the month following sale, and 20% in the second month following sale. May sales totalled $35,000, and June sales totalled $41,000. |
| d. |
Inventory purchases are paid for within 15 days. Therefore, 50% of a month’s inventory purchases are paid for in the month of purchase. The remaining 50% are paid in the following month. Accounts payable for inventory purchases at June 30 total $14,200. |
| e. |
The company maintains its ending inventory levels at 75% of the cost of the merchandise to be sold in the following month. The merchandise inventory at June 30 is $20,500. |
| f. | Land costing $4,750 will be purchased in July. |
| g. | Dividends of $1,250 will be declared and paid in September. |
| h. |
The cash balance on June 30 is $8,500; the company must maintain a cash balance of at least this amount at the end of each month. |
| i. |
The company has an agreement with a local bank that allows it to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $40,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. |
| 3. |
Prepare a cash budget for July, August, and September and for the quarter in total. (Roundup "Borrowing" and "Repayments" answers to the nearest whole dollar amount. Any "Repayments" and "Interest" should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) |
In: Accounting
A large university is well known for both its law school and its nursing program. The dean of the career services office wants to know if there is a difference in starting job salary between recently graduated law majors and nursing majors. The starting annual salaries for a random sample of 30 law majors and 30 nursing majors from the most recent graduating class are taken. Assume that the population standard deviation of the law majors' starting salaries is $12,000 and the population standard deviation of the nursing majors' starting salaries is $7,000, and that the starting salaries for both majors are normally distributed. Let the law majors' salaries be the first sample, and let the nursing majors' salaries be the second sample. The dean conducts a two-mean hypothesis test at the 0.05 level of significance, to test if there is evidence of a difference in average annual starting salary. H0:μ1=μ2; Ha:μ1≠μ2, which is a two-tailed test.
"Law Majors" Nursing Majors
72000 73000
66000 60000
78000 67000
46000 80000
72000 64000
54000 67000
68000 62000
33000 55000
73000 79000
59000 72000
59000 72000
62000 63000
71000 65000
47000 69000
41000 70000
67000 68000
49000 54000
59000 67000
54000 68000
90000 69000
39000 75000
88000 71000
61000 77000
59000 50000
69000 79000
62000 68000
66000 62000
63000 74000
69000 78000
42000 75000
The above table shows the starting annual salaries for a random sample of 30 law majors and 30 nursing majors from the most recent graduating class. Use Excel to test if the mean annual starting salaries are the same for both majors. Identify the test statistic, z, and p-value from the Excel output. Round your test statistic to two decimal places and your p-value to three decimal places.
Provide your answer below: test statistic = , p-value =
In: Statistics and Probability
A school is considering two different videos for a class. Students have been randomly assigned to two groups, and they all take the same written assignment after viewing the video. The scores are summarized below: Video 1: sample mean = 75, sample standard deviation = 7.7, sample size = 26 Video 2: sample mean = 79, sample standard deviation = 6.4, sample size = 26
Conduct an analysis to determine whether there is a difference in the test scores for the two videos. Provide the degrees of freedom. ROUND TO 4 DECIMAL PLACES.
In: Statistics and Probability
A school district establishes a vehicle repair shop that provides service to other departments, all of which are accounted for in its general fund. During its first year of operations the shop engages in the following transactions: It purchases equipment at a cost of $24 million and issues long-term notes for the purchase price. The useful life of the equipment is eight years, with no residual value. It purchases supplies at a cost of $4 million. Of these it uses $3 million. In its governmental funds, the district accounts for supplies on a purchases basis. It incurs $13 million in other operating costs. It bills other departments for $19 million. Prepare journal entries using general fund and prepare journal entries using internal service fund.
In: Accounting
Obesity in school-age children has increased substantially and affects nearly 20% of children. This is a serious condition that can have immediate negative effects that can follow a child through their entire life. Describe 6 environmental factors or other choices that increase the risk of obesity, 7 negative health effects associated with obesity, and 8 ways to prevent childhood obesity.
|
Environmental Factors/Choices that Lead to Obesity |
Negative Health Effects of Obesity |
Prevention of Obesity |
|
a) |
a) |
a) |
|
b) |
b) |
b) |
|
c) |
c) |
c) |
|
d) |
d) |
d) |
|
e) |
e) |
e) |
|
f) |
f) |
f) |
|
g) |
g) |
|
|
h) |
In: Biology
Alice is operating a small nonprofit that provides subsidized tutoring services to high school students in underserved areas. Approximately 60% of the direct costs of tutoring are billed to schools attended by the clients, while approximately 20% are billed directly to the students. The remainder comes from general operating funds provided by foundations and individual donations. Assume that Alice knows the following:
Based on this information, what would Alice expect the cash budget to show as direct operating receipts for the month of March?
In: Finance
System Administration Linux/Unix
This lab is for you to research and implement old school DNS for your virtualized environment
Currently, if you tried to ping your server01 by IP address (192.168.10.11), you would receive a response. If you tried to ping using its hostname "server01", it would result in "ping: hostname: Temporary failure in name resolution"
1) Research how and where to implement
2) Create the following entries:
192.168.10.1 router
192.168.10.11 SRV1
192.168.10.12 SRV2
192.168.10.13 client
3) Ensure these hostnames work from each VM and verify with screenshot(s).
A screenshot from each VM (except the router) should show the result of
ping router
ping srv1
ping srv2
ping client
In: Computer Science
Case Study
Win Vet High School is located in the heart of Sydney. It services students from Year eight (7) to Year twelve (12) in the local surrounding community.
Win Vet High School has hired you to create a front-end administrative website for updating student details to a database. The following are some notes that you have made following initial discussions with the principal and senior educational staff at Win Vet High School.
Based on the requirements you believe that at a minimum the following web pages need to be developed:
The website is to be written in HTML5, CSS, php using a MySQL database to store data. All web pages should be located within the same directory with any images to be stored in a sub-directory called “Images”. You have been supplied with an image called “Logo.png” which must be incorporated into all web pages. This is the high school’s logo as well as create a favicon to use for the website to ensure live presence.
Login web page
The Login web page should be the first web page that the user encounters when they visit the website. It is to contain a username and password fields and a login button to authenticate the user. The password field should also be masked.
|
Required value |
Validation required |
|
Username |
Required. Must be at least 6 characters. |
|
Password |
Required. Must be between 8 and 12 characters |
Student web page
At the top of the web page a personalised message should be displayed to the user. This message should read “Welcome <<user>>”, where <<user>> is the users name. This name should be retrieved from the stored value that was create from the users being able to use a registration form you will create. This will be displayed after the user logins into the system using the Login page.
Create different themes for different user types. An example is one theme for every guest user (a user that can access the website, student user and an administration user.
For each theme you need to create a skin and CSS file. The skin file should apply styling to the CSS styling each of the web pages while the CSS should apply styling to the HTML elements on the web page. The settings in the skin and CSS files have been left to you but there should be a visible difference between each theme based on its title.
Under this should be the functionality to be able to retrieve, add, edit and delete a student.
Each student should receive a unique student id from the system when they are first added. This should be provided by a New button. Once clicked the system should look up the current highest student id, add 1 to it and then use this as the student id value for the new student. The student id field should be between 1,000 and 10,0000.
To add a student, the user should click the Add button once they have filled out all of the relevant information about the student. At a minimum the user should provide the following information as shown in the following table for a new student.
|
Required value |
Validation required |
|
Their first name |
Required. Must be a string. |
|
Their surname |
Required. Must be a string. |
|
Their gender |
Required. Must be male or female. |
|
Their date of birth |
Required. Must be between the dates of 01/01/1950 and today's date. |
|
A street address |
Required. |
|
A suburb |
Required. Must be a string. |
|
A city |
Required. Must be a string. |
|
A post code |
Required. Must be between 0001 and 9999. |
|
A mobile number |
Required. Must be between eight and ten digits in length. |
|
An email address |
Required. Must be a valid email address. |
These details should be validated and then stored using MAMP MySQL database table so they can be accessed.
To retrieve, edit or delete an existing student the user should enter a valid student id, and then click an appropriate button (Retrieve, Update and Delete) to undertake the operation. Validation should occur to ensure that the student id exists for the student that is to be retrieved, deleted or have their details updated.
Usability functionality
As well as allowing a user to be able to change a theme the website should highlight which control the user is currently hovering the mouse cursor over. That is, when a user moves the mouse cursor over a control it should be highlighted in a different colour that none of the themes implement. Once the cursor is moved away from the control the highlighting should disappear.
QUESTION
Identify and report on attributes and determine data types that are required for your database ensuring that you undertake normalization of the attributes and draw the ERD Diagram as well
In: Computer Science
Suppose the chance of getting flu is independent of each other. Suppose 20% of graduate school students nationwide develop influenza. Further, suppose we have a class of size 15. Let X be the number of students who get flu, calculate the following probabilities:
1. Exactly 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.
a. 0.500
b. 0.188
c. 0.123
d. 0.818
2. No more than 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.
a. 0.500
b. 0.836
c. 0.001
d. 0.368
3. Less than 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.
a. 0.648
b. 0.846
c. 0.125
d. 0.684
4. How many students should the teacher expect to be sick with influenza that year? Which is the correct answer? The answer is NOT 3 students. There might be slight rounding differences. Please provide an explanation.
a. 2 students
b. 5 students
c. 1 student
d. 4 students
In: Statistics and Probability
Due to distance learning and less homework load in Peach Elementary School, parents are complaining that the average screen time is more than 3 hours per day for students in Grade 1 to Grade 3. The principal randomly selected 36 students from Grade 1 - Grade 3 and statistical summary is shown below. min 3 avg 5 max 8 std 2.5
Write the hypothesis in symbols or words Check the two conditions for CLT. Calculate the test statistics and the associated degrees of freedom Use the p-value or critical value approach to make your conclusion at 5% significance level.
In: Statistics and Probability