accounting homework

Please solve the problems on excel and or a word document. Excel is preferred for solutions to the problems, your work is neater and it is easier to check errors.

1. Place an “X” in the column that corresponds to the cost classification for each of the following scenarios. Some items may fit in more than one column.

	Avoidable Cost	Unavoidable Cost	Sunk Cost	Common Fixed Cost
Original cost of factory machinery
Direct material
Depreciation on home office furniture
Salary of employees who will be fired if product is outsourced
Cost of item previously made in factory, but now purchased from supplier
Depreciation on factory equipment
Salary of supervisor who will be moved to another production line if product is eliminated
Cost of nonrefundable airline ticket purchased last week
Cost of delivery of products to customers
Direct labor

2. Pro-forma financial statements are prepared using the information developed in the budget process. These statements reflect the results of operations and the financial position of the organization as if all actions planned in the budget had occurred. Many of the master budget components provide direct input to the pro-forma financial statements.

Required:

For each of the following components of the financial statements, indicate which pro-forma financial statement will show the item (Income Statement or Balance Sheet) and the budget within the master budget the item originated. Number 1 provides an example.

	Financial Statement Component	Pro-forma Financial Statement	Budget Where Items Originated
1.	Revenue	Income Statement	Sales Budget
2.	Selling expense
3.	Accumulated depreciation
4.	Bad debt expense
5.	Short- or long-term debt
6.	Cost of goods sold
7.	Accrued expenses
8.	Accounts payable
9.	Interest expense
10.	Raw materials inventory
11.	Accounts receivable

3. Gooding Custom Design generated $320,000 in operating income on sales revenue of $2,500,000. The company had $3,000,000 in assets on January 1 and $3,250,000 in assets on December 31.

Required

a. Calculate Gooding’s margin.

b. Calculate Gooding’s asset turnover.

c. Calculate Gooding’s return on investment.

4. Paris Manufacturing Company Inc. uses 400 units of Part #4317 each year in the manufacture of one of its products. The company currently produces the part internally, but an outside supplier has offered to provide the part at a price of $20 per part. If Paris chooses to purchase the part from the outside supplier, one third of it’s the fixed manufacturing overhead will be eliminated. The company’s standard unit cost of producing the part is listed below.

Direct material $8	$8$8
Direct labor $6	$6
Variable manufacturing overhead $5	$5
Fixed manufacturing overhead $9	$9
Total unit cost	$28

Required: Ignoring qualitative factors, should Paris continue to make the parts internally or purchase them from the outside supplier? Why? Write a few sentences to respond on why Paris should make the parts internally or purchase them based on your calculations.

5. Brian Lochte operates a popular water park. Projections for the current year are as follows:

Sales revenue $8,000,000

Operating income $700,000

Average total assets $4,000,000

The camp’s weighted-average cost of capital is 10%, and Brian requires that all new investments generate a return on investment of at least 13%.

At last week’s board meeting, Brian told the board that he had up to $50,000 to invest in new facilities at the Park and asked them to recommend some projects. Today the board’s president presented Brian with the following list of three potential investments to improve the camp facilities.

Wading Pool Diving Pool Hot Tub

Incremental operating income $ 3,250 $ 4,800 $ 2,700

Average total assets 25,000 45,000 16,000

Required:

a. Calculate the residual income and economic value added for each of the three projects.

b. Which of the three projects do you recommend Brian undertake? Why, write a brief statement to explain the resulting calculations.

6. Mantle, Inc. produces two types of wooden mallets, Ash and Oak, in its Miami factory. Data relating to the mallets are given below:

	Ash	Oak
Unit selling price	$30	$28
Variable manufacturing costs	$11	$12
Variable selling costs	$1	$1
Minutes required per unit	20	15
Demand per period	1,200	1,600

A total of 600 hours are available in the Miami facility.

Required:

a. How many hours will be required to satisfy the demand for both products?

b. How much of each product should be produced to maximize Mantle’s operating income.

7.

Comprehensive Cash Budget?Sedona Gear Company a rapidly growing distributor of camping equipment, is formulating its plants for the coming year. Cody Mosbay, the firm’s marketing director, has completed the following sales forecast.

Month Sales Month Sales

January $ 900,000 July $1,900,000

February $1,000,000 August $1,900,000

March $ 900,000 September $1,600,000

April $1,200,000 October $1,600,000

May $1,500,000 November $1,800,000

June $1,900,000 December $2,000,000

Patti Bodkin, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. She has gathered the following information.

· All sales are made on credit

· Sedona’s excellent record in accounts receivable collection is expected to continue, with 65 percent of billings collected in the month after sale and the remaining 35 percent collected in the second month after the sale.

· Cost of goods sold, Sedona’s largest expense, is estimated to equal 45 percent of sales dollars. Seventy percent of inventory is purchased one month prior to sale and 30 percent during the month of sale. For example, in April, 30 percent of April cost of goods sold is purchased and 70 percent of May cost of goods sold is purchased. (see next page)

· All purchases are made on account. Historically, 70 percent of accounts payable have been paid during the month of purchase, and the remaining 30 percent in the month following purchase.

Required:

a. Prepare the cash receipts budget for the second quarter.

b. Prepare the purchases budget for the second quarter.

c. Prepare the cash payments budget for the second quarter.