Determine the flexible budget variances and also indicate


Question 1 - Curtis Salter, the president of Kasimer Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal year 2015.

Standard rate and variable costs


Service rate per hour

$75.00

Labor cost

40.00

Overhead cost

7.20

Selling, general, and administrative cost

4.30

Expected fixed costs


Facility maintenance

$400,000

Selling, general, and administrative

150,000

a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 30,000 hours of services in 2015.

b. A marketing consultant suggests to Mr. Salter that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Kasimer charges customers $70 per hour, the firm can achieve 38,000 hours of services. Prepare a flexible budget using the consultant's assumption.

c. The same consultant also suggests that if the firm raises its rate to $80 per hour, the number of service hours will decline to 25,000. Prepare a flexible budget using the new assumption.

Question 2 - Lloyd Publications established the following standard price and costs for a hardcover picture book that the company produces.

Standard price and variable cost

 

Sales price

$45.00

Materials cost

9.00

Labor cost

4.50

Overhead cost

6.30

Selling, general, and administrative costs

7.20

Planned fixed costs

 

Manufacturing overhead

$135,000

Selling, general, and administrative

54,000

Lloyd planned to make and sell 30,000 copies of the book.

Required -

a. - d. Prepare the pro forma income statement that would appear in the master budget and also flexible budget income statements, assuming production volumes of 29,000 and 31,000 units. Determine the sales and variable cost volume variances, assuming volume is actually 31,000 units. Indicate whether the variances are favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)

Question 3 - Lloyd Publications established the following standard price and costs for a hardcover picture book that the company produces.

Standard price and variable costs


Sales price

$36.40

Materials cost

8.50

Labor cost

3.70

Overhead cost

6.10

Selling, general, and administrative costs

6.30

Planned fixed costs


Manufacturing overhead

$127,000

Selling, general, and administrative

45,000

Assume that Lloyd actually produced and sold 27,000 books. The actual sales price and costs incurred follow.

Actual price and variable costs


Sales price

$35.40

Materials cost

8.70

Labor cost

3.60

Overhead cost

6.15

Selling, general, and administrative costs

6.10

Actual fixed costs


Manufacturing overhead

$112,000

Selling, general, and administrative

51,000

Required - a. & b. Determine the flexible budget variances and also indicate the effect of each ariance by selecting favorable (F) or unfavorable (U).

Question 4 - Austen Educational Services had budgeted its training service charge at $78 per hour. The company planned to provide 24,000 hours of training services during 2015. By lowering the service charge to $63 per hour, the company was able to increase the actual number of hours to 25,400.

Required -

a. Determine the sales volume variance and indicate the effect of the variance by selecting favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)

b. Determine the flexible budget variance and indicate the effect of the variance by selecting favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).)

Question 5 - Helton Corporation's balance sheet indicates that the company has $270,000 invested in operating assets. During 2014, Helton earned operating income of $53,000 on $567,000 of sales.

Required -

a. Compute Helton's profit margin for 2014.

b. Compute Helton's turnover for 2014.

c. Compute Helton's return on investment for 2014.

d. Re-compute Helton's ROI under each of the following independent assumptions.

(1) Sales increase from $567,000 to $757,000, thereby resulting in an increase in operating income from $53,000 to $72,000.

(2) Sales remain constant, but Helton reduces expenses, resulting in an increase in operating income from $53,000 to $56,000.

(3) Helton is able to reduce its invested capital from $270,000 to $203,000 without affecting operating income.

Question 6 - Cole Corporation operates three investment centers. The following financial statements apply to the investment center named Morrison Division.

MORRISON DIVISION Income Statement For the Year Ended December 31, 2014

Sales revenue

$135,000

Cost of goods sold

78,500

Gross margin

56,500

Operating expenses


Selling expenses

(5,000)

Depreciation expense

(8,000)

Operating income

43,500

Nonoperating item


Loss of sale of land

(15,000)

Net income

$28,500

 

MORRISON DIVISION Balance Sheet As of December 31, 2014

Assets


Cash

$18,580

Accounts receivable

42,266

Merchandise inventory

37,578

Equipment less accum. dep.

90,258

Nonoperating assets

9,000

Total assets

$197,682

Liabilities


Accounts payable

$9,637

Notes payable

72,000

Stockholders' equity


Common stock

80,000

Retained earnings

36,045

Total liab. and stk. equity

$197,682

Required

a. Calculate the ROI for Morrison.

Cole has a desired ROI of 10 percent. Headquarters has $96,000 of funds to assign to its investment centers. The manager of the Morrison Division has an opportunity to invest the funds at an ROI of 12 percent. The other two divisions have investment opportunities that yield only 11 percent.

b. Calculate the new ROI for Morrison division, if the investment opportunity is adopted by Morrison.

c. Based on the original data calculate the residual income.

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Determine the flexible budget variances and also indicate
Reference No:- TGS02497795

Now Priced at $35 (50% Discount)

Recommended (93%)

Rated (4.5/5)