Monson& Company is an architectural firm specializing in home remodeling for private clients and new office buildings for corporate clients. Monson charges customers at a billing rate equal to 128%
of the client's total job cost. A client's total job cost is a combination of(1) professional time spent on the client $64 per hour cost of employing each professional) and (2) operating overhead allocated to the client's job. Monson allocates operating overhead to jobs based on professional hours spent on the job. Monson estimates its five professionals will incur a total of 10,000 professional hours working on client jobs during the year.
|
All operating costs other than professional salaries (travel reimbursements, copy costs, secretarial salaries, office lease, and so forth) can be assigned to the three activities. Total activity costs, cost drivers, and total usage of those cost drivers are estimated as follows: |
|
Total |
Total Usage |
Total Usage |
||||
|
Activity |
by Corporate |
by Private |
||||
|
Activity |
Cost |
Cost Driver |
Clients |
Clients |
||
|
Transporation to clients. . . . . |
$6,000 |
Round-trip mileage to clients. . |
2,000 |
miles |
13,000 |
miles |
|
Blueprint copying. . . . . . . . |
34,000 |
Number of copies. . . . . . . . . . . . . |
350 |
copies |
650 |
copies |
|
Office support. . . . . . . . . . . . . . |
180,000 |
Secretarial time. . . . . . . . . . . |
2,400 |
secretarial |
2,600 |
secretarial |
|
hours |
hours |
|||||
|
Total operating overhead. . |
$220,000 |
|||||
AnnikaLaughlin hired Monson to design her kitchen remodeling. A total of 2020 professional hours were incurred on this job. In addition, Laughlin's remodeling job required one of the professionals to travel back and forth to her house for a total of 160 miles. The blueprints had to be copied four times because Laughlin changed the plans several times. In addition, 19 hours of secretarial time were used lining up the subcontractors for the job.
Requirements
|
1. |
Calculate the current indirect cost allocation rate per professional hour. |
|
2. |
Calculate the total amount that would be billed to Laughlin given the current costing structure. |
|
3. |
Calculate the activity cost allocation rates that could be used to allocate operating overhead costs to client jobs. |
|
4. |
Calculate the amount that would be billed to Laughlin using ABC costing. |
|
5. |
Which type of billing system is more fair to clients? Explain. |
In: Accounting
Product Costing and Decision Analysis for a Service Company
Blue Star Airline provides passenger airline service, using
small jets. The airline connects four major cities: Charlotte,
Pittsburgh, Detroit, and San Francisco. The company expects to fly
170,000 miles during a month. The following costs are budgeted for
a month:
| Fuel | $2,120,000 |
| Ground personnel | 788,500 |
| Crew salaries | 850,000 |
| Depreciation | 430,000 |
| Total costs | $4,188,500 |
Blue Star management wishes to assign these costs to individual
flights in order to gauge the profitability of its service
offerings. The following activity bases were identified with the
budgeted costs:
| Airline Cost | Activity Base |
| Fuel, crew, and depreciation costs | Number of miles flown |
| Ground personnel | Number of arrivals and departures at an airport |
The size of the company's ground operation in each city is
determined by the size of the workforce. The following monthly data
are available from corporate records for each terminal operation:
Show work notes
| Terminal City | Ground Personnel Cost | Number of Arrivals/Departures | |||||||
| Charlotte | $256,000 | 320 | |||||||
| Pittsburgh | 97,500 | 130 | |||||||
| Detroit | 129,000 | 150 | |||||||
| San Francisco | 306,000 | 340 | |||||||
| Total | $788,500 | 940 | |||||||
Three recent representative flights have been selected for the
profitability study. Their characteristics are as
follows:
| Description | Miles Flown | Number of Passengers | Ticket Price per Passenger | ||||
| Flight 101 | Charlotte to San Francisco | 2,000 | 80 | $695.00 | |||
| Flight 102 | Detroit to Charlotte | 800 | 50 | 441.50 | |||
| Flight 103 | Charlotte to Pittsburgh | 400 | 20 | 382.00 | |||
Required:
1. Determine the fuel, crew, and depreciation
cost per mile flown.
$ per mile
2. Determine the cost per arrival or departure by terminal city.
| Charlotte | $ |
| Pittsburgh | $ |
| Detroit | $ |
| San Francisco | $ |
3. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.
| Blue Star Airline | |||
| Flight Profitability Report | |||
| For Three Representative Flights | |||
| Flight 101 | Flight 102 | Flight 103 | |
| Passenger revenue | $ | $ | $ |
| Fuel, crew, and depreciation costs | $ | $ | $ |
| Ground personnel | |||
| Total costs | $ | $ | $ |
| Flight operating income (loss) | $ | $ | $ |
In: Accounting
Product Costing and Decision Analysis for a Service Company
Blue Star Airline provides passenger airline service, using
small jets. The airline connects four major cities: Charlotte,
Pittsburgh, Detroit, and San Francisco. The company expects to fly
170,000 miles during a month. The following costs are budgeted for
a month:
| Fuel | $2,120,000 |
| Ground personnel | 788,500 |
| Crew salaries | 850,000 |
| Depreciation | 430,000 |
| Total costs | $4,188,500 |
Blue Star management wishes to assign these costs to individual
flights in order to gauge the profitability of its service
offerings. The following activity bases were identified with the
budgeted costs:
| Airline Cost | Activity Base |
| Fuel, crew, and depreciation costs | Number of miles flown |
| Ground personnel | Number of arrivals and departures at an airport |
The size of the company's ground operation in each city is
determined by the size of the workforce. The following monthly data
are available from corporate records for each terminal
operation:
| Terminal City | Ground Personnel Cost | Number of Arrivals/Departures | |||||||
| Charlotte | $256,000 | 320 | |||||||
| Pittsburgh | 97,500 | 130 | |||||||
| Detroit | 129,000 | 150 | |||||||
| San Francisco | 306,000 | 340 | |||||||
| Total | $788,500 | 940 | |||||||
Three recent representative flights have been selected for the
profitability study. Their characteristics are as
follows:
| Description | Miles Flown | Number of Passengers | Ticket Price per Passenger | ||||
| Flight 101 | Charlotte to San Francisco | 2,000 | 80 | $695.00 | |||
| Flight 102 | Detroit to Charlotte | 800 | 50 | 441.50 | |||
| Flight 103 | Charlotte to Pittsburgh | 400 | 20 | 382.00 | |||
Required:
1. Determine the fuel, crew, and depreciation
cost per mile flown.
$ per mile
2. Determine the cost per arrival or departure by terminal city.
| Charlotte | $ |
| Pittsburgh | $ |
| Detroit | $ |
| San Francisco | $ |
3. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.
| Blue Star Airline | |||
| Flight Profitability Report | |||
| For Three Representative Flights | |||
| Flight 101 | Flight 102 | Flight 103 | |
| Passenger revenue | $ | $ | $ |
| Fuel, crew, and depreciation costs | $ | $ | $ |
| Ground personnel | |||
| Total costs | $ | $ | $ |
| Flight operating income (loss) | $ | $ | $ |
In: Accounting
Product Costing and Decision Analysis for a Service Company
Blue Star Airline provides passenger airline service, using
small jets. The airline connects four major cities: Charlotte,
Pittsburgh, Detroit, and San Francisco. The company expects to fly
170,000 miles during a month. The following costs are budgeted for
a month:
| Fuel | $2,120,000 |
| Ground personnel | 788,500 |
| Crew salaries | 850,000 |
| Depreciation | 430,000 |
| Total costs | $4,188,500 |
Blue Star management wishes to assign these costs to individual
flights in order to gauge the profitability of its service
offerings. The following activity bases were identified with the
budgeted costs:
| Airline Cost | Activity Base |
| Fuel, crew, and depreciation costs | Number of miles flown |
| Ground personnel | Number of arrivals and departures at an airport |
The size of the company's ground operation in each city is
determined by the size of the workforce. The following monthly data
are available from corporate records for each terminal
operation:
| Terminal City | Ground Personnel Cost | Number of Arrivals/Departures | |||||||
| Charlotte | $256,000 | 320 | |||||||
| Pittsburgh | 97,500 | 130 | |||||||
| Detroit | 129,000 | 150 | |||||||
| San Francisco | 306,000 | 340 | |||||||
| Total | $788,500 | 940 | |||||||
Three recent representative flights have been selected for the
profitability study. Their characteristics are as
follows:
| Description | Miles Flown | Number of Passengers | Ticket Price per Passenger | ||||
| Flight 101 | Charlotte to San Francisco | 2,000 | 80 | $695.00 | |||
| Flight 102 | Detroit to Charlotte | 800 | 50 | 441.50 | |||
| Flight 103 | Charlotte to Pittsburgh | 400 | 20 | 382.00 | |||
Required:
1. Determine the fuel, crew, and depreciation
cost per mile flown.
$ per mile
2. Determine the cost per arrival or departure by terminal city.
| Charlotte | $ |
| Pittsburgh | $ |
| Detroit | $ |
| San Francisco | $ |
3. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs. Enter all amounts as positive numbers, except for a negative income from operations.
| Blue Star Airline | |||
| Flight Profitability Report | |||
| For Three Representative Flights | |||
| Flight 101 | Flight 102 | Flight 103 | |
| Passenger revenue | $ | $ | $ |
| Fuel, crew, and depreciation costs | $ | $ | $ |
| Ground personnel | |||
| $ | $ | $ | |
| Flight income from operations | $ | $ | $ |
In: Accounting
Using Java,
Ask for the runner’s name
Ask the runner to enter a floating point number for the number of miles ran, like 3.6 or 9.5
Then ask for the number of hours, minutes, and seconds it took to run
A marathon is 26.219 miles
Pace is how long it takes in minutes and seconds to run
1 mile.
Example Input:
What is your first name? // user enters Pheidippides
How far did you run today? 10.6 // user enters 10.6
miles
How long did it take? Hours: 1 // user enters 1 hours
Minutes: 34 // user enters 34 minutes
Seconds: 17 // user enters 17 seconds
Example Output:
Hi Pheidippides
Your pace is 8:53 (minutes: seconds)
At this rate your marathon time would be 3:53:12
Good luck with your training!
After your program tells the user what their pace is,
your program will build a table showing the following columns. The
pace table should start with the fastest man time which is Eliud
Kipchoge.
Example:
Pace Table
Pace Marathon
4:37 2:01:04 ←- Eliud Kipchoge
5:17 2:18:41
5:57 2:36:18
6:37 2:53:55
7:18 3:11:32
7:58 3:29:09
8:38 3:46:46
8:53 3:53:12 ← Pheidippides
The table should start with the World Record pace and time which is 4:37, 2:01:04.
Then continues in 17 minute and 37 second intervals until you reach the marathon time of the user.
Use a static function to print the pace table, introduce a while loop.
For the first person it should call a printTable function
Example : printTable (pace, “<--- Eliud Kipchoge”) something like that
The pace table continues until it reaches the user
printTable (myPace, name) something like that
For the marathon and pace time, make sure the format has 0’s if the time is 9 seconds, it should be 09.
Use the printf statement for formatting output (“02d %f%s”)
In: Computer Science
Recent research indicates that the effectiveness of antidepressant medication is directly related to the severity of the depression (Khan, Brodhead, Kolts & Brown, 2005). Based on pretreatment depression scores, patients were divided into four groups based on their level of depression. After receiving the antidepressant medication, depression scores were measured again and the amount of improvement was recorded for each patient. The following data are similar to the results of the study.
| Low Moderate |
High Moderate |
Moderately Severe |
Severe |
|---|---|---|---|
| 3.3 | 0.7 | 2 | 2.8 |
| 0 | 2.7 | 2.3 | 3.2 |
| 3.2 | 4 | 1.1 | 1.9 |
| 2.6 | 1.4 | 1 | 4.2 |
| 0.8 | 2.8 | 2.7 | 1.4 |
| 2.9 | 2.5 | 3.3 | 1.7 |
| 1.1 | 0 | 1.8 | 1.1 |
| 2.9 | 2.6 | 1.8 | 3.2 |
| 4.5 | 2 | 4.7 | 3.5 |
| 1.6 | 0.3 | 1.5 | 1.5 |
| 3.3 | 1.6 | 0.7 | 3.4 |
| 1 | 1.5 | 3 | 3.2 |
| 0.6 | 2.2 | 1.8 | 2.1 |
| 2.3 | 2.6 | 2.7 | 1.4 |
| 3.7 | 1.9 | 1.1 | 2.1 |
| 2.8 | 4.7 | 1.9 | 1.5 |
| 1.7 | 1.2 | 1.5 | 2.6 |
| 1.6 | 0.9 | 0 | 4.1 |
| 1.8 | 3.4 | 1.4 | 3.6 |
| 2.1 | 2 | 1.4 | 2.3 |
| 2.1 | 0.2 | 2.4 | 0.7 |
| 2.4 | 1.1 | 2.1 | 1.9 |
| 3.3 | 3.4 | 2.2 | 2.4 |
| 0.1 | 0.3 | 2.2 | 2.6 |
| 4.5 | 2.5 | 1.1 | 3.5 |
| 2.6 | 1.9 | 3.7 | 3.1 |
| 2.7 | 1.3 | 3.1 | 2.5 |
| 1.9 | 2.5 | 1.1 | 2.6 |
| 1.7 | 2 | 1.7 | 3.8 |
| 1.3 | 2.5 | 2.9 | 2.5 |
| 1.5 | 1.5 | 2.2 | 3.3 |
| 2.5 | 4.2 | 1.6 | 3.2 |
| 4.2 | 3.3 | 2.1 | 3.4 |
| 2.1 | 1.4 | 3.3 | 2.1 |
| 1.5 | 2.7 | 0.4 | 1.5 |
| 1.2 | 3 | 1.4 | 1.5 |
| 1.9 | 1 | 1.7 | 3.8 |
| 1.1 | 1.5 | 2.8 | 2.6 |
| 3.4 | 1.5 | 1.5 | 1.1 |
| 1.2 | 2.5 | 1.3 | 2.5 |
| 3.5 | 1.8 | 0 | 1.9 |
| 1.1 | 3.7 | 0.2 | 2.5 |
| 2.8 | 1.5 | 0.9 | 2.5 |
| 1.2 | 0.7 | 3.7 | 0 |
| 1.1 | 1.5 | 1.3 | 3.4 |
| 3.2 | 2.5 | 2.7 | 1.9 |
| 0.3 | 1.2 | 1.3 | 3.1 |
| 0.4 | 1.9 | 3.8 | 2.1 |
| 1.6 | 2.8 | 2.5 | 4.1 |
| 2.2 | 2.2 | 2 | 4.1 |
| 3.5 | 2.6 | 0.3 | 2.1 |
| 2 | 3.9 | 4 | 3.8 |
| 2.4 | 1.6 | 2 | 4.1 |
| 0 | 1.3 | 1.4 | 3.6 |
| 3.7 | 2 | 2.8 | 2.5 |
| 0.8 | 1.5 | 2.4 | 1.5 |
| 4.4 | 0.5 | 2.2 | 3.2 |
| 2.8 | 2.1 | 1.8 | 1.5 |
| 3 | 3.1 | 2.4 | 1.8 |
| 1.6 | 0.7 | 1 | 2.6 |
| 1.7 | 1.8 | 3.7 | 3.9 |
This is the summary table for the ANOVA test:
| S.S. | d.f. | M.S. | |
| Between | 14.348360655737 | 3 | 4.7827868852458 |
|---|---|---|---|
| Within | 260.6737704918 | 240 | 1.0861407103825 |
| TOTAL | 275.02213114754 | 243 |
From this table, you obtain the necessary statistics for the
ANOVA:
F-ratio: 4.4034689424001
p-value: 0.00489
η2=η2= 0.052171658316617
What is your final conclusion? Use a significance level of
α=0.02α=0.02.
Explain what this tells us about the equality of mean?
Let's look at the boxplot for each treatment:
012345Depression ScoresLow ModerateHigh ModerateModerately SevereSevere
How could boxplots refine our conclusion in an ANOVA test? Your answer should address this specific problem.
Edit
Insert
Formats
In: Statistics and Probability
Recent research indicates that the effectiveness of antidepressant medication is directly related to the severity of the depression (Khan, Brodhead, Kolts & Brown, 2005). Based on pretreatment depression scores, patients were divided into four groups based on their level of depression. After receiving the antidepressant medication, depression scores were measured again and the amount of improvement was recorded for each patient. The following data are similar to the results of the study.
| Low Moderate |
High Moderate |
Moderately Severe |
Severe |
|---|---|---|---|
| 3.3 | 0.7 | 2 | 2.8 |
| 0 | 2.7 | 2.3 | 3.2 |
| 3.2 | 4 | 1.1 | 1.9 |
| 2.6 | 1.4 | 1 | 4.2 |
| 0.8 | 2.8 | 2.7 | 1.4 |
| 2.9 | 2.5 | 3.3 | 1.7 |
| 1.1 | 0 | 1.8 | 1.1 |
| 2.9 | 2.6 | 1.8 | 3.2 |
| 4.5 | 2 | 4.7 | 3.5 |
| 1.6 | 0.3 | 1.5 | 1.5 |
| 3.3 | 1.6 | 0.7 | 3.4 |
| 1 | 1.5 | 3 | 3.2 |
| 0.6 | 2.2 | 1.8 | 2.1 |
| 2.3 | 2.6 | 2.7 | 1.4 |
| 3.7 | 1.9 | 1.1 | 2.1 |
| 2.8 | 4.7 | 1.9 | 1.5 |
| 1.7 | 1.2 | 1.5 | 2.6 |
| 1.6 | 0.9 | 0 | 4.1 |
| 1.8 | 3.4 | 1.4 | 3.6 |
| 2.1 | 2 | 1.4 | 2.3 |
| 2.1 | 0.2 | 2.4 | 0.7 |
| 2.4 | 1.1 | 2.1 | 1.9 |
| 3.3 | 3.4 | 2.2 | 2.4 |
| 0.1 | 0.3 | 2.2 | 2.6 |
| 4.5 | 2.5 | 1.1 | 3.5 |
| 2.6 | 1.9 | 3.7 | 3.1 |
| 2.7 | 1.3 | 3.1 | 2.5 |
| 1.9 | 2.5 | 1.1 | 2.6 |
| 1.7 | 2 | 1.7 | 3.8 |
| 1.3 | 2.5 | 2.9 | 2.5 |
| 1.5 | 1.5 | 2.2 | 3.3 |
| 2.5 | 4.2 | 1.6 | 3.2 |
| 4.2 | 3.3 | 2.1 | 3.4 |
| 2.1 | 1.4 | 3.3 | 2.1 |
| 1.5 | 2.7 | 0.4 | 1.5 |
| 1.2 | 3 | 1.4 | 1.5 |
| 1.9 | 1 | 1.7 | 3.8 |
| 1.1 | 1.5 | 2.8 | 2.6 |
| 3.4 | 1.5 | 1.5 | 1.1 |
| 1.2 | 2.5 | 1.3 | 2.5 |
| 3.5 | 1.8 | 0 | 1.9 |
| 1.1 | 3.7 | 0.2 | 2.5 |
| 2.8 | 1.5 | 0.9 | 2.5 |
| 1.2 | 0.7 | 3.7 | 0 |
| 1.1 | 1.5 | 1.3 | 3.4 |
| 3.2 | 2.5 | 2.7 | 1.9 |
| 0.3 | 1.2 | 1.3 | 3.1 |
| 0.4 | 1.9 | 3.8 | 2.1 |
| 1.6 | 2.8 | 2.5 | 4.1 |
| 2.2 | 2.2 | 2 | 4.1 |
| 3.5 | 2.6 | 0.3 | 2.1 |
| 2 | 3.9 | 4 | 3.8 |
| 2.4 | 1.6 | 2 | 4.1 |
| 0 | 1.3 | 1.4 | 3.6 |
| 3.7 | 2 | 2.8 | 2.5 |
| 0.8 | 1.5 | 2.4 | 1.5 |
| 4.4 | 0.5 | 2.2 | 3.2 |
| 2.8 | 2.1 | 1.8 | 1.5 |
| 3 | 3.1 | 2.4 | 1.8 |
| 1.6 | 0.7 | 1 | 2.6 |
| 1.7 | 1.8 | 3.7 | 3.9 |
This is the summary table for the ANOVA test:
| S.S. | d.f. | M.S. | |
| Between | 14.348360655737 | 3 | 4.7827868852458 |
|---|---|---|---|
| Within | 260.6737704918 | 240 | 1.0861407103825 |
| TOTAL | 275.02213114754 | 243 |
From this table, you obtain the necessary statistics for the
ANOVA:
F-ratio: 4.4034689424001
p-value: 0.00489
η2=η2= 0.052171658316617
What is your final conclusion? Use a significance level of
α=0.02α=0.02.
Explain what this tells us about the equality of mean?
Let's look at the boxplot for each treatment:
012345Depression ScoresLow ModerateHigh ModerateModerately SevereSevere
How could boxplots refine our conclusion in an ANOVA test? Your answer should address this specific problem.
Edit
Insert
Formats
In: Statistics and Probability
Suppose the following data represent the ratings (on a scale from 1 to 5) for a certain smart phone game, with 1 representing a poor rating. Complete parts (a) through (d) below. Stars Frequency 1 2963 2 2372 3 4696 4 4393 5 10 comma 585 (a) Construct a discrete probability distribution for the random variable x. Stars (x) P(x) 1 nothing 2 nothing 3 nothing 4 nothing 5 nothing (Round to three decimal places as needed.) (b) Graph the discrete probability distribution. Choose the correct graph below. A. 1 2 3 4 5 0 0.1 0.2 0.3 0.4 0.5 A histogram has a horizontal axis labeled from 0 to 4 in intervals of 1 and a vertical axis labeled from 0 to 0.5 in intervals of 0.1 has five vertical lines positioned on the horizontal axis tick marks. The approximate heights of the vertical lines are as follows, with the horizontal coordinate listed first and the line height listed second: 1, 0.42; 2, 0.18; 3, 0.19; 4, 0.1; 5, 0.12. B. 1 2 3 4 5 0 0.1 0.2 0.3 0.4 0.5 A histogram has a horizontal axis labeled from 0 to 4 in intervals of 1 and a vertical axis labeled from 0 to 0.5 in intervals of 0.1 five vertical lines positioned on the horizontal axis tick marks. The approximate heights of the vertical lines are as follows, with the horizontal coordinate listed first and the line height listed second: 1, 0.12; 2, 0.1; 3, 0.19; 4, 0.18; 5, 0.42. C. 1 2 3 4 5 0 0.1 0.2 0.3 0.4 0.5 A histogram has a horizontal axis labeled from 0 to 4 in intervals of 1 and a vertical axis labeled from 0 to 0.5 in intervals of 0.1 five vertical lines positioned on the horizontal axis tick marks. The approximate heights of the vertical lines are as follows, with the horizontal coordinate listed first and the line height listed second: 1, 0.1; 2, 0.18; 3, 0.12; 4, 0.19; 5, 0.42. D. 1 2 3 4 5 0 0.1 0.2 0.3 0.4 0.5 A histogram has a horizontal axis labeled from 0 to 4 in intervals of 1 and a vertical axis labeled from 0 to 0.5 in intervals of 0.1 five vertical lines positioned on the horizontal axis tick marks. The approximate heights of the vertical lines are as follows, with the horizontal coordinate listed first and the line height listed second: 1, 0.19; 2, 0.18; 3, 0.42; 4, 0.12; 5, 0.1. (c) Compute and interpret the mean of the random variable x. The mean is nothing stars. (Round to one decimal place as needed.) Which of the following interpretations of the mean is correct? A. As the number of experiments decreases, the mean of the observations will approach the mean of the random variable. B. The observed value of an experiment will be less than the mean of the random variable in most experiments. C. The observed value of an experiment will be equal to the mean of the random variable in most experiments. D. As the number of experiments increases, the mean of the observations will approach the mean of the random variable. (d) Compute the standard deviation of the random variable x. The standard deviation is nothing stars. (Round to one decimal place as needed.)
In: Statistics and Probability
Mastery Problem: Corporations: Organization, Stock Transactions, and Dividends Pranks, Inc. Pranks, Inc. is a manufacturer of joke and novelty products for perpetrators of practical jokes. The corporation has paid several cash dividends throughout Year 6, the current year. It is also declaring a stock dividend to its stockholders as the calendar year-end approaches. You’ve been brought in as a consultant to assist with this process, and also to help determine whether some missing information can be determined before the distribution of the stock dividend is made. The company has two classes of stock: common stock and cumulative preferred stock. Number of common shares authorized 900,000 Number of common shares issued 750,000 Par value of common shares $20 Par value of cumulative preferred shares $30 Paid-in capital in excess of par-common stock $7,000,000 Paid-in capital in excess of par-preferred stock $0 Total retained earnings before the stock dividend is declared $33,500,000 No treasury share have been reissued. Preferred Dividends Common Dividends Year Total Cash Dividends Total Per Share Total Per Share Year 1 30,000 30,000 0.20 0 0.00 Year 2 54,000 54,000 0.36 0 0.00 Year 3 105,000 51,000 0.34 54,000 0.09 Year 4 135,000 45,000 0.3 90,000 0.15 Year 5 153,000 45,000 0.3 108,000 0.18 Year 6 225,000 45,000 0.3 180,000 0.3 Cash Dividends The accounting manager for the company prepared the schedule of cash dividends paid from Year 1 to Year 6 on the Pranks, Inc. panel. However, one of the reasons for Pranks, Inc.’s missing information is that the manager is away on vacation and is unreachable by phone, because he is backpacking on a remote island that does not have cell phone reception. Management would like you to determine some information from the data you’ve collected regarding its outstanding stock. Fill in the following answers. How many shares of common stock are outstanding? How many shares of preferred stock are outstanding? What is the preferred dividend as a percent of par? % Additional Questions 1. After completing the Cash Dividends panel, answer the following question. Does Pranks, Inc. have any treasury stock? How can you tell? 2. In which years has Pranks, Inc. paid cumulative preferred dividends in arrears? a. Year 1 b. Year 2 c. Year 3 d. Year 4 e. Year 5 f. Year 6 Stock Dividend The company declared a 2% common stock dividend on December 1, and would like you to compute the following pieces of missing information. The market value of the common shares is $26 on December 1, and is $30 on the actual distribution date of the stock, December 31. Fill in the missing information in the following table, using the information given and your work on the other panels. All “before” items are before the stock dividend was declared. All “after” items are after the stock dividend was declared and closing entries were recorded at the end of the year.
Total paid-in capital before the stock dividend $
Total retained earnings before the stock dividend $
Total stockholders’ equity before the stock dividend $
Total paid-in capital after the stock dividend $
Total retained earnings after the stock dividend $
Total stockholders’ equity after the stock dividend $
In: Accounting
ABC, Inc. is undergoing scrutiny for a possible wage discrimination suit. The following data is available: SALARY(monthly salary for each employee $), YEARS (years with the company), POSITION (position with company coded as: 1 = manual labor 2 = secretary 3 = lab technician 4 = chemist 5 = management EDUCAT (amount of education completed coded as: 1 = high school degree 2 = some college 3 = college degree 4 = graduate degree), GENDER (employee gender).
| SALARY | YEARS | POSITION | EDUCAT | GENDER |
| 1720 | 6 | 3 | 2 | female |
| 2400 | 4.9 | 1 | 1 | male |
| 1600 | 4.2 | 2 | 2 | female |
| 2900 | 3.7 | 4 | 3 | female |
| 1200 | 1.6 | 3 | 1 | female |
| 1000 | 0.3 | 3 | 1 | female |
| 2900 | 1 | 4 | 3 | male |
| 2400 | 1.8 | 4 | 3 | male |
| 1900 | 6.8 | 3 | 1 | female |
| 2200 | 1.2 | 4 | 3 | male |
| 1000 | 0.3 | 3 | 1 | female |
| 900 | 0.2 | 3 | 1 | female |
| 1250 | 0.6 | 3 | 1 | female |
| 950 | 0.5 | 3 | 1 | female |
| 2000 | 0.7 | 4 | 3 | male |
| 2000 | 1.9 | 4 | 3 | male |
| 1900 | 1.6 | 1 | 1 | male |
| 1000 | 1.4 | 3 | 1 | female |
| 1000 | 1.4 | 3 | 1 | female |
| 2800 | 3.4 | 4 | 3 | female |
| 2900 | 3.5 | 4 | 3 | male |
| 1550 | 3.1 | 3 | 1 | female |
| 1550 | 3 | 2 | 1 | female |
| 2200 | 2.5 | 4 | 3 | male |
| 1650 | 2.2 | 1 | 1 | male |
| 2200 | 2 | 4 | 3 | male |
| 900 | 0.5 | 3 | 1 | female |
| 1000 | 0.5 | 3 | 2 | female |
| 1220 | 2 | 3 | 1 | female |
| 2100 | 0.5 | 4 | 3 | male |
| 900 | 0.5 | 3 | 1 | female |
| 900 | 0.2 | 3 | 1 | female |
| 2000 | 0.5 | 4 | 3 | male |
| 2330 | 0.6 | 4 | 3 | male |
| 2400 | 0.3 | 4 | 3 | male |
| 900 | 1 | 1 | 1 | male |
| 1069 | 0.5 | 3 | 1 | female |
| 1400 | 0.5 | 1 | 1 | male |
| 1650 | 1 | 1 | 1 | male |
| 1200 | 0.3 | 1 | 1 | male |
| 3500 | 13.5 | 5 | 4 | male |
| 1750 | 11 | 5 | 3 | female |
| 4000 | 6.4 | 5 | 3 | male |
| 1800 | 7.2 | 2 | 1 | female |
| 4000 | 6.1 | 5 | 3 | male |
| 4600 | 5.8 | 5 | 4 | male |
| 1350 | 5.1 | 4 | 3 | male |
In: Statistics and Probability