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,523,000 |
$ |
3,177,000 |
$ |
1,980,000 |
|||
|
Estimated costs to complete as of year-end |
6,177,000 |
1,800,000 |
0 |
||||||
|
Billings during the year |
2,070,000 |
3,630,000 |
4,300,000 |
||||||
|
Cash collections during the year |
1,835,000 |
3,400,000 |
4,765,000 |
||||||
Westgate recognizes revenue over time according to percentage of
completion.
Required:
1. Calculate the amount of revenue and gross
profit (loss) to be recognized in each of the three years.
2-a. In the journal below, complete the necessary
journal entries for the year 2018 (credit "Various accounts" for
construction costs incurred).
2-b. In the journal below, complete the necessary
journal entries for the year 2019 (credit "Various accounts" for
construction costs incurred).
2-c. In the journal below, complete the necessary
journal entries for the year 2020 (credit "Various accounts" for
construction costs incurred).
3. Complete the information required below to
prepare a partial balance sheet for 2018 and 2019 showing any items
related to the contract.
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.
|
2018 |
2019 |
2020 |
|||||||
|
Cost incurred during the year |
$ |
2,523,000 |
$ |
3,835,000 |
$ |
3,235,000 |
|||
|
Estimated costs to complete as of year-end |
6,177,000 |
3,135,000 |
0 |
||||||
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.
|
2018 |
2019 |
2020 |
|||||||
|
Cost incurred during the year |
$ |
2,523,000 |
$ |
3,835,000 |
$ |
4,005,000 |
|||
|
Estimated costs to complete as of year-end |
6,177,000 |
4,170,000 |
0 |
||||||
In: Accounting
The 160th Ohio State Fair in 2013 had an estimated 903,824 visitors during the twelve days of the fair, which was record-breaking attendance. The high attendance led to a record-breaking profit of about $400,000 for the fair. Among the sources of revenue for The Ohio State Fair are the revenues generated from the food vendors. A number of food vendors offer a wide variety of fair foods to attendees, including funnel cakes, gyros, cotton candy, milkshakes, and corn dogs. The Ohio State Fair fee schedule for food vendors for 2014 is as follows: $10 per linear foot for ground service fees (front footage x depth) 10% of concessions (food sales) $40 per 12-day parking permit $290 for 100-amp electrical service $50 per 12-day fair admittance pass (one included with basic rental agreement) Questions Of the fees listed in the schedule, which fees are variable with respect to the number of customers at the booth? Which fees are fixed? Assume that Star Concessions has a food booth that requires 15’ of frontage and is 12’ deep. Star expects to have sales averaging $3,600 per day for each of the 12 days of the fair. It has a total of four employees who will work the fair throughout the entire 12-day period. Star pays for each employee’s fair admission and parking. What is the projected total fee that Star will need to pay to The Ohio State Fair? Assume that variable costs are 40% of sales revenue. This 40% includes the 10% charged by The Ohio State Fair. What total sales revenue is needed for Star Concessions to breakeven? What is the average daily sales revenue needed to breakeven? Using your answers from #2 and #3 above, calculate Star’s margin of safety in dollars and percentage.
In: Accounting
Required information
[The following information applies to the questions displayed below.]
Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below:
|
Fixed Element per Month |
Variable Element per Customer Served |
Actual Total for May |
|||||
| Revenue | $ | 6,100 | $ | 223,500 | |||
| Employee salaries and wages | $ | 68,000 | $ | 1,500 | $ | 126,000 | |
| Travel expenses | $ | 600 | $ | 20,400 | |||
| Other expenses | $ | 47,000 | $ | 44,300 | |||
When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers.
1. What is Adger’s revenue variance, employee salaries and wages spending variance, travel expenses spending variance, and other expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
2. What amount of revenue, employee salaries and wages, travel expenses, and other expenses would be included in Adger’s planning budget for May?
3. What activity variance would Adger report in May with respect to its revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
4. What activity variances would Adger report with respect to each of its expenses for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
5. What net operating income would appear in Adger’s flexible budget for May?
In: Accounting
Lavage Rapide is a Canadian company that owns and operates a large automatic carwash facility near Montreal. The following table provides data concerning the company’s costs:
|
Fixed Cost per Month |
Cost per Car Washed |
||||
| Cleaning supplies | $ | 0.70 | |||
| Electricity | $ | 1,100 | $ | 0.05 | |
| Maintenance | $ | 0.20 | |||
| Wages and salaries | $ | 4,300 | $ | 0.20 | |
| Depreciation | $ | 8,100 | |||
| Rent | $ | 2,000 | |||
| Administrative expenses | $ | 1,600 | $ | 0.04 | |
For example, electricity costs are $1,100 per month plus $0.05 per car washed. The company expects to wash 8,000 cars in August and to collect an average of $6.30 per car washed.
The actual operating results for August appear below.
|
Lavage Rapide Income Statement For the Month Ended August 31 |
||
| Actual cars washed | 8,100 | |
| Revenue | $ | 52,500 |
| Expenses: | ||
| Cleaning supplies | 6,100 | |
| Electricity | 1,470 | |
| Maintenance | 1,840 | |
| Wages and salaries | 6,260 | |
| Depreciation | 8,100 | |
| Rent | 2,200 | |
| Administrative expenses | 1,820 | |
| Total expense | 27,790 | |
| Net operating income | $ | 24,710 |
Required:
Complete the flexible budget performance report that shows the company’s activity variances and revenue and spending variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Requirements:
1. Journalize and Post the adjusting entries using the T-accounts
2. Prepare an adjusted trial balance as of December 31, 2018
November 3: Purchased Canoes for $4,800 on account.
December 2: Purchased Canoes signing a notes payable for $7,200.
At December 31, the business gathers the following information for the adjusting entries:
a. Office supplies on hand, $165
b. Rent of one month has been used (1000.00).
c. Determine the depreciation on the building using straight-line depreciation. Assume the useful life of the building is five years and the residual value is $5,000.
d. $400 of unearned revenue has now been earned.
e. The employee who has been working the rental booth has earned $1,250 in wages that will be paid January 15, 2013.
f. Canyon Canoes has earned $1,850 of canoe rental revenue that has not been recorded or received.
g. Determine the depreciation on the canoes purchased on November 3 using straight-line depreciation. Assume the useful life of the canoes is 4 years and the residual value is $0.
h. Determine the depreciation on the canoes purchased on December 2 using straight-line depreciation. Assume the useful life of the canoes is 4 years and the residual value is $0.
i. Interest expense accrued on the notes payable, $50.
Unadjusted Trial Balance
| Account | Debit | Credit |
| Cash | $12,125 | |
| Accounts Recievable | $5,750 | |
| Office Supplies | $1,250 | |
| Prepaid Rent | $3,000 | |
| Land | $85,000 | |
| Building | $35,000 | |
| Canoe | $12,000 | |
| Accounts Payable | $3,050 | |
| Utilities Payable | $325 | |
| Telephone Payable | $295 | |
| Unearned Revenue | $750 | |
| Notes Payable | $7,200 | |
| Wilson, Capital | $136,000 | |
| Wilson, Withdrawl | $450 | |
| Canoe Rental Revenue | $12,400 | |
| Rent Expense | $1,200 | |
| Utilities Expense | $475 | |
| Wages Expense | $3,300 | |
| Telephone Expense | $470 | |
| TOTALS: | $160,020 | $160,020 |
In: Accounting
Problem 8-19A More Than One Cost Driver [LO8-2, LO8-3] Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made. Data concerning the pizzeria’s costs appear below:
|
Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
|
|---|---|---|---|
| Pizza Ingredients | $4.40 | ||
| Kitchen Staff | $5,910 | ||
| Utilities | $610 | $.30 | |
| Delivery Person | $3.10 | ||
| Delivery Vehicle | $630 | $1.50 | |
| Equipment depreciation | $400 | ||
| Rent | $1870 | ||
| Miscellaneous | $730 | $.15 |
In November, the pizzeria budgeted for 1,560 pizzas at an average selling price of $15 per pizza and for 220 deliveries.
Data concerning the pizzeria’s operations in November appear below:
|
Actual Results |
|
|---|---|
| Pizzas | 1,660 |
| Deliveries | 200 |
| Revenue | $25,450 |
| Pizza Ingredients | $7,210 |
| Kitchen Staff | $5,850 |
| Utilities | $885 |
| Delivery person | $620 |
| Delivery Vehicle | $986 |
| Equipment depreciation | $400 |
| Rent | $1870 |
| Miscellaneous | $790 |
Required: 1. Compute the revenue and spending variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
| Milano Pizza | ||||
|---|---|---|---|---|
| Revanue and Spending Variances | ||||
| For the Month Ended November 30 | ||||
|
Actual Results |
Revenue And Spending Variances |
Flexible Budget |
||
| Revenue | $25,450 | |||
| Expenses: | ||||
| Pizza ingredients | 7,210 | |||
| Kitchen staff | 5,850 | |||
| Utilities | 885 | |||
| Delivery person | 620 | |||
| Delivery vehicle | 986 | |||
| Equipment depreciation | 400 | |||
| Rent | 1,870 | |||
| Miscellaneous | 790 | |||
| Total Expense | 18,611 | |||
| Net Operating Income | $6,839 | |||
In: Accounting
Beth is a second-grader who sells lemonade on a street corner in your neighborhood. Each cup of lemonade costs Beth $0.20 to produce; she has no fixed costs. The reservation prices for the 10 people who walk by Beth's lemonade stand each day are listed in the following table.
|
Person |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Reservation price |
$0.50 |
$0.45 |
$0.40 |
$0.35 |
$0.30 |
$0.25 |
$0.20 |
$0.15 |
$0.10 |
$0.05 |
Beth knows the distribution of reservation prices (that is, she knows that one person is willing to pay $0.50, another $0.45, and so on), but she does not know any specific individual’s reservation price.
a. Calculate the marginal revenue of selling an additional cup of lemonade. (Start by figuring out the price Beth would charge if she produced only one cup of lemonade, and calculate the total revenue; then find the price Beth would charge if she sold two cups of lemonade; and so on.)
|
Price |
Quantity |
Total revenue ($ per day) |
Marginal revenue ($ per cup) |
|
0.50 |
1 |
|
|
|
0.45 |
2 |
||
|
0.40 |
3 |
||
|
0.35 |
4 |
||
|
0.30 |
5 |
||
|
0.25 |
6 |
||
|
0.20 |
7 |
||
|
0.15 |
8 |
||
|
0.10 |
9 |
||
|
0.05 |
10 |
b. What is Beth’s profit-maximizing price?
Instruction: Enter your response rounded to two decimal places.
$ .
c. At that price, what are Beth’s economic profit and total consumer surplus?
Instruction: Enter your responses rounded to two decimal places.
Economic profit: $ per day.
Consumer surplus: $ per day.
d. What price should Beth charge if she wants to maximize total economic surplus?
Instruction: Enter your response rounded to two decimal places.
Price to maximize total economic surplus: $ .
In: Economics
Exercise 5-20 Long-term contract; revenue recognition upon project completion; loss projected on entire project [LO5-8, 5-9] On February 1, 2018, Arrow Construction Company entered into a three-year construction contract to build a bridge for a price of $8,025,000. During 2018, costs of $2,010,000 were incurred, with estimated costs of $4,010,000 yet to be incurred. Billings of $2,512,000 were sent, and cash collected was $2,260,000.
In 2019, costs incurred were $2,512,000 with remaining costs estimated to be $3,615,000. 2019 billings were $2,762,000, and $2,485,000 cash was collected. The project was completed in 2020 after additional costs of $3,810,000 were incurred. The company’s fiscal year-end is December 31. This project does not qualify for revenue recognition over time.
Required: 1. Calculate the amount of revenue and gross profit or loss to be recognized in each of the three years.
|
2b. Prepare journal entries for 2019 to record the transactions described (credit "various accounts" for construction costs incurred).
| No | Year | General Journal | Debit | Credit |
|---|---|---|---|---|
| 1 | 2019 | Construction in progress | 2,512,000 | |
| Various accounts | 2,512,000 | |||
| 2 | 2019 | Accounts receivable | 2,762,000 | |
| Billings on construction contract | 2,762,000 | |||
| 3 | 2019 | Cash | 2,485,000 | |
| Accounts receivable | 2,485,000 | |||
| 4 | ??? Record the expected loss | ???? |
3a. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2018.
|
|||||||||||||||||||||||
3b. Prepare a partial balance sheet to show the presentation of the project as of December 31, 2019.
|
|||||||||||||||||||||||
In: Accounting
| Excel Assignment (Percentage-of-completion) | |||
| Required: | |||
| 1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year. (10 points) | |||
| Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss. | |||
| 2- Using the data given and the solutions your spreadsheet generated, prepare all journal entries for 2017. Whevenver possible, the amounts for your journal entries should be formulas that reference the appropriate cells in the calcuations below. (10 points) | |||
| 3-Once you have completed the spreadsheet save your file with your last name(s) and first name(s) and upload it under Assignments by the assignment due date. | |||
| Data: | |||
| Contract price | 1,200,000 | ||
| 2016 | 2017 | 2018 | |
| Costs incurred to date** | $280,000 | $600,000 | $785,000 |
| Estimated costs yet to be incurred | 520,000 | 200,000 | 0 |
| Customer billings to date** | 250,000 | 500,000 | 1,200,000 |
| Collections of billings to date** | 120,000 | 320,000 | 1,040,000 |
| **Hint: You have to figure out the actual cost, billings, and collections for each respective year. The information presented is "to date" not "Costs expended this year" as in the handouts and some of your assigned exercises/problems. | |||
| Use the format provided below to input formulas for each respective year. | |||
| 2016 | 2017 | 2018 | |
| Costs expended to date | |||
| Estimated total costs | |||
| % complete | |||
| Contract price | |||
| % complete | |||
| Revenue recognized to date | |||
| Revenue recognized prior | |||
| Revenue recognized current | |||
| Estimated total gross profit | |||
| % complete | |||
| Gross profit recognized to date | |||
| Gross profit recognized prior | |||
| Gross profit recognized current | |||
In: Accounting
Calculate the times interest earned ratio from 2015 to 2018 and interpret them.
| ASX Code | Item | 06/15 | 06/16 | 06/17 | 06/18 |
| TLS | Operating Revenue | 25,845,000,000.00 | 25,834,000,000.00 | 25,912,000,000.00 | 25,667,000,000.00 |
| TLS | Other Revenue | 762,000,000.00 | 1,216,000,000.00 | 2,293,000,000.00 | 3,375,000,000.00 |
| TLS | Total Revenue Excluding Interest | 26,607,000,000.00 | 27,050,000,000.00 | 28,205,000,000.00 | 29,042,000,000.00 |
| TLS | Operating Expenses | -15,845,000,000.00 | -16,103,000,000.00 | -17,231,000,000.00 | -18,754,000,000.00 |
| TLS | EBITDA | 10,762,000,000.00 | 10,947,000,000.00 | 10,974,000,000.00 | 10,288,000,000.00 |
| TLS | Depreciation | -2,922,000,000.00 | -2,957,000,000.00 | -3,058,000,000.00 | -3,005,000,000.00 |
| TLS | Amortisation | -1,061,000,000.00 | -1,198,000,000.00 | -1,383,000,000.00 | -1,465,000,000.00 |
| TLS | Depreciation and Amortisation | -3,983,000,000.00 | -4,155,000,000.00 | -4,441,000,000.00 | -4,470,000,000.00 |
| TLS | EBIT | 6,779,000,000.00 | 6,792,000,000.00 | 6,533,000,000.00 | 5,818,000,000.00 |
| TLS | Interest Revenue | 157,000,000.00 | 86,000,000.00 | 138,000,000.00 | 82,000,000.00 |
| TLS | Interest Expense | -846,000,000.00 | -796,000,000.00 | -729,000,000.00 | -631,000,000.00 |
| TLS | Net Interest Expense | -689,000,000.00 | -710,000,000.00 | -591,000,000.00 | -549,000,000.00 |
| TLS | PreTax Profit | 6,090,000,000.00 | 6,082,000,000.00 | 5,942,000,000.00 | 5,269,000,000.00 |
| TLS | Tax Expense | -1,787,000,000.00 | -1,768,000,000.00 | -1,910,000,000.00 | -1,573,000,000.00 |
| TLS | Net Profit after Tax Before Abnormals | 4,303,000,000.00 | 4,314,000,000.00 | 4,032,000,000.00 | 3,696,000,000.00 |
| TLS | Abnormals | -17,000,000.00 | -482,000,000.00 | -295,000,000.00 | -167,000,000.00 |
| TLS | Abnormals Tax | 0.00 | 0.00 | 137,000,000.00 | 0.00 |
| TLS | Net Abnormals | -17,000,000.00 | -482,000,000.00 | -158,000,000.00 | -167,000,000.00 |
| TLS | Reported NPAT After Abnormals | 4,305,000,000.00 | 5,849,000,000.00 | 3,874,000,000.00 | 3,529,000,000.00 |
| TLS | Outside Equity Interests | -74,000,000.00 | -69,000,000.00 | 17,000,000.00 | 34,000,000.00 |
| TLS | Shares Outstanding at Period End | 12,225,655,836.00 | 12,225,655,836.00 | 11,893,297,855.00 | 11,893,297,855.00 |
| TLS | Weighted Average Number of Shares | 12,264,000,000.00 | 12,202,000,000.00 | 11,968,000,000.00 | 11,877,000,000.00 |
| TLS | EPS Adjusted (cents/share) | 34.48 | 34.75 | 33.83 | 31.41 |
| TLS | EPS After Abnormals (cents/share) | 34.50 | 47.32 | 32.51 | 30.00 |
In: Finance