Description of this paper

4 Assume the following regarding variables versus...




4 Assume the following regarding variables versus fixed-nature-of-income-statement operating expenses for the existing business: a. 80% of wage benefits is variable and 20% is fixed. b. 100% of fuel expenses, purchased transportation, and operating supplies is variable. c. 100% of operating taxes is fixed. d. 20% of insurance and claims is fixed; the balance is variable. e. Assume depreciation, even with new expenditures, is fixed as the retirement of written-off assets, equaling new equipment. 5 There will be new spending areas reflected on future budgets to reflect added satellite warehouse costs and space rental and costs of running the locations. a. In the first year, add $10 million of inflation, space rental, and operating costs at 25% of revenues from the new initiative. b. In the second year, add $10 million space rental, with inflation at the same variable percentage of sales. c. In the third year, add $7.5 million of the variable percentage of sales. 6 In marketing, budget accounts have been added for new incurred costs. We will continue our present promotion and launch a new program, with the assistance of our marketing partner, the ABC Marketing Agency. They will advise us on the type, frequency, and content of new messages. Assume 100% of the existing budget is fixed with respect to volume along with new expenses. We expect incremental expenses, with $5 million of inflation in the first three years. 7 Our existing sales force, comprised of four national account managers, will call on clients such as Wal-Mart?, Sears?, and Best Buy?. Existing expenses are assumed to be 100% fixed in relation to revenue. To tap into specialized markets, our strategy is aimed at adding four industry-specific managers, each with a salary base of $50,000 and 2% commission of generated revenues. 8 The human resources budget will not change substantially aside from added hiring, recruiting, training, and drug testing fees. Assume 10% of expenses is fixed; the balance is variable with volume. 9 Assume current assets and liabilities are variable. Expect an addition of $10 million to operating property, spent in the first year. Our payment to vendors, suppliers, and taxes will be in thirty-day terms. We expect all payments to be in sixty-day terms. 10 Assume revenue growth from our existing business will grow at 8% versus 10% in past years. Our new strategy, however, adds incremental consulting revenues of $3.5, $4.5, and $6.5 million in the first, second, and third years. New warehousing will add revenue of $10, $30, and $40 million in the first, second, and third years. All new revenue will be subject to commissions for industry-specific managers. 15 Complete the first year pro forma statements (income statement and balance sheet) using the above assumptions.


Paper#8723 | Written in 18-Jul-2015

Price : $25