#########################PANDAS LANGUAGE##################
#########################MATPLOT LIB#########################
# read movie.csv into a DataFrame called 'movie' # describe the dataframe #rename the column Runtime (Minutes) with Runtime_Minutes, and Revenue (Millions) with Revenue_Millions
# show if any column has null value
# count total number of null vlaues in the dataframe
# print those rows which has null values
# fill null values,
#if column is numerical than fill with means (if there is no numerical missing value in
#data frame then don't code in this)
#if column is categorical than fill with most frequent value (if there is no categorical missing value in
#data frame then don't code in this)
# plot histogram of the column name year in movie dataframe, which shows how many movies release in a year.
# print the movie detail with title 'Grumpier Old Men'.
# show those movies which are released after 1995-01-01
# sort the movie DataFrame in decending order based on release_date
# for each year, display the total number of movie with specific gerne for example Action=1000,adventure=400
# plot histogram the upper calculated total count
# filter the movies with specific gerne # like show only those movies which are selected Action gerne
# filter the movies with specific gerne
# like show only those movies which are selected Action gerne
# for each Director, display all the movies with detail.
# count the movies and plot barchart top 10 director's movies.
# for each Actor, display all the movies with detail.
# count the movies and visualize the top 10 actor's movies in plot
In [27]:
data file
| Rank | Title | Genre | Description | Director | Actors | Year | Runtime (Minutes) | Rating | Votes | Revenue (Millions) | Metascore | |
| 1 | Guardians of the Galaxy | Action,Adventure,Sci-Fi | A group of intergalactic criminals are forced to work together to stop a fanatical warrior from taking control of the universe. | James Gunn | Chris Pratt, Vin Diesel, Bradley Cooper, Zoe Saldana | 2014 | 121 | 8.1 | 757074 | 333.13 | 76 | |
| 2 | Prometheus | Adventure,Mystery,Sci-Fi | Following clues to the origin of mankind, a team finds a structure on a distant moon, but they soon realize they are not alone. | Ridley Scott | Noomi Rapace, Logan Marshall-Green, Michael Fassbender, Charlize Theron | 2012 | 124 | 7 | 485820 | 126.46 | 65 | |
| 3 | Split | Horror,Thriller | Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th. | M. Night Shyamalan | James McAvoy, Anya Taylor-Joy, Haley Lu Richardson, Jessica Sula | 2016 | 117 | 7.3 | 157606 | 138.12 | 62 | |
| 4 | Sing | Animation,Comedy,Family | In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists' find that their lives will never be the same. | Christophe Lourdelet | Matthew McConaughey,Reese Witherspoon, Seth MacFarlane, Scarlett Johansson | 2016 | 108 | 4.2 | 60545 | 270.32 | 59 | |
| 5 | Suicide Squad | Action,Adventure,Fantasy | A secret government agency recruits some of the most dangerous incarcerated super-villains to form a defensive task force. Their first mission: save the world from the apocalypse. | David Ayer | Will Smith, Jared Leto, Margot Robbie, Viola Davis | 2015 | 123 | 3.2 | 393727 | 325.02 | 40 | |
| 6 | The Great Wall | Action,Adventure,Fantasy | European mercenaries searching for black powder become embroiled in the defense of the Great Wall of China against a horde of monstrous creatures. | Yimou Zhang | Matt Damon, Tian Jing, Willem Dafoe, Andy Lau | 2014 | 103 | 6.1 | 56036 | 45.13 | 42 | |
| 7 | La La Land | Comedy,Drama,Music | A jazz pianist falls for an aspiring actress in Los Angeles. | Damien Chazelle | Ryan Gosling, Emma Stone, Rosemarie DeWitt, J.K. Simmons | 2013 | 128 | 5.3 | 258682 | 151.06 | 93 | |
| 8 | Mindhorn | Comedy | A has-been actor best known for playing the title character in the 1980s detective series "Mindhorn" must work with the police when a serial killer says that he will only speak with Detective Mindhorn, whom he believes to be a real person. | Sean Foley | Essie Davis, Andrea Riseborough, Julian Barratt,Kenneth Branagh | 2010 | 89 | 6.4 | 2490 | 71 | ||
In: Computer Science
Antuan Company set the following standard costs for one unit of its product.
| Direct materials (4.0 Ibs. @ $5.00 per Ib.) | $ | 20.00 |
| Direct labor (1.8 hrs. @ $11.00 per hr.) | 19.80 | |
| Overhead (1.8 hrs. @ $18.50 per hr.) | 33.30 | |
| Total standard cost | $ | 73.10 |
The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the factory’s capacity of 20,000 units per month. Following are the company’s budgeted overhead costs per month at the 75% capacity level.
| Overhead Budget (75% Capacity) | |||||
| Variable overhead costs | |||||
| Indirect materials | $ | 15,000 | |||
| Indirect labor | 75,000 | ||||
| Power |
15,000 |
||||
| Repairs and maintenance | 30,000 | ||||
| Total variable overhead costs | $ | 135,000 | |||
| Fixed overhead costs | |||||
| Depreciation—Building | 24,000 | ||||
| Depreciation—Machinery | 71,000 | ||||
| Taxes and insurance | 16,000 | ||||
| Supervision | 253,500 | ||||
| Total fixed overhead costs | 364,500 | ||||
| Total overhead costs | $ | 499,500 | |||
The company incurred the following actual costs when it operated at 75% of capacity in October.
| Direct materials (61,000 Ibs. @ $5.20 per lb.) | $ | 317,200 | |||
| Direct labor (19,000 hrs. @ $11.30 per hr.) | 214,700 | ||||
| Overhead costs | |||||
| Indirect materials | $ | 41,500 | |||
| Indirect labor | 176,050 | ||||
| Power | 17,250 | ||||
| Repairs and maintenance | 34,500 | ||||
| Depreciation—Building | 24,000 | ||||
| Depreciation—Machinery | 95,850 | ||||
| Taxes and insurance | 14,400 | ||||
| Supervision | 253,500 | 657,050 | |||
| Total costs | $ | 1,188,950 | |||
Required:
1&2. Prepare flexible overhead budgets for October showing the amounts of each variable and fixed cost at the 65%, 75%, and 85% capacity levels and classify all items listed in the fixed budget as variable or fixed.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
| 1. | ||||||||||||
| Rainier Company | Yakima Company | |||||||||||
| Materials inventory, May 1 | $100,000 | $48,200 | ||||||||||
| Materials inventory, May 31 | (A) | 50,000 | ||||||||||
| Materials purchased | 950,000 | 710,000 | ||||||||||
| Cost of direct materials used in production | 938,500 | (A) | ||||||||||
| Direct labor | 2,860,000 | (B) | ||||||||||
| Factory overhead | 1,800,000 | 446,000 | ||||||||||
| Total manufacturing costs incurred during May | (B) | 2,484,200 | ||||||||||
| Total manufacturing costs | 5,998,500 | 2,660,600 | ||||||||||
| Work in process inventory, May 1 | 400,000 | 176,400 | ||||||||||
| Work in process inventory, May 31 | 382,000 | (C) | ||||||||||
| Cost of goods manufactured | (C) | 2,491,500 | ||||||||||
| Finished goods inventory, May 1 | 615,000 | 190,000 | ||||||||||
| Finished goods inventory, May 31 | 596,500 | (D) | ||||||||||
| Sales | 9,220,000 | 4,550,000 | ||||||||||
| Cost of goods sold | (D) | 2,470,000 | ||||||||||
| Gross profit | (E) | (E) | ||||||||||
| Operating expenses | 1,000,000 | (F) | ||||||||||
| Net income | (F) | 1,500,000 | ||||||||||
| 2. | Yakima Company | |||||||||||
| Statement of Cost of Goods Manufactured | ||||||||||||
| For the Month Ended May 31 | ||||||||||||
| Work in process inventory, May 1 | $176,400 | |||||||||||
| Direct materials: | ||||||||||||
| Materials inventory, May 1 | $48,200 | |||||||||||
| Purchases | ||||||||||||
| Cost of materials available for use | ||||||||||||
| Materials inventory, May 31 | ||||||||||||
| Cost of direct materials used in production | ||||||||||||
| Direct labor | ||||||||||||
| Factory overhead | ||||||||||||
| Total manufacturing costs incurred during May | ||||||||||||
| Total manufacturing costs | $2,660,600 | |||||||||||
| Work in process inventory, May 31 | ||||||||||||
| Cost of goods manufactured | $2,491,500 | |||||||||||
| 3. | Yakima Company | |||||||||||
| Income Statement | ||||||||||||
| For the Month Ended May 31 | ||||||||||||
| Sales | $4,550,000 | |||||||||||
| Cost of goods sold: | ||||||||||||
| Finished goods inventory, May 1 | $190,000 | |||||||||||
| Cost of goods manufactured | 2,491,500 | |||||||||||
| Cost of finished goods available for sale | ||||||||||||
| Finished goods inventory, May 31 | ||||||||||||
| Cost of goods sold | ||||||||||||
| Gross profit | ||||||||||||
| Operating expenses | ||||||||||||
| Net income | $1,500,000 | |||||||||||
Several items are omitted from the income statement and cost of goods manufactured statement data for two different companies for the month of May:
| Rainier Company | Yakima Company | |
|---|---|---|
| Materials inventory, May 1 | $ 100,000 | $ 48,200 |
| Materials inventory, May 31 | (A) | 50,000 |
| Materials purchased | 950,000 | 710,000 |
| Cost of direct materials used in production | 938,500 | (A) |
| Direct labor | 2,860,000 | (B) |
| Factory overhead | 1,800,000 | 446,000 |
| Total manufacturing costs incurred in May | (B) | 2,484,200 |
| Total manufacturing costs | 5,998,500 | 2,660,600 |
| Work in process inventory, May 1 | 400,000 | 176,400 |
| Work in process inventory, May 31 | 382,000 | (C) |
| Cost of goods manufactured | (C) | 2,491,500 |
| Finished goods inventory, May 1 | 615,000 | 190,000 |
| Finished goods inventory, May 31 | 596,500 | (D) |
| Sales | 9,220,000 | 4,550,000 |
| Cost of goods sold | (D) | 2,470,000 |
| Gross profit | (E) | (E) |
| Operating expenses | 1,000,000 | (F) |
| Net income | (F) | 1,500,000 |
Instructions
For both companies, determine the amounts of the missing items (A) through (F), identifying them by letter.
Check Figure: B. Yakima Company, $1,330,000
Prepare Yakima Company's statement of cost of goods manufactured for May.
Prepare Yakima Company's income statement for May.
In: Accounting
A purely competitive nut and bolt manufacturer faces a market price of $7.00, an average total cost of $7.50, an average variable cost of $6.00, and a marginal cost of $6.75. Should this firm expand output, contract output, or shut down in the short-run? Use a graph to illustrate your answer, making sure to indicate these price and cost values
In: Economics
. The purchased cost of 200000 inch3 stainless hemispherical tank in 1996 was RO 10700. If the tank is covered fully with 2 inch thickness magnesia block, estimate the present total cost for installed and insulated tank. The cost for covering 2 inch magnesia was 5.1 RO per ft2 and installation labor cost 4.3 RO per ft2 .
In: Other
Lamps R Us makes lamps. The variable materials cost $8.85 per unit. The variable labor cost is $8.10 per unit.
what is variable cost per unit
suppose Lamps R Us has fixed costs of $800,000 during the year in which its total production is 150,000 units. What are the total costs for the year?
If the selling price is $39.99 per unit. Does Lamps R Us break even on a cash basis? If depreciation is $400,000 per year, what is the accounting break-even point?
(Use Excel and Excel Formulas)
In: Finance
Complete all true or false questions
Firms maximize profits where MR=MC. MR= dTR/dQ , MC= dTC/dQ Using the following Total Revenue and Cost functions to answer the following questions.
TR= 50Q TC=10Q^2 - 50Q +100
_____ (1) Marginal Revenue is $50 and is constant over all Q.
_____ (2) Profits are maximized at a Q more than 20.
_____ (3) The total cost function is in the form of a quadratic function.
_____ (4) Marginal Cost is: MC= 20Q-100
_____ (5) Profits (TR-TC) at the maximum is greater than $280.
In: Economics
A Company produces and sells two types of smart phones. The price of Type-1 and Type –II smart phone assigned by Hamza is Rs. 120,000 per unit and 135,000 respectively. Variable cost for producing type-I phone is Rs. 150,000 and type –II is Rs. 300,000. Suppose there is Rs. 500,000 fixed cost.1. Formulate revenue and cost function for type-I and type-II smart phone jointly.2. Formulate total profit function3. What will be the total profit if Hamza produces and sells 500 sets of type-I and 750 sets of type – II.
In: Economics
Consider the quarterly demand of 3500, 2600, 5500, 4400, for quarters 1,2,3,4, respectively. Let the production standard be 250 items/quarter. Let the carrying cost be $5/item/quarter.
If the beginning annual inventory is 500 but the ending annual inventory objective is 620,
then what is the total annual carrying cost for the aggregate planning strategies listed?
|
Select One Answer |
Aggregate Planning Strategy |
Total Annual Carrying Cost |
|
|
A |
Level Capacity |
25500 |
|
|
B |
Chase Demand |
11200 |
|
|
C |
Level Capacity |
6375 |
|
|
D |
Chase Demand |
11500 |
|
|
E |
None of the above |
In: Accounting
High-Low Method
Impeccable Puppy Training, Inc. provides classes that are popular with dog owners. The number of classes offered over five months, along with the total costs of offering these classes, follows:
Classes Offered Costs Incurred
April 10 $9,500
May 8 $9,000
June 20 $18,000
July 13 $12,000
August 18 $17,500
1. Using the high-low method, determine AND state the cost formula (3 points):
2. Using the cost formula, determine the total cost of offering 25 puppy training classes in September (3 points):
In: Accounting