2.) Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved.
| Transportation Costs | Gross-Ton Miles | |||
| January | $896,400 | 265,000 | ||
| February | 999,400 | 296,000 | ||
| March | 706,300 | 192,000 | ||
| April | 958,200 | 287,000 | ||
| May | 803,600 | 231,000 | ||
| June | 1,030,300 | 312,000 | ||
Determine the variable cost per gross-ton mile and the fixed cost.
| Variable cost (Round to two decimal places.) | $ per gross-ton mile |
| Total fixed cost |
3.) For a recent year, Wicker Company-owned restaurants had the following sales and expenses (in millions):
| Sales | $31,900 |
| Food and packaging | $12,490 |
| Payroll | 8,000 |
| Occupancy (rent, depreciation, etc.) | 5,850 |
| General, selling, and administrative expenses | 4,600 |
| $30,940 | |
| Income from operations | $960 |
Assume that the variable costs consist of food and packaging, payroll, and 40% of the general, selling, and administrative expenses.
a. What is Wicker Company's contribution
margin? Round to the nearest million. (Give answer in millions of
dollars.)
$ million
b. What is Wicker Company's contribution margin
ratio? Round to one decimal place.
%
c. How much would income from operations
increase if same-store sales increased by $1,900 million for the
coming year, with no change in the contribution margin ratio or
fixed costs? Round your answer to the closest million.
$ million
4.) Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $369,000, and the sales mix is 30% bats and 70% gloves. The unit selling price and the unit variable cost for each product are as follows:
| Products | Unit Selling Price | Unit Variable Cost | ||
| Bats | $60 | $50 | ||
| Gloves | 150 | 90 | ||
a. Compute the break-even sales (units) for
both products combined.
units
b. How many units of each product, baseball bats and baseball gloves, would be sold at break-even point?
| Baseball bats | units |
| Baseball gloves | units |
In: Accounting
Several months ago, Ayers Industries Inc. experienced a hazardous materials spill at one of its plants. As a result, the Environmental Protection Agency (EPA) fined the company $258,000. The company is contesting the fine. In addition, an employee is seeking $202,000 in damages related to the spill. Lastly, a homeowner has sued the company for $310,000. The homeowner lives 35 miles from the plant but believes that the incident has reduced the home’s resale value by $310,000.
Ayers’ legal counsel believes that it is probable that the EPA fine will stand. In addition, counsel indicates that an out-of-court settlement of $140,000 has recently been reached with the employee. The final papers will be signed next week. Counsel believes that the homeowner’s case is much weaker and will be decided in favor of Ayers. Other litigation related to the spill is possible, but the damage amounts are uncertain.
Several months ago, Ayers Industries Inc. experienced a hazardous materials spill at one of its plants. As a result, the Environmental Protection Agency (EPA) fined the company $258,000. The company is contesting the fine. In addition, an employee is seeking $202,000 in damages related to the spill. Lastly, a homeowner has sued the company for $310,000. The homeowner lives 35 miles from the plant but believes that the incident has reduced the home’s resale value by $310,000.
Several months ago, Ayers Industries Inc. experienced a hazardous materials spill at one of its plants. As a result, the Environmental Protection Agency (EPA) fined the company $258,000. The company is contesting the fine. In addition, an employee is seeking $202,000 in damages related to the spill. Lastly, a homeowner has sued the company for $310,000. The homeowner lives 35 miles from the plant but believes that the incident has reduced the home’s resale value by $310,000.
Ayers’ legal counsel believes that it is probable that the EPA fine will stand. In addition, counsel indicates that an out-of-court settlement of $140,000 has recently been reached with the employee. The final papers will be signed next week. Counsel believes that the homeowner’s case is much weaker and will be decided in favor of Ayers. Other litigation related to the spill is possible, but the damage amounts are uncertain.
| Required: | |
| a. Journalize the contingent liabilities associated with the hazardous materials spill. Use the account “Damage Awards and Fines” to recognize the expense for the period. Refer to the Chart of Accounts for exact wording of account titles. | |
In: Accounting
Your task in this exercise is to write a function called get_playlist_tracks(database_filename, which_playlist), which formulates a SELECT statement that returns track name, album title, genre name, artist name and track composer for all tracks in the database which are associated with a given playlist. This statement requires several nested INNER JOINs to pull together data from the "tracks", "albums", "genres", "artists", and "playlists" table. The default ordering of tracks should be used. The result of the function is a list of database records. The parameter which_playlist specifies a playlist in the database. You first have to check if the playlist is contained in the "playlists" table, if not an error message as indicated in the examples has to be printed and an empty list has to be returned.
Don't forget to close the database connection after you have finished accessing it!
For example:
| Test | Result |
|---|---|
database_filename = 'chinook.db'
which_playlist = 'On-The-Go 1'
query_result = get_playlist(database_filename, which_playlist)
print(f"Playlist '{which_playlist}'")
for count, database_record in enumerate(query_result):
print(f"{count:<2} Track Name: {database_record[0]}")
print(f" Album Title: {database_record[1]}")
print(f" Genre: {database_record[2]}")
print(f" Artist: {database_record[3]}")
print(f" Composer: {database_record[4]}") |
Playlist 'On-The-Go 1' 0 Track Name: Now's The Time Album Title: The Essential Miles Davis [Disc 1] Genre: Jazz Artist: Miles Davis Composer: Miles Davis |
database_filename = 'chinook.db' which_playlist = 'Independent' query_result = get_playlist(database_filename, which_playlist ) for database_record in query_result: print(database_record) |
ERROR: Could not find playlist 'Independent' in database! |
------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is my code so far but dones't work. the output shows that there is no such table as track;
import sqlite3
def get_playlist(database_filename, which_playlist):
file_in = sqlite3.connect(database_filename)
curser_object = file_in.cursor()
curser_object.execute("""Select T.name, A.Title, G.name, A1.name,
T.composer
From track T
Join Album A On A.AlbumId = T.AlbumId
Join Genre G On G.GenreId = T.GenreId
Join Artist A1
On A1.ArtistId = A.ArtistId
Join PlaylistTrack P2
On P2.TrackId = T.TrackId
Join Playlist P
On P.PlaylistId = p2.PlaylistId
Where P.name =?""",(which_playlist,))
ViewData = curser_object.fetchall()
DataTableCompAndClient([ViewData])
file_in.close()
return ViewData
In: Computer Science
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
The price of Stock A today is 50, and stock B is 100. The
probability of a booming, normal, and recessionary economy are 0.2,
0.7, and 0.1 respectively. If the economy is booming, stock’s A
price will be 65 and stock B will be 108. If the economy is normal,
stock’s A price will be 55 and stock’s B will be 105. If the econ
falls into recession, stock’s A price will be 40 and stock’s B will
be 102.
a) Calculate the expected return and standard deviation for each
stock.
b) Assume you create a portfolio and put 50% of you money in stock
A and 50% of you money in stock B. Calculate the portfolio expected
return and standard deviation.
Please show formula and steps
In: Finance
1) A nutritionist claims that the proportion of females who consume too much saturated fat is lower than the proportion of males who consume too much saturated fat. In interviews with 513 randomly selected females, she determines that 300 consume too much saturated fat. In interviews with 564 randomly selected males, she determines that 391 consume too much saturated fat.
Do the data support the claim that the proportion of females who consume too much saturated fat is less than the proportion of males who consume too much saturated fat? Use α = 0.05 and the 4-step process.
2)
The developer of a new filter for filter-tipped cigarettes claims that it leaves less nicotine in the smoke than does the current filter. Because cigarette brands differ in a number of ways, he tests each filter on one cigarette of each of nine randomly selected brands and records the difference in nicotine content. His results are given in the table below.
|
Brand |
A |
B |
C |
D |
E |
F |
G |
H |
J |
|
Old Filter nicotine, mg |
0.7 |
0.8 |
0.8 |
0.9 |
0.9 |
1.0 |
1.2 |
1.2 |
1.8 |
|
New Filter nicotine, mg |
0.6 |
0.6 |
0.7 |
0.8 |
0.7 |
1.0 |
0.8 |
0.9 |
1.5 |
Does the data give convincing evidence that the filter tips leave less nicotine in the smoke? Follow the 4-step process.
old=c(.7, .8, .8, .9, .9, 1, 1.2, 1.2, 1.8)
new=c(.6, .6, .7, .8, .7, 1, .8, .9, 1.5)
3)
An investor with a stock portfolio worth several hundred thousand dollars sued his broker and brokerage firm because lack of diversification in his portfolio led to poor performance. The following data lists the rates of return, in percent, for a random sample of 39 months that the account was managed by the broker. The arbitration panel compared these returns with the average S&P 500 for the same period.
stock=c(-8.36, 1.63, -2.27, -2.93, -2.70, -2.93, -9.14, -2.64, 6.82, -2.35, -3.58, 6.13, 7.00, -15.25, -8.66, -1.03, -9.16, -1.25, -1.22, -10.27, -5.11, -0.80, -1.44, 1.28, -0.65, 4.34, 12.22, -7.21, -0.09, 7.34, 5.04, -7.24, -2.14, -1.01, -1.41, 12.03, -2.56, 4.33, 2.35)
Does the data show that the mean return is different from 0.95%, the average return for the S&P 500. Use α = 0.01 and the 4-step process.
4) A random sample of 328 medical doctors showed that 171 had a solo practice. Find and interpret a 95% confidence interval for the proportion of all doctors who have a solo practice. Follow the 4-step process.
5)
You are conduction a t-test for the mean using a sample of 9 observations. Do the following graphs indicate that it is safe to conclude the sample data is normal? Explain.
answer all please. thank you.
In: Statistics and Probability