Question: Cameron Parts has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: Sales revenue (12,500 units).

Cameron Parts has the following data from year 1 operations, which are to be used for developing year 2 budget estimates:

Sales revenue (12,500 units). . . . . . . . $1,119,000

Manufacturing costs

Materials. . . . . . . . . . . . . . . . . . . . .$ 199,500

Variable cash costs . . . . . . . . . . . . . 271,350

Fixed cash costs . . . . . . . . . . . . . . . 108,000

Depreciation (fixed) . . . . . . . . . . . . 133,500

Marketing and administrative costs

Marketing (variable, cash) . . . . . . . . 142,500

Marketing depreciation . . . . . . . . . . 33,900

Administrative (fixed, cash) . . . . . . . 135,165

Administrative depreciation . . . . . . .$ 12,600

Total costs . . . . . . . . . . . . . . . . . . $1,036,515

Operating profits . . . . . . . . . . . . . . . . .$ 82,485

All depreciation charges are fixed. Old manufacturing equipment with an annual depreciation charge of $14,550 will be replaced in year 2 with new equipment that will incur an annual depreciation charge of $21,000. Sales volume and prices are expected to increase by 12 per- cent and 6 percent, respectively. On a per-unit basis, expectations are that materials costs will increase by 10 percent and variable manufacturing costs will decrease by 4 percent. Fixed manufacturing costs are expected to decrease by 7 percent. Variable marketing costs will change with volume. Administrative cash costs are expected to increase by 8 percent. Inventories are kept at zero. Cameron operates on a cash basis.


Required

Prepare a budgeted income statement for year 2.


Step by Step Solution

3.44 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

CAMERON PARTS Year 1 information Sales Revenue 12500 units Manufacturing costs Materials Variable ca... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

269-B-M-A-B-P-C (1191).xlsx

300 KBs Excel File

Students Have Also Explored These Related Managerial Accounting Questions!