Required information
[The following information applies to the questions
displayed below.]
In 2018, the Westgate Construction Company entered into a contract
to construct a road for Santa Clara County for $10,000,000. The
road was completed in 2020. Information related to the contract is
as follows:
| 2018 | 2019 | 2020 | |||||||
| Cost incurred during the year | $ | 2,204,000 | $ | 3,192,000 | $ | 2,424,400 | |||
| Estimated costs to complete as of year-end | 5,396,000 | 2,204,000 | 0 | ||||||
| Billings during the year | 2,140,000 | 3,256,000 | 4,604,000 | ||||||
| Cash collections during the year | 1,870,000 | 3,200,000 | 4,930,000 | ||||||
Westgate recognizes revenue over time according to percentage of
completion.
rev: 09_15_2017_QC_CS-99734
4. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)
In: Accounting
Required information
[The following information applies to the questions
displayed below.]
In 2018, the Westgate Construction Company entered into a contract
to construct a road for Santa Clara County for $10,000,000. The
road was completed in 2020. Information related to the contract is
as follows:
| 2018 | 2019 | 2020 | |||||||
| Cost incurred during the year | $ | 2,204,000 | $ | 3,192,000 | $ | 2,424,400 | |||
| Estimated costs to complete as of year-end | 5,396,000 | 2,204,000 | 0 | ||||||
| Billings during the year | 2,140,000 | 3,256,000 | 4,604,000 | ||||||
| Cash collections during the year | 1,870,000 | 3,200,000 | 4,930,000 | ||||||
Westgate recognizes revenue over time according to percentage of
completion.
rev: 09_15_2017_QC_CS-99734
5. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.)
In: Accounting
Bottoms Up Diaper Service is considering the purchase of a new industrial washer for a 4-year project. The old machine was bought 3 years ago for $10,000 and will be depreciated to 1,000 using straight-line method with an assume life of 5 years. Actually, the old machine can be sold for $8,000 now. The new washer can be installed today for $12,000. The new machine will have a 3-year life and will be depreciated to $3,000 using straight-line depreciation. At the end of the project life, the after-tax cash flow of selling the machine is $3,000. With the new washer, the firm is expected to have revenue of $10,000, $12,000, and $13,000 for each of the next three years. The COGS is 40% of the revenue, and the SG&A is $3,000 each year. Suppose Bottoms Up Diaper Service’s inventories are 15% of total expense. If the opportunity cost of capital is 9%, and corporate tax rate is 35%, what is the project’s NPV?
In: Finance
"There are different sections that make up a classified income statement. The first section is operating revenue, this is the revenue that is earned from normal business activities. The next section is the cost of goods sold, where the information pertaining to the cost of merchandise sold during that period; three entries are needed for this section: beginning inventory, net delivered cost of purchases, and ending inventory. The next section is gross profit, which is the difference in net sales and cost of goods sold. Operating expenses are the expenses that are accumulated during normal business activities. Net income and net loss from operations is separated for easier readability. Other expenses and incomes are entered into different sections along with net income and net losses. Sometimes a condensed income statement is provided with summarized information in fewer lines of information." Is this information substantially different from the income statement that you would normally consider? Why do we call it classified?
In: Accounting
In the Chicago mayor's race, candidate A proposes a project that will cost $200,000 today (t=0), $100,000 next year (t=1) and $15,000 to destroy it after ten years of operation (t=12) when the project is discontinued. Once finished in three years (t=3), it will generate a flow of revenue of $40,000 per year until it is discontinued in (t=12) - ie in t=12 the project generates that flow of revenue too.
1. Set the discount rate as r and write the expected present value of the costs and benefits.
2. Calculate the present value of the project if the discount rate is r=.1
3. Candidate B considers that a discount rate r=.3 is more realistic. Calculate the present value of the project with this new discount rate proposed by Candidate B. Why do you think Candidate B has an interest in convincing the public that her discount rate is more realistic?
In: Finance
Question 3 Scranton Motors Ltd faced the following situations. Journalize the adjusting entry needed at year end for each situation. Each scenario should be considered independently. The business has interest expense of $9,000 early in January 2017. Interest revenue of $3,000 has been earned but not yet received. When the business collected $12,000 in advance three months ago, the accountant debited Cash and credited Unearned Revenue. The client was paying for two cars, one delivered in December, the other to be delivered in February 2017. Salary expense is $1,000 per day – Monday through Friday – and the business pays employees each Friday. For example purposes, assume that this year, December 31 falls on a Tuesday. The unadjusted balance of the Supplies account is $3,100. The total cost of supplies on hand is $800. Equipment was purchased at the beginning of this year at a cost of $60,000. The equipment’s useful life is five years. Record the depreciation for this year and then determine the equipment’s carrying amount.
In: Accounting
Suppose you are working at Air Italy, a commercial airline company in the European Union, and you recently purchased an order of 5 new planes of the Boeing 737 Max 8 for a total of $622 million from Boeing, a United States airplane manufacturer. Due to the news of two recent accidents likely linked to the software on these planes, Air Italy no longer wants to risk using them. Thus, Air Italy decides to return the order to Boeing for the full price. In order to receive all the funds, you must return this plane in 3 months (the remaining length of the warrantee), at which time Boeing will then pay you. However, you will have to convert this entire dollar payment into Euros in order to cover wages, routine maintenance costs, and administrative costs. You anticipate the dollar will depreciate relative to the euro and consider hedging the foreign exchange risk by using a forward contract to sell dollars for Euros. Today’s spot and 3-month forward exchange rates are given below.
Spot Price: $1 = € 0.901 3-Month Forward Price: $1 = € 0.889
a) Assuming that there are no transactions costs, how many Euros will Air Italy receive in three months if it enters into the forward contract?
b) If Air Italy does not hedge its risk and the exchange rate remains constant, how many Euros will it receive in three months?
c) Now, suppose that the dollar does in fact depreciate and that its spot price three months from today equals €0.876. If Air Italy does not hedge, how much revenue does the company lose from the exchange rate fluctuation (compared to what they would have made without hedging if the exchange rate had remained constant)?
d) Assuming the spot rate equals €0.876 three months from today, would entering into the forward contract have been a good idea in this case? Explain your answer.
e) If after three months the dollar has appreciated by exactly 5.0% and Air Italy has a hedged position, what is the value of its forgone revenue (i.e. what are the company's lost profits)?
In: Economics
Can annual sports team revenues be used to predict franchise values?
Team Revenue ($mil) Value ($mil)
Team 1 554 2806
Team 2 676 3437
Team 3 371 1333
Team 4 628 3202
Team 5 559 1852
Team 6 312 691
Team 7 342 858
Team 8 355 851
Team 9 394 869
Team 10 219 482
Team 11 258 579
Team 12 224 513
Team 13 516 414
Team 14 203 347
Team 15 156 329
Team 16 177 326
Team 17 162 307
Team 18 332 599
Team 19 411 863
Team 20 157 296
A. At the 0.05 level of significance, is there evidence of a linear relationship between the annual revenues generated and the value of a soccer franchise?
- The null and alternative hypotheses ?
- The value is?
- the test statistic is ?
B. Construct a 95% confidence interval estimate of the mean value of all soccer franchises that generate $300 million of annual revenue.
C. Construct a 95% prediction interval of the value of an individual soccer franchise that generates $300 million of annual revenue.
In: Statistics and Probability
Question 1
If you lower the price of a product by 5% and the volume sold increases by 10%, this is considered _____.
Question 2
A negative aspect of selecting unit volume as a pricing objective is that..
Question 3
Netflix used to charge $14.99 per month for its movie rental service. However, when Blockbuster introduced the same service at $13.99, Netflix dropped its price to $13.99. Netflix most likely made this price reduction in an attempt to...
Question 4
Buyers are more price sensitive when _____.
In: Economics
| Employee | Project | Hours Week1 | Hours Week2 | Hours Week3 | Hours Week4 |
| Sophia | APC101 | 47 | 64 | 73 | 25 |
| Isabella | APC101 | 33 | 72 | 73 | 46 |
| Emma | APC101 | 33 | 51 | 44 | 53 |
| Olivia | APC101 | 31 | 3 | 49 | 19 |
| Ava | APC101 | 37 | 35 | 60 | 21 |
| Emily | APC101 | 62 | 32 | 58 | 11 |
| Abigail | APC101 | 37 | 65 | 47 | 77 |
| Madison | FXCK301 | 33 | 40 | 12 | 50 |
| Mia | FXCK301 | 15 | 49 | 5 | 57 |
| Chloe | FXCK301 | 69 | 55 | 58 | 21 |
| Elizabeth | FXCK301 | 46 | 60 | 7 | 38 |
| Ella | FXCK301 | 38 | 58 | 77 | 25 |
| Addison | FXCK301 | 14 | 55 | 28 | 38 |
| Natalie | FXCK301 | 66 | 9 | 11 | 74 |
| Lily | VERZ123 | 28 | 74 | 52 | 22 |
| Grace | VERZ123 | 52 | 18 | 36 | 21 |
| Samantha | VERZ123 | 25 | 67 | 56 | 46 |
| Avery | VERZ123 | 76 | 49 | 43 | 50 |
| Sofia | TMOB001 | 43 | 30 | 51 | 56 |
| Aubrey | TMOB001 | 47 | 44 | 40 | 23 |
| Brooklyn | TMOB001 | 6 | 3 | 40 | 35 |
| Lillian | TMOB001 | 64 | 55 | 17 | 44 |
| Victoria | TMOB001 | 42 | 57 | 41 | 27 |
| Evelyn | TCK999 | 41 | 51 | 27 | 36 |
| Hannah | TCK999 | 4 | 49 | 15 | 58 |
| Alexis | TCK999 | 50 | 48 | 48 | 16 |
| Charlotte | TCK999 | 58 | 55 | 33 | 19 |
| Zoey | TCK999 | 51 | 46 | 8 | 34 |
| John | STUB301 | 73 | 42 | 60 | 46 |
| Nathan | STUB301 | 24 | 16 | 79 | 43 |
| Lucas | STUB301 | 42 | 57 | 10 | 50 |
| Christian | STUB301 | 51 | 56 | 34 | 79 |
| Jonathan | STUB301 | 17 | 58 | 58 | 74 |
| Caleb | STUB301 | 10 | 58 | 64 | 30 |
| Dylan | VN095 | 22 | 51 | 50 | 52 |
| Landon | VN095 | 51 | 41 | 59 | 40 |
| Isaac | VN095 | 5 | 38 | 54 | 54 |
| Gavin | VN095 | 53 | 41 | 54 | 10 |
| Brayden | VN095 | 59 | 2 | 44 | 67 |
| Tyler | VN095 | 65 | 47 | 7 | 53 |
| Luke | VN095 | 48 | 5 | 9 | 41 |
| Evan | VN095 | 58 | 52 | 26 | 56 |
| Carter | VN095 | 2 | 38 | 57 | 20 |
| Nicholas | VN095 | 44 | 54 | 65 | 6 |
| Isaiah | VN095 | 67 | 50 | 26 | 75 |
| Owen | VN095 | 48 | 32 | 19 | 48 |
| Jack | GUA001 | 51 | 67 | 62 | 44 |
| Jordan | GUA001 | 50 | 7 | 61 | 29 |
| Brandon | GUA001 | 54 | 53 | 42 | 61 |
| Wyatt | GUA001 | 63 | 73 | 26 | 17 |
| Julian | GUA001 | 26 | 34 | 60 | 61 |
| Aaron | GUA001 | 52 | 28 | 52 | 38 |
| Jeremiah | DEF001 | 40 | 43 | 17 | 11 |
| Angel | DEF001 | 75 | 31 | 17 | 44 |
| Cameron | DEF001 | 10 | 58 | 40 | 62 |
| Connor | DEF001 | 15 | 60 | 17 | 70 |
| Hunter | DEF001 | 52 | 62 | 69 | 37 |
| Adrian | DEF001 | 38 | 40 | 24 | 8 |
| Employee | Employee ID | Rate per hour ($) |
| Aaron | 1 | 94 |
| Aarony | 2 | 55 |
| Abigail | 3 | 21 |
| Addison | 4 | 60 |
| Adrian | 5 | 16 |
| Alex | 6 | 55 |
| Alexis | 7 | 44 |
| Angel | 8 | 55 |
| Aubrey | 9 | 46 |
| Ava | 10 | 79 |
| Avan | 11 | 44 |
| Avery | 12 | 69 |
| Brand | 13 | 55 |
| Brandon | 14 | 22 |
| Brayden | 15 | 95 |
| Brooklyn | 16 | 14 |
| Caleb | 17 | 37 |
| Cameron | 18 | 79 |
| Carter | 19 | 42 |
| Charlotte | 20 | 90 |
| Chloe | 21 | 65 |
| Christian | 22 | 42 |
| Christianie | 23 | 55 |
| Connor | 24 | 83 |
| Connory | 25 | 55 |
| Dylan | 26 | 12 |
| Elizabeth | 27 | 30 |
| Ella | 28 | 68 |
| Emily | 29 | 46 |
| Emma | 30 | 15 |
| Evan | 31 | 38 |
| Evelyn | 32 | 95 |
| Evene | 33 | 55 |
| Gavin | 34 | 72 |
| Grace | 35 | 95 |
| Hannah | 36 | 44 |
| Hunter | 37 | 94 |
| Isaac | 38 | 89 |
| Isabell | 39 | 11 |
| Isabella | 40 | 28 |
| Isaiah | 41 | 59 |
| Jack | 42 | 59 |
| Jeremiah | 43 | 98 |
| John | 44 | 50 |
| Jonath | 45 | 55 |
| Jonathan | 46 | 8 |
| Jordan | 47 | 76 |
| Julian | 48 | 92 |
| Landon | 49 | 33 |
| Lillian | 50 | 60 |
| Lily | 51 | 88 |
| Lucas | 52 | 18 |
| Luke | 53 | 16 |
| Madison | 54 | 77 |
| Mia | 55 | 12 |
| Miana | 56 | 33 |
| Natalia | 57 | 55 |
| Natalie | 58 | 28 |
| Nathan | 59 | 59 |
| Nicholas | 60 | 13 |
| Olivia | 61 | 55 |
| Owen | 62 | 71 |
| Samantha | 63 | 83 |
| Sofi | 64 | 55 |
| Sofia | 65 | 44 |
| Sophia | 66 | 54 |
| Tyler | 67 | 49 |
| Victoria | 68 | 22 |
| Wyatt | 69 | 75 |
| Zoey | 70 | 18 |
| Project | Payments |
| STUB301 | 12,000 |
| FXCK301 | 10,000 |
| TCK999 | 10,000 |
| VERZ123 | 10,000 |
| FXCK301 | 9,000 |
| GUA001 | 3000 |
| TMOB001 | 10,000 |
| STUB301 | 20,000 |
| VN095 | 17,000 |
| DEF001 | 35000 |
| VN095 | 5,000 |
| DEF001 | 5000 |
| VN095 | 9,000 |
| GUA001 | 23000 |
| APC101 | 15000 |
| TCK999 | 3,000 |
| GUA001 | 8000 |
| STUB301 | 16,000 |
| DEF001 | 4000 |
| FXCK301 | 10,000 |
| VN095 | 15,000 |
| STUB301 | 18,000 |
| TCK999 | 15,000 |
| VN095 | 13,000 |
| FXCK301 | 10,000 |
| TMOB001 | 10,000 |
| GUA001 | 18000 |
| APC101 | 5000 |
| APC101 | 15000 |
| TMOB001 | 10,000 |
| VN095 | 11,000 |
| FXCK301 | 1,000 |
| VERZ123 | 10,000 |
| VERZ123 | 10,000 |
| GUA001 | 13000 |
| DEF001 | 5000 |
| TMOB001 | 10,000 |
| VERZ123 | 10,000 |
| VN095 | 7,000 |
| TCK999 | 5,000 |
| APC101 | 15000 |
| APC101 | 25000 |
| STUB301 | 14,000 |
| DEF001 | 15000 |
| DEF001 | 25000 |
| STUB301 | 10,000 |
| FXCK301 | 1,000 |
| TCK999 | 10,000 |
| APC101 | 5000 |
| GUA001 | 28000 |
| APC101 | 5000 |
| General question for the company: | |||||||||||||
| 1 | How many projects does this company have? | ||||||||||||
| 2 | What is the average total working hours per week for the whole company? | ||||||||||||
| 3 | Who work the most during this 4 weeks? Report his/her ID (clearly it is not included in Working hours sheet but you have to find it) | ||||||||||||
| 4 | Over this reporting period, who have the highest pay rate? | ||||||||||||
| Project level questions: | |||||||||||||
| 5 | Which project have the highest revenue? | ||||||||||||
| 6 | What is the total profit for the company over this reporting window? | ||||||||||||
| 7 | What is the (%) gross profit margin for the whole company? If the answer is 25.23%, simply put 25.23 on Sakai | ||||||||||||
| 8 | Which project posts the largest $ profit? | ||||||||||||
| 9 | Which project posts the largest profit margin? | ||||||||||||
| 10 | Which project posts the largest dollar loss? | ||||||||||||
| 11 | Which project posts the lowest profit margin? | ||||||||||||
| 12 | Report the (%) gross profit margin for project that have the highest margin. If the answer is 25.23%, simply put 25.23 on Sakai | ||||||||||||
In: Finance