Assignment 1
xlsx
keyboard_arrow_up
School
Chapman University *
*We aren’t endorsed by this school
Course
215
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
16
Uploaded by UltraCoyote4128
Numbers Sheet Name
Numbers Table Name
Questions
Table 1
Shadow Stocks
Table 1
TV Show Demand
Table 1
Florida counties crime
Table 1
This document was exported from Numbers. Each table was converte
objects on each Numbers sheet were placed on separate worksheets. calculations may differ in Excel.
Excel Worksheet Name
ed to an Excel worksheet. All other Please be aware that formula Questions
Shadow Stocks
TV Show Demand
Florida counties crime
3
MGSC 209
Professor Brett Danaher
Student Name(s):
Homework Assignment 1
Instructions:
You must insert your full name into the student name blank in the upper right hand corner of this worksheet (cel
You may complete this assignment is groups of up to 3 students. If you are working in a team, place all studen
This worksheet contains all of the questions to be answered, as well as blanks in which to answer them.
You MUST place your answers in the blanks provided on THIS worksheet. This is the worksheet on which I wil
Other worksheets in this document contain datasets to be used for each question. You may do anything you w
check them to see how you did your work, but it is your answers in THIS worksheet that will mostly determine y
Question 1
Column A indicates the name of the company. Column B indicates the exchange on which the stock is traded. Column D indicates the P/E ratio (price/earnings ratio), a metric that investors use to gauge the value of a comp
a. Make a histogram for the variable P/E Ratio. For the bins, use "0 to 10", "10.01 to 20", "20.01 to 3
Paste the histogram into the blank space below - you may resize it a bit to fit it into the space.
b. What is the mean P/E ratio?
Mean P/E ratio = c. What is the median P/E ratio?
Median P/E ratio = d. What is the mean Earnings per Share for stocks listed on OTC? How about the mean for stocks
Mean Earnings per Share for OTC Stocks = Mean Earnings Per Share for AMEX Stocks = The worksheet "Shadow Stocks" contains data on 20 shadow stocks. The term shadow
indicates stocks for sm
Paste histogram here
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
4
e. What is the standard deviation of the Earnings per Share for all stocks?
Std. Dev. of Earnings Per Share = f. What is the standard deviation of the P/E Ratio for all stocks?
Std. Dev. of P/E Ratio = g. Which variable shows more variation (EPS or P/E Ratio) according to the standard deviation?
h. Is there any reason that standard deviation might not be the best way to compare which variable Based on your reading of the book or our class lectures, is there a measure that might be better fo
Question 2
The Worksheet "TV Show Demand" contains data on iTunes downloads and pirated downloads (using BitTorre
Column A is the show name. Column B indicates total pirated downloads, and Column C indicates total paid iT
For simplicity, a download of any season or episode of a particular series counts as 1 download.
a. What is the mean of pirated downloads, and what is the mean of iTunes downloads?
Mean Pirated Downloads = Mean iTunes Downloads = b. Which mean is higher (piracy or iTunes downloads?) and give one reason why you think this is?
c. What is the standard deviation of pirated downloads? How about iTunes downloads?
Std. Dev. of Pirated Downloads = Std. Dev. of iTunes Downloads = d. What is the correlation coefficient between pirated downloads and iTunes downloads?
Correlation Coefficient = e. Are these two variables positively or negatively correlated?
5
f. Is this correlation strong or weak?
g. Does this mean that piracy of a show increases sales of that show? Why or why not? (explain yo
Question 3
The worksheet "Florida Counties Crime" contains data on 24 different counties in Florida.
Column A indicates the county name. Column B indicates the crime rate, defined as the number of crimes per Column C indicates the median income in that country. Column D indicates the percent of residents in that cou
Column E indicates the percentage of residents in that county who live in an urban environment (city-like enviro
a. What is the mean crime rate for just the counties in which less than 40% of residents live in urban
Mean Crime Rate (for countries with less than 40% urban) = b. What is the mean crime rate for just the counties in which more than 40% of residents live in urba
Mean Crime Rate (for countries with more than 40% urban) = c. Calculate the correlation coefficients between crime rate and each of the other 3 variables.
Correl(Crime Rate, Median Income) = Correl(Crime Rate, % High School) = Correl(Crime Rate, % Urban) = d. Let's assume that having more people dwelling in urban areas CAUSES an increase in crime rate
urban areas actually foster more crime than rural areas, because the tightly packed nature of urb
We note that there is a positive correlation coefficient between the % of people with a high school de
tend to cause less crime in an area? Can you come up with a good explanation for why areas where
6
Question 4
In a class of 25 students, the following table shows the amount of time spend studying for a test:
Study time
0 to 4
4 to 8
8 to 12
12 to 16
16 to 20
(hours)
3
7
8
5
2
In other words, 3 students spent between 0 and 4 hours studying, 7 students spend between 4 and 8 hours stu
Estimate the mean study time for this sample of students given only the grouped data above. (hint, use the form
Estimated mean study time = Number of students
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
7
ll K4). If you do not, you may not receive credit for your assignment!
nt names on this assignment and only one of you needs to upload it to Canvas.
ll base your grades.
want in these worksheets in order to answer the question. I may
your grade for this assignment.
Column C indicates the earnings-per-share (EPS) for the stock.
pany/stock.
30", "30.01 to 40", and "Greater than 40".
s listed on AMEX?
mall to medium-sized firms not followed closely by major brokerage houses
8
shows more variation/dispersion?
or comparing which of two variables is more dispersed?
ent) for 81 different television shows during a 6 week period in 2007.
Tunes downloads.
9
our answer)
1000 residents.
unty over age 25 who have a high school degree.
onment).
n areas?
an areas?
e. (This is, in fact, true. Other more complex studies have shown that ban areas facilitates easier crime, and because urban areas have more dispersed income ranges).
egree, and the crime rate. This does not seem to make sense - wouldn't people having more education
e more people have high school degrees are prone to more crime? (a concise explanation will do)
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
10
udying, and so on.
mula for estimating a mean from grouped data)
11
Stock
Exchange
P/E Ratio
Chemi-Trol
OTC
0.39
27.3
Candie's
OTC
0.07
36.2
TST/Impreso
OTC
0.65
12.7
Unimed Pharm.
OTC
0.12
59.3
Skyline Chili
AMEX
0.34
19.3
Cyanotech
OTC
0.22
29.3
Catalina Light.
NYSE
0.15
33.2
DDL Elect.
NYSE
0.1
10.2
Euphonix
OTC
0.09
49.7
Mesa Labs
OTC
0.37
14.4
RCM Tech.
OTC
0.47
18.6
Anuhco
AMEX
0.7
11.4
Hello Direct
OTC
0.23
21.1
Hilite Industries
OTC
0.61
7.8
Alpha Tech.
OTC
0.11
34.6
Wegener Group
OTC
0.16
24.5
U.S. Home &Garden
OTC
0.24
8.7
Chalone Wine
OTC
0.27
44.4
Eng. Support Sys.
OTC
0.89
16.7
Int. Remote Imaging
AMEX
0.86
4.7
Earnings Per Share
12
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
13
Series
Pirated Downloads
iTunes purchases
'Till Death
26631
82
24
4297711
49718
30 Rock
1179939
8010
According To Jim
48648
175
Adam-12
6107
34
Alfred Hitchcock Presents
98584
318
Alias
731363
2286
American Dad
506799
3662
Andy Barker P.I.
1468
3
Battlestar Galactica
2734506
8567
Battlestar Galactica Classic
161824
480
Beverly Hills 90210
152167
456
Bionic Woman 1976
226461
1660
Bones
636799
2883
Boston Legal
763056
3028
Brothers & Sisters
573411
1231
CSI: Crime Scene Investigation
1565368
15771
CSI: Miami
830200
5012
CSI: NY
341112
758
Cold Case
279156
1517
Criminal Minds
478212
1829
Desperate Housewives
4153120
22700
Eureka
140198
445
Everybody Loves Raymond
613027
5872
Family Guy
4549277
25998
Family Ties
78
0
Friday Night Lights
430427
3917
Ghost Whisperer
405698
2506
Grey's Anatomy
3717452
35791
Hercules: The Legendary Journeys
74012
201
Heroes
6658636
25503
House
4129241
15279
How I Met Your Mother
1378444
10096
Jericho
1303057
7622
King Of The Hill
124572
380
14
Knight Rider Classic
85027
544
Kolchak: The Night Stalker
5996
46
Law & Order
174076
855
Law & Order: Criminal Intent
181026
460
Law & Order: Special Victims Unit
264780
2195
Law & Order: Trial by Jury
4774
14
Lost
6037949
17394
MacGyver
281999
963
Magnum PI
25563
192
Medium
171169
469
Melrose Place
22214
81
Men In Trees
168390
621
Miami Vice
130770
514
Monk
241853
1191
My Name Is Earl
1420112
4507
NCIS
1107366
2696
New Adventures of Old Christine
28595
124
Numb3rs
415677
1032
Prison Break
4737619
17485
Psych
53492
131
Raines
5241
23
Rules Of Engagement
77645
226
Saved by the Bell
141212
301
Scrubs
4628258
15632
Shark
153383
1756
Sliders
122576
639
Star Trek: The Original Series
304160
3450
StarGate SG1
1592907
5495
Surface
52366
570
The A-Team
74082
502
The Black Donnellys
56927
598
The Dead Zone
152057
330
The Dresden Files
91802
918
The Incredible Hulk
1940
4
The King Of Queens
333198
3204
The Munsters
10921
25
15
The Office
3146064
9911
The Simpsons
8020982
82021
The Starter Wife
10740
25
The Unit
517476
2118
Tremors
4017
13
Twin Peaks
455693
2973
Two And A Half Men
809596
6643
Ugly Betty
696620
3681
Will And Grace
452125
2529
Without A Trace
221519
638
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
16
County
Crime Rate
Median Income
High School
Percent Urban
LAFAYETTE
0
20.7
58.2
0
LEVY
45
18.8
62.8
0
GLADES
62
20.7
57.4
0
UNION
6
22.8
67.7
0
MADISON
26
18.2
56.5
20.3
JEFFERSON
36
21.8
64.1
22.3
WASHING.
21
18.3
60.9
22.9
FRANKLIN
37
17.2
59.5
30.2
COLUMBIA
69
22
69
31.1
MARION
64
22.5
69.6
39.6
SEMINOLE
56
35.6
78.5
44.4
SANTAR.
43
27.6
79.9
57.2
PASCO
42
21.5
66.9
67.4
POLK
84
25.2
68
70.3
ALACHUA
104
22.1
82.7
73.2
MONROE
89
29.4
79.7
73.2
COLLIER
55
34
79
77.6
CHARLOTTE
35
25.7
75.7
80.2
MARTIN
53
31.8
79.7
83.2
ESCAMBIA
70
25.2
76.2
85.9
HILLSBOR.
110
28.5
75.6
89.2
SARASOTA
58
29.9
71.7
92.1
STJOHNS
54
29.9
81.3
93.2
BROWARD
94
30.6
76.8
98.9
Related Documents
Related Questions
This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J.
Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amounts
arrow_forward
ne
O
File Edit View History
Bookmarks
Bookmarks Profiles Tab Window Help
Review Submission History: X Bb Microsoft Word - EXCEL GRO X
getproctorio.com/secured #lockdown
Proctoring Enabled: Chapter 6 Homework Assignm... i
с
Mc
Graw
Hill
Item Description
TV
Remote
Installation
Total revenue
Required:
Please answer: how much revenue would be allocated to the TV, the remote, and the installation service by Best Buy?
Note: Do not round intermediate calculations.
3
$
$
4
Allocated
Revenue
New Tab
2
Best Buy Co. Inc. is an American multinational consumer electronics retailer headquartered in Richfield, Minnesota sells a big screen
TV package consisting of a 60-inch plasma TV, a universal remote, and on-site installation by Best Buy staff. The installation includes
programming the remote to have the TV interface with other parts of the customer's home entertainment system. Best Buy concludes
that the TV, remote, and installation service are separate performance obligations. Best Buy sells the…
arrow_forward
e
File Edit View History Bookmarks Profiles Tab Window Help
Week 4 Home X
Short Exercis X G Dalton Hair St X C For each acco X
plus.pearson.com/products/658729f2-cb81-45ee-babb-bf032e847a35/pages/urn:pearso... ☆
5
6
32 Total
33 Net (b)
34 Total
35
A partial worksheet for Ramey Law Firm is presented below. Solve for
the missing information.
A
6
32 Total
33 Net (c)
34 Total
35
End of Chapter: Completing the Accounting Cycle
A
J
Income Statement
Debit
(a)
8,375
(d)
Credit
$ 24,850
(e)
$ 24,850
JA
23
Income Statement
Debit
$ 22,400
K
Credit
(a)
F4-34
S-F:4-8. Determining net loss using a worksheet (Learning Objective 2)
A partial worksheet for Aaron Adjusters is presented below. Solve for the
missing information.
5,300
(f)
L
▶
M
Balance Sheet
Debit
$ 211,325
C For each acce X
(e)
L
Debit
(b)
(d)
(g)
Credit
$ 202,950
tv
(c)
(f)
Balance Sheet
M
Credit
$61,400
+
$ 61,400
AA
⠀
arrow_forward
Eva Oca mpo Bank Statement
+.
y onE68 GBzq2 ORffwnqVtgYY/edit # slide-id.g78c78cf0c6_0_0
%23
ades and Attend
S Pearson Realize Student Assignmen..
* Login Page n NoRedink is on a m..
Dictionary.com |FL
K K
xton
O Present
ons Help
Last edit was 6 days ago
ckground Layout-
Theme
Transition
2 13 r 4 .
5.
|.6 7
Example 1
Allison currently has a balance of $2,300 in her
checking account. She deposits a $425.33
paycheck, a $20 rebate check, and a personal
check for $550 into her checking account. She
wants to receive $200 in cash. How much will she
have in her account after the transaction?
Show work here:
arrow_forward
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
- 10 - A A
Insert v
Σ
Arial
ab
General
EXDelete v
BIU
$- % 9 0 0
Conditional Format as
Cell
Sort &
Formatting
Table -
Styles v
Format v
Filter
oard
Font
Alignment
Number
Styles
Cells
Editing
fr
C D
H.
The following amounts summarize the financial position of Little Black Dog Inc. on May 31, 2021:
В
F
G
IJK L
M
N
O P
Q
R
S
V
W
Assets
Liabilities
Shareholders' Equity
%D
Cash +
Accounts
Computers
+
+ Supplies + Land
Accounts
+
Note
Salaries
+
Interest
Common
+
Retained
Receivable
(net)
Payable
Payable
Payable
Payable
Shares
Earnings
Balance 1820
700
70
8400
5600
2800
2590
During June 2021, the business completed these transactions:
June 1: Received cash of $6300 and issued common shares.
June 1: Bought two computers for a total of $5600 by paying $1400 down and signing a note payable for the rest. Interest of 5% to be paid with the
note payable on June 1, 2022. The computers are expected to last 5 years.
June 5: Performed services for…
arrow_forward
Can I get some help with this?
arrow_forward
e web
Games
ACC101 Chapter 8 Mini Case - Word
O Search
raquel rodriguez
sert
Draw
Design
Layout
References
Mailings
Review
View
Help
Body)
v 11
AaBbCcDd AaBbCcDd AaBbC
U v ab x, x A
三三
I Normal
1 No Spac. Heading 1
Editing
Dictate
Sensi
A
v Aa v
A A
。田、刻T
Font
Paragraph
Styles
Voice
Sensit
Suppose Easton Company reported net receivables of $2,582 million and $2,260 million at January 31,
2019, and 2018, respectively, after subtraction allowances of $72 million and $67 million respectively.
Easton earned total revenue of $43,333 million (all on account) and recorded uncollectible account
expense of $13 million for the year ended January 31, 2019. Use the following T accounts to sort out
your answer.
1. Use this information to measure the following amounts for the year ended January 31, 2019.
a. Write-off of uncollectible receivables.
b. Collection from customers
Allowance for Uncollectible Accounts
D Focus
G
arrow_forward
I am struggling with the question listed below.
arrow_forward
View Assessment
se data from Rollaird
Live balance sheets, perform a
Use Chapter 13 "Financial
ture" as a guidance.
g your numbers, use whole
ation, and one decimal point
een in the example below. The
ht red if incorrect after clicking
bottom right corner).
Terminology Matching - Academic Resources
EHCS380 Week 4 Horizontal and Vertical Analysis
00
multimedia.phoenix.edu
b Answered: Terminology Matching Independent... | bartleby
Accounts Receivable
Inventory
Total Assets
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
Dec. 31, 2022
460,000
780,000
3,164,000
Example:
Dec. 31, 2021
Accounts Receivable 2022
400,000
650,000
2,800,000
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).…
arrow_forward
este X
* CengageNOww2 | Online teachin x
: Cengage Learning
genow.com.filrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=8inprogress=false
еВook
Show Me How
Providing for Doubtful Accounts
At the end of the current year, the accounts receivable account has a debit balance of $969,000 and sales for the year total $10,990,000.
a. The allowance account before adjustment has a credit balance of $13,100. Bad debt expense is estimated at 1/4 of 1% of sales.
b. The allowance account before adjustment has a credit balance of $13,100. An aging of the accounts in the customer ledger indicates estimated
doubtful accounts of $41,900.
C. The allowance account before adjustment has a debit balance of $4,600. Bad debt expense is estimated at 3/4 of 1% of sales.
d. The allowance account before adjustment has a debit balance of $4,600. An aging of the accounts in the customer ledger indicates estimated
doubtful accounts of $38,200.
Determine the amount of the adjusting…
arrow_forward
I need help with parts b - e.
arrow_forward
can you please explain how they got these answers and where they are getting the highlighted numbers on the second image from?
arrow_forward
Ucation.com/ext/map/index.html?_con3con&external_browser%3D0&launchUrl%3Dhttps%253A%252F%252Fblackboard.american.edu%2...
CH 9 Concept Overview Videos
Saved
Help
Save & Exit
!
Required Information
3.
Part 3 of 3
Knowledge Check 01
On June 30 a designer received a check in the amount of $7,500 from a customer for design services to be provided after the
customer chooses a color scheme for the first floor of her house. Complete the necessary journal entry. (If no entry is required for a
transaction/event, select "No Journal entry required" In the first account fleld.)
0.38
polnts
View transaction list
eBook
Journal entry worksheet
Print
Record the receipt of a check dated June 30 for $7,500 from a customer for
design services to be provided.
References
Note: Enterr debits before credits,
Date
General Journal
Debit
Credit
June 30
Mc
Graw
Hill
3.
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
Edit
View
History
Bookmarks
People
Tab
Window
Help
N Academic Tools :: Northern Virgi X
63%
Mon 12:07 PM
weCS Virginia Community College Syst X
N CHAPTER 08 HW NOVA
learn.vccs.edu/courses/240149/assignments/4704240?module_item_id=17254910
https://checkout.wileyplus.com/ X
des
View Policies
rse Evaluations
Current Attempt in Progress
A Policies
Cullumber Co. has the following transactions related to notes receivable during the last 2 months of the year. The company does not make entries to
accrue interest except at December 31.
r.com: 24/7 On-
Tutoring
Nov. 1 Loaned $53,400 cash to C. Bohr on a 12-month, 9% note.
ary Resources
Dec. 11 Sold goods to K. R. Pine, Inc., receiving a $5,400, 90-day, 8% note.
16 Received a $9,600, 180-day, 8% note to settle an open account from A. Murdock.
31 Accrued interest revenue on all notes receivable.
Journalize the transactions for Cullumber Co. (Omit cost of goods sold entries.) (Credit account titles are automatically indented when amount is entered.…
arrow_forward
Don’t understand
arrow_forward
please help me provide complete and correct answer for all requirements with all working for all parts answer in text please answer correct please remember answer all requirements or skip /leave for other expert thanks million thanks please double underline need answer for all requirements or skip please do not waste time or question by giving incomplete or incorrect answer please no copy paste from other answer
arrow_forward
History
Bookmarks
Profiles Tab
Window
Help
M Question 2 - Ch 21: Homewor
×
D2L Classlist - Spring 2024 Intro
×
New Tab
.edu/webwork2/MATH_107_online_Spring_2024/HW_20_Simple_and_Compound_Interest/14
MAA
MATHEMATICAL ASSOCIATION OF AMERICA
/ HW 20 Simple and Compound Interest / 14
Previous Problem Problem List Next Problem
HW 20 Simple and Compound Interest: Problem 14
(6 points)
What are the effective annual rates for an account paying an annual interest rate of 6% which is compounded:
(a) annually?
(b) quarterly?
%
%
(c) daily (assuming there are 365 days in the year)?
%
(d) continuously?
%
Note: You can earn partial credit on this problem.
Preview My Answers Submit Answers
You have attempted this problem 0 times.
You have unlimited attempts remaining.
Page generated at 05/04/2024 at 02:41pm EDT
WeBWorK 1996-2022 | theme: math4-green | ww_version: 2.17 | pg_version 2.17 | The WeBW
arrow_forward
2 Homework
Saved
Help
Save & E
Calibri
11
A A
Paste
B I
E - O -A-
Alignment Number Conditional Format as Cell
Styles
Cells
Editing
Formatting
Styles
Table
Clipboard
Font
A2
fr
(Accounts are in alphabetical order.)
E
1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1.
2 (Accountsare in alphabetical order.)
Accounts Payable
8,088
4.
6,960
13,445
4,800
5
Accounts Receivable
es
6
Cash
Equipment
Insurance Expense
Operating Expense
Other Expenses
Other Revenues
1,350
8
11,800
3,482
10
6,050
11
4,800
6,882
17,200
15,400
12
Rent Expense
13
Salaries Expense
Short-term Notes Payable
Test Prep Revenue
14
15
9,100
16
Tutoring Revenue
1,046
17
Unearned Revenue
18
19 Required:
20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references
21 to select account titles and amounts to be included on the income statement.
22 Note: List revenues and expenses in order of largest to smallest dollar amounts.
23
24 2. After entering the…
arrow_forward
Using the completed table in “required 1” complete the table in “required 2” please.
Thank you!
arrow_forward
X
SAM.gov | Home
First Financial Bank
Question 1- Week 5: X
devry: Cost Managem X
-Portal
X
M Inbox (17) - princessp: X
X
https://ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com...
A to
Homework i
Saved
Help
Save & Exit
Check
The following information is available for Brownstone Products Company for the month of July:
Master
Actual
Budget
Units
3,500
4,000
Sales revenue
$ 54,300
$ 60,000
Variable manufacturing costs
10,000
16,000
Fixed manufacturing costs
13,000
14,000
Variable selling and administrative expenses
6,500
8,000
Fixed selling and administrative expenses
8,000
9,100
Required:
1. What was the master budget variance for July? Was this variance favorable or unfavorable?
es
2. Compute the July sales volume variance and the flexible-budget variance for the month, both in terms of contribution margin and in
terms of operating income.
4. Prepare pro-forma budgets for activities within its relevant range of…
arrow_forward
uni
403 a
Cha
Pra
(Ch
Preview File Edit View
Go Tools Window Help
mgt120h-j17.pdf
Page 7 of 10
0
CC
Search
b. Company B has current assets of $234,000, total assets of $459,000, and equity of
$100,000. The company wants to reorganize its liabilities so that is current ratio is
2: 1. If it does, what will its noncurrent liabilities be?
S
QSun Apr 16 1:23 PM
arrow_forward
Need help with this questiin please. Thank you
arrow_forward
A v2.cengagenow.com
da EXCHANGE PASSWORD REQUIRED
12m
na...
X CengageNOWv2 | Online teaching and learning reso..
https://www.toolingu.com/Ims/contentplayer/?corpo..
Enter your password for "hjmolin" in Internet
Accounts.
n eBook
Warranties
Lee Electronics, a franchise of electronics stores located in small towns throughout the United States, sold 850 32-inch televisions for $740 each. The televisions carry an
attached 3-year warranty for repairs. Lee Electronics estimates that repair costs will average 3.5% of the total selling price.
Required:
1. How much is recorded in the Warranty Liability account as a result of selling the televisions during the year, assuming no warranty service has yet been performed?
estimated warranty liability
Feedback
2. Provide the necessary adjusting entry at December 31. If an amount box does not require an entry, leave it blank.
Dec. 31 Warranty Expense
Warranty Liability
(Record warranty expense)
Feedback
Feedback
arrow_forward
Prepare the following journal entries
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- This is the excel spreadsheet to complete problem E6-23 all shaded cells in column D,H and J. Attached is the page from the book for E6-23 and the spreadsheet is attached to where the account titles goes and amountsarrow_forwardne O File Edit View History Bookmarks Bookmarks Profiles Tab Window Help Review Submission History: X Bb Microsoft Word - EXCEL GRO X getproctorio.com/secured #lockdown Proctoring Enabled: Chapter 6 Homework Assignm... i с Mc Graw Hill Item Description TV Remote Installation Total revenue Required: Please answer: how much revenue would be allocated to the TV, the remote, and the installation service by Best Buy? Note: Do not round intermediate calculations. 3 $ $ 4 Allocated Revenue New Tab 2 Best Buy Co. Inc. is an American multinational consumer electronics retailer headquartered in Richfield, Minnesota sells a big screen TV package consisting of a 60-inch plasma TV, a universal remote, and on-site installation by Best Buy staff. The installation includes programming the remote to have the TV interface with other parts of the customer's home entertainment system. Best Buy concludes that the TV, remote, and installation service are separate performance obligations. Best Buy sells the…arrow_forwarde File Edit View History Bookmarks Profiles Tab Window Help Week 4 Home X Short Exercis X G Dalton Hair St X C For each acco X plus.pearson.com/products/658729f2-cb81-45ee-babb-bf032e847a35/pages/urn:pearso... ☆ 5 6 32 Total 33 Net (b) 34 Total 35 A partial worksheet for Ramey Law Firm is presented below. Solve for the missing information. A 6 32 Total 33 Net (c) 34 Total 35 End of Chapter: Completing the Accounting Cycle A J Income Statement Debit (a) 8,375 (d) Credit $ 24,850 (e) $ 24,850 JA 23 Income Statement Debit $ 22,400 K Credit (a) F4-34 S-F:4-8. Determining net loss using a worksheet (Learning Objective 2) A partial worksheet for Aaron Adjusters is presented below. Solve for the missing information. 5,300 (f) L ▶ M Balance Sheet Debit $ 211,325 C For each acce X (e) L Debit (b) (d) (g) Credit $ 202,950 tv (c) (f) Balance Sheet M Credit $61,400 + $ 61,400 AA ⠀arrow_forward
- Eva Oca mpo Bank Statement +. y onE68 GBzq2 ORffwnqVtgYY/edit # slide-id.g78c78cf0c6_0_0 %23 ades and Attend S Pearson Realize Student Assignmen.. * Login Page n NoRedink is on a m.. Dictionary.com |FL K K xton O Present ons Help Last edit was 6 days ago ckground Layout- Theme Transition 2 13 r 4 . 5. |.6 7 Example 1 Allison currently has a balance of $2,300 in her checking account. She deposits a $425.33 paycheck, a $20 rebate check, and a personal check for $550 into her checking account. She wants to receive $200 in cash. How much will she have in her account after the transaction? Show work here:arrow_forwardHome Insert Page Layout Formulas Data Review View Help - 10 - A A Insert v Σ Arial ab General EXDelete v BIU $- % 9 0 0 Conditional Format as Cell Sort & Formatting Table - Styles v Format v Filter oard Font Alignment Number Styles Cells Editing fr C D H. The following amounts summarize the financial position of Little Black Dog Inc. on May 31, 2021: В F G IJK L M N O P Q R S V W Assets Liabilities Shareholders' Equity %D Cash + Accounts Computers + + Supplies + Land Accounts + Note Salaries + Interest Common + Retained Receivable (net) Payable Payable Payable Payable Shares Earnings Balance 1820 700 70 8400 5600 2800 2590 During June 2021, the business completed these transactions: June 1: Received cash of $6300 and issued common shares. June 1: Bought two computers for a total of $5600 by paying $1400 down and signing a note payable for the rest. Interest of 5% to be paid with the note payable on June 1, 2022. The computers are expected to last 5 years. June 5: Performed services for…arrow_forwardCan I get some help with this?arrow_forward
- e web Games ACC101 Chapter 8 Mini Case - Word O Search raquel rodriguez sert Draw Design Layout References Mailings Review View Help Body) v 11 AaBbCcDd AaBbCcDd AaBbC U v ab x, x A 三三 I Normal 1 No Spac. Heading 1 Editing Dictate Sensi A v Aa v A A 。田、刻T Font Paragraph Styles Voice Sensit Suppose Easton Company reported net receivables of $2,582 million and $2,260 million at January 31, 2019, and 2018, respectively, after subtraction allowances of $72 million and $67 million respectively. Easton earned total revenue of $43,333 million (all on account) and recorded uncollectible account expense of $13 million for the year ended January 31, 2019. Use the following T accounts to sort out your answer. 1. Use this information to measure the following amounts for the year ended January 31, 2019. a. Write-off of uncollectible receivables. b. Collection from customers Allowance for Uncollectible Accounts D Focus Garrow_forwardI am struggling with the question listed below.arrow_forwardView Assessment se data from Rollaird Live balance sheets, perform a Use Chapter 13 "Financial ture" as a guidance. g your numbers, use whole ation, and one decimal point een in the example below. The ht red if incorrect after clicking bottom right corner). Terminology Matching - Academic Resources EHCS380 Week 4 Horizontal and Vertical Analysis 00 multimedia.phoenix.edu b Answered: Terminology Matching Independent... | bartleby Accounts Receivable Inventory Total Assets DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Dec. 31, 2022 460,000 780,000 3,164,000 Example: Dec. 31, 2021 Accounts Receivable 2022 400,000 650,000 2,800,000 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner).…arrow_forward
- este X * CengageNOww2 | Online teachin x : Cengage Learning genow.com.filrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=8inprogress=false еВook Show Me How Providing for Doubtful Accounts At the end of the current year, the accounts receivable account has a debit balance of $969,000 and sales for the year total $10,990,000. a. The allowance account before adjustment has a credit balance of $13,100. Bad debt expense is estimated at 1/4 of 1% of sales. b. The allowance account before adjustment has a credit balance of $13,100. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $41,900. C. The allowance account before adjustment has a debit balance of $4,600. Bad debt expense is estimated at 3/4 of 1% of sales. d. The allowance account before adjustment has a debit balance of $4,600. An aging of the accounts in the customer ledger indicates estimated doubtful accounts of $38,200. Determine the amount of the adjusting…arrow_forwardI need help with parts b - e.arrow_forwardcan you please explain how they got these answers and where they are getting the highlighted numbers on the second image from?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 Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning