Lab 2_Problems & Exercises (3)
.xlsx
keyboard_arrow_up
School
Curtin University *
*We aren’t endorsed by this school
Course
1000
Subject
Accounting
Date
Jan 9, 2024
Type
xlsx
Pages
24
Uploaded by ChiefGiraffeMaster910
The lab 2 Problems, Textbook Chapter 2, Pages 75-85
Essential problems to be done in class with your Tutor
Extension problems to be attempted if you want a challenge.
(To unhide any extension activities you might want to explore, for example
Right-click tab 2.1 below, Left-click "Unhide", then choose a P&E you want to Hint: These are solutions worksheets that contain the data with
formatting, formulas, sometimes a screenshot from the textbook
Lab Learning Modules in the ECOM1000 Blackboard Site have
the original data files, you should in all cases use the original data
and do the problem yourself for the best learning!
Unhide)
Airbnb Samples
(Naming data and using the "AVERAGE" function)
Sample Room Rates
Sample Observations
Average
Accomodation 1
$159
$162
$125
$75
$329
$170
Accomodation 2
$400
$70
$250
$125
$115
$192
Accomodation 3
$48
$200
$120
$90
$100
$112
Accomodation 4
$65
$89
$190
$50
$220
$123
Accomodation 5
$200
$109
$69
$70
$129
$115
Accomodation 6
$150
$100
$101
$89
$180
$124
Accomodation 7
$170
$175
$120
$199
$190
$171
Accomodation 8
$130
$139
$288
$99
$89
$149
Accomodation 9
$100
$200
$300
$150
$59
$162
Accomodation 10
$115
$150
$120
$470
$225
$216
Accomodation 11
$110
$56
$155
$55
$230
$121
Accomodation 12
$92
$150
$150
$150
$65
$121
Accomodation 13
$149
$144
$320
$105
$114
$166
Accomodation 14
$295
$88
$120
$149
$98
$150
Accomodation 15
$149
$95
$141
$100
$169
$131
Accomodation 16
150
160
170
180
190
170
As for Problem 2.1 define the Row names this time and use a formula to calculate the average of Samples 1-15 in column G
Select a row of data to see the range name in the Name box (e.g., B4:F4).
Click on a formula in column G to see the range names applied.
Th
has
wit
G1
Th
on
you
for
Av
See
an
try
Sample Room Rates
Sample Observations
Accomodation 1
$159
$162
$125
$75
$329
$170
Accomodation 2
$400
$70
$250
$125
$115
$192
Accomodation 3
$48
$200
$120
$90
$100
$112
Accomodation 4
$65
$89
$190
$50
$220
$123
Accomodation 5
$200
$109
$69
$70
$129
$115
Accomodation 6
$150
$100
$101
$89
$180
$124
Accomodation 7
$170
$175
$120
$199
$190
$171
Accomodation 8
$130
$139
$288
$99
$89
$149
Accomodation 9
$100
$200
$300
$150
$59
$162
Accomodation 10
$115
$150
$120
$470
$225
$216
Accomodation 11
$110
$56
$155
$55
$230
$121
Accomodation 12
$92
$150
$150
$150
$65
$121
Accomodation 13
$149
$144
$320
$105
$114
$166
Accomodation 14
$295
$88
$120
$149
$98
$150
Accomodation 15
$149
$95
$141
$100
$169
$131
Accomodation 16
150
160
170
180
190
$170
he average calculation formula s been removed and replace th the answer in cells G4 to 18.
he Unit Coordinator has pasted nly the answer values here and u should try to write the rmulas to calculate these verages.
e the Solutions worksheet for nswers if you are unsuccessful ying to write the formulas.
Qu. After leaving Curtin University you become an AirBnB Investor and Property M
How does the average foom rate for your 15 properties help you make decisio
What type of decisions might it help you with?
help inform on how to price each room
Manager
ons?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Could i have this answer in formula version?
arrow_forward
Please see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.
arrow_forward
Is this an equation I have deducted from an answer provided by a tutor? If it is right, what is it for because I’ve since been given these other formulas in the second pic
arrow_forward
I'm not sure if I did my calculations correctly for Aug 3.
arrow_forward
4
arrow_forward
myOpenMath
Course Messages Forums Calendar | Gradebook
Home > Math 173-4 Spring 2024> Assessment
Quiz 2 (Sec. 1.5-1.7)
54 points possible 5/12 answered
Question 6
The graph of the function
y = f(x - 39)
can be obtained from the graph of
y = f(x)
by one of the following actions:
> Next Question
Home | My
Oshifting the graph of f(x) to the right 39 units
shifting the graph of f(x) to the left 39 units
shifting the graph of f(x) upwards 39 units
shifting the graph of f(x) downwards 39 units
arrow_forward
-vera fonda@student.pms..
Course: Intro Fin Acc- Bus 28
WileyPLUS
Exercise 9-5 (Part Level Submission)
Math Problem Solver and Caiculator
Print by: 13111810287 Vera Maria Fonda
50077495-50077495MJNV1W09_C:Intro Fin Acc - Bus 28 / Chapter 9a
*Exercise 9-5 (Part Level Submission)
Windsor Bus Lines uses the units-of-activity method in depreciating its buses. One bus was purchased on January 1, 2017, at a cost of R$245,210. Over its 7-year useful life, the bus is expected to be
driven 170,600 miles. Residual value is expected to be R$14,900.
V Your answer is correct.
Compute the depreciable cost per unit. (Round answer to 2 decimal places, e.g. e.50.)
Depreciation cost per unit
RSL.35
per mile
Attempts: 1 of 2 used
Mari
1181
*(b)
Prepare a depreciation schedule assuming actual mileage was 2017, 42,900; 2018, 49,500; 2019, 42,300; and 2020, 35,900. (Round answers to o decimal places, e.g. 2,125 except Depreciation
Cost /Unit.)
reen Sh
1222
End of Year
Computation
Annual
Accumulated…
arrow_forward
NSPIRON
متوقف مؤقتا
elearn.squ.edu.om/mod/quiz/review.php?attempt=D16687
G... Obs -Jblicyl .lyI all zihll Go
SQU E-LEARNING SYSTEM (ACADEMIC) E-LEARNING SERVICES SQU LIBRARIES SQU PORTALATTENDANCE
The correct answer is: OMR 35,200
Question
10
Company XYZ is currently producing AND selling 10,000 units of product A. At this level, the total product cost was $60,000.
This included $10,000 direct materials, $20,000 direct labor and $30,000 manufacturing overhead cost, which included 20%
variable manufacturing overhead cost. The selling and administrative expenses were $100,000, which included $60,000
variable selling and administrative costs. Assume that the selling price per unit $20, how much was the total contribution
margin?
Theorrect
Mark0.00 out of
2.00
Flag
question
a. $134,000
b. None of the given answers
C. $40,000
d. $104,000
e. $194,000
The correct answer is: $104,000
Windows
Finish review
ENG
II
...
arrow_forward
Info is in 1st slide, question in 2nd. Thanks a lot!
arrow_forward
A CSUF Portal
E MyLab and Mastering
P Do Homework - Chapter 8 Hon x
->
->
a mathxl.com/Student/PlayerHomework.aspx?homeworkld=606850034&questionld=1&flushed%3false&cld%3D6647439&back=https://www.mathxl.com/Student/DOAS..
Update
Financial Management I
Shaheen Behbehani a
10/25/21 8:33 PM
Question 2, P 8-8 (similar...
HW Score: 0%, 0 of 10 points
E Homework: Chapter 8 Homework
O Points: 0 of 1
Save
Part 1 of 3
Your factory has been offered a contract to produce a part for a new printer. The contract would last for 3 years and your cash flows from the contract would be $4.93 million per year. Your upfront setup costs to be ready to produce the part would
be $7.91 million. Your discount rate for this contract is 7.6%.
a. What does the NPV rule say you should do?
b. If you take the contract, what will be the change in the value of your firm?
a. What does the NPV rule say you should do?
The NPV of the project is $ million. (Round to two decimal places.)
Clear All
Check Answer
Help Me Solve…
arrow_forward
whats the answer for number 2
arrow_forward
Chapter 2: Applying Excel: Excel Worksheet (Part 1 of 2)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text.
Enter formulas in the cells that contain question marks. For example, in cell B25 enter the formula "=B10".
After entering formulas in all of the cells that contained question marks, verify that the amounts match the example in the text.
Check your worksheet by changing the total fixed manufacturing overhead cost for the Milling Department in the Data area to $300,000, keeping all other data the same as in the original example. If your worksheet is operating properly, the total cost of Job 407 should now be $2,350. If you do not get this answer, find the errors in your worksheet and correct them.
You should proceed to the requirements below only after completing your worksheet.
Save your completed Applying Excel form…
arrow_forward
Please note: You can draw your trees either by hand on paper or in Excel. If you do it on a
paper, please take a picture of the tree and insert it in your solution file. You can submit
your solution as an Excel file or Word document. In either case, your solution should
contain your decision trees and all necessary calculations (not just the results of
calculations).
Problem 1. The WHN Company
Problem.
The WHN Company is going to introduce one of the three new products: a widget, a hummer, or a nimnot. The market
condition could be favorable, stable, or unfavorable with the probabilities 0.2, 0.5, and 0.3 respectively. The monetary
outcomes for each product under each condition are described in the following table:
Unfavorable
$120,000 $70,000 -875,000
$40,000 $20,000
$30,000 $30,000
Favorable
Stable
Widget
Hummer $60,000
Nimnot $35,000
Create a decision tree to identify which new product should be introduced in order to maximize the company's profit?
arrow_forward
Can you help solve this problem. I have one more try.
arrow_forward
CAN YOU HELP ME SOLVE THIS QUESTION
arrow_forward
MindTap - Cengage Learning
CengageNOWv2 | Online teachin x
9 Cengage Learning
b Answered: CengageNOWv2| Onli x
i v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Ch 13-2 Practice Exercises
E Calculator
eBook
Show Me How
Print Item
Reporting Stockholders' Equity
Using the following accounts and balances, prepare the Stockholders' Equity section of the balance sheet using Method 1 of Exhibit 8. 50,000 shares of common stock authorized, and 2,000 shares have been reacquired.
Common Stock, $80 par
$3,200,000
Paid-In Capital from Sale of Treasury Stock
64,000
Paid-In Capital in Excess of Par-Common Stock
440,000
Retained Earnings
1,728,000
Treasury Stock
42,000
Stockholders' Equity
Paid-In Capital:
Common Stock, $80 Par
3,200,000
Excess over par
440,000
Treasury Stock
From Sale of Treasury Stock
64,000
Total Paid-in Capital
$ 3,704,000
Retained Earnings
Total
Treasury Stock
Total Stockholders' Equity
Check My Work 2 more…
arrow_forward
Examity Dashboard (click this
Question 2 - Chapter 12 Home x
O ezto.mheducation.com/ext/map/index.html?.con=con&external browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%25
Chapter 12 Homework a
Check my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate comp
Zachary Services Company has 61 employees, 36 of whom are assigned to Division A and 25 to Division B. Zachary incurred $364,170
of fringe benefits cost during year 2.
20
points
Required
Determine the amount of the fringe benefits cost to be allocated to Division A and to Division B.
O Answer is complete but not entirely correct.
Allocated
Cost
Division
A
s 160,420 O
B
$ 172,760
MacBook Air
arrow_forward
- Fi X
* MindTap - Cengage Learning
O ) (4) lofi hip hop radio - beats x
ng.cengage.com/static/nb/ui/evo/index.html?deploymentld=590512258542108435051542&elSBN=9780357114582&id=1062959402..
* CENGAGE MINDTAP
Q Search this course
HW 6
Andre is an amateur investor who holds a small portfolio consisting of only four stocks. The stock holdings in his portfolio are shown in the following
table:
A-Z
Stock
Percentage of Portfolio
Expected Return
Standard Deviation
Artemis Inc.
20%
6.00%
30.00%
Office
Babish & Co.
30%
14.00%
34.00%
Cornell Industries
35%
13.00%
37.00%
Danforth Motors
15%
5.00%
39.00%
What is the expected return on Andre's stock portfolio?
O 16.05%
O 8.03%
O 14.45%
O 10.70%
Suppose each stock in Andre's portfolio has a correlation coefficient of 0.4 (p = 0.4) with each of the other stocks. If the weighted average of the risk
of the individual securities (as measured by their standard deviations) included in the partially diversified four-stock portfolio is 35%, the portfolio's…
arrow_forward
* MindTap - Cengage Learning
O ) (4) lofi hip hop radio - beats
g.cengage.com/static/nb/ui/evo/index.html?deploymentld=590512258542108435051542&EISBN=9780357114582&id=1062959402...
5
CENGAGE MINDTAP
Q Search this
HW 6
Back to Assignment
Attempts
Keep the Highest / 2
4. The beta coefficient
A stock's contribution to the market risk of a well-diversified portfolio is called
risk. It can be measured by a metric called the beta
coefficient, which calculates the degree to which a stock moves with the movements in the market.
Based on your understanding of the beta coefficient, indicate whether each statement in the following table is true or false:
Statement
True
False
Beta coefficients are generally calculated using historical data.
Higher-beta stocks are expected to have higher required returns.
Stock A's beta is 1.0; this means that the stock has a negative correlation with the market.
arrow_forward
Hey I was wondering if I can get help with this thank you
arrow_forward
Screenshot of question is attached.
thanks in advance
arrow_forward
BOR
Tutor - Solution Page 1 of 1 | Ha X
A learn.hawkeslearning.com/Portal/Lesson/lesson_certify#!
MSC SSO Login
To Do Assignments.
E Reading list
E Apps
BSA Violation Civil... Search FAQS for Indian Trib...
CPAJ The Past, Present, a...
CPAJ Fraud in a World of...
You were asked to answer the following question:
Consider a small photography studio with 8 workers and 5 printers. The total cost of labor and capital is $3,300. In order to reduce total operating costs, the
owner leases 5 additional printers and fires 5 workers. After these changes, the salary of each worker increases by $30, the cost of using each of the printers (both
new and old) remains constant, and the total cost of labor and capital decreases to $2,950. What is the cost of using one printer?
The following answer is correct:
First, calculate the new total quantities of workers and printers after the changes were made.
New quantity of workers= 8-5= 3 workers
New quantity of printers = 5 + 5 = 10 printers
Assume that C,…
arrow_forward
Not a previously submitted question.
Thank you
arrow_forward
Not a previously submitted question.
Thank you
arrow_forward
Not a previously submitted question.
Thank you
arrow_forward
Not a previously submitted question.
Thank you
arrow_forward
Not a previously submitted question.
Thank you
arrow_forward
* CengageNOWv2 | Online teachin x
i Cengage Learning
b Search results for 'Utica Machine x
+
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
☆ 回 身 司 ee
E Apps
YouTube
S Марs
O Gmail
6 News
Q Translate
O My Grades
O Untitled document.
Chapter 11 Homework Assignment (pa
O eBook
E Print Item
1. RE.11.05.BLANKSHEET.AL...
Depreciation Methods
Sorter Company purchased equipment for $320,000 on January 2, 2019. The equipment has an estimated service life of 8 years and an estimated residual
2. RE.11.07.BLANKSHEET.AL.
value of $32,000 .
3. EX.11.01.ALGO
Required:
Compute the depreciation expense for 2019 under each of the following methods:
4. EX.11.02.ALGO
1. Straight-line: $
2. Sum-of-the-years'-digits: $
3. Double-declining-balance: $
4. Depreciation causes the book value of the assets to decrease
each period. When an accelerated depreciation method is used, the rate of return
increases
each period.
10:09 AM
P Type here…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Related Questions
- Could i have this answer in formula version?arrow_forwardPlease see below. I need help with this excel sheet. Please note that this problem requires cell referencing and particular formulas to get the correct answers. Please be sure to include these items.arrow_forwardIs this an equation I have deducted from an answer provided by a tutor? If it is right, what is it for because I’ve since been given these other formulas in the second picarrow_forward
- I'm not sure if I did my calculations correctly for Aug 3.arrow_forward4arrow_forwardmyOpenMath Course Messages Forums Calendar | Gradebook Home > Math 173-4 Spring 2024> Assessment Quiz 2 (Sec. 1.5-1.7) 54 points possible 5/12 answered Question 6 The graph of the function y = f(x - 39) can be obtained from the graph of y = f(x) by one of the following actions: > Next Question Home | My Oshifting the graph of f(x) to the right 39 units shifting the graph of f(x) to the left 39 units shifting the graph of f(x) upwards 39 units shifting the graph of f(x) downwards 39 unitsarrow_forward
- -vera fonda@student.pms.. Course: Intro Fin Acc- Bus 28 WileyPLUS Exercise 9-5 (Part Level Submission) Math Problem Solver and Caiculator Print by: 13111810287 Vera Maria Fonda 50077495-50077495MJNV1W09_C:Intro Fin Acc - Bus 28 / Chapter 9a *Exercise 9-5 (Part Level Submission) Windsor Bus Lines uses the units-of-activity method in depreciating its buses. One bus was purchased on January 1, 2017, at a cost of R$245,210. Over its 7-year useful life, the bus is expected to be driven 170,600 miles. Residual value is expected to be R$14,900. V Your answer is correct. Compute the depreciable cost per unit. (Round answer to 2 decimal places, e.g. e.50.) Depreciation cost per unit RSL.35 per mile Attempts: 1 of 2 used Mari 1181 *(b) Prepare a depreciation schedule assuming actual mileage was 2017, 42,900; 2018, 49,500; 2019, 42,300; and 2020, 35,900. (Round answers to o decimal places, e.g. 2,125 except Depreciation Cost /Unit.) reen Sh 1222 End of Year Computation Annual Accumulated…arrow_forwardNSPIRON متوقف مؤقتا elearn.squ.edu.om/mod/quiz/review.php?attempt=D16687 G... Obs -Jblicyl .lyI all zihll Go SQU E-LEARNING SYSTEM (ACADEMIC) E-LEARNING SERVICES SQU LIBRARIES SQU PORTALATTENDANCE The correct answer is: OMR 35,200 Question 10 Company XYZ is currently producing AND selling 10,000 units of product A. At this level, the total product cost was $60,000. This included $10,000 direct materials, $20,000 direct labor and $30,000 manufacturing overhead cost, which included 20% variable manufacturing overhead cost. The selling and administrative expenses were $100,000, which included $60,000 variable selling and administrative costs. Assume that the selling price per unit $20, how much was the total contribution margin? Theorrect Mark0.00 out of 2.00 Flag question a. $134,000 b. None of the given answers C. $40,000 d. $104,000 e. $194,000 The correct answer is: $104,000 Windows Finish review ENG II ...arrow_forwardInfo is in 1st slide, question in 2nd. Thanks a lot!arrow_forward
- A CSUF Portal E MyLab and Mastering P Do Homework - Chapter 8 Hon x -> -> a mathxl.com/Student/PlayerHomework.aspx?homeworkld=606850034&questionld=1&flushed%3false&cld%3D6647439&back=https://www.mathxl.com/Student/DOAS.. Update Financial Management I Shaheen Behbehani a 10/25/21 8:33 PM Question 2, P 8-8 (similar... HW Score: 0%, 0 of 10 points E Homework: Chapter 8 Homework O Points: 0 of 1 Save Part 1 of 3 Your factory has been offered a contract to produce a part for a new printer. The contract would last for 3 years and your cash flows from the contract would be $4.93 million per year. Your upfront setup costs to be ready to produce the part would be $7.91 million. Your discount rate for this contract is 7.6%. a. What does the NPV rule say you should do? b. If you take the contract, what will be the change in the value of your firm? a. What does the NPV rule say you should do? The NPV of the project is $ million. (Round to two decimal places.) Clear All Check Answer Help Me Solve…arrow_forwardwhats the answer for number 2arrow_forwardChapter 2: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all cells that contain question marks. The Chapter 2 Form worksheet is to be used to create your own worksheet version of the example in the text. Enter formulas in the cells that contain question marks. For example, in cell B25 enter the formula "=B10". After entering formulas in all of the cells that contained question marks, verify that the amounts match the example in the text. Check your worksheet by changing the total fixed manufacturing overhead cost for the Milling Department in the Data area to $300,000, keeping all other data the same as in the original example. If your worksheet is operating properly, the total cost of Job 407 should now be $2,350. If you do not get this answer, find the errors in your worksheet and correct them. You should proceed to the requirements below only after completing your worksheet. Save your completed Applying Excel form…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningAccounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L