
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 7 Solutions
Fundamental Managerial Accounting Concepts
- Eldora Systems is a privately-held firm. You are asked to estimate its value using market data from a comparable public firm. The comparable firm has a stock price of $32.00, net income of $48,000, and 12,000 shares outstanding. Eldora Systems has an earnings per share (EPS) of $4.00. What is the estimated value per share of Eldora Systems? A) $12.00 B) $16.00 C) $20.00 D) $32.00 E) $28.00arrow_forwardNeed urgently soln and don't answer if you don't know value sure unhelarrow_forwardProvide answerarrow_forward
- Fennel Industries had 6,420 actual direct labor hours at an actual rate of $15.60 per hour. Original production had been budgeted for 950 units, but only 880 units were actually produced. Labor standards were 7.2 hours per completed unit at a standard rate of $16.10 per hour. What is the direct labor rate variance?arrow_forwardWhat is the bank costarrow_forwardHelp this accounting question answerarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





