QUESTION-1 (CONTINUED) Eric: Linda, my wife would be ecstatic if I were able to improve our financial position as Quickly as this opportunity

QUESTION-1 (CONTINUED)

Eric: "Linda, my wife would be ecstatic if I were able to improve our financial position as

Quickly as this opportunity affords. I certainly hope that you win the bid. What kind of help can I provide?"

Linda: "Simple. To win, all I have to do is beat the bid of your firm. Before 1 submit my bid, I would like you to review it. With the financial skills you have, it should be easy for you to spot any excessive costs that I may have included. Or perhaps I included the wrong kind of costs. By cutting excessive costs and eliminating costs that may not be directly related to the project, my bid should be competitive enough to meet or beat your firm's bid."

Required: (Please note this answer should not be more than 3 pages maximum)

a) What would you do if you were Eric? Explain the reasons for your decision and apply the code of ethics to the proposal given, to Eric assume that Eric is a member of a professional accounting body. (10 marks)

b) What is the risk to Eric personally if he reviews the bid? Should the degree of risk influence his decision? Explain your reasons. (9 marks)

QUESTION 2 PACIFIC AIR CORPORATION (18 marks)

Pacific Air Corporation is a business 'providing a wide variety of aviation products to pilots throughout the world. Dana Lombardi, the recently hired assistant controller, has been asked to develop a cost function to forecast shipping costs. The previous assistant controller had forecasted shipping department costs each year by plotting cost data against; direct labor-hours for the most recent 12 months and visually fitting a straight line through the points. The results were not satisfactory.

After discussions with the shipping department personnel, Lombardi decided that shipping costs could be more closely related to the number of orders filled. She based this conclusion on the fact that 10 months ago the shipping department added some automated equipment. Furthermore, she believes that using linear regression analysis will improve the forecasts of shipping costs. Cost data for the shipping department have been accumulated for the last 25 weeks. She ran two regression analysis of the data, one using direct labor-hours, and one using the number of cartons shipped. The information from the two linear regressions is the following:

Regression 1

Regression 2

Equation

SC = 804.3 + 15.68 DL

SC = 642.9 + 3.92 NR

R-squared

0.365

0.729

Standard error of the estimate

2.652

1.884

QUESTION 2 (CONTINUED)

Where:

SC = Total shipping department costs

DL = Total direct labour hours

NR = Number of cartons shipped

Required:

a) Identify which regression equation (Regression 1 or Regression 2) that Pacific Air should adopt for forecasting total shipping department costs and explain your reasons. (7 marks)

b) If Pacific Air estimates that 600 orders will be filled in the coming week, calculate the total shipping department costs using the regression that you have selected in part (a). (3 marks)

c) Are there any limitations to the regression that you have selected in part (a) above? If so, identify ways to address the limitations. Include in your answer the effect, if any, of the global nature of Pacific Air Corporation business. (8 marks)

QUESTION 3 HILLVIEW GARDEN CARE INC. (25 marks)

Hillview Garden Care Inc. is a lawn and garden care service. The company originally specialized in serving small residential clients but has recently started contracting for work on large apartment and office building grounds. Since Phyllis Flower (owner) believes that commercial lawn care is more profitable she is considering dropping residential services altogether.

Five field employees worked a total of 20,000 hours last year, 13,000 on residential jobs and 7,000 on commercial jobs. Wages amounted to $9 per hour for all work done. Direct materials used are included in overhead as supplies. All overhead is allocated on the basis of labour-hours worked, which is also the basis for customer charges. Because of the increased competition for commercial accounts, Phyllis can charge $22 per hour for residential work but only $19 per hour for commercial work.

Recently, Phyllis attended an accounting workshop on overhead-costing and activity analysis. She applied what she had learnt on the company. Further analysis revealed that the overheads consist of activities relating to transportation, equipment use and supplies. These costs are attributed to the following cost drivers as shown below:

QUESTION 3 (CONTINUED)

Activity Level

Activity Cost Driver Cost Commercial Residential

Transportation Number of

clients serviced

$8,000 15 45

Equipment Use Equipment

hours

$18,000 3,500 2,100

Supplies Area serviced in

square yards

$36,000 130,000 70,000

Total Overhead $62,000

Required:

a) If the overhead is $62,000, calculate the profits of commercial and residential services using

labour as the allocation base. (7 marks)

b) Recalculate your profits for the commercial and residential services using overhead as the

cost driver.(10 marks)

c) Based on your results for both a) and b), make recommendations to management on what

action to take on both of these services and explain your reasons. (8 marks)

QUESTION 4 – ELF’s PLACE INC. (18 marks)

Elf’s Place Inc. (Elf’s) sells toys, games and books. A poplar service is the birthday service,

which includes free gift wrapping and delivery of gifts to local families. Elf’s accepts cash,

cheques, Visa, MasterCard, and American Express credit cards. These methods of payment have

the following characteristics:

Cash Payment is immediate; no fee is charged

Cheque Payment is immediate; the bank charges $0.25 per cheque; and

1 percent of cheque revenue is from “bad” cheques that Elf

cannot collect

Visa/MasterCard Elf accumulates these credit card receipts throughout the month

and submits them in one bundle for payment on the last day of

the month. The money is credited to Elf’s account by the fifth

day of the following month. A fee of 1.50 percent is charged

by the credit card company.

American

Express

Elf accumulates these credit card receipts throughout the month

and mails for payment on the last day of the month. American

Express credit’s Elf’s account by the tenth day of the following

month. A fee of 3.50 percent is charged by American Express.

QUESTION 4 (CONTINUED)

During a typical month, the type of payment used by customers is as follows:

American Express: 20% of sales

Visa/MasterCard: 50% of sales

Cheque: 5% of sales (average cheque is $37.50)

Cash: 25% of sales

Required:

If Elf’s estimates sales of $30,000 in April and $60,000 in May, what are his planned net cash receipts for May? Show your workings. (18 marks)

QUESTION 5 LINK’S FINE BURGERS INC. (20 marks)

Link’s Fine Burgers Inc. (Link’s), is a new company currently studying various alternatives in regard to opening burger outlets. The only available data was formulated by a hired consultant who, unfortunately, left the country suddenly. A summary of the information that the consultant developed is as follows:

Average Selling Price per Pizza $7.50

Normal Monthly Costs

Fixed

Variable

Cost of Burger’s Sold

$0

$5,500

Manager’s Salary

2,000

0

Wages

2,000

0

Rent

1,500

500

Utilities

500

200

Insurance and Commissions

1,000

0

Total Costs

$7,000

$6,200

*Note: Costs are based on budgeted sales of 2,000 burger’s per month.

The above information represents estimates for the operations of a burger outlet. Link’s is interested in opening the outlets as soon as possible and has asked you to comment on the various scenarios as reflected in the questions a thru to c below.

. " .

'

Required:

a) Compute the breakeven point for a burger outlet in terms of both sales dollars and number of burger’s sold each month. (6 marks)

b) The company is considering offering a promotional selling price of $5.00 per burger during the first month of operations. How many extra burger’s will have to be sold by a burger outlet at

QUESTION 5 (CONTINUED)

the promotional price compared to the normal average selling price in order to earn operating income of $2,500 during the first month? (6 marks)

c) As an incentive program for the outlet manager, Link’s is considering implementing an alternative compensation method. Instead of paying the manager a fixed salary of $2,000 per month, the company is considering an incentive plan of $1,000 per month plus 8% of monthly revenue Using this alternative method and the normal average selling price per burger, calculate how many burger’s will have to be sold to achieve an operating income of $2,000 per month.(8 marks)