Question 1
A worksheet is composed of multiple workbooks.
True
False
Question 2
A1 contains 3 and A2 contains 4. Cell B2 contains = $A$1 ^
$A$1.
What value will cell C2 display if you copy the formula from cell
B2 to cell C2?
0
27
12
16
Question 3
Which of the following cannot be a cell reference?
cell1
B3
$C5
$F$3
none of the above is correct
Question 4
What are the 3 most common types of data that are used in a worksheet cell?
Group of answer choices
text, numbers, and formulas
text, numbers, and values
text, sheets, and formulas
names, values, and formulas
none of the above is correct
Question 5
If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =C2 - B5 + A1 in it, what is displayed in cell D1?
3
4
6
7
this formula has a syntax error in it
Question 6
If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has =2 * C2 -( B5 + A1) in it, what is displayed in cell D1?
2
4
7
11
none of the above is correct
Question 7
If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5
in it, and cell D1 has = 2 * (C2 - B5) + A1 in it, what is
displayed in cell D1?
4
5
10
11
none of the above is correct
Question 8
If cell A1 has a 2 in it, cell B5 has a 1 in it, cell C2 has a 5 in it, and cell D1 has = 2 * C2 - B5 + A1 in it, what is displayed in cell D1?
5
6
11
none of the above is correct
Question 9
In the formula below, which operator will a worksheet evaluate
first?
=A2+B2*(2-5/C3)
=
+
*
-
/
Flag this Question
Question 10
In the formula below, which operation will a worksheet perform
first?
=A2+B2*2-5/C3
=
+
*
-
/
Question 11
If cell A1 has 3 in it, cell B2 has 2 in it, what is the value
displayed in cell B3 if it contains the following formula?
= 2*A1^B2+1
216
37
19
3
none of the above
Question 12
Which of the choices below is the correct way to express the mathematical value π in a worksheet?
p
pi
=pi
=PI
=PI()
Question 13
If A1 has 3 in it and A2 has 5 in it, what is the value in cell
B3 if it contains the following formula?
=SQRT( A1 + 3 * A2 - 2 )
1.73...
2.236...
2.828...
3.46...
4
Question 14
Which formula below is a correct implementation of the square root of the sum of the squares of B2 and C3?
Group of answer choices
=SQRT( B2 + C3 )
=SQRT( B2 ^ 2 + C3 ^ 2)
=SQRT( B2 + C3 ) ^ 2
=SQRT( B2 ^ 2 ) + SQRT( C3 ^ 2 )
none of the above
Question 15
Which is the correct formula in a spreadsheet program to calculate x in the equation 10x = 27?
=LOG10( 27 )
=SIN( 27 )
=LOG( 10, 27 )
=LN ( 20 )
none of the above
Question 16
Which of the following is NOT an acceptable range in a worksheet?
F2:G4
G, H
A1:A3
B3:B1
Question 17 1 pts
The formula below is in cell C5. If the formula is copied and
pasted into D6, how will it appear?
= A1^(2-B2)
Group of answer choices
= B2^(2-C3)
= A1*(2-B2)
= C5^(2-D6)
= A1^(2-B2)
none of the above
Question 18
Which formula below has a syntax error in it?
= A2 + A3 - EXP( A4 )
= A2 + A3 - SQRT( A3 - A4 )
= LOG10(A2 + A3 - LOG10( A4 )
= A2 + 3 * A3 - PI()
= LN( SQRT( A2 + A3 - A4) )
Question 19
A spreadsheet has -2 in cell A3 and 4 in cell B7. Exactly what
will be displayed in cell C5 if it contains
exactly the following (be
careful!):
B7/A3
Group of answer choices
0
-2
2
B7/A3
Question 20
In a worksheet, cell A1 contains 5 and A2 contains miles. What is displayed in cell B4 if it contains the formula
=A1 + A2?
5miles
5 miles
A1 + A2
error message
5
In: Computer Science
Short Answer Writing Assignment All answers should be complete sentences.
In the Week 2 Lab, you found the mean and the standard deviation for the SLEEP variable for both males and females. Use those values for follow these directions to calculate the numbers again.
(From Week 2 Lab: Calculate descriptive statistics for the variable Sleep by Gender. Sort the data by gender by clicking on Data and then Sort. Copy the Sleep of the males from the data file into the Descriptive Statistics worksheet of the Week 1 Excel file. [Write down the mean and standard deviation.] These are sample data. Then, copy and paste the female data into the Descriptive Statistics workbook and do the same. Keep three decimal places.)
| 7 | M |
| 7 | F |
| 5 | F |
| 7 | F |
| 6 | F |
| 8 | F |
| 7 | F |
| 8 | F |
| 5 | M |
| 8 | M |
| 8 | F |
| 4 | F |
| 8 | F |
| 8 | M |
| 6 | M |
| 8 | M |
| 8 | M |
| 8 | M |
| 7 | F |
| 10 | M |
| 6 | F |
| 7 | M |
| 8 | F |
| 5 | F |
| 8 | F |
| 7 | F |
| 7 | M |
| 4 | M |
| 9 | M |
| 8 | M |
| 7 | F |
| 7 | M |
| 8 | M |
| 8 | M |
| 10 | M |
You will also need the number of males and the number of females in the dataset. You can actually count these in the dataset. Then use the Week 5 spreadsheet to calculate the following confidence intervals. The male confidence interval would be one calculation in the spreadsheet and the females would be a second calculation.
1. Give and interpret the 95% confidence intervals for males and a second 95% confidence interval for females on the SLEEP variable. Which is wider and why?
2. Give and interpret the 99% confidence intervals for males and a second 99% confidence interval for females on the SLEEP variable. Which is wider and why? We need to find the confidence interval for the SHOE SIZE variable. To do this, we need to find the mean and standard deviation with the Week 1 spreadsheet. Then we can the Week 5 spreadsheet to find the confidence interval. This does not need to be separated by males and females, rather one interval for the entire data set. First, find the mean and standard deviation by copying the SHOE SIZE variable and pasting it into the Week 1 spreadsheet. Write down the mean and the sample standard deviation as well as the count. Open the Week 5 spreadsheet and type in the values needed in the green cells at the top to find the confidence interval.
3. Give and interpret the 95% confidence interval for the size of students’ shoes. Change the confidence level to 99% to find the 99% confidence interval for the SHOE SIZE variable.
4. Give and interpret the 99% confidence interval for the size of students’ shoes.
5. Compare the 95% and 99% confidence intervals for the size of students’ shoes. Explain the difference between these intervals and why this difference occurs.
6. Find the mean and standard deviation of the DRIVE variable by copying that variable into the Week 1 spreadsheet. Use the Week 4 spreadsheet to determine the percentage of data points from that data set that we would expect to be less than 25. To find the actual percentage in the dataset, sort the DRIVE variable and count how many of the data points are less than 25 out of the total 35 data points. That is the actual percentage. How does this compare with your prediction? Mean: ______________ Standard deviation: ____________________ Predicted percentage: Actual percentage: Comparison ___________________________________________________ ______________________________________________________________
7. What percentage of data would you predict would be between 25 and 50 and what percentage would you predict would be more than 50 miles? Use the Week 4 spreadsheet again to find the percentage of the data set we expect to have values between 25 and 50 as well as for more than 50. Now determine the percentage of data points in the dataset that fall within each of these ranges, using same strategy as above for counting data points in the data set. How do each of these compare with your prediction and why is there a difference? Predicted percentage between 25 and 50: ______________________________ Actual percentage: Predicted percentage more than 50 miles: Actual percentage: ___________________________________________ Comparison ____________________________________________________ _______________________________________________________________ Why? __________________________________________________________ ________________________________________________________________
In: Statistics and Probability
October
1. S.Erickson invested $50,000 cash, a $16,000 pool equipment, and $12,000 of office equipment in the company.
2. The company paid $4,000 cash for five months’ rent.
3. The company purchased $1,620 of office supplies on credit from Todd’s Office Products.
5. The company paid $4,220 cash for one year’s premium on a property and liability insurance policy.
6. The company billed Deep End Co $4,800 for services performed in installing a new pool
8. The company paid $1, 620 cash for the office supplies purchased from Todd’s Office Products on October 3.
10. The company hired Julie Kruitas a part-time assistant for $136 per day, as needed.
12. The company billed Deep End Co another $1,600 for services performed.
15. The company received $4,800 cash from Deep End Co as partial payment on its account.
17. The company paid $750 cash to repair pool equipment that was damaged when moving it.
20. The company paid $1,958 cash for advertisements published in the local newspaper.
22. The company received $1,600 cash from Deep End Co. on its account.
28. The company billed Happy Summer Corp $6,802 for consulting services performed.
31. The company paid $952 cash for Julie Kruit’s wages for seven days’ work.
31. S.Erickson withdrew $3,500 cash from the company for personal use.
November
1. The Company reimbursed S. Erickson in cash for business automobile mileage allowance (Erickson logged 1,500 miles at $0.32 per mile).
2. The company received $5,630 cash from Underground Inc. for consulting services performed.
5. The company purchased office supplies for $1,325 cash from Todd’s Office Products.
8. The company billed Slides R Us $7,568 for services performed.
13. The company agreed to perform future services for Henry’s Pool and Spa Co. No work has been performed.
18. The company received $2,802 cash from Happy Summer Corp as partial payment of the October 28 bill.
22. The company donated $450 cash to the United Way in the company’s name.
24. The company completed work and sent a bill for $4,800 to Henry’s Pool and Spa Co.
25. The company sent another bill to Happy Summer Corp for the past-due amount of$4,000.
28. The company reimbursed S. Erickson in cash for business automobile mileage(1,300miles at $0.32 per mile).
30. The company paid cash to Julie Kruit for 14 days’ work.
30. S.Erickson withdrew $1,500 cash from the company for personal use.
December
2. Paid $1,200 cash to West Side Mall for Splashing Around’s share of mall advertising costs.
3. Paid $350 cash for minor repairs to the company’s pool equipment.
4. Received $ 4,800 cash from Henry’s Pool and Spa Co. for the receivable from November.
10. Paid cash to Julie Kruit for six days of work at the rate of $136 per day.
14. Notified by Henry’s Pool and Spa Co. that Splashing Around’s bid of $10,000 on a proposed project has been accepted. Henry’s paid a $6,500 cash advance to Splashing Around
15. Purchased $1,400 of office supplies on credit from Todd’sOffice Products.
16. Sent a reminder to Slides R Us to pay the fee for services recorded on November 8.
20. Completed a project for Underground Inc and received $6,545 cash.
22–26. Took the week off for the holidays.
28. Received $4,500 cash from Slides R Us on its receivable.
29. Reimbursed S.Erickson for business automobile mileage (500 miles at $0.32 per mile).31.S.Erickson withdrew $2,500 cash from the company for personal use
Prepare an income statement for the three months ended December 31, 2019
Prepare a statement of owner’s equity for the three months ended December 31, 2019
Prepare a classified balance sheet as of December 31, 2019
Record the closing entries for Splashing Around
Post the closing entries to the general ledger under "closing entry"
Prepare a post-closing trial balance as of December 31, 2019.
In: Accounting
We need to find the confidence interval for the SLEEP variable. To do this, we need to find the mean and standard deviation with the Week 1 spreadsheet. Then we can the Week 5 spreadsheet to find the confidence interval.
First, find the mean and standard deviation by copying the SLEEP variable and pasting it into the Week 1 spreadsheet. Write down the mean and the sample standard deviation as well as the count. Open the Week 5 spreadsheet and type in the values needed in the green cells at the top. The confidence interval is shown in the yellow cells as the lower limit and the upper limit.
| Sleep (hours) |
| 7 |
| 7 |
| 5 |
| 7 |
| 6 |
| 8 |
| 7 |
| 8 |
| 5 |
| 8 |
| 8 |
| 4 |
| 8 |
| 8 |
| 6 |
| 8 |
| 8 |
| 8 |
| 7 |
| 10 |
| 6 |
| 7 |
| 8 |
| 5 |
| 8 |
| 7 |
| 7 |
| 4 |
| 9 |
| 8 |
| 7 |
| 7 |
| 8 |
| 8 |
| 10 |
In the Week 2 Lab, you found the mean and the standard deviation for the HEIGHT variable for both males and females. Use those values for follow these directions to calculate the numbers again.
| Height (inches) |
| 61 |
| 62 |
| 63 |
| 63 |
| 64 |
| 65 |
| 65 |
| 66 |
| 66 |
| 67 |
| 67 |
| 67 |
| 67 |
| 68 |
| 68 |
| 69 |
| 69 |
| 69 |
| 69 |
| 69 |
| 69 |
| 69 |
| 70 |
| 70 |
| 70 |
| 70 |
| 70 |
| 71 |
| 71 |
| 71 |
| 73 |
| 73 |
| 74 |
| 74 |
| 75 |
(From Week 2 Lab: Calculate descriptive statistics for the variable Height by Gender. Click on Insert and then Pivot Table. Click in the top box and select all the data (including labels) from Height through Gender. Also click on “new worksheet” and then OK. On the right of the new sheet, click on Height and Gender, making sure that Gender is in the Rows box and Height is in the Values box. Click on the down arrow next to Height in the Values box and select Value Field Settings. In the pop up box, click Average then OK. Write these down. Then click on the down arrow next to Height in the Values box again and select Value Field Settings. In the pop up box, click on StdDev then OK. Write these values down.)
You will also need the number of males and the number of females in the dataset. You can either use the same pivot table created above by selecting Count in the Value Field Settings, or you can actually count in the dataset.
Then use the Week 5 spreadsheet to calculate the following confidence intervals. The male confidence interval would be one calculation in the spreadsheet and the females would be a second calculation.
|
Mean ______________ Standard deviation ____________________ Predicted percentage ______________________________ Actual percentage _____________________________ Comparison ___________________________________________________ ______________________________________________________________ |
|
Predicted percentage between 40 and 70 ______________________________ Actual percentage _____________________________________________ Predicted percentage more than 70 miles ________________________________ Actual percentage ___________________________________________ Comparison ____________________________________________________ _______________________________________________________________ Why? __________________________________________________________ ________________________________________________________________ |
In: Math
On October 1, 2016, Adria Lopez launched a computer services company called Success Systems, which provides consulting services, computer system installations, and custom program development. Adria adopts the calendar year for reporting purposes and expects to prepare the company's first set of financial statements on December 31, 2016. The company's initial chart of accounts and transactions follows. Account No. Account No. Cash 101 Common Stock 307 Accounts Receivable 106 Dividends 319 Computer Supplies 126 Computer Services Revenue 403 Prepaid Insurance 128 Wages Expense 623 Prepaid Rent 131 Advertising Expense 655 Office Equipment 163 Mileage Expense 676 Computer Equipment 167 Miscellaneous Expenses 677 Accounts Payable 201 Repairs Expense - Computer 684 Oct. 1 Adria Lopez invested $55,000 cash, a $20,000 computer system, and $8,000 of office equipment in the company in exchange for its common stock. The company paid $3,300 cash for four months' rent. (Hint: Debit Prepaid Rent for $3,300.) The company purchased $1,420 of computer supplies on credit from Harris Office Products. The company paid $2,220 cash for one year's premium on a property and liability insurance policy. (Hint Debit Prepaid Insurance for $2,220.) The company billed Easy leasing $4,800 for services performed in installing a new Web server. 8 The company paid $1,420 cash for the computer supplies purchased from Harris Office Products on October 3. 10 The company hired Lyn Addie as a part-time assistant for $125 per day, as needed. 12 The company billed Easy leasing another $1,400 for services performed. 15 The company received $4,800 cash from Easy Leasing as partial payment on its account. 17 The company paid $805 cash to repair computer equipment that was damaged when moving it. 20 The company paid $1,940 cash for advertisements published in the local newspaper. 22 The company received $1,400 cash from Easy Leasing on its account. 28 The company billed IFM Company $5,208 for services performed. 31a The Company paid $875 cash for Lyn Addie's wages for seven days' work. 31b The Company paid $3,600 cash in dividends. Nov. 1 The Company reimbursed Adria Lopez in cash for business automobile mileage allowance (Lopez logged 1,000 miles at $0.32 per mile). 2 The company received $4,633 cash from Liu Corporation for computer services performed. 5 The company purchased computer supplies for $1,125 cash from Harris Office Products. 8 The company billed Gomez Co. $5,668 for services performed. 13 The company received notification from Alex's Engineering Co. that Success Systems' bid of $3,950 for an upcoming project is accepted. 18 The company received $2,208 cash from IFM Company as partial payment of the October 28 bill. 22 The company donated $250 cash to the United Way in the company's name. The company completed work for Alex's Engineering Co. and sent it a bill for $3,950. The company sent another bill to IFM Company for the past-due amount of $3,000. 28 The company reimbursed Adria Lopez in cash for business automobile mileage (1,200 miles at $0.32 per mile). 30a The Company paid $1,750 cash for Lyn Addie's wages for 14 days' work. 30b The Company paid $2,000 cash in dividends. Required: Using Micro Soft Excel and Word: Prepare journal entries to record each of the above transactions for Success Systems. (If no entry is required for a particular transaction, select "No journal entry required” in the first account field.) Post the journal entries to ledger accounts. (Add additional ledger accounts when necessary.) Prepare a trial balance as of the end of November. (Trial Balance total $ 108,659) (Be sure to show formulas in your worksheets.) This question has been posted but the answer is wrong please review and help thanks I found the mistake in the answer the 11/2 transaction shoud be cash debit revenue credit your welcome!
In: Accounting
If you have a chance please answer as many as possible, thank you and I really appreciate your help experts!
Question 16 2 pts
In a hypothesis test, the claim is μ≤28 while the sample of 29 has a mean of 41 and a standard deviation of 5.9. In this hypothesis test, would a z test statistic be used or a t test statistic and why?
| t test statistic would be used as the sample size is less than 30 |
| t test statistic would be used as the standard deviation is less than 10 |
| z test statistic would be used as the mean is less than than 30 |
| z test statistic would be used as the sample size is greater than 30 |
Flag this Question
Question 17 2 pts
A university claims that the mean time professors are in their offices for students is at least 6.5 hours each week. A random sample of eight professors finds that the mean time in their offices is 6.2 hours each week. With a population standard deviation of 0.49 hours, can the university’s claim be supported at α=0.05?
| No, since the test statistic is in the rejection region defined by the critical value, the null is rejected. The claim is the null, so is not supported |
| Yes, since the test statistic is not in the rejection region defined by the critical value, the null is not rejected. The claim is the null, so is supported |
| Yes, since the test statistic is in the rejection region defined by the critical value, the null is not rejected. The claim is the null, so is supported |
| No, since the test statistic is not in the rejection region defined by the critical value, the null is rejected. The claim is the null, so is not supported |
Flag this Question
Question 18 2 pts
A credit reporting agency claims that the mean credit card debt in a town is greater than $3500. A random sample of the credit card debt of 20 residents in that town has a mean credit card debt of $3619 and a standard deviation of $391. At α=0.10, can the credit agency’s claim be supported?
| Yes, since p-value of 0.09 is less than 0.55, reject the null. Claim is alternative, so is supported |
| No, since p-value of 0.09 is greater than 0.10, fail to reject the null. Claim is alternative, so is not supported |
| Yes, since p-value of 0.19 is greater than 0.10, fail to reject the null. Claim is null, so is supported |
| No, since p-value of 0.09 is greater than 0.10, reject the null. Claim is null, so is not supported |
Flag this Question
Question 19 2 pts
A car company claims that its cars achieve an average gas mileage of at least 26 miles per gallon. A random sample of eight cars from this company have an average gas mileage of 25.6 miles per gallon and a standard deviation of 1 mile per gallon. At α=0.06, can the company’s claim be supported?
| No, since the test statistic of -1.13 is close to the critical value of -1.24, the null is not rejected. The claim is the null, so is supported |
| Yes, since the test statistic of -1.13 is not in the rejection region defined by the critical value of -1.77, the null is not rejected. The claim is the null, so is supported |
| Yes, since the test statistic of -1.13 is not in the rejection region defined by the critical value of -1.55, the null is rejected. The claim is the null, so is supported |
| No, since the test statistic of -1.13 is in the rejection region defined by the critical value of -1.77, the null is rejected. The claim is the null, so is not supported |
Flag this Question
Question 20 2 pts
A researcher wants to determine if extra homework problems help
8th
grade students learn algebra. One 8th grade class has
extra homework problems and another 8th grade class does
not. After 2 weeks, the both classes take an algebra test and the
results of the two groups are compared. To be a valid matched pair
test, what should the researcher consider in creating the two
groups?
| That the group without extra homework problems receives different instruction |
| That the group with the extra homework problems has fewer after school activities |
| That each class has similar average IQs or abilities in mathematics |
| That each class of students has similar ages at the time of the testing |
In: Math
Can someone just answer 8 A B C D and E please!!!
Regression Analysis (Excel 2010 & 2007)
1. Open a new Excel worksheet (which will be saved as REGRESSION.xlsx). In cell A1 type your name. In cell A2 type the course and section number (i.e. ECON225-01). In cell A3 type the date. Skip cell A4. In cell A5 type “Assignment: Regression Analysis”. In cell A6 type “File: REGRESSION.xlsx”.
2. Type X in cell B8 and type Yin cell C8. Type Miles in cell B9 and type Minutes in cell C9.
In cells B10 through B18 enter the following values:
11, 10, 15, 7, 3, 6, 9, 12, 5
In cells C10 through C18, enter the following data values:
28, 27, 35, 15, 8, 14, 20, 29, 13
Center format cells B8 through C18 for a more professional appearance.
3. Click on the Datatab in the toolbar, then select Data Analysis. Next, select Regressionfrom the Analysis Tools and click on OK. In the Regression dialog boxes type C10:C18in the Input Y Range dialog box, then type B10:B18in the Input X Range dialog box. Under Output Options select Output Range and type A20:I40in the output range dialog box. Click onOK. A Summary Output table will appear.
4. Select cell D27 and type Forecast for Y when X = 13: Next select cell G27, then click on the Formulas tabin the toolbar, then select More Functions. Under the Function category select Statistical. Under the Function name select FORECAST. In the dialog boxes type 13in the X dialog box, type C10:C18in the Known Y’s dialog box, and type B10:B18in the Known X’s dialog box. Click on OK. The forecasted value for Y when X=13 will appear in cell G27.
5. Return to the Home tab in the toolbar. Select the columns of X and Y data values from B10 through C18(do not select their headings). Next, click on the Insert tabin the toolbar, under Charts select Scatter, then select the first choice of a scatter diagram graph. Resize and reposition the scatter diagram to the location of cell E9 for the top left corner of the diagram, and cell I 22 for the bottom right corner of the diagram. (This will allow everything to fit on one printed page.) Delete the “Series 1” label box. You can label the axes with the variable names (Miles and Minutes) by clicking on the outside corner of the graph, then select Axis Titles in the toolbar. Label both the X and Y axes of the graph with their appropriate variable names.
(Instructions continue on the next page.)
6. Next, click any place inside of the scatter diagram. Under the Analysis options, click on Trendline,thenselectLinear Trendline. Click on OK. A trend line will be added to the scatter diagram. Do a Print Preview to make sure that your graph fits onto the printed page.
7. Save your worksheet on a disk as REGRESSION.xlsx and print-out the worksheet to submit to the instructor.
8. In addition to submitting a print-out of the worksheet(s), also submit typed answers to the following questions, referencing the data in your print-out and your textbook or Notes:
(a) What is the regression equation for this data set? (Write the printed “a” and “b” values into the equation. Hint: Under the Coefficient column the value for the Intercept is the value for “a” and the X Variable value is the value for “b”.)
(b) Interpret the printed value for “a” relative to its definition, the X and Y variable names, and its value.
(c) Interpret the printed value for “b” relative to its definition, the X and Y variable names, and its value.
(d) Interpret the printed value for “r” relative to its definition, the X and Y variable names, and its value. (**Hint: Under the Regression Statistics section the Multiple R value is the correlation coefficient and the R Square value is the Coefficient of Determination. The printed table value for “r” does not always indicate direction (+ or -), therefore, check that the sign for your “r” value agrees with the sign for your “b” value.)
(e) Interpret the printed value for “r2” relative to its definition, the X and Y variable names, and its value.
In: Math
20. A weakness of many struggling retailers this year may be due to the cost of operating too many branch stores with their high overhead - on top of the pandemic.
True or False
21. Warby Parker is a socially conscious accessories and apparel company that has built a global movement connecting customers to social change.
True or False
22. Demographics include population or consumer statistics regarding socioeconomic factors such as age, income, gender, occupation, education, family size, etc.
True or False
23. The three basic service levels in brick-n-mortar retailers are self-service, self selection and phone service.
True or False
25. Product depth is the variety within each assortment category, with a deep assortment having many sizes or color offerings while a shallow assortment has few size or color offerings.
True or false
26. A commissary store is a retailer that serves the environment in which it is housed, such as a hair/nail salon or gift shop in a hotel lobby.
True or false
27. A big box retail location is a mixed-use property where one building can house retail/ restaurants/gyms/offices/ services on lower levels, and apartments/condos above on upper floors.
True or false
30. Shop! Retail Environments is an example of a trade periodical while Inc. Magazine is an example of a consumer periodical.
True or false
31. A broad assortment contains many styles of a product category , while a narrow assortment contains few styles.
True or false
32. A liquid asset is a reference to cash on hand or an asset that can be readily converted to cash; a non-liquid asset is not readily converted to cash – i.e., property, as there is no guarantee it will sell within a certain time period.
True or false
33. The three major levels of retail competition are Product Field, Subfield and Assets/Liabilities.
True or false
34. Referring to Ilse Metchek's guest presentation, The California Fashion Association (CFA) is the Business-to-Business (B2B) forum for California's Apparel and Textile Industries.
True or false
35. Consumers being shown the breakdown of the retail price of the products they buy - what the labor, materials, duties and transport as well as the store's profit - is known as retail vision.
True or false
In: Economics
You are opening a landscaping business, and wish to estimate your levered cost of equity. Beatrice's Yard Maintenance has an equity beta of 1.5, and a D/E ration of 0.7. If the riskless rate is 0.04, the expected return on the S&P500 is 0.16, and your firm will have a D/E ratio of 1, what would your firm's levered cost of equity be if the tax rate is 0.28? Please give your answer in the form of a decimal to 2 places - if your answer is 10.5%, please enter 0.105.
In: Finance
madtack Company’s beginning and ending inventories for the month of July are
|
July 1 |
July 30 |
||||
|
|
|
||||
|
Direct materials |
$ 67,000 |
$ 62,000 |
|||
|
Work-in-process |
145,000 |
171,000 |
|||
Production data for the month of July follows:
|
Direct labor |
$200,000 |
|
Direct materials purchased |
163,000 |
Madtack has one overhead cost account and assigns overhead to production based on direct labor cost. The predetermined allocation rate is 0.7. The company formally reconciles over- or underapplied overhead at year end.
What are the costs of good manufactured for July?
In: Accounting