a)
Determine the percentage increase in sales and prepare the pro forma income statement.
a)
Explanation of Solution
The formula to calculate the percentage of increase in sales:
Compute net income:
Excel workings:
Table (1)
Excel spread sheet:
Table (2)
Compute the sales value:
Consider sales as X:
Hence, sales are $1,817,500.
Compute selling and administration expenses:
Hence, the selling and administration expenses are $211,750.
Prepare a pro forma income statement:
Table (3)
Hence, the net income is $333,500.
Compute the percentage of increase in sales:
Hence, the percentage of increase in sales is 13.59%.
b)
Prepare the pro forma income statement and the other ideas to reach the Company T’s goal.
Given information:
Discount rate of 2% on COGS
b)
Explanation of Solution
Compute the COGS:
Excel workings:
Table (4)
Excel spread sheet:
Table (5)
Hence, the COGS are $1,097,600.
Compute the selling and administration expenses:
Consider selling and administration expenses as X:
Hence, selling and administration expenses are $168,900.
Prepare a pro forma income statement:
Excel spreadsheet:
Table (6)
Hence, the net income is $333,500.
The management cuts the selling and administrative expenses by the amount of $21,100 that is
c)
Whether the company can reach the goal of Company T
c)
Explanation of Solution
Compute projected sales:
Hence, the projected sales are $1,840,000.
Compute the projected cost of goods sold:
Hence, the projected cost of goods sold is $1,288,000.
Prepare a pro forma income statement:
Excel spreadsheet:
Table (7)
Hence, the net income is $322,000.
The company cannot reach the goal as the desired profit is less than the actual that is $322,000 is less than the $333,500.
Want to see more full solutions like this?
Chapter 14 Solutions
SURVEY OF ACCOUNTING >C<
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.arrow_forwardForecast sales volume and sales budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Unit Sales Unit Selling Total Product and Area Volume Price Sales 8"10" Frame: East 8,500 16 136,000 Central 6,200 16 99,200 West 12,600 16 201,600 Total 27,300 436,800 12" x 16" Frame: East 3,800 30 5114,000 Central 3,000 30 90,000 West 5,400 30 162,000 Total 12,200 366,000 Total revenue from sales 802,800 For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for the 8" 10"frame is expected to increase to 17, and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y7. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y6 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent 8" 10" Frame: East Central West 12"16" Frame: East Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y6 Percentage 20Y7 Actual Increase Budgeted Units (Decrease! Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y7.arrow_forwardBudget performance report for a cost center Sneed Industries Company sells vehicle parts to manufacturers of heavy construction equipment. The Crane Division is organized as a cost center. The budget for the Crane Division for the month ended August 31, 20Y6, is as follows (in thousands): During August, the costs incurred in the Crane Division were as follows: Instructions Prepare a budget performance report for the director of the Crane Division for the month of August.arrow_forward
- Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December 2016: a. Estimated .sales for December: Bird house 3,200 units at 50 per unit Bird feeder 3,000 units at 70 per unit b. Estimated inventories at December 1: Direct materials: Finished products: Wood 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 270 units at 40 per unit c. Desired inventories at December 31: Direct materials: Finished products: Wood 220 ft Bird house....... 290 units at 27 per unit Plastic 200 lbs. Bird feeder....... 250 units at 41 per unit d. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood 0.80 ft. per unit of product Wood........... 1.20 ft per unit of product Plastic 050 lb. per unit of product Plastic........... 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft. Plastic................. 1.00 per lb. f. Direct labor requirements: Bird House: Fabrication Department 0.20 hr. at 16 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at 16 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,000 Insurance and property tax 5,000 h. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 i. Estimated other income and expense for December: Interest revenue 200 Interest expense 122 j. Estimated lax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000 and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.arrow_forwardEthics and professional conduct in business The director of marketing for Truss Industries Inc.. Ellen Knutson, had the following discussion with the company controller. Bud Wyckoff. on February 26 of the current year: Ellen: Bud, it looks like I'm going to spend much less than indicated on my February budget. Butt: I'm glad to hear it. Ellen: Well. I'm not so sure it's good news. I'm concerned that the president will see that I'm under budget and reduce my budget in the future. The only reason that I look good is that we've delayed an advertising campaign. Once the campaign hits in May. I'm sure my actual expenditures will go up. You see. we are also having our sales convention in May. Having the advertising campaign and the convention at the same time is going to kill my May numbers.arrow_forwardBudgeted income statement and supporting budgets The budget director of Feathered Friends Inc., with the assistance of thee controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December: A. Estimated sales for December Bird house....................... 3,200 units at 50 per unit Bird feeder....................... 3,000 units at 70 per unit B. Estimated inventories at December 1: Direct materials Finished products: Wood............ 220 ft Bird house........ 320 units at 27 per unit Plastic............ 240 ft Bird house........ 270 units at 40 per unit C. Desired inventories at December 31: Direct materials Finished products: Wood............ 220 ft Bird house........ 290 units at 27 per unit Plastic............ 200 ft Bird house........ 205 units at 41 per unit D. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood............ 0.80 ft. per unit of product Wood........ 1.20 ft. per unit of product Plastic............ 0.50 lb. per unit of product Plastic......... 0.75 lb. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft Plastic 1.00 per lb. F. Direct labor requirements: Bird House: Fabrication Department...................... 0.20 hr. at 16 per hr. Assembly Department........................ 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department...................... 0.40 hr. at 16 per hr. Assembly Department........................ 0.35 hr. at 12 pr hr. G. Estimated factory overhead costs for December: Indirect factory wages 75,000 Depreciation of plant and equipment 23,000 Power and light 6,000 Insurance and property tax 5,000 H. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 I. Estimated other income and expense for December: Interest revenue200 Interest expense122 J. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000, and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.arrow_forward
- Budgeted income statement and supporting budgets The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof product Plastic . . 0.50 lb. per unit of product Plastic 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.arrow_forwardBudgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y8, the following tentative trial balance as of December 31, 20Y7, is prepared by the Accounting Department of Mesa Publishing Co.: Cash 26,000 Accounts Receivable 23,800 Finished Goods 16,900 Work in Process 4,200 Materials 6,400 Prepaid Expenses 600 Plant and Equipment 82.000 Accumulated DepreciationPlant and Equipment 32,000 Accounts Payable 14.800 Common Stock. 1.50 par 30,000 Retained Earnings 83,100 159,900 159,900 Factory output and sales for 20Y8 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y8, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials 30.00 Direct labor B.40 Factory overhead: Depreciation of plant and equipment 4,000 Other factory overhead 1,400 4.30 Selling expenses: Sales salaries and commissions 12,800 13.50 Advertising 13,200 Miscellaneous selling expense 1,000 2.50 Administrative expenses: Office and officers salaries 7,800 7.00 Supplies 500 1.20 Miscellaneous administrative expense 400 2.40 Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y8 taxable income will be paid during 20Y8. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y8. 2. Prepare a budgeted balance sheet as of December 31,20Y8, with supporting calculations.arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningAccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning