Question

In: Accounting

Problem 20-3A Manufacturing: Preparation and analysis of budgeted income statements LO P3 Merline Manufacturing makes its...

Problem 20-3A Manufacturing: Preparation and analysis of budgeted income statements LO P3

Merline Manufacturing makes its product for $55 per unit and sells it for $141 per unit. The sales staff receives a 10% commission on the sale of each unit. Its December income statement follows.

MERLINE MANUFACTURING
Income Statement
For Month Ended December 31, 2017

Sales

$

1,410,000

Cost of goods sold

550,000

Gross profit

860,000

Operating expenses

Sales commissions (10%)

141,000

Advertising

222,000

Store rent

25,100

Administrative salaries

45,500

Depreciation—Office equipment

55,500

Other expenses

13,100

Total expenses

502,200

Net income

$

357,800

Management expects December’s results to be repeated in January, February, and March of 2018 without any changes in strategy. Management, however, has an alternative plan. It believes that unit sales will increase at a rate of 10% eachmonth for the next three months (beginning with January) if the item's selling price is reduced to $126 per unit and advertising expenses are increased by 10% and remain at that level for all three months. The cost of its product will remain at $55 per unit, the sales staff will continue to earn a 10% commission, and the remaining expenses will stay the same.

Required:
Prepare budgeted income statements for each of the months of January, February, and March that show the expected results from implementing the proposed changes. (Enter your final answers in whole dollars.)

MERLINE MANUFACTURING

Budgeted Sales

For Months of January, February, and March, 2018

January

February

March

Budgeted sales (in units)

Budgeted selling price per unit

Budgeted sales (in dollars)

MERLINE MANUFACTURING

Budgeted Income Statement

For Months of January, February, and March, 2018

January

February

March

Sales

Cost of goods sold

Gross profit

Expenses

Sales commissions

Advertising

Store rent

Administrative salaries

Depreciation—Office equipment

Other expenses

Total expenses

0

0

0

Net income

$0

$0

$0

Solutions

Expert Solution


Related Solutions

Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 65,000 Accounts receivable 434,850 Raw materials inventory 87,505 Finished goods inventory 374,640 Total current assets 961,995 Equipment, gross 624,000 Accumulated depreciation (162,000 ) Equipment, net 462,000 Total assets $ 1,423,995 Liabilities and Equity Accounts payable $ 199,405 Short-term notes payable 24,000 Total...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 80,000 Accounts receivable 364,000 Raw materials inventory 96,000 Finished goods inventory 364,800 Total current assets 904,800 Equipment, gross 610,000 Accumulated depreciation (155,000 ) Equipment, net 455,000 Total assets $ 1,359,800 Liabilities and Equity Accounts payable $ 195,500 Short-term notes payable 17,000 Total...
Exercise 20-34 Budgeted income statement LO P3 Fortune, Inc., is preparing its master budget for the...
Exercise 20-34 Budgeted income statement LO P3 Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 37,000 for January, 57,000 for February, and 47,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions 11 % of sales dollars Rent $ 22,000 per month Advertising 14 % of sales dollars...
Problem 22-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of...
Problem 22-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 53,000 Accounts receivable 392,400 Raw materials inventory 96,600 Finished goods inventory 313,920 Total current assets 855,920 Equipment, gross 626,000 Accumulated depreciation (163,000 ) Equipment, net 463,000 Total assets $ 1,318,920 Liabilities and Equity Accounts payable $ 204,800 Short-term notes payable 25,000 Total...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO P1, P2, P3 [The...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO P1, P2, P3 [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items a...
Question: Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of...
Question: Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of N... Using an "EXCEL" spreadsheet, create budgets (Items 1-9). Problem 20-4B Manufacturing: Preparation of a complete master budget P1 P2 P3 The management of Nabar Manufacturing prepared the following estimated balance sheet for June, 2015: NABAR MANUFACTURING Estimated Balance Sheet June 30, 2015 Assets Liabilities and Equity $ 40,000 ...249.900 35,000 Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3 [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3 [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3 [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3...
Problem 3-3A Preparing adjusting entries, adjusted trial balance, and financial statements LO A1, P1, P2, P3 [The following information applies to the questions displayed below.] Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT