Question

In: Accounting

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.

4. Operating expenses are estimated to be as follows:

  

sales

35,000 per month
advertising 6% of monthly sales
delivery expense 2% of monthly sales
sales commission 5% of monthly sales
rent expense 5,000 per month
depreciation 800 per month
utilites 600 per month
insurance 500 per month

interest expense is 2,000 per month. Income taxes are estimated to be 30% of income before income taxes.

a) prepare the merchandise purchases budget for each month in columnar form.

b) prepare budgeted multiple-step income statements for each month in columnar form. Show in the statements the details of cost of good sold.

Solutions

Expert Solution


Related Solutions

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....
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...
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...
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