Required information
Exercise 6-21B Complete the accounting cycle using inventory transactions (LO6-2, 6-3, 6-5, 6-6, 6-7)
[The following information applies to the questions displayed below.]
On January 1, Year 1, the general ledger of a company includes the following account balances:
| Accounts | Debit | Credit | ||||
| Cash | $ | 22,500 | ||||
| Accounts Receivable | 38,000 | |||||
| Allowance for Uncollectible Accounts | $ | 3,700 | ||||
| Inventory | 33,000 | |||||
| Land | 66,100 | |||||
| Accounts Payable | 30,900 | |||||
| Notes Payable (8%, due in 3 years) | 33,000 | |||||
| Common Stock | 59,000 | |||||
| Retained Earnings | 33,000 | |||||
| Totals | $ | 159,600 | $ | 159,600 | ||
The $33,000 beginning balance of inventory consists of 330 units, each costing $100. During January Year 1, the company had the following inventory transactions:
| January | 3 | Purchase 1,200 units for $129,600 on account ($108 each). | ||
| January | 8 | Purchase 1,300 units for $146,900 on account ($113 each). | ||
| January | 12 | Purchase 1,400 units for $165,200 on account ($118 each). | ||
| January | 15 | Return 115 of the units purchased on January 12 because of defects. | ||
| January | 19 | Sell 4,000 units on account for $600,000. The cost of the units sold is determined using a FIFO perpetual inventory system. | ||
| January | 22 | Receive $577,000 from customers on accounts receivable. | ||
| January | 24 | Pay $407,000 to inventory suppliers on accounts payable. | ||
| January | 27 | Write off accounts receivable as uncollectible, $2,800. | ||
| January | 31 | Pay cash for salaries during January, $117,000. |
The following information is available on January 31, Year 1.
Exercise 6-21B Part 2
a. At the end of January, the company estimates
that the remaining units of inventory are expected to sell in
February for only $100 each.
b. The company estimates future uncollectible
accounts. The company determines $4,300 of accounts receivable on
January 31 are past due, and 30% of these accounts are estimated to
be uncollectible. The remaining accounts receivable on January 31
are not past due, and 5% of these accounts are estimated to be
uncollectible. (Hint: Use the January 31 accounts receivable
balance calculated in the general ledger.)
c. Accrued interest expense on notes payable for
January. Interest is expected to be paid each December 31.
d. Accrued income taxes at the end of January are
$12,600.
2. Record adjusting entries on January 31 for the
above transactions. (If no entry is required for a
transaction/event, select "No journal entry required" in the first
account field.)
In: Accounting
Two construction companies were vying for market share dominance. Company A embraced total quality, whereas company B did not. After an initial transition created by various change initiatives, during which company A lost some of their employees because of the quality initiative, a period of equilibrium and growth ensued. Customer were surveyed, employees were trained, and team began working on customer value and satisfaction improvements. At first company B was not concerned with company A Actually Company B hired the former employees from company A and watched as company A’s employees talked to customers and spent their off-season conducting employee training and forming problem and project teams However things changed. Company B began losing customers, to its rival, and they were replaced with other customers who had strained credit and multiple grievances. In addition, some of Company B’s finest employees left Company A despite promises of higher salaries and future bonuses. Company B decided to mimic Company A’s quality program by hiring an outside consultant. Time was spent advertising for and screening an appropriate consultant. The consultant was empowered to lead the program, with the blessing and support of the owner and president. The consultant met with the executive team and later with the employees and laid out the vision for the new quality program. This included training all employees in the concept and principle of total quality. Shortly with after the training sessions ended, teams were assembled with specific issues to solve. Meanwhile, valuable of- seasons time was expended, and the new construction seasons was drawing near. The new season meant employee workloads increased, which in turn required more employee work hours. Profit opportunities quickly replaced quality meetings and employees were left angry and confused. The initial hope of more involvement with work activities, netter contact with customers, and increased communications was replaced with frustration and cynicism. Before much could be done, the new construction season was in full swing. Later, as Company B’s construction season came to end, the consultant had difficulty finding volunteers to staff the quality teams. Conscripts were found, and teams resumed their work. Team meetings were plagued with personal attacks, finger pointing and conflict. Employees were threatened and some times fired before the whole quality program was solved. What went wrong? Why couldn’t company B mimic company A’s apparent success with quality? What might you have done differently?
In: Operations Management
1. Match each transaction with the type of entry that will be required at April 30, the company's year-end.
A. Deferral Adjusting entry
B. Accrual Adjusting entry
|
The company has $8,300 in Prepaid Rent at the beginning of April and uses $3,600 of that for its April rent.
|
||||||||||
In: Accounting
Top executive officers of Baird Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement. Current Year Sales revenue $ 2,300,000 Cost of goods sold 1,725,000 Gross profit 575,000 Selling & administrative expenses 304,000 Net income $ 271,000 Cost of goods sold is usually 75 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $74,000. The president has announced that the company’s goal is to increase net income by 15 percent. Required The following items are independent of each other. Using Excel prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Baird Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
|
Current Year |
|||
|
Sales revenue |
$ |
2,300,000 |
|
|
Cost of goods sold |
1,725,000 |
||
|
Gross profit |
575,000 |
||
|
Selling & administrative expenses |
304,000 |
||
|
Net income |
$ |
271,000 |
|
Cost of goods sold is usually 75 percent of sales revenue, and
selling and administrative expenses are usually 10 percent of sales
plus a fixed cost of $74,000. The president has announced that the
company’s goal is to increase net income by 15 percent.
Required
The following items are independent of each other.
Using Excel prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
| Current Year | |||
| Sales revenue | $ | 1,600,000 | |
| Cost of goods sold | 1,120,000 | ||
| Gross profit | 480,000 | ||
| Selling & administrative expenses | 190,000 | ||
| Net income | $ | 290,000 | |
Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $30,000. The president has announced that the company’s goal is to increase net income by 15 percent.
Required
The following items are independent of each other:
A. Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
B. The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
C. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $230,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
| Sales revenue | $ | 1,600,000 | |
| Cost of goods sold | 1,120,000 | ||
| Gross profit | 480,000 | ||
| Selling & administrative expenses | 190,000 | ||
| Net income | $ | 290,000 | |
|
Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $30,000. The president has announced that the company’s goal is to increase net income by 15 percent. |
|||
Required
The following items are independent of each other:
A Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
B The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
C The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $230,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Baird Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
|
Current Year |
|||
|
Sales revenue |
$ |
2,300,000 |
|
|
Cost of goods sold |
1,725,000 |
||
|
Gross profit |
575,000 |
||
|
Selling & administrative expenses |
304,000 |
||
|
Net income |
$ |
271,000 |
|
Cost of goods sold is usually 75 percent of sales revenue, and
selling and administrative expenses are usually 10 percent of sales
plus a fixed cost of $74,000. The president has announced that the
company’s goal is to increase net income by 15 percent.
Required
The following items are independent of each other.
Using Excel prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Baird Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
|
Current Year |
|||
|
Sales revenue |
$ |
2,300,000 |
|
|
Cost of goods sold |
1,725,000 |
||
|
Gross profit |
575,000 |
||
|
Selling & administrative expenses |
304,000 |
||
|
Net income |
$ |
271,000 |
|
Cost of goods sold is usually 75 percent of sales revenue, and
selling and administrative expenses are usually 10 percent of sales
plus a fixed cost of $74,000. The president has announced that the
company’s goal is to increase net income by 15 percent.
Required
The following items are independent of each other.
Using Excel prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year’s budget. The controller has provided everyone with the current year’s projected income statement.
| Current Year | |||
| Sales revenue | $ | 1,600,000 | |
| Cost of goods sold | 1,120,000 | ||
| Gross profit | 480,000 | ||
| Selling & administrative expenses | 190,000 | ||
| Net income | $ | 290,000 | |
Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $30,000. The president has announced that the company’s goal is to increase net income by 15 percent.
Required
The following items are independent of each other:
A. Prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal?
B. The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income.
C. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $230,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?
In: Accounting