Harrison Company maintains a checking account at the First
National City Bank. The bank provides a bank statement along with
canceled checks on the last day of each month. The July 2021 bank
statement included the following information:
Balance, July 1, 2021 | $ | 56,803 | |
Deposits | 180,400 | ||
Checks processed | (193,510 | ) | |
Service charges | (75 | ) | |
NSF checks | (1,650 | ) | |
Monthly payment on note, deducted directly by bank from
account (includes $870 in interest) |
(3,770 | ) | |
Balance, July 31, 2021 | $ | 38,198 | |
The company’s general ledger account had a balance of $40,448 at
the end of July. Deposits outstanding totaled $7,200 and all checks
written by the company were processed by the bank except for those
totaling $8,510. In addition, a $2,900 July deposit from a credit
customer was recorded as a $290 debit to cash and credit to
accounts receivable, and a check correctly recorded by the company
as a $75 disbursement was incorrectly processed by the bank as a
$750 disbursement.
Required:
1. Prepare a bank reconciliation for the month of
July.
2. Prepare the necessary journal entries at the
end of July to adjust the general ledger cash account.
|
Prepare the necessary journal entries at the end of July to adjust the general ledger cash account. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)
|
Record the credits to cash revealed by the bank reconciliation. Use the miscellaneous expense account to record the bank service charges.
.
|
In: Accounting
Pillow Corporation acquired 80 percent ownership of Sheet
Company on January 1, 20X7, for $173,000. At that date, the fair
value of the noncontrolling interest was $43,250. The trial
balances for the two companies on December 31, 20X7, included the
following amounts:
Pillow Corporation | Sheet Company | ||||||||||||||||
Item | Debit | Credit | Debit | Credit | |||||||||||||
Cash | $ | 38,000 | $ | 25,000 | |||||||||||||
Accounts Receivable | 50,000 | 55,000 | |||||||||||||||
Inventory | 240,000 | 100,000 | |||||||||||||||
Land | 80,000 | 20,000 | |||||||||||||||
Buildings & Equipment | 500,000 | 150,000 | |||||||||||||||
Investment in Sheet Company | 202,000 | ||||||||||||||||
Cost of Goods Sold | 500,000 | 250,000 | |||||||||||||||
Depreciation Expense | 25,000 | 15,000 | |||||||||||||||
Other Expenses | 75,000 | 75,000 | |||||||||||||||
Dividends Declared | 50,000 | 20,000 | |||||||||||||||
Accumulated Depreciation | $ | 155,000 | $ | 75,000 | |||||||||||||
Accounts Payable | 70,000 | 35,000 | |||||||||||||||
Mortgages Payable | 200,000 | 50,000 | |||||||||||||||
Common Stock | 300,000 | 50,000 | |||||||||||||||
Retained Earnings | 290,000 | 100,000 | |||||||||||||||
Sales | 700,000 | 400,000 | |||||||||||||||
Income from Sheet Company | 45,000 | ||||||||||||||||
$ | 1,760,000 | $ | 1,760,000 | $ | 710,000 | $ | 710,000 | ||||||||||
Additional Information
a. Prepare all journal entries recorded by Pillow with regard to its investment in Sheet during 20X7.Record the initial investment in Sheet Company
Record the initial investment in Sheet Company
B
Record Pillow Corporation's 80% share of Sheet Company's 20X7 income.
C
Record Pillow Corporation's 80% share of Sheet Company's 20X7 dividend.
D
Record the amortization of the excess acquisition price.
In: Accounting
A farmer has 1000 acre of land on which he can grow corn, wheat and soyabeans. Each acre of corn cost Rs. 100 for preparation, requires 7 man days of work and yields a profit of Rs. 30. An acre of wheat cost Rs. 120 for preparation, requires 10 man days of work and yields a profit of Rs. 40. An acre of soyabeans cost Rs. 70 to prepare, requires 8 man days of work and yields a profit of Rs, 200. If the farmer has Rs. 1, 00,000 for preparation and count on 8000man days of work, how many acres should be allocated to each crop to maximise profit. (Use Simplex Method) Discuss the profitability of different alternatives.
In: Accounting
Facts: Paul Willard is a self-employed attorney. Because of erroneous advice that he gave, one of Paul’s clients incurred unnecessary costs of $20,000. The client threatened to sue Paul for malpractice, and Paul reimbursed this sum to his client. Although his malpractice insurance would have covered the payment, he chose not to file for reimbursement. Because he had two recent malpractice claims, Paul is convinced that another claim could cause him to be either uninsurable or insurable only at unaffordable rates.
Issue: May Paul deduct the $20,000 reimbursement paid to his client?
Please solve the conclusion & Analysis:
Conclusion:
Analysis:
Code Section 162
Code Section 165
Based on above Section
In: Accounting
EXCEL CRYSTAL BALL:
Not wanting to leave his beloved alma mater, Will Anderson has
come up with a scheme to stay
around for 5 more years: He has decided to bid on the fast-food
concession rights at the football
stadium. He feels sure that a bid of $60,000 will win the
concession, which gives him the right to sell
food at football games for the next 5 years. He estimates that
annual operating costs will be 40% of sales
and annual sales will average $100,000. His Uncle Josh has agreed
to lend him the $60,000 to make the
bid. He will pay Josh $15,400 at the end of each year. His tax rate
is 15%.
(a) Use a spreadsheet model to answer the following question.
What is Will’s average annual after-tax
profit? Assume that the yearly payments of $15,400 are tax
deductible.
(b) Suppose that sales will probably vary plus or minus 40% from
the average of $100,000 each year.
Will is concerned about the minimum after-tax profit he can earn in
a year. He feels that he can survive
if it is at least $20,000. Model annual sales for the 5 years as
five continuous uniform random variables.
Based on a sample of 7,500 five-year periods (750 periods if using
Excel alone), estimate the probability
that over any five-year period the minimum after-tax profit for a
year will be at least $20,000. Should
Will bid for the concession?
In: Accounting
A company uses the manufacturing cost hierarchy to allocate costs to various activities. During the past year, it has incurred:
Costs | Description |
725,000 | Product Development Costs |
475,000 | Materials handling costs |
1,250,000 | Production line labor costs |
450,000 | Production setup costs |
250,000 | Power costs (for cooling beer and running equipment) |
875,000 | Manufacturing facility management costs |
A. Using the manufacturing cost hierarchy, what is the total cost that would be classified as unit-level activity costs?
B. Using the manufacturing cost hierarchy, what is the total cost that would be classified as batch-level activity costs?
C. Using the manufacturing cost hierarchy, what is the total cost that would be classified as product-level activity costs?
D. Using the manufacturing cost hierarchy, what is the total cost that would be classified as facility-level activity costs?
In: Accounting
On January 1, 2014, Fishbone Corporation sold equipment to Lost Company that cost $250,000 and that had accumulated depreciation of $100,000 on the date of sale. Fishbone received as consideration a non-interest-bearing note requiring payments of $80,000 annually for 3 years. The first note payment is to be made on January 1, 2014. The prevailing rate of interest for a note of this type on January 1, 2014, was 5%.
Record the 1/1/14 transaction for Fishbone Corporation and all necessary entries from 2014-2016.
Record the 1/1/14 transaction for Lost Company and all necessary entries from 204-2016.
In: Accounting
There wasn't an answer for this question, I'm looking to verify my answers with another individual. This pertains to the following question:
https://www.chegg.com/homework-help/essentials-of-accounting-for-governmental-and-not-for-profit-organizations-13th-edition-chapter-1-problem-9qe-solution-9781259741012
Here is what I came up with by trying to fit the descriptions to each defined fund(s):
a. | Capital Projects |
b. | Agency Funds, Special Revenue Funds |
c. | Capital Projects |
d. | Permanent Funds |
e. | Private-purpose Trust Funds |
f. | Enterprise Funds |
g. | Pension Trust Fund, Internal Service Fund, General Fund |
I haven't used this service before so I'm not sure if this is the appropriate way to use it. Any feedback would be appreciated. Thank you.
In: Accounting
I figured out the weighted average method, but can anyone show me the FIFO and LIFO treatment of this problem????
Timekeeper Inc. manufactures clocks on a highly automated assembly line. Its costing system uses two cost categories, direct materials and conversion costs. Each product must pass through the Assembly Department and the Testing Department. Direct materials are added at the beginning of the production process. Conversion costs are allocated evenly throughout production. Timekeeper Inc. uses weighted-average costing. Data for the Assembly Department for June 2015 are: Work in process, beginning inventory 350 units Direct materials (100% complete) Conversion costs (50% complete) Units started during June 1050 units Work in process, ending inventory: 160 units Direct materials (100% complete) Conversion costs (75% complete) Costs for June 2015: Work in process, beginning inventory: Direct materials $91,000 Conversion costs $136,500 Direct materials costs added during June $603,500 Conversion costs added during June $401,500 Required: What is the conversion cost per equivalent unit in June?
In: Accounting
Improving Decision Making: Making the Rent vs. Buy Decision for Data Storage for ABC Digital
Software skills: Spreadsheet formulas, and charts
Business skills: Technology rent vs. buy decision, TCO analysis
This project provides an opportunity for you help a real-world company make a decision about whether to rent or buy new technology for data storage. You’ll use spreadsheetsoftware to compare the total 4-year cost of ownership for two options.
Deciding whether to store data on the cloud or on-site is often the dilemma for most business owners. There are advantages and disadvantages to both options. However, in this project you are only focusing on the cost benefits of each option regardless of other aspects including the access time, privacy and scalability issues which are also critically important in making this decision.
Scenario
ABC Digital is looking for a solution for storing their data. They have approximately 100 Terabytes of data that they need to store. The followings are typical cost information associated to option 1, that is to store data on the premises:
Description |
Cost/ Resource |
Copies of data needed for redundancy |
3 |
Dollar per Gigabyte of Storage |
$4 |
Typical Fulltime Staff for Data Admin |
1 Full Time Admin for 200TB of data |
Typical Cost of Full Time Data Engineer |
$80,000 for the first year, increases by 10% each year |
Facilities and Power Charges |
$20,000 for the first year, increases by 8% each year |
The cost items associated to cloud-based storage (Option 2) is given below.
Description |
Cost/ Resource |
Dollar per Gigabyte per year for cloud charge |
$1.48 |
Dollar per Gigabyte of initial data migration into cloud |
$0.1 |
Cost of Data Communication and Networks |
$60,000 for the first year, increases by 7% each year |
Note that with cloud solution, the backup and redundancies are provided by the cloud provider and the service is included in the cost.
Tasks
Use your spreadsheet application to calculate the cost of each option for year 1 to year 4. To get the full mark, you should use Excel formula when it is appropriate. In other words, I should be able to change the above parameters (listed in the tables) and the total cost values should be changed automatically. (30 points)
Use an appropriate chart type to present and compare the cost of both solutions in one graph for year 1 to year 4. (15 points)
Determine which cost items are considered as capital expenditure (Capex) and which ones are operational expenditures (Opex) for each solution. (15 points)
Calculate the total cost of ownerships for a 4-year period for each of the two solutions and suggest the best solution for the ABC Digital. (20 points)
One of the main advantages of spreadsheets is that you can easily change the parameters of the model and evaluate “What if...” types of scenarios. Your manager wants to see the sensitivity of the total cost for solution 1 in relation to the year-to-year increase in the “Facilities and Power Charges”. More specifically, your current solution shows the total cost when considering 8% year-to-year increase of the cost of “Facilities and Power Charges” as shown in the Table. However, she wants to see how your estimates changes with this quantity. You should evaluate the total costs over 4 years when evaluating 4%,6%,8% (your current solution), 10%,12% and 14% increase in the year-to-year cost of “Facilities and Power Charges”. The first year cost is still the same, i.e. $20,000 for all scenarios. You should create a new sheet for this. This sheet should show the total cost of solution 1 when changing the year-to-year changes in the Facilities and Power Charges as suggested above. (20 points)
In: Accounting
The comparative balance sheets for Larkspur Corporation show the
following information.
December 31 |
||||
2017 |
2016 |
|||
Cash |
$33,700 |
$13,200 |
||
Accounts receivable |
12,100 |
9,900 |
||
Inventory |
12,000 |
9,100 |
||
Available-for-sale debt investments |
–0– |
3,000 |
||
Buildings |
–0– |
29,500 |
||
Equipment |
45,000 |
19,800 |
||
Patents |
5,000 |
6,100 |
||
$107,800 |
$90,600 |
|||
Allowance for doubtful accounts |
$3,100 |
$4,500 |
||
Accumulated depreciation—equipment |
2,000 |
4,500 |
||
Accumulated depreciation—building |
–0– |
6,100 |
||
Accounts payable |
5,000 |
3,000 |
||
Dividends payable |
–0– |
4,900 |
||
Notes payable, short-term (nontrade) |
2,900 |
4,000 |
||
Long-term notes payable |
31,000 |
25,000 |
||
Common stock |
43,000 |
33,000 |
||
Retained earnings |
20,800 |
5,600 |
||
$107,800 |
$90,600 |
Additional data related to 2017 are as follows.
1. | Equipment that had cost $11,100 and was 40% depreciated at time of disposal was sold for $2,500. | |
2. | $10,000 of the long-term note payable was paid by issuing common stock. | |
3. | Cash dividends paid were $4,900. | |
4. | On January 1, 2017, the building was completely destroyed by a flood. Insurance proceeds on the building were $30,200 (net of $2,100 taxes). | |
5. | Investments (available-for-sale) were sold at $1,800 above their cost. The company has made similar sales and investments in the past. | |
6. | Cash was paid for the acquisition of equipment. | |
7. | A long-term note for $16,000 was issued for the acquisition of equipment. | |
8. | Interest of $2,000 and income taxes of $6,400 were paid in cash. |
Prepare a statement of cash flows using the indirect method. Flood
damage is unusual and infrequent in that part of the country.
In: Accounting
Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system and applies manufacturing overhead cost to products on the basis of machine-hours. The predetermined overhead rate was based on a cost formula that estimates $612,000 of total manufacturing overhead for an estimated activity level of 68,000 machine-hours.
During the year, a large quantity of furniture on the market resulted in cutting back production and a buildup of furniture in the company’s warehouse. The company’s cost records revealed the following actual cost and operating data for the year:
Machine-hours | 50,000 | |
Manufacturing overhead cost | $ | 570,000 |
Inventories at year-end: | ||
Raw materials | $ | 18,000 |
Work in process (includes overhead applied of $22,500) | $ | 93,500 |
Finished goods (includes overhead applied of $76,500) | $ | 317,900 |
Cost of goods sold (includes overhead applied of $351,000) | $ | 1,458,600 |
Required:
1. Compute the underapplied or overapplied overhead.
2. Assume that the company closes any underapplied or overapplied overhead to Cost of Goods Sold. Prepare the appropriate journal entry.
3. Assume that the company allocates any underapplied or overapplied overhead proportionally to Work in Process, Finished Goods, and Cost of Goods Sold. Prepare the appropriate journal entry.
4. How much higher or lower will net operating income be if the underapplied or overapplied overhead is allocated to Work in Process, Finished Goods, and Cost of Goods Sold rather than being closed to Cost of Goods Sold?
In: Accounting
The following selected events and transactions were recorded by
Milos County Hospital.
Patient service revenue | $1,664,900 |
Contractual adjustments | $ | 632,000 |
Provision for bad debts | 30,200 | |
Charity care | 261,400 | |
Fiscal and administrative services expenses | $ | 194,440 |
General services expenses | 253,100 | |
Nursing services expenses | 585,000 | |
Other professional services expenses | 185,600 | |
Inventory | 101,200 | |
Expenses accrued at December 31 | 7,200 | |
Buildings | $ | 51,000 |
Equipment | 73,000 | |
11. On December 31, closing entries were made in the general
journal.
Required
In: Accounting
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.
The pizzeria’s cost formulas appear below:
Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
Pizza ingredients | $ | 4.30 | ||||||||
Kitchen staff | $ | 6,110 | ||||||||
Utilities | $ | 710 | $ | 0.30 | ||||||
Delivery person | $ | 3.10 | ||||||||
Delivery vehicle | $ | 730 | $ | 1.30 | ||||||
Equipment depreciation | $ | 480 | ||||||||
Rent | $ | 2,070 | ||||||||
Miscellaneous | $ | 830 | $ | 0.15 | ||||||
In November, the pizzeria budgeted for 1,860 pizzas at an average selling price of $17 per pizza and for 240 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
Actual Results | |||
Pizzas | 1,960 | ||
Deliveries | 220 | ||
Revenue | $ | 33,970 | |
Pizza ingredients | $ | 9,010 | |
Kitchen staff | $ | 6,050 | |
Utilities | $ | 935 | |
Delivery person | $ | 682 | |
Delivery vehicle | $ | 1,006 | |
Equipment depreciation | $ | 480 | |
Rent | $ | 2,070 | |
Miscellaneous | $ | 850 | |
Required:
1. Complete the flexible budget performance report that shows both revenue and spending variances and activity 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.)
In: Accounting
In: Accounting