Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense. 1-Dec Began business by depositing $7000 in a bank account in the name of the company in exchange for 700 shares of $10 per share common stock. 1-Dec Paid the rent for the current month, $600 . 1-Dec Paid the premium on a one-year insurance policy, $720 . 1-Dec Purchased Equipment for $4800 cash. 5-Dec Purchased office supplies from XYZ Company on account, $300 . 15-Dec Provided services to customers for $5800 cash. 16-Dec Provided service to customers ABC Inc. on account, $3100 . 21-Dec Received $1700 cash from ABC Inc., customer on account. 23-Dec Paid $170 to XYZ company for supplies purchased on account on December 5 . 28-Dec Paid wages for the period December 1 through December 28, $4760 . 30-Dec Declared and paid dividend to stockholders $200 . #2. Post all of the December transactions from the “General Journal” tab to the T-accounts under the “T-Accounts” tab in the excel template file "Accounting Cycle Excel Template.xlsx". Assume there are no beginning balances in any of the accounts. #3. Compute the balance for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31. #4. Prepare the unadjusted trial balance under the “Unadjusted Trial Balance” tab in the excel template file "Accounting Cycle Excel Template.xlsx" . Provide the total of the credit column from the Unadjusted Trial Balance #5. Record the following four transactions as adjusting entries under the “General Journal” tab. 31-Dec One month’s insurance has been used by the company $60. 31-Dec The remaining inventory of unused office supplies is $90. 31-Dec The estimated depreciation on equipment is $80. 31-Dec Wages incurred from December 29 to December 31 but not yet paid or recorded total $510. #6. Post all of the adjusting entries to the T-accounts under the “T-Accounts” tab. Compute the balance for each T-account after all of the adjusting entries have been posted. These are the adjusted balance as of December 31. #7. Prepare the adjusted trial balance under the “Adjusted Trial Balance” tab as of December 31 in the excel template file "Accounting Cycle Excel Template.xlsx" . Provide the following accounts balances from the Adjusted Trial Balance: Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Wages Payable Common Stock Retained Earnings #8. Prepare Income Statement, Statement of Stockholder’s Equity, and Classified Balance Sheet under the “Financial Statements” tab for the month ended December 31, 20XX in the excel template file "Accounting Cycle Excel Template.xlsx". Provide the following amount from the Income Statement: Service Revenue Depreciation Expense Wages Expense Supplies Expense Rent Expense Insurance Expense Net Income Provide the following account balance from the Statement of Stockholders' Equity: Dividends Provide the following account balances from the Balance Sheet: Current Assets Long-Term Assets Total Liabilities Total Stockholder’s Equity Cash #9. Record the closing entries under the “General Journal” tab. #10. Post all of the closing entries to the T-accounts under the “T-Accounts” tab. Compute the balance for each T-account after all of the closing entries have been posted. Provide the ending balance of Cash at December 31 from the T-account Provide the balance of the Retained Earnings T-account after closing entries have been posted. Does the ending balance of the Retained Earnings T-account agree with the balance of Retained Earnings on the Balance Sheet? Check Point: Total Assets $ 10,120.00
In: Accounting
When should a company prepare budgets? What are the advantages of preparing budgets?
In: Accounting
3. The partnership has four partners A 2% partner,
individual calendar year. B 51% partner, corporation, 6/30 fiscal
year. C 30% partner, corporation, 6/30 fiscal; D 17% corporation,
6/30 fiscal. What taxable years may the partnership use under the
following alternative situations?
(a) What taxable year(s) may the partnership use?
(b) Suppose C and D use the 4/30 fiscal year instead.
(c) Suppose A is 22%, B is 31%, and C and D use the 4/30 fiscal
year.
In: Accounting
Variable Costs, Contribution Margin, Contribution Margin Ratio
Super-Tees Company plans to sell 13,000 T-shirts at $16 each in the coming year. Product costs include:
| Direct materials per T-shirt | $5.60 |
| Direct labor per T-shirt | $1.12 |
| Variable overhead per T-shirt | $0.48 |
| Total fixed factory overhead | $45,000 |
Variable selling expense is the redemption of a coupon, which averages $0.80 per T-shirt; fixed selling and administrative expenses total $14,000.
Required:
1. Calculate the following values:
Round dollar amounts to the nearest cent and round ratio values to
three decimal places (express the ratio as a decimal rather than a
percentage).
| a. Variable product cost per unit | $ |
| b. Total variable cost per unit | $ |
| c. Contribution margin per unit | $ |
| d. Contribution margin ratio | |
| e. Total fixed expense for the year | $ |
2. Prepare a contribution-margin-based income statement for Super-Tees Company for the coming year. If required, round your per unit answers to the nearest cent.
| Super-Tees Company | ||
| Contribution-Margin-Based Operating Income Statement | ||
| For the Coming Year | ||
| Total | Per Unit | |
| $ | $ | |
| $ | $ | |
| $ | ||
3. What if the per
unit selling expense increased from $0.80 to $1.75? Calculate new
values for the following:
Round dollar amounts to the nearest cent and round ratio values to
four decimal places (express the ratio as a decimal rather than a
percentage):
| a. Variable product cost per unit | $ |
| b. Total variable cost per unit | $ |
| c. Contribution margin per unit | $ |
| d. Contribution margin ratio | |
| e. Total fixed expense for the year | $ |
In: Accounting
Please Show calculations and work
Company has budgeted the following unit sales:
2019 Units
January 10,000
February 8,000
March 9,000
April 11,000
May 15,000
The finished goods units on hand on December 31, 2018, was 2,000 units. Each unit requires 2 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have a policy of maintaining a raw materials inventory at the end of each month equal to 30% of the pounds needed for the following month's production. There were 5,760 pounds of raw materials on hand at December 31, 2018.
1. Prepare a production budget for January and February.
2. Prepare a direct materials budget for January and February
In: Accounting
Net Present Value Method, Internal Rate of Return Method, and Analysis
The management of Quest Media Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows:
| Year | Radio Station | TV Station | ||
| 1 | $270,000 | $570,000 | ||
| 2 | 270,000 | 570,000 | ||
| 3 | 270,000 | 570,000 | ||
| 4 | 270,000 | 570,000 | ||
| Present Value of an Annuity of $1 at Compound Interest | |||||
| Year | 6% | 10% | 12% | 15% | 20% |
| 1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
| 2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
| 3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
| 4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
| 5 | 4.212 | 3.791 | 3.605 | 3.352 | 2.991 |
| 6 | 4.917 | 4.355 | 4.111 | 3.784 | 3.326 |
| 7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
| 8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
| 9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
| 10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
The radio station requires an investment of $819,990, while the TV station requires an investment of $1,627,350. No residual value is expected from either project.
Required:
1a. Compute the net present value for each project. Use a rate of 10% and the present value of an annuity of $1 in the table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest whole dollar.
| Radio Station | TV Station | |
| Present value of annual net cash flows | $ | $ |
| Less amount to be invested | $ | $ |
| Net present value | $ | $ |
1b. Compute a present value index for each project. If required, round your answers to two decimal places.
| Present Value Index | |
| Radio Station | |
| TV Station |
2. Determine the internal rate of return for each project by (a) computing a present value factor for an annuity of $1 and (b) using the present value of an annuity of $1 in the table above. If required, round your present value factor answers to three decimal places and internal rate of return to the nearest whole percent.
| Radio Station | TV Station | |||
| Present value factor for an annuity of $1 | ||||
| Internal rate of return | % | % |
3. The net present value, present value index, and internal rate of return all indicate that the is a better financial opportunity compared to the , although both investments meet the minimum return criterion of 10%.
In: Accounting
| Girls Education, a non-profit promoting the formal education of girls in economically depressed areas, receives a contribution of $100,000 that the donor restricts to purchasing technology and books for the girls in FY 01. In FY 01, Girls Education purchases books for $1,000 and electronic readers for $20,000. |
| Required |
| Make all necessary journal entries to record the transactions for FY 01. |
In: Accounting
A consulting firm has two departments, Corporate and Government. Computer support is common to both departments. The cost of computer support is $11.92 million. The following information is given:
| Gigabytes of Storage |
Number of Consultants |
||||
| Corporate | 101,600 | 135 | |||
| Government | 50,300 | 170 | |||
Required:
What is the cost allocation if fixed computer costs of $9.46 million are allocated on the basis of number of consultants and the remaining costs (all variable) are allocated on the basis of the number of gigabytes of storage used by the department? (Do not round intermediate calculations. Enter your answers in thousands of dollars.)
In: Accounting
Fogerty Company makes two products—titanium Hubs and Sprockets. Data regarding the two products follow:
| Direct Labor-Hours per Unit |
Annual Production |
||
| Hubs | 0.80 | 12,000 | units |
| Sprockets | 0.40 | 48,000 | units |
Additional information about the company follows:
Hubs require $35 in direct materials per unit, and Sprockets require $17.
The direct labor wage rate is $13 per hour.
Hubs require special equipment and are more complex to manufacture than Sprockets.
The ABC system has the following activity cost pools:
| Estimated | Activity | ||||
| Activity Cost Pool (Activity Measure) | Overhead Cost | Hubs | Sprockets | Total | |
| Machine setups (number of setups) | $ | 20,250 | 125 | 100 | 225 |
| Special processing (machine-hours) | $ | 148,000 | 3,700 | 0 | 3,700 |
| General factory (organization-sustaining) | $ | 259,200 | NA | NA | NA |
Required:
1. Compute the activity rate for each activity cost pool.
2. Determine the unit product cost of each product according to the ABC system.
In: Accounting
Hrubec Products, Inc., operates a Pulp Division that manufactures wood pulp for use in the production of various paper goods. Revenue and costs associated with a ton of pulp follow:
| Selling price | $ | 24 | ||
| Expenses: | ||||
| Variable | $ | 15 | ||
| Fixed (based on a capacity of 98,000 tons per year) |
6 | 21 | ||
| Net operating income | $ | 3 | ||
Hrubec Products has just acquired a small company that manufactures paper cartons. This company will be treated as a division of Hrubec with full profit responsibility. The newly formed Carton Division is currently purchasing 32,000 tons of pulp per year from a supplier at a cost of $24 per ton, less a 10% purchase discount. Hrubec’s president is anxious for the Carton Division to begin purchasing its pulp from the Pulp Division if an acceptable transfer price can be worked out.
Required:
For (1) and (2) below, assume the Pulp Division can sell all of its pulp to outside customers for $24 per ton.
1. What is the lowest acceptable transfer price from the perspective of the Pulp Division? What is the highest acceptable transfer price from the perspective of the Carton Division? What is the range of acceptable transfer prices (if any) between the two divisions? Are the managers of the Carton and Pulp Divisions likely to voluntarily agree to a transfer price for 32,000 tons of pulp next year?
2. If the Pulp Division meets the price that the Carton Division is currently paying to its supplier and sells 32,000 tons of pulp to the Carton Division each year, what will be the effect on the profits of the Pulp Division, the Carton Division, and the company as a whole?
For (3)–(5) below, assume that the Pulp Division is currently selling only 58,000 tons of pulp each year to outside customers at the stated $24 price.
3. What is the lowest acceptable transfer price from the perspective of the Pulp Division? What is the highest acceptable transfer price from the perspective of the Carton Division? What is the range of acceptable transfer prices (if any) between the two divisions? Are the managers of the Carton and Pulp Divisions likely to voluntarily agree to a transfer price for 32,000 tons of pulp next year?
4. If the Pulp Division does not meet the $20 price, what will be the effect on the profits of the company as a whole?
5. Refer to (4) above. Assume that due to inflexible management policies, the Carton Division is required to purchase 32,000 tons of pulp each year from the Pulp Division at $24 per ton. What will be the effect on the profits of the company as a whole?
In: Accounting
The concept of accounting infrastructure, which encompasses the various environmental factors affecting the issues concerning auditing in a particular country. Required: Explain the environmental factors that affect the issues concerning auditing in India
In: Accounting
Lafleur Corporation needs to set a target price for its newly designed product, M14-M16. The following data relate to it:
| Per Unit | Total | ||||
| Direct materials | $12 | ||||
| Direct labour | 17 | ||||
| Variable manufacturing overhead | 10 | ||||
| Fixed manufacturing overhead | $2,970,000 | ||||
| Variable selling and administrative expenses | 4 | ||||
| Fixed selling and administrative expenses | 2,376,000 |
These costs are based on a budgeted volume of 297,000 units
produced and sold each year. Lafleur uses cost-plus pricing to set
its target selling price. The markup on the total unit cost is
40%.
Calculate the total variable cost per unit, total fixed cost per unit, and total cost per unit for M14-M16.
| Total variable cost per unit | $ | |
| Total fixed costs per unit | $ | |
| Total cost per unit | $ |
eTextbook and Media
Question Part Score
--/3
Calculate the desired markup per unit for M14-M16. (Round answer to 2 decimal places, e.g. 15.25.)
| Markup per unit | $ |
eTextbook and Media
Question Part Score
--/2
Calculate the target selling price for M14-M16. (Round answer to 2 decimal places, e.g. 15.25.)
| Target selling price | $ |
eTextbook and Media
Question Part Score
--/2
Assuming that 237,600 M14-M16s are produced during the year, calculate the variable cost per unit, fixed cost per unit, and total cost per unit. (Round answers to 2 decimal places, e.g. 15.25.)
| Total variable cost per unit | $ | |
| Total fixed costs per unit | $ | |
| Total cost per unit | $ |
eTextbook and Media
In: Accounting
Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below:
| Activity Cost Pool | Activity Measure |
| Caring for lawn | Square feet of lawn |
| Caring for garden beds–low maintenance | Square feet of low maintenance beds |
| Caring for garden beds–high maintenance | Square feet of high maintenance beds |
| Travel to jobs | Miles |
| Customer billing and service | Number of customers |
The company already has completed its first stage allocations of costs and has summarized its annual costs and activity as follows:
| Activity Cost Pool | Estimated Overhead Cost |
Expected Activity | ||
| Caring for lawn | $ | 81,800 | 180,000 | square feet of lawn |
| Caring for garden beds–low maintenance | $ | 34,400 | 28,000 | square feet of low maintenance beds |
| Caring for garden beds–high maintenance | $ | 62,920 | 22,000 | square feet of high maintenance beds |
| Travel to jobs | $ | 3,600 | 19,000 | miles |
| Customer billing and service | $ | 7,500 | 26 | customers |
Required:
Compute the activity rate for each of the activity cost pools. (Round your answers to 2 decimal places.
In: Accounting
| During its first month of operation, the Bethany's Bicycle Corporation, which specializes in bicycle repairs, completed the following transactions. | ||||
| March Transactions | ||||
| Date | Transaction Description | |||
| March 1 | Began business by making a deposit in a company bank account of $20,000, in exchange for 2,000 shares of $10 par value common stock. | |||
| March 1 | Paid the premium on a 1-year insurance policy, $2,400. | |||
| March 1 | Paid the current month's store rent expense, $1,900. | |||
| March 3 | Purchased repair equipment from Andrew Company, $5,800. Paid $1,000 down and the balance was placed on account. Payments will be $400.00 per month for 12 months. The first payment is due 4/1. Note: Use Accounts Payable for the Balance Due. | |||
| March 8 | Purchased repair supplies from Jackson Company on credit, $650. | |||
| March 10 | Paid telephone bill for March, $340. | |||
| March 11 | Cash bicycle repair revenue for the first third of March, $1,650. | |||
| March 18 | Made payment to Jackson Company, $400. | |||
| March 20 | Cash bicycle repair revenue for the second third of March, $2,450. | |||
| March 31 | Cash bicycle repair revenue for the last third of March, $1,250. | |||
| March 31 | Paid the current month's electice bill, $250. | |||
| March 31 | Declared and paid cash dividend of $1,000. | |||
|
Requirement #8: Prepare the closing entries at
March 31 in the General Journal below. Hint:Use the
balances for each account which appear on the
Adjusted Trial Balance for your closing entries. |
||||
| Requirement #9: Post the closing entries to the T-Accounts on the General Ledger ( Step 2) worksheet and compute ending balances. Just add to the adjusted balances already listed. |
In: Accounting
On December 1, 2021, Liang Chemical provides services to a
customer for $86,000. In payment for the services, the customer
signs a three-year, 12% note. The face amount is due at the end of
the third year, while annual interest is due each December 1.
Required:
1. Record the acceptance of the note on
December 1, 2021.
2. Record the interest collected on December 1 for
2022 and 2023, and the adjustment for interest revenue on December
31 for 2021, 2022, and 2023.
3. Record the cash collection on December 1,
2024.
Prepare the journal entries for the above transactions. (If
no entry is required for a particular transaction/event, select "No
Journal Entry Required" in the first account field.)
In: Accounting