Problem 23-5A
The budget committee of Suppar Company collects the following
data for its San Miguel Store in preparing budgeted income
statements for May and June 2017.
1. Sales for May are expected to be $803,000. Sales in June and
July are expected to be 5% higher than the preceding month.
2. Cost of goods sold is expected to be 75% of sales.
3. Company policy is to maintain ending merchandise inventory at
10% of the following month’s cost of goods sold.
4. Operating expenses are estimated to be as follows:
Sales salaries $30,000 per month
Advertising 6 % of monthly sales
Delivery expense 2 % of monthly sales
Sales commissions 5 % of monthly sales
Rent expense $5,390 per month
Depreciation $910 per month
Utilities $710 per month
Insurance $560 per month
5. Interest expense is $2,000 per month. Income taxes are estimated to be 30% of income before income taxes.
[Partially correct answer.] Your answer is partially correct.
Try again.
Prepare the merchandise purchases budget for each month in
columnar form. (Round answers to 0 decimal places, e.g.
5,275.)
SUPPAR COMPANY
San Miguel Store
Merchandise Purchases Budget
[Entry field with correct answer]
For the Quarter Ended June, 2017
May and June, 2017
For the Months of May and June, 2017
May
June
[Entry field with correct answer]
Total
Direct Materials per Unit
Beginning Direct Materials
Total Materials Required
Units to be Produced
Budgeted Cost of Goods Sold
Beginning Merchandise Inventory
Desired Ending Direct Materials
Desired Ending Merchandise Inventory
Direct Materials Purchases
Required Merchandise Purchases
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
[Entry field with correct answer]
Add
Less
:
[Entry field with correct answer]
Direct Materials per Unit
Desired Ending Direct Materials
Required Merchandise Purchases
Direct Materials Purchases
Total
Desired Ending Merchandise Inventory
Total Materials Required
Units to be Produced
Beginning Direct Materials
Beginning Merchandise Inventory
Budgeted Cost of Goods Sold
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Direct Materials Purchases
Desired Ending Direct Materials
Direct Materials per Unit
Required Merchandise Purchases
Budgeted Cost of Goods Sold
Beginning Merchandise Inventory
Beginning Direct Materials
Total
Total Materials Required
Desired Ending Merchandise Inventory
Units to be Produced
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Add
Less
:
[Entry field with correct answer]
Total Materials Required
Total
Budgeted Cost of Goods Sold
Direct Materials per Unit
Desired Ending Direct Materials
Units to be Produced
Direct Materials Purchases
Beginning Direct Materials
Required Merchandise Purchases
Beginning Merchandise Inventory
Desired Ending Merchandise Inventory
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Direct Materials Purchases
Required Merchandise Purchases
Total
Total Materials Required
Units to be Produced
Beginning Direct Materials
Beginning Merchandise Inventory
Direct Materials per Unit
Budgeted Cost of Goods Sold
Desired Ending Direct Materials
Desired Ending Merchandise Inventory
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
LINK TO TEXT
[Partially correct answer.] Your answer is partially correct.
Try again.
Prepare budgeted multiple-step income statements for each month
in columnar form. Show in the statements the details of cost of
goods sold. (Round answers to 0 decimal places, e.g.
5,275.)
SUPPAR COMPANY
San Miguel Store
Budgeted Income Statement
[Entry field with correct answer]
For the Months of May and June, 2017
May and June, 2017
For the Quarter Ended June, 2017
May
June
[Entry field with correct answer]
Advertising
Gross Profit
Depreciation
Income Before Income Taxes
Beginning Inventory
Cost of Goods Available for Sale
Purchases
Income from Operations
Interest Expense
Rent
Sales Commissions
Sales
Sales Salaries
Income Tax Expense
Total Operating Expenses
Utilities
Cost of Goods Sold
Ending Inventory
Delivery
Insurance
Net Income / (Loss)
Operating Expenses
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
[Entry field with correct answer]
Income from Operations
Ending Inventory
Sales Commissions
Total Operating Expenses
Beginning Inventory
Income Tax Expense
Delivery
Cost of Goods Available for Sale
Cost of Goods Sold
Advertising
Insurance
Net Income / (Loss)
Rent
Operating Expenses
Purchases
Utilities
Gross Profit
Sales Salaries
Depreciation
Sales
Income Before Income Taxes
Interest Expense
[Entry field with correct answer]
Income Tax Expense
Beginning Inventory
Cost of Goods Sold
Operating Expenses
Delivery
Depreciation
Rent
Utilities
Sales Salaries
Purchases
Ending Inventory
Income Before Income Taxes
Gross Profit
Insurance
Interest Expense
Advertising
Cost of Goods Available for Sale
Income from Operations
Net Income / (Loss)
Sales
Sales Commissions
Total Operating Expenses
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Delivery
Income from Operations
Utilities
Cost of Goods Available for Sale
Sales Salaries
Income Before Income Taxes
Income Tax Expense
Operating Expenses
Depreciation
Gross Profit
Advertising
Ending Inventory
Interest Expense
Beginning Inventory
Insurance
Purchases
Cost of Goods Sold
Net Income / (Loss)
Rent
Sales
Sales Commissions
Total Operating Expenses
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Depreciation
Delivery
Cost of Goods Available for Sale
Interest Expense
Income from Operations
Sales Commissions
Total Operating Expenses
Net Income / (Loss)
Operating Expenses
Beginning Inventory
Income Before Income Taxes
Ending Inventory
Income Tax Expense
Advertising
Cost of Goods Sold
Insurance
Sales Salaries
Rent
Gross Profit
Purchases
Sales
Utilities
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Purchases
Beginning Inventory
Depreciation
Gross Profit
Total Operating Expenses
Income from Operations
Insurance
Ending Inventory
Income Tax Expense
Net Income / (Loss)
Operating Expenses
Cost of Goods Available for Sale
Rent
Sales
Sales Commissions
Cost of Goods Sold
Sales Salaries
Delivery
Utilities
Income Before Income Taxes
Interest Expense
Advertising
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Insurance
Income Tax Expense
Total Operating Expenses
Net Income / (Loss)
Utilities
Operating Expenses
Income from Operations
Gross Profit
Ending Inventory
Purchases
Income Before Income Taxes
Depreciation
Sales
Delivery
Rent
Sales Commissions
Sales Salaries
Interest Expense
Advertising
Beginning Inventory
Cost of Goods Available for Sale
Cost of Goods Sold
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Gross Profit
Beginning Inventory
Utilities
Income Before Income Taxes
Rent
Cost of Goods Available for Sale
Advertising
Ending Inventory
Depreciation
Interest Expense
Cost of Goods Sold
Income from Operations
Purchases
Operating Expenses
Delivery
Net Income / (Loss)
Income Tax Expense
Sales
Insurance
Sales Commissions
Sales Salaries
Total Operating Expenses
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Income Tax Expense
Net Income / (Loss)
Beginning Inventory
Total Operating Expenses
Ending Inventory
Sales Salaries
Cost of Goods Sold
Insurance
Operating Expenses
Interest Expense
Depreciation
Gross Profit
Sales
Sales Commissions
Rent
Income from Operations
Advertising
Utilities
Delivery
Cost of Goods Available for Sale
Purchases
Income Before Income Taxes
[Entry field with correct answer]
Total Operating Expenses
Utilities
Ending Inventory
Income Before Income Taxes
Purchases
Income Tax Expense
Sales Commissions
Rent
Beginning Inventory
Gross Profit
Interest Expense
Delivery
Sales Salaries
Income from Operations
Advertising
Cost of Goods Available for Sale
Depreciation
Cost of Goods Sold
Insurance
Sales
Net Income / (Loss)
Operating Expenses
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Purchases
Interest Expense
Income from Operations
Cost of Goods Available for Sale
Advertising
Total Operating Expenses
Beginning Inventory
Income Tax Expense
Operating Expenses
Delivery
Cost of Goods Sold
Depreciation
Utilities
Rent
Ending Inventory
Net Income / (Loss)
Sales Commissions
Gross Profit
Sales
Insurance
Sales Salaries
Income Before Income Taxes
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Sales Commissions
Total Operating Expenses
Purchases
Rent
Delivery
Interest Expense
Utilities
Cost of Goods Sold
Depreciation
Income from Operations
Sales
Income Tax Expense
Income Before Income Taxes
Advertising
Sales Salaries
Insurance
Gross Profit
Beginning Inventory
Cost of Goods Available for Sale
Ending Inventory
Net Income / (Loss)
Operating Expenses
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Cost of Goods Available for Sale
Cost of Goods Sold
Sales Salaries
Delivery
Total Operating Expenses
Depreciation
Beginning Inventory
Interest Expense
Ending Inventory
Income Tax Expense
Advertising
Utilities
Gross Profit
Income from Operations
Operating Expenses
Purchases
Net Income / (Loss)
Insurance
Rent
Sales
Income Before Income Taxes
Sales Commissions
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Advertising
Total Operating Expenses
Rent
Cost of Goods Sold
Sales Salaries
Sales
Depreciation
Delivery
Gross Profit
Income from Operations
Purchases
Income Tax Expense
Net Income / (Loss)
Operating Expenses
Cost of Goods Available for Sale
Utilities
Sales Commissions
Insurance
Interest Expense
Beginning Inventory
Income Before Income Taxes
Ending Inventory
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Sales
Operating Expenses
Depreciation
Total Operating Expenses
Net Income / (Loss)
Insurance
Sales Commissions
Advertising
Ending Inventory
Purchases
Delivery
Sales Salaries
Utilities
Gross Profit
Income Before Income Taxes
Beginning Inventory
Rent
Interest Expense
Cost of Goods Available for Sale
Income from Operations
Cost of Goods Sold
Income Tax Expense
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Ending Inventory
Gross Profit
Sales Commissions
Net Income / (Loss)
Rent
Sales
Sales Salaries
Total Operating Expenses
Cost of Goods Available for Sale
Operating Expenses
Insurance
Income Tax Expense
Utilities
Interest Expense
Advertising
Income Before Income Taxes
Cost of Goods Sold
Beginning Inventory
Delivery
Depreciation
Income from Operations
Purchases
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Advertising
Net Income / (Loss)
Beginning Inventory
Cost of Goods Available for Sale
Cost of Goods Sold
Sales Commissions
Sales Salaries
Utilities
Ending Inventory
Income from Operations
Total Operating Expenses
Sales
Income Before Income Taxes
Gross Profit
Delivery
Income Tax Expense
Depreciation
Insurance
Interest Expense
Operating Expenses
Purchases
Rent
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Delivery
Depreciation
Insurance
Advertising
Net Income / (Loss)
Ending Inventory
Operating Expenses
Purchases
Gross Profit
Beginning Inventory
Utilities
Income from Operations
Rent
Income Tax Expense
Sales Salaries
Sales
Sales Commissions
Cost of Goods Available for Sale
Total Operating Expenses
Interest Expense
Income Before Income Taxes
Cost of Goods Sold
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with correct answer]
Cost of Goods Available for Sale
Net Income / (Loss)
Income from Operations
Utilities
Operating Expenses
Delivery
Income Before Income Taxes
Purchases
Depreciation
Interest Expense
Total Operating Expenses
Income Tax Expense
Rent
Advertising
Beginning Inventory
Insurance
Cost of Goods Sold
Ending Inventory
Gross Profit
Sales
Sales Commissions
Sales Salaries
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
Income Before Income Taxes
Rent
Cost of Goods Sold
Sales Commissions
Net Income / (Loss)
Advertising
Delivery
Interest Expense
Sales Salaries
Sales
Beginning Inventory
Depreciation
Total Operating Expenses
Income Tax Expense
Income from Operations
Cost of Goods Available for Sale
Ending Inventory
Gross Profit
Utilities
Operating Expenses
Insurance
Purchases
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
Net Income / (Loss)
Rent
Operating Expenses
Purchases
Depreciation
Sales
Utilities
Beginning Inventory
Income Before Income Taxes
Insurance
Sales Commissions
Sales Salaries
Ending Inventory
Total Operating Expenses
Interest Expense
Cost of Goods Available for Sale
Cost of Goods Sold
Delivery
Gross Profit
Advertising
Income from Operations
Income Tax Expense
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
Advertising
Gross Profit
Beginning Inventory
Net Income / (Loss)
Ending Inventory
Operating Expenses
Delivery
Depreciation
Income from Operations
Sales Commissions
Cost of Goods Available for Sale
Insurance
Purchases
Rent
Cost of Goods Sold
Income Tax Expense
Sales
Sales Salaries
Total Operating Expenses
Utilities
Income Before Income Taxes
Interest Expense
[Entry field with incorrect answer]
[Entry field with incorrect answer]
[Entry field with incorrect answer]
Utilities
Beginning Inventory
Gross Profit
Interest Expense
Total Operating Expenses
Income from Operations
Cost of Goods Available for Sale
Income Before Income Taxes
Net Income / (Loss)
Advertising
Sales Commissions
Sales Salaries
Sales
Cost of Goods Sold
Delivery
Income Tax Expense
Depreciation
Ending Inventory
Insurance
Operating Expenses
Purchases
Rent
$
[Entry field with incorrect answer]
$
[Entry field with incorrect answer]
In: Accounting
Consider the hand bag market.
Assume this market is monopolistic competition.
1. Select a company and its handbags and explain how their handbags are distinguished in the market. (For example, Bottega Veneta uses a cross woven leather that makes its hand bags, supple, durable and attractive).
Because of that distinguishing characteristic, assume your company is earning a profit.
2. Please draw a monopolistic competition diagram showing that your company is earning a profit (note: careful with the demand line - it should be distinguished from a monopoly diagram - see section 10.1 in your text and the diagrams in "perceived demand …)
3. Assume now that competition has heated up and a competitor has a handbag out that is similar to your own (For example Michael Kors might come out with a cross hatched leather hand bag). Please explain this competition and show how it effects the demand of your handbag as well as your profits on the diagram.
4. Given this event, assume that your company would like to maintain its profits. Explain what it might do, and explain how it would effect your diagram.
5. Please explain some of the efficiency issues with monopolistic competition as they relate to your example..
6. Please explain some of the advantages of monopolistic competition as they relate to your example.
In: Economics
Here are some important figures from the budget of Wise Corporation for the third quarter of 2020:
| --------- | July | August | September |
| Credit sales | $1,275,800 | $1,483,500 | $1,096,300 |
| Credit purchases | 765,480 | 890,160 | 657,780 |
| Cash disbursements | |||
| Wages , taxes and expenses | 348,600 | 395,620 | 337,150 |
| Interest | 29,900 | 29,900 | 29,900 |
| Equipment | 0 | 158,900 | 96,300 |
| Credit sales collection | |||
| Collected in month of sale | 35% | ||
| Collected month after sale | 60% | ||
| Never Collected | 5% | ||
| June Credit sales | $1,135,020 | ||
June Credit purchases | $681,012 |
Beginning Cash balance $425,000
All credit purchases are paid in the following month after the purchase.
Instructions:
a) Using the above information, complete the following cash budget. (15 points)
July | August | September | |
Beginning cash balance | |||
Cash receipts: | |||
Cash collections from credit sales | |||
Total cash available |
Cash disbursements: | |||
Payments for purchases | |||
Wages, taxes, and expenses | |||
Interest | |||
Equipment purchases | |||
Total cash disbursements | |||
Ending cash balance |
b) What are the steps in preparing cash budget? Explain. (5 points)
In: Finance
At September 30, the end of Beijing Company’s third quarter, the following stockholders’ equity accounts are reported. Common stock, $12 par value $ 360,000 Paid-in capital in excess of par value, common stock 100,000 Retained earnings 360,000 In the fourth quarter, the following entries related to its equity are recorded. Date General Journal Debit Credit Oct. 2 Retained Earnings 70,000 Common Dividend Payable 70,000 Oct. 25 Common Dividend Payable 70,000 Cash 70,000 Oct. 31 Retained Earnings 75,000 Common Stock Dividend Distributable 36,000 Paid-In Capital in Excess of Par Value, Common Stock 39,000 Nov. 5 Common Stock Dividend Distributable 36,000 Common Stock, $12 Par Value 36,000 Dec. 1 Memo—Change the title of the common stock account to reflect the new par value of $4. Dec. 31 Income Summary 290,000 Retained Earnings 290,000 Required: 2. Complete the following table showing the equity account balances at each indicated date.
At September 30, the end of Beijing Company’s third quarter, the following stockholders’ equity accounts are reported.
| Common stock, $12 par value | $ | 360,000 |
| Paid-in capital in excess of par value, common stock | 100,000 | |
| Retained earnings | 360,000 | |
In the fourth quarter, the following entries related to its equity
are recorded.
| Date | General Journal | Debit | Credit |
| Oct. 2 | Retained Earnings | 70,000 | |
| Common Dividend Payable | 70,000 | ||
| Oct. 25 | Common Dividend Payable | 70,000 | |
| Cash | 70,000 | ||
| Oct. 31 | Retained Earnings | 75,000 | |
| Common Stock Dividend Distributable | 36,000 | ||
| Paid-In Capital in Excess of Par Value, Common Stock | 39,000 | ||
| Nov. 5 | Common Stock Dividend Distributable | 36,000 | |
| Common Stock, $12 Par Value | 36,000 | ||
| Dec. 1 | Memo—Change the title of the common stock | ||
| account to reflect the new par value of $4. | |||
| Dec. 31 | Income Summary | 290,000 | |
| Retained Earnings | 290,000 | ||
Required:
2. Complete the following table showing the equity
account balances at each indicated date.
|
In: Accounting
Victor French made deposits of $4,600 at the end of each quarter to Book Bank, which pays 8% interest compounded quarterly. After 5 years, Victor made no more deposits. What will be the balance in the account 4 years after the last deposit?
In: Finance
A quarterly forecasted balance sheet is below. Calculate OWC in each quarter. What is the maximum OWC level?
| Q1 | Q2 | Q3 | Q4 | |
| Cash and equivalents | 273,963.7 | 210,182.0 | 251,475.6 | 357,125.6 |
| Accounts receivable, net | 279,881.2 | 335,352.0 | 580,500.0 | 458,039.6 |
| Inventories | 256,128.0 | 341,518.0 | 348,314.0 | 235,008.4 |
| Prepaid assets and other current assets | 228,915.6 | 228,936.4 | 228,594.8 | 228,571.6 |
| Total current assets | 1,038,888.5 | 1,115,988.4 | 1,408,884.4 | 1,278,745.2 |
| Property, plant, and equipment | 286,243.2 | 293,200.8 | 288,519.6 | 296,458.8 |
| Goodwill | 554,358.0 | 557,258.8 | 555,183.6 | 553,808.0 |
| Other fixed assets | 564,118.4 | 576,780.4 | 542,821.2 | 492,063.6 |
| Total Assets | 2,443,608.1 | 2,543,228.4 | 2,795,408.8 | 2,621,075.6 |
| Short term borrowings | 800.5 | 14,107.6 | 0.0 | 6,765.6 |
| Current portion of long term debt | 0.0 | 0.0 | 0.0 | 120,000.0 |
| Accounts payable | 115,039.6 | 198,704.0 | 324,267.2 | 260,672.4 |
| Accrued expenses | 198,720.8 | 244,050.8 | 375,201.6 | 263,290.0 |
| Income taxes payable | 4,214.8 | 3,114.8 | 12,767.2 | 7,500.8 |
| Total current liabilities | 318,775.7 | 459,977.2 | 712,236.0 | 658,228.8 |
| Long-term debt | 840,000.0 | 840,000.0 | 840,000.0 | 720,000.0 |
| Other noncurrent liabilities | 218,175.2 | 217,462.0 | 214,107.6 | 189,545.2 |
| Total noncurrent liabilities | 1,058,175.2 | 1,057,462.0 | 1,054,107.6 | 909,545.2 |
| Common stock | 176,547.6 | 176,547.6 | 176,547.6 | 176,547.6 |
| Retained earnings | 890,109.6 | 849,241.6 | 852,517.6 | 876,754.0 |
| Total stockholders’ equity | 1,066,657.2 | 1,025,789.2 | 1,029,065.2 | 1,053,301.6 |
| Total Liabilities and Stockholders’ Equity | 2,443,608.1 | 2,543,228.4 | 2,795,408.8 | 2,621,075.6 |
| Check | 0.0 | 0.0 | 0.0 | 0.0 |
| OK | OK | OK | OK |
Select one:
720,112.8
446,149.1
459,936.8
604,546.8
In: Accounting
Every quarter, Bronx Co. ships computer chips to a firm in central Asia. It has not used any trade financing because the importing firm always pays its bill in a timely manner upon receipt of the computer chips. However, Bronx Co. was concerned that the foreign government may impose foreign exchange controls. Bronx Co. reconsidered whether it should use some form of trade financing that would ensure that it would be paid for its exports upon delivery. How could Bronx Co. have achieved its goal?
In: Finance
Problem 4 Hart Insurance is a regulated insurance company. During the 4th quarter of 2014 the company declared a dividend that was paid to shareholders at year end. Also, in the fourth quarter the company had to record a significant insurance loss associated with insurance coverage in an area hit by a major hurricane. As a result the company of the impairment and the dividend, the company had a retained deficit. However, state insurance laws prohibit paying a dividend when the company has an accumulated deficit.
Questions: Describe the ethical responsibilities of a CPA:
Who is also the audit partner on the annual audit of Hart Insurance (i.e. what are the ethical responsibilities of a CPA who is also the audit partner on an audit engagement).
Who is also the CFO (i.e. what are the ethical responsibilities of a CPA who also serves as a CFO for a company)?
Who has also been hired by an attorney to investigate a potential violation of law on behalf of the board of directors?
The following case studies use the conceptual
frameworks for members in public practice and for members in
business that are embedded in new Codification of the AICPA Code of
Professional Conduct. The conceptual frameworks were approved by
the AICPA Professional Ethics Executive Committee in January of
2014 and it are effective beginning December 15, 2015. The AICPA
Code of Professional Conduct (see reference above) includes both
conceptual frameworks.
In: Accounting
A payroll summary for Mark Consulting Company, owned by Mark
Fronke, for the quarter ending June 30, 2019, appears below. The
firm made the required tax deposits as follows
For April taxes, paid on May 15.
For May taxes, paid on June 17.
|
Date Wages Paid |
Total Earnings |
Social Security Tax Deducted |
Medicare Tax Deducted |
Income Tax Withheld |
||||||||||
| April | 8 | $ | 3,400.00 | $ | 210.80 | $ | 49.30 | $ | 338.00 | |||||
| 15 | 3,700.00 | 229.40 | 53.65 | 365.00 | ||||||||||
| 22 | 4,100.00 | 254.20 | 59.45 | 338.00 | ||||||||||
| 29 | 4,400.00 | 272.80 | 63.80 | 436.00 | ||||||||||
| $ | 15,600.00 | $ | 967.20 | $ | 226.20 | $ | 1,477.00 | |||||||
| May | 5 | $ | 3,200.00 | $ | 198.40 | $ | 46.40 | $ | 318.00 | |||||
| 12 | 3,400.00 | 210.80 | 49.30 | 338.00 | ||||||||||
| 19 | 3,400.00 | 210.80 | 49.30 | 338.00 | ||||||||||
| 26 | 4,400.00 | 272.80 | 63.80 | 436.00 | ||||||||||
| $ | 14,400.00 | $ | 892.80 | $ | 208.80 | $ | 1,430.00 | |||||||
| June | 2 | $ | 3,700.00 | $ | 229.40 | $ | 53.65 | $ | 365.00 | |||||
| 9 | 3,400.00 | 210.80 | 49.30 | 338.00 | ||||||||||
| 16 | 4,400.00 | 272.80 | 63.80 | 436.00 | ||||||||||
| 23 | 3,400.00 | 210.80 | 49.30 | 338.00 | ||||||||||
| 30 | 3,200.00 | 198.40 | 46.40 | 318.00 | ||||||||||
| $ | 18,100.00 | $ | 1,122.20 | $ | 262.45 | $ | 1,795.00 | |||||||
| Total | $ | 48,100.00 | $ | 2,982.20 | $ | 697.45 | $ | 4,702.00 | ||||||
| Social security | 6.2 | percent |
| Medicare | 1.45 | |
| FUTA | 0.6 | |
| SUTA | 5.4 | |
Required:
Using the tax rates given above, and assuming that all earnings are taxable, make the general journal entry on April 8, 2019, to record the employer’s payroll tax expense on the payroll ending that date.
Prepare the entries in general journal form to record deposit of the employee income tax withheld and the social security and Medicare taxes (employee and employer shares) on May 15 for April taxes and on June 17 for May taxes.
In: Finance
For the given quarterly sales data, a) calculate seasonal indices for each quarter, b) the year 4 annual forecast based on a linear regression trend forecasting method, c) the seasonally adjusted trend based quarterly forecasts for that 4th year, d) the year 4 annual forecast based on the Naive forecasting method, and e) the seasonally adjusted Naive based quarterly forecast for that 4th year.
| Quarter: | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| 1 | 2 | 3 | 7 |
| 2 | 6 | 10 | 18 |
| 3 | 2 | 6 | 8 |
| 4 | 5 | 9 | 15 |
| Total | 15 | 28 | 48 |
a) Seasonal indices: Q1 ; Q2 ; Q3 ; Q4
b) Year 4 forecast, trend based: Year 4
c) Seasonally adjusted trend forecast, year 4: Year 4 Q1 ; Year 4 Q2 ; Year 4 Q3 ; Year 4 Q5
d) Year 4 forecast, Naive based: Year 4
e) Seasonally adjusted Naive forecast, year 4: Year 4 Q1 ; Year 4 Q2 ; Year 4 Q3 ; Year 4 Q5
In: Accounting