Question

In: Accounting

Problem 23-5A The budget committee of Suppar Company collects the following data for its San Miguel...

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]

Solutions

Expert Solution

Month May June July
Sales $ 803,000.00 803000*(1.05)=$843150 843150*(1.05)=$885307.50
COGS(75% of sales) $ 602,250.00 $                           632,362.50 $                               663,980.63
Ending Inventory
May=($632362.5*10%) $    63,236.25
June=($663980.63*10%) $    66,398.06
Begnning Inventory of May=($602250*10%) $    60,225.00
Suppar Company
San Migual Store
Merchandise Purchase Budget
May June
Sales $ 803,000.00 $                           843,150.00
Cost of goods sold=(A) $ 602,250.00 $                           632,362.50
Add: Ending Inventory=(B) $    63,236.25 $                             66,398.06
Total Needs=(C )=(A)+(B) $ 665,486.25 $                           698,760.56
Less: Beginning Inventory=(D) $    60,225.00 $                             63,236.25
Merchandise Purchased=(E )=(C )-(D ) $ 605,261.25 $                           635,524.31
Suppar Company
San Migual Store
Budgeted Income Statement for May and June
May June
Sales=(A) $ 803,000.00 $                           843,150.00
Cost of goods sold=(B) $ 602,250.00 $                           632,362.50
Gross Profit=(C )=(A)-(B) $ 200,750.00 $                           210,787.50
Operating Expenses
Sales Salaries $    30,000.00 $                             30,000.00
Advertising(Sales*6%) $    48,180.00 $                             50,589.00
Delivery Expense(Sales *2%) $    16,060.00 $                             16,863.00
Sales Commission(Sales*5%) $    40,150.00 $                             42,157.50
Rent Expense $      5,390.00 $                               5,390.00
Deprecation $          910.00 $                                   910.00
Utilites $          710.00 $                                   710.00
Insurance $          560.00 $                                   560.00
Interest Expense $      2,000.00 $                               2,000.00
Total Operating Expenses=(D) $ 143,960.00 $                           149,179.50
Income before income tax=(E )=(C )-(D) $    56,790.00 $                             61,608.00
Income Tax=(F )=(E )*30% $    17,037.00 $                             18,482.40
Net Income after tax=(G)=(E )-(F) $    39,753.00 $                             43,125.60
Working
May June
Advertisement Expenses ($803000*6%) ($843150*6%)
Delivery Expenses ($803000*2%) ($843150*2%)
Sales Commission ($803000*5%) ($843150*5%)
Income Tax ($56790*30%) ($61608*30%)

Related Solutions

Problem 23-5A The budget committee of Suppar Company collects the following data for its San Miguel...
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 $815,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...
The budget committee of Suppar Company collects the following data for its San Miguel Store in...
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....
The budget committee of SUppar Company collects the following data for its San Miguel store in...
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 800,000. sales in June and July are expected to be 5% higher than the preceeding month. 2. Cost of good sold is expecte to be 70% of sales 3. Company policy is to maintain ending merchandise inventory at 10% of the following months cost of goods sold....
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter  5,200; second quarter  6,700; third quarter  7,000 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,380 units. The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to production and sales...
On January 1, 2019 the DAYUMSON Company budget committee has reached agreement on the following data...
On January 1, 2019 the DAYUMSON Company budget committee has reached agreement on the following data for the 6 months ending June 30,2019. Sales units First quarter 5,000; second quarter 6,000; third quarter 7,000 Ending raw materials inventory 40% of the next quarter’s production requirements Ending finished goods inventory 30% of the next quarter’s expected sales units Third-quarter 2019 production 7,500 units The ending raw materials and finished goods inventories at December 31, 2018, follow the same percentage relationships to...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,800; second quarter 6,700; third quarter 7,200 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,800 units. The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,400; second quarter 6,100; third quarter 7,900. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,430 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
On January 1, 2020, the Ivanhoe Company budget committee has reached agreement on the following data...
On January 1, 2020, the Ivanhoe Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,800; second quarter 6,600; third quarter 7,600. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,780 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,100; second quarter 6,300; third quarter 7,300 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,670 units. The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,100; second quarter 6,800; third quarter 7,300 Ending raw materials inventory: 40% of the next quarter’s production requirements Ending finished goods inventory: 25% of the next quarter’s expected sales units Third-quarter production: 7,390 units. The ending raw materials and finished goods inventories at December 31, 2016, follow the same percentage relationships to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT